List.Generate Pagination Help?

[rsderby68]

Hello All, 

I have this Query below that does a POST REST API call for results.  Note the "Page=" where I can specify a page of results.  I'm trying to figure out how to paginate this to get all results.  I think it would somehow use List.Generate to check against a null value?  Would someone help out?  Note that with this API the total record count value is in a return header which I gather from reading we can't actually see in Power Query/Power BI?  Normally I would use that record count to create a table of that number.  Help?  

let

url = "https://tessy.com/tessituraservice/Reporting/Lists/182243/Results",

body = "OutputSetId = 1137"&"Page=1",

Source = Json.Document(Web.Contents(url,[Headers = [#"Authorization"="Basic <<encoded>>", #"Content-Type"="application/x-www-form-urlencoded"], Content = Text.ToBinary(body)]))

in

    Source

[rsderby68 · Accepted solution]

I got this working using a different method found on youtube.  thanks!

[ppm1]

Please see Method 3 in this article to see how to do this. The example is pretty close to your scenario.

Handling Paginated REST API Results with Power Query | John Dalesandro

Pat

[Anonymous]

Hi @rsderby68 ,

You can try to remove "&"Page=1" and run again to get all pages.

Or you need to get the maximum number of pages according to your API.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.