News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... how to do pagination i...

Microsoft Dynamics 365 | Integration, Dataverse...

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?

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... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans