Repeat or loop API request with updated date

[chvizda]

Hi all

I have following simple API request to receive historical weather data:

https://api.weather.com/v2/pws/history/all?stationId=INUSSBAU12&format=json&units=m&date=20180802&apiKey=MYKEY

I want to download the historical data for every day between 2018-08-02 and today. Therefore I must let the request repeat and update the date +1 day.

Is there a way to update the date and loop the request after receiving the data ?

Many thanks in advance

Steffen

[patrick_digan · Accepted solution]

@chvizdaI've attached something for you to start with. You can use a generate rows to generate all the dates needed, create your URL, and then just connect this to a download tool. Hope this helps!

[chvizda]

Thanks that works perfect