Power Query api pagination

Patrick Arrastia 21 Reputation points


I am trying to paginate through an unknown number of pages. There is a value in the table called "end_of_stream", which I think could be used for this. Once there are no more pages the "end_of_stream" value = true.
I believe there is a way to use List.Generate to achieve this just unsure of how to get there.


Source = Json.Document(Web.Contents("https://wwwwwwwww.zendesk.com/api/v2/incremental/tickets.json?start_time=1667808000")),
#"Converted to Table" = Record.ToTable(Source)
#"Converted to Table"

Ideally, PQ will loop through the pages until it sees the "end_of_stream" value = true.

This particular api uses cursor-based pagination as opposed to offset with a max of 100 per page

Many thanks!258426-end-of-stream.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,987 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dave Patrick 426.3K Reputation points MVP

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at

    --please don't forget to Accept as answer if the reply is helpful--

0 additional answers

Sort by: Most helpful