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 Platform Community / Forums / Power Automate / HTTP GET Record Limit ...
Power Automate
Unanswered

HTTP GET Record Limit - The response is not a valid paginated response. The paginated response is missing a property 'value' of type array.

(0) ShareShare
ReportReport
Posted on by 82

I am making an API call to retrieve client information. The call I am making should return 2,700 records but the limitations of the HTTP step means I am only receiving 1,000. I have tried turning Pagination on and setting the threshold to 5,000 but receiving the following - 

 

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

 

I have also attempted this solution but does not fix my issue: https://powerusers.microsoft.com/t5/Using-Flows/Flow-and-Pagination-Error/td-p/502334   

 

Thanks for your help.

 

Daragh

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

    Hello 

    Have you tried with different account higher privilege's account ?

     

    What API are you trying to get data from?

  • dwalker97 Profile Picture
    82 on at

    Hi Kierian,

     

    What do you mean by higher privileges?

     

    I am using an internal API to pull in client records. 

     

    Thanks

    Daragh

  • dwalker97 Profile Picture
    82 on at

    ^

  • ameetvd Profile Picture
    2 on at

    Hi All

     

    Any workaround available on the below issue. I am stuck on the same issue. I have more than 100000 records and pagination gives me an error: The response is not a valid paginated response. The paginated response is missing a property 'value' of type array.

     

    Is there any possible solution ?

     

    Regards

    Ameet

  • vayinapurapu1 Profile Picture
    233 on at

    have you tried the below fix from github thread?

    https://github.com/MicrosoftDocs/azure-docs/issues/30744

     

    Cheers,

    Vinay. 

  • mkilp91 Profile Picture
    41 on at

    Unfortunately, the API I am using has the same issue where the "nextLink" and "value" keys/properties are called "next" and "results" respectively in the model I am using.

    I do have a work around, granted it is pretty annoying. That said, I am pretty new to programming so take it easy on me if this solution is a bit messy. Here are the steps:

    1. Initialize variables: integer: "count"=1, integer: "offset"=0, array: "response"=[]. Make sure that count is initialized to be greater than 0. It will be reset after the HTTP action returns a response.
    2. Create a Do Until loop where the condition is "@{variables('offset')}>@{variables('count')}"
    3. Within the loop create your HTTP action and use limit and offset query parameters. For example, the URI is "https://{your endpoint}?limit=100&offset=@{variables('offset')}".
    4. Add a Parse JSON action after the HTTP action. Content should come from the body of your HTTP request and then define your schema based on your API's model.
    5. Append to array @{variables('response')}. Value=@{body('Parse_JSON')?['results'].
    6. Set variable "count" from the value in the HTTP response.
    7. Increment offset by the value you set your limit parameter to. In my case 100.

    Once the offset exceeds the count, the loop will stop and you now have an array of your paginated JSON (response).

    I really wish there was a way to tell the HTTP action that a key/property in your payload is the same as the "value" key/property the HTTP action uses to paginate responses. However, this workaround has been a viable solution in my automation development.

    I hope this helps!

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 227

#2
David_MA Profile Picture

David_MA 204 Super User 2026 Season 1

#3
Valantis Profile Picture

Valantis 177

Last 30 days Overall leaderboard