We are attempting to construct an Analytics API aggregation query that groups interaction data by both queue and media type. The goal is to retrieve a summary of handle times and wait times for specific queues across voice and chat channels.
The endpoint is POST /api/v2/analytics/interactions/aggregates. Here is the request body we are sending:
{
"interval": "2023-10-01T00:00:00Z/2023-10-02T00:00:00Z",
"metrics": [
{ "id": "handleTime" },
{ "id": "waitTime" }
],
"groupings": [
{ "id": "queueId", "type": "string" },
{ "id": "mediaType", "type": "string" }
],
"filter": {
"type": "and",
"clauses": [
{
"dimension": "queueId",
"type": "in",
"values": ["queue-uuid-1", "queue-uuid-2"]
}
]
}
}
The API returns a 200 OK status, but the data array in the response is completely empty. We have verified that the queue IDs are correct and that interactions occurred during the specified interval. The same query works if we remove the mediaType grouping, but adding it back results in no data returned. Is there a limitation on combining these specific grouping types?