web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / odata.maxpagesize in p...
Power Pages
Unanswered

odata.maxpagesize in powerpage webapi

(0) ShareShare
ReportReport
Posted on by 126

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.

Categories:
I have the same question (0)
  • Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at
    Re: odata.maxpagesize in powerpage webapi

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 66

#2
Fubar Profile Picture

Fubar 47 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard