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"

All responses (4)

Answers (2)

Benjamin Fallar III 245 on at

Like (0)

Report

RE: Web API query using $expand and related entities

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

Like (0)

Report

RE: Web API query using $expand and related entities

Thank you PG. FetchXMLBuilder is a good tool.
Verified answer

Pankaj Gogoi 3,177 on at

Like (1)

Report

RE: Web API query using $expand and related entities

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
Verified answer

Benjamin Fallar III 245 on at

Like (0)

Report

RE: Web API query using $expand and related entities

Got it already!