Forum Discussion

AI14's avatar
AI14
Helper III
3 years ago
Solved

Dynamically Change date range of web source (api link)

Im new to powerquery and have made a connection to a site using APi key. im trying to avoid going into the source every day to look at yesterdays data or any previous day. how can i do this dynamic...
Need Help
Show and Tell
  • AntrikshSharma's avatar
    AntrikshSharma
    3 years ago

    AI14You need to include to and from in double quotes .... & "from=" & DateParameter & "to=" & DateParameter & ....

AI14's avatar
AI14
Helper III
3 years ago

I meant i done this also and still not pulling data.

 

usually date range is "form=2022-11-20&" "to=2022-11-20&"

 

= Json.Document(Web.Contents("https://www.findmyshift.co.uk/api/1.4/reports/hours?" & "apiKey=xxxxx&" & "teamId=y22t0l5t4i&" & from=DateParameter & to=DateParameter & "timesheetData=yes&" & "additional-columns=staff.jobtitle&" & "additional-columns=staff.department"))

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    3 years ago

    AI14You need to include to and from in double quotes .... & "from=" & DateParameter & "to=" & DateParameter & ....

    • AI14's avatar
      AI14
      Helper III
      3 years ago

      = Json.Document(Web.Contents("https://www.findmyshift.co.uk/api/1.4/reports/hours?" & "apiKey=xxxxx&" & "teamId=y22t0l5t4i&" & "from=" & DateParameter & "to=" & DateParameter & "timesheetData=yes&" & "additional-columns=staff.jobtitle&" & "additional-columns=staff.department"))

       

      not working, i think its because its creating additional line in code when the date should be after the from= and to=