Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rest API Dynamic Date Query

Hi Everyone. I am having a problem with the Ariba API dynamic time filter. Code is listed below.   Source = Json.Document(Web.Contents("https://openapi.ariba.com/api/analytics-reporting-details...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    You can adjust your code to:

    let
    startMonthDate = Date.StartOfMonth( Date.From( DateTime.LocalNow() ) ) ,
    endDate = Date.AddDays(  startMonthDate , -1 ),
    startDate = Date.AddMonths( startMonthDate , -2 ),
    endDateText = Date.ToText( endDate, "yyyy-MM-ddT00:00:00Z" ),
    startDateText = Date.ToText( startDate, "yyyy-MM-ddT00:00:00Z" ),
    Custom1 = "https://openapi.ariba.com/api/analytics-reporting-details/v1/prod/views/templatename?realm=myrealm&filters={""createdDateFrom"":"& startDateText &",""createdDateTo"":"&endDateText&"}"
in
    Custom1

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 


Are you looking for the current month and previous or last two months?

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Mariusz - Please help. I have a similar requirement and struggling as I dont understand programming that well. I am trying to simply get the end date to dynamically pick the previous day or yesterdays date (i.e today -1). Below is my code that is picking a particular date range at the moment I need help with the end date to change dynamically. 

 

url = "https://abc.abcedfoperations.com/abcccc-adminisabc/c3/GetDataBCDEFG",
body = "{""filters"":{""fromDate"":""2020-01-01"",""endDate"":""2021-03-25""}}",
Parsed_JSON = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_JSON),
Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json",#"Authorization" = "Bearer "&APILoopBackToken(),#"Ocp-Apim-Subscription-Key" = "abcdefxxxxxxxabcdefxxxxxabc"],
Content = Text.ToBinary(body) ] )),
Response = Source[Response],
#"Converted to Table" = Table.FromList(Response, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Entity",.........