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?
Solved! Go to Solution.
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.
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?
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.
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?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.