Dynamically update URL with tomorrow date

(0) Share

Report

Posted on by mattadams84

Hello,

In excel i have a power query that fetches data from a web JSON API. What i would like to be able to do is to append the URL of this API so that it is automatically appended to include tomorows date at the end.

Here is how i currently call the api:

Source = Json.Document(Web.Contents("https://api.football-data-api.com/todays-matches?key=xxxxx")),

What i need to do is add, in this format, the date of tomorrows date to the end of the API address.

&date=YYYY-MM-DD

So the end result would look like this:

Source = Json.Document(Web.Contents("https://api.football-data-api.com/todays-matches?key=xxxxx&date=YYYY-MM-DD")),

Is this possible?

All responses (1)

Answers (1)

Verified answer

mattadams84 9 on at

Like (0)

Report
Re: Dynamically update URL with tomorrow date

After some searching, i found my own solution :
Source = Json.Document(Web.Contents("https://api.football-data-api.com/todays-matches?key=xxxxx&date=" & Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()), 1), "YYYY-MM-DD"))),