News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum how to do pagination i...

Dynamics 365 general forum

Suggested answer

how to do pagination in MS Dynamics REST APIs

(1) Share

Report

Report

Posted on by Dishant Sharma

30

I want to implement pagination in the API:

[dynamics_instance_url]/api/data/v9.0/roles?$select=_businessunitid_value,roleid

Currently, it is giving me a list of all the security roles inside the MS Dynamics instance. I want to get 50 results at a time. I tried implementing the

$top and $skip query parameters but, the $skip parameter is only supported in the CRM platform.

How can I implement the pagination on the returned response irrespective of the Dynamics platform?

Categories:

Other Functionality

Applications and Add-ons

Customization / Solutions / SDK and API

Integration with Other Products

Email and Office Integration

Dynamics 365 Administration

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

how to do pagination in MS Dynamics REST APIs?

Hi Partner,

Please refer to the following link:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api#page-results

Dataverse doesn't support the $skip query option, so you can't use the the combination of $top and $skip for paging.

1.Paging Regular Queries

Use the Prefer: odata.maxpagesize request header to control the number of records returned.

2.Paging with FetchXML

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/use-fetchxml-web-api#paging-with-fetchxml

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2

Martin Dráb 228,625 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans