News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Can not filter on Expa...

Customer experience | Sales, Customer Insights,...

Suggested answer

Can not filter on Expanded fields using Web API O-DATA 4.0 Dynamics CRM 365 v9.0

(0) Share

Report

Report

Posted on by Saad Kabarousse

732

hello every one,

Im on D365 v9.0 , and i'm working with Web API, it's working fine for simple retrieve or post requests. Now i am trying to apply filter on a field of a related entity as shown below. i have tried all the combinaisons that've found on the internet but i am always getting bad request.

can any one tell me what's wrong with the following request?

https:/URL /api/data/v8.2/incidents

?$select=_new_contact_value

&$expand=new_contact($select=firstname)

&$filter=new_contact/firstname eq 'contact1'

Thanks,

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Can not filter on Expanded fields using Web API O-DATA 4.0 Dynamics CRM 365 v9.0

Hello,

Here is what possible - docs.microsoft.com/.../gg334767(v=crm.8)

If you have complex query I would recommend to use fetchXml instead - docs.microsoft.com/.../mt607533(v=crm.8)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans