Forum Discussion

DocDri's avatar
DocDri
Icon for Helper I rankHelper I
3 years ago
Solved

Hand over date from last year to URL

Hello,   what I want to do is to hand over the date from last year (-365 days) to a URL as text for my web source. As I'm pretty new to power query I tried this:   Source = Json.Document(Web.Cont...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Please try this syntax instead.

     

    = Json.Document(Web.Contents("https://myurl.com/visits?startDate=" & Date.ToText(Date.AddYears(Date.From(DateTime.LocalNow()), -1), "yyyy-MM-dd") & "&limit=500"))

     

    Pat

ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

Please try this syntax instead.

 

= Json.Document(Web.Contents("https://myurl.com/visits?startDate=" & Date.ToText(Date.AddYears(Date.From(DateTime.LocalNow()), -1), "yyyy-MM-dd") & "&limit=500"))

 

Pat

  • DocDri's avatar
    DocDri
    Icon for Helper I rankHelper I
    3 years ago

    Thank you!