Forum Discussion
Add dynamic dates in API Source url
Hi, I have connected to a online system using API url and Auth key. Below is my code. This I enter in the blank query as source step. = Json.Document(Web.Contents("https://xyz.com.au/api/", [...
Hi, I am still getting these errors. I have added the code above.
Also, before I put static date values, I used this code. I was told to use this date format to get the output
= Json.Document(Web.Contents("https://xyz.com.au/api/",
[Query=[
dbtable="statementitems",
fundingtype= "2",
DateStart = "01/Jun/2024",
Date.End = "29/Jun/2024",
Authkey = ApiKey,
includedeleted = "yes",
toprestrict = "1000000",
source= "powerBI"
]]
))