I have an entity called as medicalcase
Each medical case has a subgrid, N:N relationship with an entity called as mcfamily
Each mcfamily has Father, Mother, Child fields which are lookups to contact field
Now if I make a webapi call
http://serverurl/api/data/v8.0/new_medicalcase(caseid)?expand=new_medcase_mcfamily
I get the new_father_value, but I want to expand the Father lookup and get the contact name. How can I do it?
I tried
http://serverurl/api/data/v8.0/new_medicalcase(caseid)?expand=new_medcase_mcfamily($expand=new_father($select=fullname))
But it said
navigation property can't be expanded. Multiple levels of expansion aren't supported.
*This post is locked for comments
$expand=new_gridlayerdimension_entities($select=new_entityid)&$filter=acn_gridlayerentitydimensionid eq 07f55627-fc91-ef11-8a69-6045bd9883e2
Hi,
You can only use expand with lookup field. It does not work with N:N relationship.
To solve your issue you might have to use 2 web api.
If found helpful, Please mark my answer verified.
Hello Vicky,
Please take a look on this one:
docs.microsoft.com/.../query-data-web-api
Check this one as well:
Hi
I there any solution for above issue.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,316 Most Valuable Professional
nmaenpaa 101,156