Why my OData url don't work ?

[Anonymous]

Hi

I have an OData feed who work perfectly but not in a particular configuration. I work on Dynamics 365 CRM and can obtain all tables since :

"https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.1/"

and contacts Attributes with

https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.0/EntityDefinitions(LogicalName='contact')?$select=LogicalName&$expand=Attributes($select=LogicalName;$filter=AttributeType eq Microsoft.Dynamics.CRM.AttributeTypeCode'Picklist')

but not since

https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.0/EntityDefinitions(LogicalName='contact')/Attributes/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet,GlobalOptionSet

I've followed all instruction on https://docs.microsoft.com/fr-fr/dynamics365/customer-engagement/developer/webapi/query-metadata-web... but it don't work.

Someone can say why? I would like to get OptionList attributes but it was not present in table GlobalOptionSetDefinition

The complete code in M in power query :

let
    Source = OData.Feed("https://{MY_SITE}.api.crm4.dynamics.com/api/data/v9.0/EntityDefinitions(LogicalName='contact')?$select=LogicalName&$expand=Attributes($select=LogicalName;$filter=AttributeType eq Microsoft.Dynamics.CRM.AttributeTypeCode'Picklist')", null, [Implementation="2.0", Headers = [Accept = "application/json"]]),
    Attributes = Source[Attributes]
in
    Attributes

Thanks

[Anonymous]

Not at all 

[Anonymous]

My problem is the access at /Attributes since EntityDefinitions(''contact")

This URL work perfectly

https://proactifrh.api.crm4.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='contact')

but not with /Attributes.

https://proactifrh.api.crm4.dynamics.com/api/data/v9.1/EntityDefinitions(LogicalName='contact')/Attributes

I don't understand why because it's on official documentation ! And in more, the EntityDefinitions has really a column 'Attributes' !

[Anonymous · Accepted solution]

I've solve this with https://community.powerbi.com/t5/Desktop/Power-Query-How-to-get-a-Dynamics-365-pick-list/td-p/659978

Thanks

[v-frfei-msft]

Hi @Anonymous ,

Hope this case can help you.

https://community.powerbi.com/t5/Power-Query/OData-filter-pass-through/td-p/155386