Forum Discussion
Syndicate_Admin
4 years agoAdministrator
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
- Syndicate_AdminAdministrator
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"))),