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

Announcements

News and Announcements icon
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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 463

#1
Valantis Profile Picture

Valantis 463

#3
11manish Profile Picture

11manish 264

Last 30 days Overall leaderboard