topic Re: Passing Variables in API Post Request JSON Body in Power Query

Passing Variables in API Post Request JSON Body

pelucapampa — Tue, 23 Oct 2018 19:02:05 GMT

Hi all, I've a Public API, i defined all of Headers parameters

HEADERS

X-PW-AccessToken <your_api_token>

X-PW-Application developer_api

X-PW-UserEmail <your_email_address>

Content-Type application/json

But the next requierement from de API it's include a BODY parameters

BODY

{
  "page_size": 25,
  "sort_by": "name"
  
}

It's possible to include that??

Re: Passing Variables in API Post Request JSON Body

pelucapampa — Tue, 23 Oct 2018 20:57:11 GMT

I've put this code and obtain data, but only 20 rows, have any IDEA??

let
 
 url = "https://api.prosperworks.com/developer_api/v1/opportunities/search",

body = "#(lf)[#(lf){#(lf)""page_size"": 2000,#(lf)}#(lf)]#(lf)",
 Source = Json.Document(Web.Contents(url, [Headers=[#"X-PW-AccessToken"="7d9b078105a2dcf7ebde2bd103b2d721", #"X-PW-UserEmail"="inaki@aadesa.com.ar", #"Content-Type"="application/xml", #"X-PW-Application"="developer_api"], Content=Json.FromValue(body)]))
in
 Source

Re: Passing Variables in API Post Request JSON Body

Anonymous — Thu, 25 Oct 2018 02:30:00 GMT

pelucapampa,

It seems your API only gives you 20 rows by default, you can call the API to fetch all pages using Power Query code. For more details, please review the following similar threads.

https://community.powerbi.com/t5/Desktop/how-to-create-a-query-that-paginates/m-p/163768/highlight/false
https://community.powerbi.com/t5/Desktop/Rest-API-Json-several-pages-automatically-call-the-next-page-URL/td-p/236189

Regards,
Lydia