ODATA REST API max page size > 2000

[Prem-IKEA]

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

[SachinSharma]

You can refer below articles for the information you are looking for,

https://www.ptc.com/en/support/article/CS328466

https://www.ptc.com/en/support/article/CS294238

[Prem-IKEA]

Thanks Sachin.

But I want to return more than 2000 objects in single response without next link url.

[aaronjlarson]

Did you find any solution for this?

[slangley]

Hi @aaronjlarson.

From what I was able to find, 2000 is the max.  You can submit a request on the ideas page if you would like to suggest a different value.

Regards.

--Sharon

[aaronjlarson · Accepted solution]

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 

[slangley]

Hi @aaronjlarson.

Thank you for your follow up to advise the solution you found.

Regards.

--Sharon