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 & ....

AntrikshSharma's avatar
AntrikshSharma
Community Champion
3 years ago

AI14 You want a single day's data? You can replace those dates with this:

 

= Date.ToText ( 
    Date.From ( 
        DateTime.LocalNow ( ) 
    ), 
    [Format = "yyyy-MM-dd", Culture = "en-US"] 
)

 

  • AI14's avatar
    AI14
    Helper III
    3 years ago

    Thanks,

     

    could this also be done if i set it yesterday instead of today?

    also is it possible to have it linked to a cell where dat is entered?

     

    • AntrikshSharma's avatar
      AntrikshSharma
      Community Champion
      3 years ago

      AI14 Are you using Excel for this? Then you can create a new query from a particular cell and then reference that query in the above code.

      • AI14's avatar
        AI14
        Helper III
        3 years ago

        yes i am, sorry i didnt mention it.