Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Retrieve Accounts data from D365 using FetchXML for Web app + Azure publication

Posted on by 10

Hello,

I have a task to retrieve Accounts and related Contacts number from D365 using FetchXML method. I also need to make a C# web app and publish it on Azure.

Can anyone explain to me what is an exact process to use FetchXML in order to get required data? I need code example.

Which data should I pass in order to establish connection to CRM? 

Do I need to get token and pass the header afterwards or FetchXML works in some other way?

So Far I managed to find some examples from 2016. but it is not working.

Thank you in advance.

Categories:
  • Suggested answer
    LeoAlt Profile Picture
    LeoAlt 16,329 on at
    RE: Retrieve Accounts data from D365 using FetchXML for Web app + Azure publication

    Hi partner,

    You could divide the work into two parts.

    1. Create a web app to contect to D365 with C#.

    https://arunpotti.wordpress.com/2018/02/03/step-by-step-to-connect-dynamics-365-crm-online-v9-x-using-c-console-application/

    https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/xrm-tooling/sample-simplified-connection-quick-start

    2. Get the query fetchxml and use it to retrieve data from D365.

    https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-fetchxml-construct-query

    https://carldesouza.com/dynamics-365-fetchxml-c/

    Hope it helps.

    Best Regards,

    Leo

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

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

Featured topics

Product updates

Dynamics 365 release plans