Customer experience | Sales, Customer Insights,...

How to select records using lookup fields for filter using webapi.

(0) Share

Report

Posted on by SivaR

Hi,

I tried to select contacts where the account lookup id matches. the following API call works if I remove this 'and parentcustomerid eq '0C9A87ED-A4A0-EC11-B3FE-002248AD8D09'

As soon as i put that line back, it returns an error. How i can add the account lookup field (parentcustomerid ) to the API call.

I am using the following code.

function getContact( conId,orgId , formContext)
{

}

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

RodCTE365 15 on at

Like (0)

Report

Hi Sivar, try replace parentcustomerid with _parentcustomerid_value in your filter

If you have used XrmToolbox before, open FetchXML Builder and build your query.

Then select the View menu option and click on the 'OData 4.0 (WebAPI)'.

The correct syntax will show just above the status bar.

1 people found this reply helpful.

Was this reply helpful? Yes No
Guido Preite 54,086 Moderator on at

Like (0)

Report

you can also use my tool Dataverse REST Builder to create the Web API requests

Was this reply helpful? Yes No
Inogic 682 on at

Like (0)

Report

Use below Odata query to fetch contact record based on contactid and parentcustomerid.

var Filter ="&$filter=contactid eq '{3D36A874-49F6-EC11-82E5-002248AE4B85}' and _parentcustomerid_value eq '{0C9A87ED-A4A0-EC11-B3FE-002248AD8D09}'".

To filter any look up field based on GUID the syntax is _fieldname_value .

Alternatively you can also use the below fetch XML

"<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="contact">

<order attribute="fullname" descending="false" />

<filter type="and">

<condition attribute="contactid" operator="eq" uiname="(ContactName)" uitype="contact" value="{3D36A874-49F6-EC11-82E5-002248AE4B85}" />

<condition attribute="parentcustomerid" operator="eq" uiname="(AccountName)" uitype="account" value="{0C9A87ED-A4A0-EC11-B3FE-002248AD8D09}" />

</filter>

</entity>

</fetch>"

Thanks!

Was this reply helpful? Yes No