Skip to main content
P
Prem-IKEA14-Alexandrite
14-Alexandrite
September 23, 2020
Solved

ODATA REST API max page size > 2000

  • September 23, 2020
  • 1 reply
  • 3488 views

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

Best answer by aaronjlarson

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 

1 reply

S
SachinSharma16-Pearl
16-Pearl
September 23, 2020

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

 

P
Prem-IKEA14-AlexandriteAuthor
14-Alexandrite
September 23, 2020

Thanks Sachin.

 

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

A
aaronjlarson14-Alexandrite
14-Alexandrite
February 18, 2021

Did you find any solution for this?

Terms & ConditionsCookie settingsAccessibility statement