how to do pagination in MS Dynamics REST APIs

(0) Share

Report

Posted on by Dishant Sharma

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

Mobile Apps

Applications and Add-ons

Customization / Solutions / SDK and API

Integration with Other Products

Email and Office Integration

Dynamics 365 Administration

All responses (1)

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