Custom Reporting

Custom report endpoints.

Delete Custom Chart

DELETE https://{{account_id}}.acquire.io/api/v1​/analytics/custom-reporting/delete-custom-chart

Delete a custom report. Warning: This action cannot be undone.

Query Parameters

NameTypeDescription

report_key

string

Id of chart to delete

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

{
  "data": {
    "success": true,
    "data": {
      "title": "test chart",
      "config": [
        {
          "key": "id",
          "filters": [
            {
              "key": "id",
              "conditions": [
                {
                  "key": "is",
                  "searchValue": [
                    "1"
                  ]
                }
              ]
            }
          ],
          "joinType": "AND",
          "availableAggregation": [
            "group_by",
            "count",
            "list"
          ],
          "label": "Id"
        }
      ],
      "chartKey": "test-chart",
      "chartType": "table",
      "tenantId": "4wic4e",
      "id": 50,
      "data": [
        {
          "main_case_id": 1,
          "main_contact_id": 1,
          "id": 1
        }
      ],
      "totalCount": 1
    }
  }
}

Create Custom Chart

POST https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/generate-chart

Create a custom chart.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

Request Body

NameTypeDescription

config

array

Array of objects. The configuration of your chart. See example below.

chartType

string

Specify the type of chart. Available charts: "table"

title

string

Chart title

{
  "data": {
    "success": true,
    "data": {
      "title": "test chart",
      "config": [
        {
          "key": "id",
          "filters": [
            {
              "key": "id",
              "conditions": [
                {
                  "key": "is",
                  "searchValue": [
                    "1"
                  ]
                }
              ]
            }
          ],
          "joinType": "AND",
          "availableAggregation": [
            "group_by",
            "count",
            "list"
          ],
          "label": "Id"
        }
      ],
      "chartKey": "test-chart",
      "chartType": "table",
      "tenantId": "5mkg3t",
      "id": 15,
      "data": [
        {
          "main_case_id": 1,
          "main_contact_id": 1,
          "id": 1
        }
      ],
      "totalCount": 1
    }
  }
}

Body(raw) for Create Custom Chart

{
  "title": "test chart",
  "config": [
    {
      "key": "id",
      "filters": [
        {
          "key": "id",
          "conditions": [
            {
              "key": "is",
              "searchValue": [
                "1"
              ]
            }
          ]
        }
      ]
    }
  ],
  "objectKey": "conversations",
  "chartType": "table"
}

Edit Custom Report

POST https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/edit-custom-report

Edit a custom report.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

Request Body

NameTypeDescription

reportKey

string

Key for report which you want to edit. This is the report's current name.

description

string

Add a description for the report

reportName

string

Name of the report

{
  "data": {
    "success": true,
    "url": "updating-the-custom-reports-name"
  }
}

Body(raw) for Edit Custom Report

{
  "reportKey": "testconversation",
  "reportName": "Updating the custom reports name"
}

Create Custom Report

POST https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/generate-report

Create a custom report.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

Request Body

NameTypeDescription

objectKey

string

Selected object type. You can get object keys by calling the Get Data Points endpoint mentioned below.

description

string

A short description of the chart

reportName

string

Name of report

{
  "data": {
    "success": true,
    "url": "testing-the-new-custom-report"
  }
}

Body(raw) for Create Custom Report

{
  "reportName": "testconversation",
  "description": "Testing purpose",
  "objectKey": "conversation"
}

Delete Custom Report details

DELETE https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/delete-custom-report

Delete a custom report's details. Warning: This action cannot be undone.

Query Parameters

NameTypeDescription

report_key

string

The current name of the report which you want to delete.You can get report key by calling Get All Custom Reports.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

{
  "data": {
    "success": true
  }
}

Get Custom Report details

GET https://{{account_id}}.acquire.io/api//v1/analytics/custom-reporting/get-custom-report

Retrieve all custom report details.

Query Parameters

NameTypeDescription

report_key

string

Key of report which you want to get data. You can get report key by calling Get All Custom Reports API.

offset

string

This parameter is used for the timezone value and the default timezone will be "GMT". e.g. +05:30 for particular timezone. Default is +00:00

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

{
  "data": {
    "success": true,
    "customReport": {
      "reportName": "test report",
      "description": "test",
      "objectKey": "operator",
      "id": 37,
      "reportKey": "testreport"
    },
    "reportData": [
      {
        "id": 33,
        "title": "first table report",
        "chartKey": "first-table-report",
        "chartType": "table",
        "config": [
          {
            "key": "id",
            "label": "Operator Id",
            "filters": [],
            "dataType": "number",
            "joinType": "AND",
            "aggregation": "group_by",
            "aggregationLabel": "Operator Id",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "key": "average_response_time",
            "label": "Average Response Time",
            "filters": [
              {
                "key": "average_response_time",
                "conditions": [
                  {
                    "key": "between",
                    "searchValue": [
                      "0",
                      "10"
                    ]
                  }
                ]
              }
            ],
            "customUi": {
              "duration": true
            },
            "dataType": "object",
            "joinType": "AND",
            "aggregation": "avg",
            "aggregationLabel": "Response Time",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ]
          }
        ],
        "reportId": 37,
        "tenantId": "4wic4e",
        "data": [
          {
            "id": 56,
            "average_response_time": 9
          }
        ],
        "totalCount": 1
      },
      {
        "id": 34,
        "title": "report without aggregation",
        "chartKey": "report-without-aggregation",
        "chartType": "table",
        "config": [
          {
            "key": "id",
            "label": "Operator Id",
            "filters": [],
            "dataType": "number",
            "joinType": "AND",
            "aggregationLabel": "Operator Id",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "key": "average_response_time",
            "label": "Average Response Time",
            "filters": [
              {
                "key": "average_response_time",
                "conditions": [
                  {
                    "key": "between",
                    "searchValue": [
                      "0",
                      "10"
                    ]
                  }
                ]
              }
            ],
            "customUi": {
              "duration": true
            },
            "dataType": "object",
            "joinType": "AND",
            "aggregationLabel": "Response Time",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ]
          }
        ],
        "reportId": 37,
        "tenantId": "4wic4e",
        "data": [
          {
            "id": 56,
            "operator_id": 56,
            "average_response_time": 9
          }
        ],
        "totalCount": 1
      }
    ]
  }
}

Get All custom reports

GET https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/get-all-custom-report

Get list of all custom reports with name, description and report key. Report key will be used to get details of custom report.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

{
  "data": {
    "success": true,
    "customReport": [
      {
        "id": 35,
        "reportName": "Test_Report",
        "description": "test",
        "reportKey": "testreport"
      }
    ]
  }
}

Get All Datapoints

GET https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/get-data-points

Retrieve a list of all available data points for available objects.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

{
  "data": {
    "objects": [
      {
        "objectName": "Conversations",
        "objectKey": "conversations",
        "dataSource": [
          {
            "label": "Id",
            "key": "id",
            "options": [],
            "filters": [
              {
                "label": "Id",
                "key": "id",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "number",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Title",
            "key": "title",
            "options": [],
            "filters": [
              {
                "label": "Title",
                "key": "title",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "customUi": {
              "isEmojiSupported": true
            },
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Description",
            "key": "description",
            "options": [],
            "filters": [
              {
                "label": "Description",
                "key": "description",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "customUi": {
              "isEmojiSupported": true
            },
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Contact Name",
            "key": "contact_name",
            "options": [],
            "filters": [
              {
                "label": "Contact Name",
                "key": "name",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Contact Email",
            "key": "contact_email",
            "options": [],
            "filters": [
              {
                "label": "Contact Email",
                "key": "email",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Visit Id",
            "key": "visit_visit_id",
            "filters": [
              {
                "label": "Visit Id",
                "key": "id",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Visit Date",
            "key": "visit_date",
            "filters": [
              {
                "label": "Visit Date",
                "key": "date_created",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Visit Source URL",
            "key": "visit_source",
            "filters": [
              {
                "label": "Source URL",
                "key": "source",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Site URL",
            "key": "site_url",
            "filters": [
              {
                "label": "Site URL",
                "key": "url",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Channel",
            "key": "channel",
            "options": [
              {
                "label": "Chat",
                "value": "chat"
              },
              {
                "label": "VoIP",
                "value": "voip"
              },
              {
                "label": "SMS",
                "value": "sms"
              },
              {
                "label": "Mail",
                "value": "mail"
              },
              {
                "label": "Private Form",
                "value": "private-form"
              }
            ],
            "filters": [
              {
                "label": "Channel",
                "key": "channel",
                "dataType": "text",
                "options": [
                  {
                    "label": "Chat",
                    "value": "chat"
                  },
                  {
                    "label": "VoIP",
                    "value": "voip"
                  },
                  {
                    "label": "SMS",
                    "value": "sms"
                  },
                  {
                    "label": "Mail",
                    "value": "mail"
                  },
                  {
                    "label": "Private Form",
                    "value": "private-form"
                  }
                ],
                "conditions": [
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Status",
            "key": "status",
            "options": [
              {
                "label": "Pending",
                "value": "pending"
              },
              {
                "label": "Active",
                "value": "active"
              },
              {
                "label": "Closed",
                "value": "closed"
              }
            ],
            "filters": [
              {
                "label": "Status",
                "key": "status",
                "dataType": "text",
                "options": [
                  {
                    "label": "Pending",
                    "value": "pending"
                  },
                  {
                    "label": "Active",
                    "value": "active"
                  },
                  {
                    "label": "Closed",
                    "value": "closed"
                  }
                ],
                "conditions": [
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Reopened",
            "key": "parent_id",
            "options": [
              {
                "label": "Yes",
                "value": "is"
              },
              {
                "label": "No",
                "value": "no"
              }
            ],
            "filters": [
              {
                "label": "Reopened",
                "key": "parent_id",
                "dataType": "text",
                "options": [
                  {
                    "label": "Yes",
                    "value": "is"
                  },
                  {
                    "label": "No",
                    "value": "no"
                  }
                ],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Case Created Date and time",
            "key": "date_created",
            "options": [],
            "filters": [
              {
                "label": "Case Created Date and time",
                "key": "date_created",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "datetime",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Case Last Updated Date and time",
            "key": "date_updated",
            "options": [],
            "filters": [
              {
                "label": "Case Last Updated Date and time",
                "key": "date_updated",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "datetime",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Case Pending Date and time",
            "key": "date_pending",
            "options": [],
            "filters": [
              {
                "label": "Case Pending Date and time",
                "key": "date_pending",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "datetime",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Waiting time for case",
            "key": "wait_time",
            "options": [],
            "filters": [
              {
                "label": "Waiting time for case",
                "key": "wait_time",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "number",
            "customUi": {
              "duration": true
            },
            "availableAggregation": [
              "sum",
              "list"
            ]
          },
          {
            "label": "Case Active Date and time",
            "key": "date_active",
            "options": [],
            "filters": [
              {
                "label": "Case Active Date and time",
                "key": "date_active",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "datetime",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Case Closed Date and time",
            "key": "date_closed",
            "options": [],
            "filters": [
              {
                "label": "Case Closed Date and time",
                "key": "date_closed",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "datetime",
            "availableAggregation": [
              "group_by",
              "list"
            ]
          },
          {
            "label": "Duration of Case",
            "key": "duration",
            "options": [],
            "filters": [
              {
                "label": "Duration of Case",
                "key": "duration",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "number",
            "customUi": {
              "duration": true
            },
            "availableAggregation": [
              "sum",
              "list"
            ]
          },
          {
            "label": "Total Messages",
            "key": "total_messages",
            "filters": [
              {
                "label": "Total Messages",
                "key": "total",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Messages"
          },
          {
            "label": "Total Sent Messages",
            "key": "total_sent_messages",
            "filters": [
              {
                "label": "Total Sent Messages",
                "key": "total_sent",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Sent Messages"
          },
          {
            "label": "Total Received Messages",
            "key": "total_received_messages",
            "filters": [
              {
                "label": "Total Received Messages",
                "key": "total_received",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Received Messages"
          },
          {
            "label": "Total Mails",
            "key": "totalEmails",
            "filters": [
              {
                "label": "Total Mails",
                "key": "totalEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Mails"
          },
          {
            "label": "Total Sent Mails",
            "key": "totalSentEmails",
            "filters": [
              {
                "label": "Total Sent Mails",
                "key": "totalSentEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Sent Mails"
          },
          {
            "label": "Total Received Mails",
            "key": "totalReceivedEmails",
            "filters": [
              {
                "label": "Total Received Mails",
                "key": "totalReceivedEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Received Mails"
          },
          {
            "label": "Total Read Mails",
            "key": "totalReadEmails",
            "filters": [
              {
                "label": "Total Read Mails",
                "key": "totalReadEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Read Mails"
          },
          {
            "label": "Total Unread Mails",
            "key": "totalUnreadEmails",
            "filters": [
              {
                "label": "Total Unread Mails",
                "key": "totalUnreadEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Unread Mails"
          },
          {
            "label": "Total Delivered Mails",
            "key": "totalDeliveredEmails",
            "filters": [
              {
                "label": "Total Delivered Mails",
                "key": "totalDeliveredEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Delivered Mails"
          },
          {
            "label": "Total Replied Mails",
            "key": "totalRepliedEmails",
            "filters": [
              {
                "label": "Total Replied Mails",
                "key": "totalRepliedEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Replied Mails"
          },
          {
            "label": "Total Bounced Mails",
            "key": "totalBouncedEmails",
            "filters": [
              {
                "label": "Total Bounced Mails",
                "key": "totalBouncedEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Bounced Mails"
          },
          {
            "label": "Agents Involved",
            "key": "user",
            "options": {},
            "filters": [
              {
                "label": "Agent",
                "key": "user_id",
                "dataType": "number",
                "options": [
                  {
                    "value": 1,
                    "label": "Kaushal Madani"
                  },
                  {
                    "value": 5,
                    "label": "Karan Panwar"
                  },
                  {
                    "value": 6,
                    "label": "Zalak "
                  },
                  {
                    "value": 10,
                    "label": "Test Developer of acquire"
                  },
                  {
                    "value": 11,
                    "label": "dharma"
                  },
                  {
                    "value": 22,
                    "label": "Dev User1"
                  },
                  {
                    "value": 23,
                    "label": "dev_user2@mail.com"
                  },
                  {
                    "value": 24,
                    "label": "dev_user3@mail.com"
                  },
                  {
                    "value": 25,
                    "label": "dev_user4@mail.com"
                  },
                  {
                    "value": 26,
                    "label": "dev_user5@mail.com"
                  },
                  {
                    "value": 27,
                    "label": "dev_user6@mail.com"
                  },
                  {
                    "value": 28,
                    "label": "dev_user7@mail.com"
                  },
                  {
                    "value": 29,
                    "label": "dev_user8@mail.com"
                  },
                  {
                    "value": 30,
                    "label": "dev_user9@mail.com"
                  },
                  {
                    "value": 33,
                    "label": "new test"
                  },
                  {
                    "value": 34,
                    "label": "Hiren Gohil"
                  },
                  {
                    "value": 35,
                    "label": "Test1"
                  },
                  {
                    "value": 36,
                    "label": "Test2"
                  },
                  {
                    "value": 37,
                    "label": "Test3"
                  },
                  {
                    "value": 38,
                    "label": "karan test"
                  },
                  {
                    "value": 56,
                    "label": "Ana 1"
                  },
                  {
                    "value": 64,
                    "label": "User from docs"
                  },
                  {
                    "value": 65,
                    "label": "UserFromAPI0"
                  },
                  {
                    "value": 66,
                    "label": "UserFromAPI1"
                  },
                  {
                    "value": 67,
                    "label": "UserFromAPI2"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Feedback",
            "key": "feedback",
            "options": [
              {
                "label": "Ratings",
                "value": "text"
              },
              {
                "label": "List Type",
                "value": "list"
              },
              {
                "label": "Multiple",
                "value": "multiple"
              },
              {
                "label": "Ratings",
                "value": "rating"
              },
              {
                "label": "Multiple Radio",
                "value": "multiple_radio"
              },
              {
                "label": "Multiple Checkbox",
                "value": "multiple_checkbox"
              }
            ],
            "filters": [
              {
                "label": "Feedback Type",
                "key": "type",
                "dataType": "text",
                "options": [
                  {
                    "label": "Ratings",
                    "value": "text"
                  },
                  {
                    "label": "List Type",
                    "value": "list"
                  },
                  {
                    "label": "Multiple",
                    "value": "multiple"
                  },
                  {
                    "label": "Ratings",
                    "value": "rating"
                  },
                  {
                    "label": "Multiple Radio",
                    "value": "multiple_radio"
                  },
                  {
                    "label": "Multiple Checkbox",
                    "value": "multiple_checkbox"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "count",
              "list"
            ]
          },
          {
            "label": "Tags",
            "key": "tags",
            "options": {},
            "filters": [
              {
                "label": "Tags",
                "key": "tag_id",
                "dataType": "number",
                "options": [
                  {
                    "value": 1,
                    "label": "Tag1"
                  },
                  {
                    "value": 2,
                    "label": "Tag2"
                  },
                  {
                    "value": 3,
                    "label": "Tag3"
                  },
                  {
                    "value": 4,
                    "label": "private-form"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "customUi": {
              "type": "badge",
              "multipleValues": true,
              "separator": "|",
              "valueSeparator": ":"
            },
            "availableAggregation": [
              "count",
              "list"
            ]
          },
          {
            "label": "Notes",
            "key": "notes",
            "options": [],
            "filters": [],
            "dataType": "object",
            "customUi": {
              "isEmojiSupported": true
            },
            "availableAggregation": [
              "count",
              "list"
            ]
          },
          {
            "label": "Business Apps Involved In Case",
            "key": "business_apps",
            "options": {},
            "filters": [
              {
                "label": "Business App",
                "key": "app_id",
                "dataType": "text",
                "options": [
                  {
                    "value": "freshdesk",
                    "label": "Freshdesk"
                  },
                  {
                    "value": "freshservice",
                    "label": "Freshservice"
                  },
                  {
                    "value": "hubspot",
                    "label": "HubSpot"
                  },
                  {
                    "value": "infusionsoft",
                    "label": "Keap (Infusionsoft)"
                  },
                  {
                    "value": "leadsquared",
                    "label": "LeadSquared"
                  },
                  {
                    "value": "microsoft_dynamics_crm",
                    "label": "Microsoft Dynamics CRM"
                  },
                  {
                    "value": "salesforce",
                    "label": "Salesforce"
                  },
                  {
                    "value": "salesforce_sandbox",
                    "label": "Salesforce Sandbox"
                  },
                  {
                    "value": "salesloft",
                    "label": "SalesLoft"
                  },
                  {
                    "value": "sugarcrm",
                    "label": "Sugar CRM"
                  },
                  {
                    "value": "test_app2",
                    "label": "Test app22"
                  },
                  {
                    "value": "with_testing_data",
                    "label": "With Testing data"
                  },
                  {
                    "value": "zendesk",
                    "label": "Zendesk"
                  },
                  {
                    "value": "zoho_crm",
                    "label": "Zoho CRM"
                  },
                  {
                    "value": "zoho_desk",
                    "label": "Zoho Desk"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "count",
              "list"
            ]
          },
          {
            "label": "Social Media Involved In Case",
            "key": "social_apps",
            "options": {},
            "filters": [
              {
                "label": "Social App",
                "key": "app_id",
                "dataType": "text",
                "options": [
                  {
                    "value": "apple_business_chat",
                    "label": "Apple business chat"
                  },
                  {
                    "value": "facebook",
                    "label": "Facebook"
                  },
                  {
                    "value": "line",
                    "label": "Line"
                  },
                  {
                    "value": "skype",
                    "label": "Skype"
                  },
                  {
                    "value": "slack",
                    "label": "Slack"
                  },
                  {
                    "value": "telegram",
                    "label": "Telegram"
                  },
                  {
                    "value": "twitter",
                    "label": "Twitter"
                  },
                  {
                    "value": "viber",
                    "label": "Viber"
                  },
                  {
                    "value": "wechat",
                    "label": "WeChat"
                  },
                  {
                    "value": "whatsapp",
                    "label": "WhatsApp"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "count",
              "list"
            ]
          },
          {
            "label": "Departments Involved",
            "key": "department",
            "options": {},
            "filters": [
              {
                "label": "Department",
                "key": "department_id",
                "dataType": "number",
                "options": [
                  {
                    "value": 1,
                    "label": "Analytics12"
                  },
                  {
                    "value": 2,
                    "label": "Test"
                  },
                  {
                    "value": 3,
                    "label": "aaaa"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "count",
              "list"
            ]
          },
          {
            "label": "Total Calls",
            "key": "totalCalls",
            "filters": [
              {
                "label": "Total Calls",
                "key": "totalCalls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Calls"
          },
          {
            "label": "Total Outgoing Calls",
            "key": "totalOutgoingCalls",
            "filters": [
              {
                "label": "Total Outgoing Calls",
                "key": "totalOutgoingCalls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Outgoing Calls"
          },
          {
            "label": "Total Incoming Calls",
            "key": "totalIncomingCalls",
            "filters": [
              {
                "label": "Total Incoming Calls",
                "key": "totalIncomingCalls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Incoming Calls"
          },
          {
            "label": "Total Missed Calls",
            "key": "totalMissedCalls",
            "filters": [
              {
                "label": "Total Missed Calls",
                "key": "totalMissedCalls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Missed Calls"
          },
          {
            "label": "Total Calls Duration",
            "key": "totalDuration",
            "filters": [
              {
                "label": "Total Calls Duration",
                "key": "totalDuration",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Calls Duration"
          },
          {
            "label": "Total SMS",
            "key": "totalSms",
            "filters": [
              {
                "label": "Total SMS",
                "key": "totalSms",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "SMS"
          },
          {
            "label": "Total Outgoing SMS",
            "key": "totalOutgoingSms",
            "filters": [
              {
                "label": "Total Outgoing SMS",
                "key": "totalOutgoingSms",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Outgoing SMS"
          },
          {
            "label": "Total Incoming SMS",
            "key": "totalIncomingSms",
            "filters": [
              {
                "label": "Total Incoming SMS",
                "key": "totalIncomingSms",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Incoming SMS"
          },
          {
            "label": "Total Failed SMS",
            "key": "totalFailedSms",
            "filters": [
              {
                "label": "Total Failed SMS",
                "key": "totalFailedSms",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Failed SMS"
          },
          {
            "label": "All Custom Attributes",
            "key": "custom_attributes",
            "options": [],
            "filters": [],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "my custom attribute",
            "key": "my_custom_attribute",
            "filters": [
              {
                "label": "my custom attribute",
                "key": "my_custom_attribute",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          }
        ]
      },
      {
        "objectName": "Operator",
        "objectKey": "operator",
        "dataSource": [
          {
            "label": "Operator Id",
            "key": "id",
            "options": [],
            "filters": [
              {
                "label": "Operator Id",
                "key": "id",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "number",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Name",
            "key": "name",
            "options": [],
            "filters": [
              {
                "label": "Name",
                "key": "name",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Email",
            "key": "email",
            "options": [],
            "filters": [
              {
                "label": "Email",
                "key": "email",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Role",
            "key": "role",
            "options": {},
            "filters": [
              {
                "label": "Role",
                "key": "role_id",
                "dataType": "text",
                "options": [
                  {
                    "value": 1,
                    "label": "Administrator"
                  },
                  {
                    "value": 2,
                    "label": "Operator"
                  },
                  {
                    "value": 3,
                    "label": "User"
                  },
                  {
                    "value": 4,
                    "label": "new role"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Departments",
            "key": "departments",
            "options": {},
            "filters": [
              {
                "label": "Departments",
                "key": "department_id",
                "dataType": "text",
                "options": [
                  {
                    "value": 1,
                    "label": "Analytics12"
                  },
                  {
                    "value": 2,
                    "label": "Test"
                  },
                  {
                    "value": 3,
                    "label": "aaaa"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "group_by",
              "count",
              "list"
            ]
          },
          {
            "label": "Average Response Time",
            "key": "average_response_time",
            "options": [],
            "filters": [
              {
                "label": "Average Response Time",
                "key": "average_response_time",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "customUi": {
              "duration": true
            },
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Response Time"
          },
          {
            "label": "Average Rating",
            "key": "rating",
            "options": [],
            "filters": [
              {
                "label": "Average Rating",
                "key": "rating",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "avg",
              "list"
            ],
            "aggregationLabel": "Rating"
          },
          {
            "label": "Total Case",
            "key": "total_case",
            "options": [],
            "filters": [
              {
                "label": "Total Case",
                "key": "total_case",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "count",
              "list"
            ],
            "aggregationLabel": "Case"
          },
          {
            "label": "Total Chat",
            "key": "total_chat",
            "options": [],
            "filters": [
              {
                "label": "Total Chat",
                "key": "total_chat",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "count",
              "list"
            ],
            "aggregationLabel": "Chat"
          },
          {
            "label": "Total Mails",
            "key": "totalEmails",
            "filters": [
              {
                "label": "Total Mails",
                "key": "totalEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ]
          },
          {
            "label": "Total Sent Mails",
            "key": "totalSentEmails",
            "filters": [
              {
                "label": "Total Sent Mails",
                "key": "totalSentEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ]
          },
          {
            "label": "Total Received Mails",
            "key": "totalReceivedEmails",
            "filters": [
              {
                "label": "Total Received Mails",
                "key": "totalReceivedEmails",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ]
          },
          {
            "label": "Total of All Calls",
            "key": "total_all_calls",
            "options": [],
            "filters": [
              {
                "label": "Total of All Calls",
                "key": "total_all_calls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "All Calls"
          },
          {
            "label": "Total Outgoing Calls",
            "key": "outgoing_calls",
            "options": [],
            "filters": [
              {
                "label": "Total Outgoing Calls",
                "key": "outgoing_calls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "Outgoing Calls"
          },
          {
            "label": "Total Incoming Calls",
            "key": "incoming_calls",
            "options": [],
            "filters": [
              {
                "label": "Total Incoming Calls",
                "key": "incoming_calls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "Incoming Calls"
          },
          {
            "label": "Total Missed Calls",
            "key": "missed_calls",
            "options": [],
            "filters": [
              {
                "label": "Total Missed Calls",
                "key": "missed_calls",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "Missed Calls"
          },
          {
            "label": "Total Calls Duration",
            "key": "call_duration",
            "options": [],
            "filters": [
              {
                "label": "Total Calls Duration",
                "key": "call_duration",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "customUi": {
              "duration": true
            },
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "Calls Duration"
          },
          {
            "label": "Total of All SMS",
            "key": "total_all_sms",
            "options": [],
            "filters": [
              {
                "label": "Total of All SMS",
                "key": "total_all_sms",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "All SMS"
          },
          {
            "label": "SMS Sent",
            "key": "sms_sent",
            "options": [],
            "filters": [
              {
                "label": "SMS Sent",
                "key": "sms_sent",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "SMS Sent"
          },
          {
            "label": "SMS Received",
            "key": "sms_received",
            "options": [],
            "filters": [
              {
                "label": "SMS Received",
                "key": "sms_received",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "SMS Received"
          },
          {
            "label": "SMS Failed",
            "key": "sms_failed",
            "options": [],
            "filters": [
              {
                "label": "SMS Failed",
                "key": "sms_failed",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "sum",
              "list"
            ],
            "aggregationLabel": "SMS Failed"
          }
        ]
      },
      {
        "objectName": "Contact",
        "objectKey": "contact",
        "dataSource": [
          {
            "label": "Contact Id",
            "key": "id",
            "options": [],
            "filters": [
              {
                "label": "Contact Id",
                "key": "id",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "number",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Name",
            "key": "name",
            "options": [],
            "filters": [
              {
                "label": "Name",
                "key": "name",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Email",
            "key": "email",
            "options": [],
            "filters": [
              {
                "label": "Email",
                "key": "email",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Phone",
            "key": "phone",
            "options": [],
            "filters": [
              {
                "label": "Phone",
                "key": "phone",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "City",
            "key": "city",
            "options": [],
            "filters": [
              {
                "label": "City",
                "key": "city",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "State",
            "key": "state",
            "options": [],
            "filters": [
              {
                "label": "State",
                "key": "state",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Custom Attributes",
            "key": "custom_attributes",
            "options": [],
            "filters": [],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Company",
            "key": "company",
            "options": [],
            "filters": [],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Tags",
            "key": "tags",
            "options": {},
            "filters": [
              {
                "label": "Tags",
                "key": "tags",
                "dataType": "text",
                "options": [
                  {
                    "value": 1,
                    "label": "Tag1"
                  },
                  {
                    "value": 2,
                    "label": "Tag2"
                  },
                  {
                    "value": 3,
                    "label": "Tag3"
                  },
                  {
                    "value": 4,
                    "label": "private-form"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "customUi": {
              "type": "badge",
              "multipleValues": true,
              "separator": ",",
              "valueSeparator": ":"
            },
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "IP",
            "key": "ip",
            "options": [],
            "filters": [
              {
                "label": "IP",
                "key": "ip",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Browser",
            "key": "client_name",
            "options": [],
            "filters": [
              {
                "label": "Browser",
                "key": "client_name",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "OS",
            "key": "client_os_name",
            "options": [],
            "filters": [
              {
                "label": "OS",
                "key": "client_os_name",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Device",
            "key": "client_device_type",
            "options": [],
            "filters": [
              {
                "label": "Device",
                "key": "client_device_type",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "Is",
                    "key": "is",
                    "supportMultiple": false
                  },
                  {
                    "label": "Contains",
                    "key": "like",
                    "supportMultiple": false
                  },
                  {
                    "label": "One of",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "text",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Contact Date",
            "key": "date_created",
            "options": [],
            "filters": [
              {
                "label": "Contact Date",
                "key": "date_created",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "datetime",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Last Contact Date",
            "key": "date_updated",
            "options": [],
            "filters": [
              {
                "label": "Last Contact Date",
                "key": "date_updated",
                "dataType": "datetime",
                "options": [],
                "conditions": [
                  {
                    "label": "Equals",
                    "key": "between",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "datetime",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Total Cases",
            "key": "total_cases",
            "options": [],
            "filters": [
              {
                "label": "Total Cases",
                "key": "total_cases",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Total Visits",
            "key": "total_visits",
            "options": [],
            "filters": [
              {
                "label": "Total Visits",
                "key": "total_visits",
                "dataType": "number",
                "options": [],
                "conditions": [
                  {
                    "label": "Between",
                    "key": "between",
                    "supportMultiple": true
                  },
                  {
                    "label": "More Than",
                    "key": "greater_than",
                    "supportMultiple": false
                  },
                  {
                    "label": "Less Than",
                    "key": "less_than",
                    "supportMultiple": false
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Notes",
            "key": "notes",
            "options": [],
            "filters": [],
            "dataType": "object",
            "customUi": {
              "isEmojiSupported": true
            },
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Business Apps Involved In Contact",
            "key": "business_apps",
            "options": {},
            "filters": [
              {
                "label": "Business App",
                "key": "app_id",
                "dataType": "text",
                "options": [
                  {
                    "value": "freshdesk",
                    "label": "Freshdesk"
                  },
                  {
                    "value": "freshservice",
                    "label": "Freshservice"
                  },
                  {
                    "value": "hubspot",
                    "label": "HubSpot"
                  },
                  {
                    "value": "infusionsoft",
                    "label": "Keap (Infusionsoft)"
                  },
                  {
                    "value": "leadsquared",
                    "label": "LeadSquared"
                  },
                  {
                    "value": "microsoft_dynamics_crm",
                    "label": "Microsoft Dynamics CRM"
                  },
                  {
                    "value": "salesforce",
                    "label": "Salesforce"
                  },
                  {
                    "value": "salesforce_sandbox",
                    "label": "Salesforce Sandbox"
                  },
                  {
                    "value": "salesloft",
                    "label": "SalesLoft"
                  },
                  {
                    "value": "sugarcrm",
                    "label": "Sugar CRM"
                  },
                  {
                    "value": "test_app2",
                    "label": "Test app22"
                  },
                  {
                    "value": "with_testing_data",
                    "label": "With Testing data"
                  },
                  {
                    "value": "zendesk",
                    "label": "Zendesk"
                  },
                  {
                    "value": "zoho_crm",
                    "label": "Zoho CRM"
                  },
                  {
                    "value": "zoho_desk",
                    "label": "Zoho Desk"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Social Media Apps Involved In Contact",
            "key": "social_apps",
            "options": {},
            "filters": [
              {
                "label": "Social App",
                "key": "app_id",
                "dataType": "text",
                "options": [
                  {
                    "value": "apple_business_chat",
                    "label": "Apple business chat"
                  },
                  {
                    "value": "facebook",
                    "label": "Facebook"
                  },
                  {
                    "value": "line",
                    "label": "Line"
                  },
                  {
                    "value": "skype",
                    "label": "Skype"
                  },
                  {
                    "value": "slack",
                    "label": "Slack"
                  },
                  {
                    "value": "telegram",
                    "label": "Telegram"
                  },
                  {
                    "value": "twitter",
                    "label": "Twitter"
                  },
                  {
                    "value": "viber",
                    "label": "Viber"
                  },
                  {
                    "value": "wechat",
                    "label": "WeChat"
                  },
                  {
                    "value": "whatsapp",
                    "label": "WhatsApp"
                  }
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Address",
            "key": "address",
            "filters": [
              {
                "label": "Address",
                "key": "address",
                "dataType": "text",
                "options": [],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          },
          {
            "label": "Contact Dropdown",
            "key": "contact_dropdown",
            "filters": [
              {
                "label": "Contact Dropdown",
                "key": "contact_dropdown",
                "dataType": "text",
                "options": [
                  "First",
                  "Second",
                  "Contact Custom Dropdown Two ?><,./\":;'|}{[]\\+=_-)(*&^%$#@!"
                ],
                "conditions": [
                  {
                    "label": "In",
                    "key": "in",
                    "supportMultiple": true
                  }
                ]
              }
            ],
            "options": [],
            "dataType": "object",
            "availableAggregation": [
              "list"
            ]
          }
        ]
      }
    ]
  }
}

Get Custom Chart with data

GET https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/get-custom-chart

Retrieve data of chart with pagination enabled.

Query Parameters

NameTypeDescription

limit

string

Define limit how many records you want per page out of total records

page

string

Page number for which you want data

preview

string

If you want total count in response then send its value as false else true.

offset

string

This parameter is used for the timezone value and the default timezone will be "GMT". e.g. +05:30 for particular timezone. Default is +00:00

chart_id

string

Id of chart for which you want data.You can get chart id from get_custom_report api.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

Schedule Chart

POST https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/schedule-mail

Schedule a chart

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

Request Body

NameTypeDescription

offset

string

This parameter is used for the timezone value and the default timezone will be "GMT". e.g. +05:30 for particular timezone. Default is +00:00

schedulePeriod

object

Object for configuration. period => "monthly" or "weekly" or "daily", daysOfWeek => "monday"

emails

array

Comma separated emails to which you want to send report

chartId

string

ID of chart which you want schedule

{
  "data": {
    "success": true,
    "data": {
      "id": 19,
      "chartId": 107,
      "emails": [
        "kaushalm@acquire.io"
      ],
      "schedulePeriod": {
        "period": "monthly",
        "daysOfWeek": [
          "monday"
        ]
      },
    },
    "message": "Report Mail scheduled successfully"
  }
}

Body (raw) for Schedule Chart

{
  "chartId": 107,
  "emails": [
    "kaushalm@acquire.io"
  ],
  "schedulePeriod": {
    "period": "monthly",
    "daysOfWeek": [
      "monday"
    ]
  },
  "offset": "+00:00"
}

Remove Scheduled Chart

DELETE https://{{account_id}}.acquire.io/api/v1/analytics/custom-reporting/delete-schedule-mail

Remove already scheduled chart

Query Parameters

NameTypeDescription

scheduleMailId

number

Id of scheduled chart.You can get this id using get-custom-chart API.

Headers

NameTypeDescription

Authorization

string

Bearer ***YOUR_API_KEY***

Last updated