Help with Power Query M POST to API for results?

[Syndicate_Admin]

I am working with an API that requires a POST command to get results from a list.  It includes a Key I need to add to the body.  See how it looks in Postman below.  Also, note that the result Headers include fields I need for setting up a pagination list.

Would someone give me suggestions here on how to create this in Power Query M?  I tried a few things from articles but only got errors.  I’m also unclear how to pull those pagination variables from the header.  I have only used GET commands in API calls for Power Query, which seem reasonably straightforward.  Help?    

POST:  https://tess.com/tessituraservice/Reporting/Lists/182243/Results

With a variable OutputSetId = 1137 set in the Body as “x-www.form-urlencoded”

[Syndicate_Admin]

Note this API requires Basic Authentication. 

[Syndicate_Admin]

I got this partially working using: 

let
url = "https://tess.com/tessituraservice/Reporting/Lists/182243/Results",
body = "OutputSetId = 1137",
Source = Json.Document(Web.Contents(url,[Headers = [#"Authorization"="", #"Content-Type"="application/x-www-form-urlencoded"], Content = Text.ToBinary(body)]))
in
Source

but I don't see in the results the returned header information on pages (see below) that I can use for pagination?  Does anyone know how to set that up to get all the results?  

[Syndicate_Admin]

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.

[Syndicate_Admin]

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

[Syndicate_Admin · Accepted solution]

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