Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
61 | |
53 | |
27 | |
16 | |
10 |