Passing Variables in API Post Request JSON Body

[pelucapampa]

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

[pelucapampa]

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"="[email protected]", #"Content-Type"="application/xml", #"X-PW-Application"="developer_api"], Content=Json.FromValue(body)]))
in
 Source

[Anonymous]

@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/f...
https://community.powerbi.com/t5/Desktop/Rest-API-Json-several-pages-automatically-call-the-next-pag...

Regards,
Lydia