Power Query api pagination

Question

Hello,

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.

let
Source = Json.Document(Web.Contents("https://wwwwwwwww.zendesk.com/api/v2/incremental/tickets.json?start_time=1667808000")),
#"Converted to Table" = Record.ToTable(Source)
in
#"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!

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

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