Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

variable in API URL JSON

Hello people, I am using a JSON API string to fetch date from a date range which is parameterized. Because of that I have to change values everyday to fetch details. This URL look something like thi...
General Comment
Need Help
Tutorial Requests
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Piyush,

 

Please try the function datetime-localnow. It could be like below.

let
    now = DateTime.LocalNow(),
    Source = Json.Document(Web.Contents(XXXXXX&from_date=2018-07-01+00%3A00%3A00&to_date=now))
in
    Source

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Dale,

    Thanks for your help. I tried your way but it's not resolving my purpose instead it's showing following error :

     

     

    I also tried this -> now = Date.AddDays(Date.From(DateTime.LocalNow()),-1),

    Kindly suggest

     

    Thanks,

    Piyush

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Piyush,

       

      It seems the error was raised by other errors. Can you share the file or the Power Query code?

       

      Best Regards,

      Dale