Legacy Dev Forum Posts

 View Only

Sign Up

Missing data when filter predicate is removed

  • 1.  Missing data when filter predicate is removed

    Posted 06-05-2025 19:26

    Sree | 2024-08-09 14:09:25 UTC | #1

    Hi Gurus, I have the below request body for a POST call to the Aggregate Queries api - https://api.mypurecloud.de/api/v2/analytics/conversations/aggregates/query

    
     {
         "interval": "2023-01-16T00:00:00Z/2023-01-18T00:00:00Z",
         "granularity": "PT15M",
         "groupBy": [
             "activeSkillId",
             "direction",
             "divisionId",
             "dnis",
             "edgeId",
             "mediaType",
             "queueId"
         ],
         "filter": {
             "type": "and",
             "predicates": [
                 {
                     "type": "dimension",
                     "dimension": "queueId",
                     "operator": "exists",
                     "value": None
                 },
                 {
                     "type": "dimension",
                     "dimension": "divisionId",
                     "operator": "matches",
                     "value": "66a65635-ca81-483a-a730-xxxxxxxxxxxx"
                 },
                 {
                     "type": "dimension",
                     "dimension": "requestedRoutingSkillId",
                     "operator": "matches",
                     "value": "6ddd1266-4bc6-4e61-b43a-xxxxxxxxxxx"
                 }
             ]
         },
             "metrics": [
             "tFlowOut"
         ],
         "flattenMultivaluedDimensions": True
     }

    Note - The filter contains the predicate for the dimension requestedRoutingSkillId. I receive tFlowOut data for this request.

    However, when I remove the filter for the dimension requestedRoutingSkillId, I receive no tFlowOut data for this SkillID at all. Any ideas why removing the filter results in not getting the data in response.

    What is more confusing is that for another interval, I receive the data for this requestedRoutingSkillId even when filter is not applied.

    Kindly help with you inputs.


    system | 2024-09-09 10:40:29 UTC | #2

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


    This post was migrated from the old Developer Forum.

    ref: 27801