Forum Discussion

LangeJan's avatar
LangeJan
Helper I
5 years ago
Solved

HTTP variable query params

Hello everyone

 

I am creating a Power BI report with data from http requests e.g.

https://api.openaq.org/v1/cities 

 

From my report I would like to be able to control Query Params so I e.g. can choose city.

https://api.openaq.org/v1/cities?city=007 

 

I can set the parameter city=007 in M ​​query but I have not been able to do this param variable.

 

M query:

 

let  

   cities_url = "https://api.openaq.org/v1/cities", //Web Url

   request_limit = "10000", //number represented by a string

   request_city = "007",

   Source = Json.Document(Web.Contents(cities_url, [Query = [city = request_city,limit = request_limit]])),

    results = Source[results],

    results1 = results{0}

in

    results1

 

 

Is it possible to make a report with variable query params?

 

Let me know if any further information is necessary

Thanks

3 Replies