Dynamic URL for changing date

[Anonymous]

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 😉

[Anonymous]

Thank you !

[Anonymous]

The Logic for 29-Mar-22 would be https://hello123.testsite.net/Api/MessageCenter?action=date&value=2022-03-29

[Vijay_A_Verma · Accepted solution]

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

[Vijay_A_Verma]

What would be the logic for date in URL...So, on 29-Mar-22, what would be the date in that URL string?