Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Expression.Error: dynamic date in web source url

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. ...
PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

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