Forum Discussion

Madhu155154's avatar
Madhu155154
Helper I
2 years ago
Solved

How to change static date to dynamic date in API, for refreshing data - to current date

Any suggestion on how to change the "end date" from static to "dynamic to the (current) Present date" for capturing the data till the current date, while refreshing it, Data - I got the data throu...
Need Help
  • Madhu155154's avatar
    Madhu155154
    2 years ago

    I have used the below formula to get the date and  then passed it as a parameter in API, But Thank you for your support and suggestion 

    currentDate = Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),


    let

    currentDate = Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),


    Source = Json.Document(Web.Contents("https://cs-intmgroservices.io/intmgmtsvc/report/nReport" & "?startDt=2020-01-01&endDt=currentDate",



Madhu155154's avatar
Madhu155154
Helper I
2 years ago

I have used the below formula to get the date and  then passed it as a parameter in API, But Thank you for your support and suggestion 

currentDate = Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),


let

currentDate = Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),


Source = Json.Document(Web.Contents("https://cs-intmgroservices.io/intmgmtsvc/report/nReport" & "?startDt=2020-01-01&endDt=currentDate",