web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Retrieve all records of a view in an entity Dynamics365

(0) ShareShare
ReportReport
Posted on by

Hi All, I am new to dynamics api, please help with the following"

I want to retrieve all dynamics records data in json format within a view in an entity. I obtained the viewId from the URL in browser, assume it's viewId-bla-bla

I used "https://[rootblabla]/api/data/v9.0?savedquery=viewId-bla-bla" on a URL in browser, but the  json reponse rendered seems like metdata, i.e, not the records information in that view. 

{

"@odata.context": "https://[root]/api/data/v9.0/$metadata",

"value": [

{"name": "accountleadscollection","kind": "EntitySet","url": "accountleadscollection"},

{"name": "accounts","kind": "EntitySet","url": "accounts"},

{"name": "aciviewmappers","kind": "EntitySet","url": "aciviewmappers"},

......

]

}

What should I use as the retrieve URL, so that I can have the returned response containing the records within that view please?

Thank you very much.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Michel van den Brink Profile Picture
    4,697 on at

    Hello suehh,

    The URL of the API call isn't quite correct. You are missing the entity name and the Q in 'savedQuery' needs to be a capital (crazy detail)

    Try this URL:

    https://organizationname.crm.dynamics.com/api/data/v9.0/accounts?savedQuery=00000000-0000-0000-00AA-000010001002


    Make sure to replace the organization name, entity name and the guid of the view with your own :-)

  • Suggested answer
    Community Member Profile Picture
    on at

    Hello,

    I will also go with Michel van den Brink answer.

    Hope it will work for you!

  • Community Member Profile Picture
    on at

    Thank you Michel. I used https://[root]/api/data/v9.0/[entityname]?savedQuery=[viewId] and it worked.

  • Michel van den Brink Profile Picture
    4,697 on at

    Any time! Here to 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
AS-17030037-0 Profile Picture

AS-17030037-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans