cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ZERO
Regular Visitor

Why my OData url don't work ?

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

1 ACCEPTED SOLUTION

Accepted Solutions
ZERO
Regular Visitor

Re: Why my OData url don't work ?

4 REPLIES 4
Community Support
Community Support

Re: Why my OData url don't work ?

Hi @ZERO ,

 

Hope this case can help you.

 

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

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
ZERO
Regular Visitor

Re: Why my OData url don't work ?

Not at all Smiley Indifferent

Highlighted
ZERO
Regular Visitor

Re: Why my OData url don't work ?

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' !

 

ZERO
Regular Visitor

Re: Why my OData url don't work ?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors