ODATA REST API max page size > 2000

6 replies
3553 views
Translate All

Hello,

How to set maxpagesize as greater than 2000. I have custom odata api which would return more than 2000 records. So I wan t to return all the records in single responce. Please assist.

Regards

Prem

A

aaronjlarsonAnswer

14-Alexandrite

I've found an alternative solution. I'm creating dashboards in PowerBI. The method here provides a fairly straightforward way to iterate through all the necessary pages and assemble them into a single query result using Power Query.
https://www.myonlinetraininghub.com/scrape-data-multiple-web-pages-power-query