Why does CX REST analyticsReportResults call with filter settings not work (getting wrong data back) while running the same CX Analytics report with identical filter settings works fine from the .NET AgentDesktop(or BUI)>Report Explorer UI?

Environment:

Analytics reporting for Oracle B2C Service via CX REST API

Resolution:

The filters provided in the CX REST analyticsReportResults call is actually getting matched with the filter "Name" defined in the .NET AgentDesktop>Report Design tool. See screenshot below. Hence, if CX REST analyticsReportResults call did not have the matching "Name" filter settings, it would lead to getting wrong results back.

We can fix this by providing a name for the filter in Name text-box and use the same filter name in the CX REST analyticsReportResults call.

 

 

 

 

Here is the sample JSON filter settings (with matching filter "Name") for the CX REST analyticsReportResults call to the above custom custom Analytics report (say id: 101000):

{
"id": 101000,
"limit": 100,
"filters":
  [
    {
    "name": "answers.search_nl",
    "values": "cellular"
    },
    {
    "name": "answers.map_cat_hierarchy",
    "values": ["1.161", "2.77"]
    }
  ]
}