cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

ODATA REST API max page size > 2000

Prem-IKEA
12-Amethyst

ODATA REST API max page size > 2000

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

1 ACCEPTED SOLUTION

Accepted Solutions

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 

View solution in original post

6 REPLIES 6
SachinSharma
14-Alexandrite
(To:Prem-IKEA)

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

 

Thanks Sachin.

 

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

Did you find any solution for this?

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

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 

View solution in original post

Hi @aaronjlarson.

 

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

 

Regards.

 

--Sharon

Announcements