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
Name
Type
Description
report_key
string
Id of chart to delete
Headers
Name
Type
Description
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
Name
Type
Description
Authorization
string
Bearer ***YOUR_API_KEY***
Request Body
Name
Type
Description
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
Name
Type
Description
Authorization
string
Bearer ***YOUR_API_KEY***
Request Body
Name
Type
Description
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
Name
Type
Description
Authorization
string
Bearer ***YOUR_API_KEY***
Request Body
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
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
Name
Type
Description
Authorization
string
Bearer ***YOUR_API_KEY***
Request Body
Name
Type
Description
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
Name
Type
Description
scheduleMailId
number
Id of scheduled chart.You can get this id using get-custom-chart API.
Headers
Name
Type
Description
Authorization
string
Bearer ***YOUR_API_KEY***
Last updated