Query metadata using the web api does not return Attributes information explicitly selecting it

(0) Share

Report

Posted on by Kobia Microsoft Employee

I am running the following query

https://orgID.api.crm.dynamics.com/api/data/v9.2/EntityDefinitions

and I do get back all fields.

However, if I run

https://orgID.api.crm.dynamics.com/api/data/v9.2/EntityDefinitions?$select=DisplayName,Attributes

I get back only DisplayName and not the attributes....

Are there certain fields I need to ask for in order to get back the Attributes. Is there a depedency?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @Kobia ,

To get attributes for a particular entity, you need to drill down to a specific entity, then expand the Attributes since it is a collection.

For example:

/EntityDefinitions(LogicalName='account')/Attributes

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/query-metadata-web-api#querying-entitymetadata-attributes

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Kobia Microsoft Employee on at

Like (0)

Report

Hi Chris,
I am trying to get attributes of all entities, and be generic, that is I don't know the name of the entities beforehand.

Was this reply helpful? Yes No
Diana Birkelbach 3,072 Most Valuable Professional on at

Like (0)

Report

Hi @Kobia ,

I'm afraid you need to make several requests:

1. First to get all entities

api/data/v9.2/EntityDefinitions?$select=LogicalName,DisplayName

2. then you can make for each entity a requests for attributes

api/data/v9.2/EntityDefinitions(LogicalName='account')/Attributes

And will get worse, if you need to get some special metadata like Options for an optionset or boolean: then you need to make a separate request for each type of attribute (Picklist, Multipiclist,State, Status, Boolean).
I've tried several ways, but EntityDefinitions is still the fastest way, even when there are several requests, they can be called paralle.

Hope this helps!

Kind regards,

Diana

Was this reply helpful? Yes No