Jump to content

Jason Willis

Members

  • Joined

  • Last visited

View Profile Find content

Reputation Activity

  1. Upvote
    Jason Willis got a reaction from Jamie Taylor in Filter results by DateTime   
    Just seen the email, thank you @Jamie Taylor
  2. Like
    Jason Willis got a reaction from Jamie Taylor in Filter results by DateTime   
    Hoping someone can help with this as I can't find a clear answer...
    I have a simple query to call from the servicedesk/tickets endpoint, but I'm unable to get the filter working with a DateTime column.
    In the code block below, Filter 1 (on the TickerNumber) & Filter 2 (on the SLA Status) both work fine and give the expected results, but Filter 3 (on Actual Resolution) returns a (400): Bad Request error. It does this whether I create the datetime programmatically as in Filter3, or hard-code it as in Filter4.
    let Token = "TOKEN GOES HERE", BaseURL = "https://psa.pulseway.com/api/", Path = "servicedesk/tickets", Day = Date.Day(Date.From(DateTime.LocalNow())), Month = Date.Month(Date.From(DateTime.LocalNow())), Year = Date.Year(Date.From(DateTime.LocalNow())), Date = DateTime.ToText(#datetime(Year, Month, Day, 00, 00, 00), "yyyy-MM-ddThh:mm:ss"), Filter1 = "?$filter=endswith(TicketNumber, '2022')", Filter2 = "?$filter=StatusSLAEventId gt 1", Filter3 = "?$filter=ResolutionActualTime gte " & Date, Filter4 = "?$filter=ResolutionActualTime gte 2022-01-03T00:00:00.000Z", Source = Json.Document(Web.Contents(BaseURL & Path & Filter4, [Headers = [Authorization="Bearer " & Token]])) in Source Does anyone know where I'm going wrong?
    Thank you in advance!