Forum Discussion

palunel's avatar
palunel
Helper I
9 years ago
Solved

How to programmatically set a dymanic URL

Hi there   I want to read the daily exchange rates from www.xe.com but I need to cchange teh URL to include the correct date.  Below is my code but this does not work:   let xDate = Text.From...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    You can use Date.ToText to get the date in the required format.

    Additionally I wouldn't rely on Source{0}, but address the required element.

     

    let
    xDate = Date.ToText(DateTime.Date(DateTime.LocalNow()),"yyyy-MM-dd"),
    Source = Web.Page(Web.Contents("http://www.xe.com/currencytables/?from=ZAR&date=" & xDate )),
    Data0 = Table.SelectRows(Source, each [Id] = "historicalRateTbl"){0}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Currency code ▲▼", type text}, {"Currency name ▲▼", type text}, {"Units per ZAR", type number}, {"ZAR per Unit", type number}})
in
    #"Changed Type"
Punitsetia's avatar
Punitsetia
New Member
8 years ago
Does the data in the table changes automatically everyday or not by using it this query in Importing data.???
MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

Yes, but only if you refresh the query.

  • Punitsetia's avatar
    Punitsetia
    New Member
    8 years ago

    Is there any way in which I can get the Live without refreshing the queries??

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      8 years ago

      That doesn't make sense as the Source of your data is different every day, so how would you expect that data from another source would suddenly appear without refresh?

       

      Maybe you can schedule a refresh; I have no experience with scheduled refresh, but here is more information.