cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dwalker97
Helper II
Helper II

HTTP action max output 1000

I'm using the HTTP action with GET method to retrieve a corporate tree. The only thing is, it produces a limit of 1,000 records in the output. I tried turning Pagination on with a threshold of 50,000 but the error message states: 

 

The response is not a valid paginated response. The paginated response is missing a property 'value' of type array.

 

I'm not sure where to go from here and how to fix this. Has anyone come across this problem before?

1 ACCEPTED SOLUTION

Accepted Solutions
Johnnyg
Community Support
Community Support

Hello dwalker97,
There's no 1000 limits from Http connector end as I know while there's Message size, time out & character limits under http request: 
https://docs.microsoft.com/en-us/power-automate/limits-and-config#http-limits

In addition, the paginated option is setting for array data.

From the error message, I think the Data type you have used in the flow is not array. 

Johnnyg_0-1635079911158.png

I wonder whether there's any parameter in the API which helps set the 1000 limit? Have you tried the API in other service like Postman whether it would return more than 1000 records? In addition, have you tried with Http with AAD connector?

Johnnyg_1-1635080061597.png

 

 

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Johnnyg
Community Support
Community Support

Hello dwalker97,
There's no 1000 limits from Http connector end as I know while there's Message size, time out & character limits under http request: 
https://docs.microsoft.com/en-us/power-automate/limits-and-config#http-limits

In addition, the paginated option is setting for array data.

From the error message, I think the Data type you have used in the flow is not array. 

Johnnyg_0-1635079911158.png

I wonder whether there's any parameter in the API which helps set the 1000 limit? Have you tried the API in other service like Postman whether it would return more than 1000 records? In addition, have you tried with Http with AAD connector?

Johnnyg_1-1635080061597.png

 

 

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,601)