variable in API URL JSON

[Anonymous]

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 this :

Source = Json.Document(Web.Contents(XXXXXX&from_date=2018-07-01+00%3A00%3A00&to_date=2018-07-18+12%3A00%3A00&XXXXX"))

Now I need to set to_date as TODAY() in yyyy-mm-dd hh:mm:ss format. Help me with this.

Thanks and Regards,

Piyush

[v-jiascu-msft]

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]

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]

Hi Piyush,

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

Best Regards,

Dale