Get Range of dates in API

[Galat198]

Hi,

I have seen some answers on the theme but still can not figure out how to solve a problem.

I'm trying to read data from API :

= Json.Document(Web.Contents("https://********/api/v1/*******/xxxxxx?month=2&year=2020"))

That means each API returns data  for one month

I need to replace a month and a year each time to get data for a different period.

I need to get a table with data from 01/2020 to the current month (that next month will be another month)

I mean I need to somehow merge several APIs to create one table .... or there is another way.

I try to create a parameter, but each parameter returns a single value even if it is a parameter with a list range: the year 2020-2030, month 1-12.

***It must not be produced dynamically, because the Dynamic dataset I cant update on the Power BI WEB Service.

[ImkeF]

Hi @Galat198 ,
moving the query parameters into the query-record should allow refresh in the service.

Json.Document(Web.Contents("https://********/api/v1/*******/xxxxxx",
[Query=[month=2, year=2020]]))

Just have in mind that the original request must be valid, so you might have to leave (some) query parameters present in the initial call (they will be replaced by the dynamic values from the Query-record later):

Json.Document(Web.Contents("https://********/api/v1/*******/xxxxxx?month=2&year=2020",
[Query=[month=<ReferenceToDynamicParameter>, year=<ReferenceToDynamicParameter>]]))

More reading here: Dynamic Web.Contents() and Power BI Refresh Errors – Data Inspirations