web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / multiple level of expa...
Microsoft Dynamics CRM (Archived)

multiple level of expansion in webapi

(0) ShareShare
ReportReport
Posted on by svignesh 347

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

I have the same question (0)
  • Suggested answer
    EricRegnier Profile Picture
    EricRegnier 2 on at
    multiple level of expansion in webapi
    Hi @svignesha and @Bipin_D365,
    Note that N:N (many-to-many) relationship are supported with Web API. There's also a nice tool from XrmToolBox to easily manage Web API request especially more complex ones: https://www.xrmtoolbox.com/plugins/GuidoPreite.DRB/
     
    Here's an example of an expand on a N:N relationship: 
    ​​​​​​​$expand=new_gridlayerdimension_entities($select=new_entityid)&$filter=acn_gridlayerentitydimensionid eq 07f55627-fc91-ef11-8a69-6045bd9883e2
    Hope this helps!
  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,981 Moderator on at
    RE: multiple level of expansion in webapi

    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.

  • Johao Larios Profile Picture
    Johao Larios 1,795 on at
    RE: multiple level of expansion in webapi

    Hello Vicky,

    Please take a look on this one:

    docs.microsoft.com/.../query-data-web-api

    Check this one as well:

    docs.microsoft.com/.../retrieve-related-entities-query

  • Vicky patidar Profile Picture
    Vicky patidar 10 on at
    RE: multiple level of expansion in webapi

    Hi

    I there any solution for above issue.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Guido Preite Profile Picture

Guido Preite 5 Moderator

#2
sandeepc Profile Picture

sandeepc 2

#2
Community Member Profile Picture

Community Member 2

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans