Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 😉
Solved! Go to 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")))
Thank you !
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")))
What would be the logic for date in URL...So, on 29-Mar-22, what would be the date in that URL string?