Skip Navigation
Expand
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"
		}
	]
}