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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

HTTP GET capped at 50

(0) ShareShare
ReportReport
Posted on by 8

I have a working Flow that accesses our ERP system using a pregenerated token, and accesses tables and columns named in a URI. My issue is that I max out at 50 responses. I can't use pagination because that presumes an array is coming as output, and this is purely a JSON blob (though at least one that I can manipulate into an array later). I did see another forum's post where a link to a continued result was available, but I don't get any links returned. Anyone have suggestions as to how I could retrieve all records using the Flow?

 

And no, we can't presume I have direct SQL access. 

Categories:
I have the same question (0)
  • edguerre Profile Picture
    Microsoft Employee on at

    Hi,

     

    Are you getting all 50 responses on a single JSON blob?

    Are you able to post an example here?

     

    It appears the 50 item limitation is coming from your side, so the best suggestion would be to find a way to use pagination. Any chance you can change the output to an array?

     

    Cheers,

    Eduardo

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 Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard