Legacy Dev Forum Posts

 View Only

Sign Up

How to use a Predicate in Post Query of type date?

  • 1.  How to use a Predicate in Post Query of type date?

    Posted 06-05-2025 18:32

    stelapolu | 2024-08-28 14:19:20 UTC | #1

    Hi

    I am working with /api/v2/analytics/teams/activity/query and it is returning data based on TeamId predicate. Not able to to get it work ... I used the same date as I received part of result from previous query.

    I would like to add additional predicate of presenceDate or routingStatusDate (Dimension predicates.Valid values: organizationPresenceId, presenceDate, queueId, queueMembershipStatus, routingStatus, routingStatusDate, systemPresence, teamId, userId).

    Tried different strings like 2024-07-27 / 2024-07-27T22:56:04.022Z,

    Request: { "metrics": [ { "metric": "oTeamPresences", "details": true } ], "groupBy": [ "teamId" ], "filter": { "type": "and", "clauses": [ { "type": "and", "predicates": [ { "type": "dimension", "dimension": "teamId", "operator": "matches", "value": "9c63607a-117c-496d-a9d9-1d6aa45576eb" }, { "type": "dimension", "dimension": "presenceDate", "operator": "matches", "value": "2024-07-27T22:56:04.022Z" } ] } ], "predicates": [ { "type": "dimension", "dimension": "teamId", "operator": "matches", "value": "9c63607a-117c-496d-a9d9-1d6aa45576eb" } ] }, "order": "asc" }

    but getting "message": "For input string: \"2024-07-27t22:56:04.022z\"", "code": "bad.request",

    "message": "For input string: \"2024-07-27\"", "code": "bad.request",

    Any pointers would be appreciated.


    system | 2024-09-27 14:20:10 UTC | #2

    This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.


    This post was migrated from the old Developer Forum.

    ref: 28774