Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
REST API error with analyticsReportResults filter on categories/products
Answer ID 11980 |
Last Review Date 09/12/2023
Why is my analyticsReportResults filter on categories/products not working?
Environment:
ConnectRest API
Oracle B2C Service
Resolution:
To setup filtering on a report in regards to categories, make sure to include the categories level. This can be done in a similar fashion with products filter as well.
The JSON body would need to be called like this for a category:
{
"id": {report id},
"filters": [
{
"name": "category",
"values": "{level >= 1}.{category id}"
}
]
}
A sub_category would need:
{
"id": {report id},
"filters": [
{
"name": "category",
"values": "2.category_id"
}
]
}