Forum Discussion
Dynamic URL for changing date
Hey guys,
i need to connect to data via a web API. The URL looks like this: https://hello123.testsite.net/Api/MessageCenter?action=date&value=2022-02-14.
It would be very nice, to have the last part of the url (date) dynamic. An suitable use would be an updated url every 10 days to load the data.
Has anyone an idea?
Thank you 😉
In Power Query, open Advanced Editor and replace your Source with this
Source = Web.Page(Web.Contents("https://hello123.testsite.net/Api/MessageCenter?action=date&value=" & DateTime.ToText((DateTime.FixedLocalNow()),"yyyy-MM-dd")))
4 Replies
What would be the logic for date in URL...So, on 29-Mar-22, what would be the date in that URL string?
The Logic for 29-Mar-22 would be https://hello123.testsite.net/Api/MessageCenter?action=date&value=2022-03-29
In Power Query, open Advanced Editor and replace your Source with this
Source = Web.Page(Web.Contents("https://hello123.testsite.net/Api/MessageCenter?action=date&value=" & DateTime.ToText((DateTime.FixedLocalNow()),"yyyy-MM-dd")))