Hi,
I was trying to do a POST request using this endpoint via Postman:
https://api.bitmovin.com/v1/analytics/queries/count
Here is the request body:
{
"start": "2022-07-18T17:00:00Z",
"end": "2022-08-23T17:00:00Z",
"licenseKey": "{{bitmovin_analytics_key}}",
"limit": 200,
"offset": 0,
"filters": [
{
"name": "CUSTOM_DATA_3",
"operator": "NE",
"value": null
}, {
"name": "CUSTOM_USER_ID",
"operator": "NE",
"value": null
}, {
"name": "DOMAIN",
"operator": "NE",
"value": "localhost"
}
],
"groupBy": [
"CUSTOM_DATA_3",
"CUSTOM_USER_ID",
"DAY",
"BROWSER",
"COUNTRY",
"DOMAIN",
"PLATFORM",
"DEVICE_CLASS",
"OPERATINGSYSTEM"
],
"orderBy": [
{
"name": "CUSTOM_DATA_3",
"order": "asc"
}, {
"name": "CUSTOM_USER_ID",
"order": "asc"
}, {
"name": "DAY",
"order": "asc"
}
],
"dimension": "IMPRESSION_ID"
}
But I keep getting this result:
{
"requestId": "something-something",
"status": "ERROR",
"data": {
"code": 5003,
"message": "Error querying analytics!",
"developerMessage": "Attempting to groupBy a very high cardinality column that cannot be aggregated. Please filter the query result."
}
}
This POST request will run successfully if I only include up to 4 of any attributes in the groupBy
.
The problem is, if I can, I want to keep include all of those attributes as they are.
Is there any solution?
Thanks before