Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Dynamically update URL with tomorrow date

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?

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

1 Reply

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