Power Query api pagination

Patrick Arrastia 21 Reputation points
2022-11-09T00:19:12.58+00:00

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.

258446-image.png

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!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
    2022-11-09T00:32:19.267+00:00

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


0 additional answers

Sort by: Most helpful