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

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