HTTP GET capped at 50

(0) Share

Report

Posted on by LVanella

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.

All responses (1)

Answers (0)

edguerre Microsoft Employee on at

Like (0)

Report

Re: HTTP GET capped at 50

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