how to do pagination in MS Dynamics REST APIs

(1) 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?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No