Expression.Error: dynamic date in web source url

[Syndicate_Admin]

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 (with example url https://www.website.com/data/date/date:2023-06-19😞

Source = Json.Document(Web.Contents("https://www.website.com/data/date"),
[RelativePath="date:"&(Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"))]),

[PhilipTreacy]

Hi @Syndicate_Admin  

You've closed the Web.Contents function too early.  The closing bracket/parenthesis for that function needs to move like this

let
        RelPath = "date:" & Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),
        Source = Json.Document(Web.Contents("https://www.website.com/data/date/" & RelPath))
in
        Source

In addition, trying create a Relative path with a : will give you an other error, something about the URIString not being variable.

That's why I added a step before Source where the Relative Path is created and then that's appended directly to the URL

Regards

Phil