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.

 

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"))]),

 

 

 

 

1 Reply

  • 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