Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How get the Dynamically date range in API link?

Hi, I have this code that imports all currency rates.   let Source = Json.Document (Web.Contents("https://api.exchangerate.host/timeseries?start_date=2021-01-01&end_date=2021-01-20&base=USD&s...
Need Help
  • artemus's avatar
    artemus
    5 years ago

    Oh, sorry, wrong function... should be DateTime.ToText, not DateTime.Format

artemus's avatar
artemus
Microsoft Employee
5 years ago

Inside your url:

"https://api.exchangerate.host/timeseries?start_date=2021-01-01&end_date=2021-01-20&base..."

Insert the dynamic date

"https://api.exchangerate.host/timeseries?start_date=2021-01-01&end_date=" & DateTime.Format(DateTime.LocalNow(), "yyyy-MM-dd") & "&base..."
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    artemus 
    Hi,
    It returns an error:

     

    • artemus's avatar
      artemus
      Microsoft Employee
      5 years ago

      Oh, sorry, wrong function... should be DateTime.ToText, not DateTime.Format