Web API query using $expand and related entities

(0) Share

Report

Posted on by Benjamin Fallar III

245

Hi,

Is there a way in Web API to include the related entities in a single query without performing the @data.nextLink, for example if I issue the following request

localhost:5555/.../contacts eq '4200722132'&$expand=mli_contact_accountregistration_registrantaccountid

I want to see the related mli_contact_accountregistration_registrantaccountid records in the payload without issuing another request to the following link

"">idwicrmapd01.mlijkt01.manulife.com/.../mli_contact_accountregistration_registrantaccountid"

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Benjamin Fallar III 245 on at

Like (0)

Report
Copy link

Link copied!

Got it already!

Was this reply helpful? Yes No
Verified answer

Pankaj Gogoi 3,177 on at

Like (1)

Report
Copy link

Link copied!

Hi Benjamin,

Good you are able to resolve it. For reference, you can also use the FetchXMLBuilder to generate oData queries from FetchXML

Best Regards

PG

Was this reply helpful? Yes No
kokane Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you PG. FetchXMLBuilder is a good tool.

Was this reply helpful? Yes No
Benjamin Fallar III 245 on at

Like (0)

Report
Copy link

Link copied!

Web API doesn't support INNER join, so instead of using OData filter expression, I used the expression /contacts(guid) and use the $expand

Was this reply helpful? Yes No