Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to write Web Api request with inner join

Posted on by

Hello

I have following fetchXML request:


var fetchXML2 = `
<fetch>
  <entity name="team" >
    <attribute name="name" />
      <filter>
         <condition attribute="name" operator="eq" value="Private access to notes" />
      </filter>
         <link-entity name="teammembership" from="teamid" to="teamid" link-type="inner" >
       <filter>
         <condition attribute="systemuserid" operator="eq" value="${currentUserId}" />
       </filter>
    </link-entity>
  </entity>
</fetch>
`;

Here I just have inner join and condition for each table. Now I need to write Web Api request which will return the same result. My new request must look like "?$select=name&$filter=name eq 'Private access to notes'"; or something like this.

Is there some converter for getting Web Api requests? (for example there is fetchXML creator in Xmr tool box for creating fetchXML requests).  How to write request with inner join?

  • Suggested answer
    Sergi Valero Profile Picture
    Sergi Valero 145 on at
    RE: How to write Web Api request with inner join

    Hello EaredGen!

    Here you have the Microsoft Dataverse Web API guide. You will find information about how it works and also how you can execute different type of actions. If you want to see how filter queries are made without looking all the documentation, I recommend you to see the code Samples, you can find them in JS, HTTPS and also C#, here you have the link to the JS ones.

  • EaredGen2 Profile Picture
    EaredGen2 on at
    RE: How to write Web Api request with inner join

    Hi. Probably you are right.

    My question about JS plugins for Dynamics crm 365, forms customization.

    Thank you for removing)

  • Nya Profile Picture
    Nya 29,056 on at
    RE: How to write Web Api request with inner join

    Hi,

    It seems not to be the feature of Guides application.

    Would you please specify which application you're using in Dynamics?

    And I'll move it to the proper forum for more help.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans