My web source has a dynamic date, I want it to always return today's date. I'm trying to create a work around to be able to refresh dynamic data in the cloud via BI but it's throwing back an error
Code causing the issue:
Source = Json.Document(Web.Contents("https://www.examplewebsite.com/data/date"), [RelativePath="date:"&(Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"))])Example url: https://www.examplewebsite.com/data/date/date:2023-06-19


Report
All responses (
Answers (