Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, I've a Public API, i defined all of Headers parameters
{ "page_size": 25, "sort_by": "name" }
It's possible to include that??
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.