Dynamically update URL with tomorrow date

[Syndicate_Admin]

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 ate of tomorrows date to the end of the API address.

&date=YYYY-MM-DD

So the end result would look like this:

Is this possible?

[Syndicate_Admin · Accepted solution]

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"))),