Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
Not at all
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' !
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
Hi @Anonymous ,
Hope this case can help you.
https://community.powerbi.com/t5/Power-Query/OData-filter-pass-through/td-p/155386
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
12 | |
11 | |
11 | |
8 |
User | Count |
---|---|
45 | |
28 | |
14 | |
14 | |
13 |