Forum Discussion

k13's avatar
k13
Frequent Visitor
3 years ago
Solved

Dynamic Querying with Static URL and Headers

Gooday, I have a query that needs to be able to schedule refresh.  The following query in desktop can manually refresh:         let day = DateTime.LocalNow() Source = Json.Document(Web.Conte...
Need Help
Tutorial Requests
  • k13's avatar
    k13
    Frequent Visitor
    3 years ago

    Yes, thank you!! This is the code I used to make this work from that link.

    let
day = DateTime.LocalNow()
Source = Json.Document(Web.Contents("URL"&day, 
     [RelativePath = day,
     Headers = 
     [Accept="application/json",
      Authorization="token"
]]))
in

#"Source"