Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

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 la...

Vijay_A_Verma
4 years ago
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")))

Anonymous

Not applicable

4 years ago

Thank you !