
Hi Experts,
I have to query and retrieve data from dataverse using power page web api. And what I can see is the maximum records the api can return is 5000.
Is there any way setup pagination in the web api so that in each call I will get certain number of records(for ex. 200) as response and making subsequent multiple calls to be able to retrieve all the records.
I see this is possible in dataverse api by setting odata.maxpagesize and after which it returns a link odata.nextLink which can be invoked to get next set of records.
Any assistance regarding this would be super helpful.
Thank you.
You can use the odata.maxpagesize inside Power Pages api calls (my tool Dataverse REST Builder supports it inside the Portals syntax) but I don't know (as I don't have an instance to check) which kind of odata.nextLink property you retrieve (and if is returned or not) but after you get it you just call the url returned.