---
title: "Querying Attributes"
description: "You can use querying of attributes from Lucanet, among other things, to export element names in Lucanet via the OID of elements."
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-attributes
language: en
last_updated: 2023-08-16
---
# Querying Attributes

## Overview

You can use querying of attributes from Lucanet, among other things, to export element names in Lucanet via the **OID** of elements. The OID of an element is always unique while its name does not have to be unique. If an element exists with the same name at several points in Lucanet, a query leads to an error message, while a query with the OID returns the correct result.

## Structure of the LUCANET Formulas

To read in attributes from Lucanet to MS Excel, the formula must be set up as follows:

```
=LN.ATTRIBUTE("Attribute","Object")

```

## Attribute

The parameter **Attribute** specifies either the key of an attribute or the name of an object.

| Attribute | Definition |
|---------|---------|
| Key | Key of the attribute in Lucanet |
| Name | Returns the element name of the specified object |

## Object

The **Object** parameter specifies either the element name or the OID of the object whose attribute is to be read in to MS Excel.

| Object | Definition |
|---------|---------|
| Element name | Returns the attribute of the object with the specified element name |
| lucanet://oid=XXX | Returns the attribute of the object using the URL lucanet://oid=XXX |