How to use Filter condition on related entity using CRM Web API

(1) Share

Report

Posted on by Ramakanta

2,715

Hello ,

I want to get all the account records based on my primary contact GUID .So i want use the WEB API ,can i filter my result sets based on my contact GUID?If so then how filter on multiple GUIDs,do i need to use the contains operator or IN Operator or Equal operator with multiple or condition

SQL Replica of my Query is

Select * from Account where primarycontactid in('GUID1','GUID2','GUID3')

Thanks in Advance

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Brad Sprigg 985 on at

Like (0)

Report
Copy link

Link copied!

You should be able to use something like

$filter=primarycontactid eq GUID1 or primarycontactid eq GUID2 or primarycontactid eq GUID3

See msdn.microsoft.com/.../gg334767.aspx

Was this reply helpful? Yes No
Suggested answer

Anirban Dutta 5 on at

Like (1)

Report
Copy link

Link copied!

I believe it must be something like the below:

?$select=<your select query>&$filter=primarycontactid/contactid eq GUID1 or primarycontactid/contactid eq GUID2 or primarycontactid/contactid eq GUID3

In general "primarycontactid" field must be schema name of the lookupfield and contactid is the actual primaryguid in the related table, which in this case is the contact entity.

Hope this helps!

Was this reply helpful? Yes No
Pavan Deepala 90 on at

Like (0)

Report
Copy link

Link copied!

Thanks

Was this reply helpful? Yes No
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report
Copy link

Link copied!

You can use CRM REST builder to create query and add filters also you can test your Web API query .

Was this reply helpful? Yes No