{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID for the authenticated connection"
},
"tableName": {
"type": "string",
"description": "Name of the table to aggregate (e.g., incident, change_request, task)"
},
"sysparm_query": {
"type": "string",
"description": "Encoded query to filter records before aggregating (e.g., 'state=1^priority=2')"
},
"sysparm_count": {
"type": "boolean",
"description": "Set to true to return the total record count"
},
"sysparm_avg_fields": {
"type": "string",
"description": "Comma-separated fields to compute the average for"
},
"sysparm_sum_fields": {
"type": "string",
"description": "Comma-separated fields to compute the sum for"
},
"sysparm_min_fields": {
"type": "string",
"description": "Comma-separated fields to find the minimum value for"
},
"sysparm_max_fields": {
"type": "string",
"description": "Comma-separated fields to find the maximum value for"
},
"sysparm_group_by": {
"type": "string",
"description": "Comma-separated fields to group results by (e.g., 'state,priority')"
},
"sysparm_having": {
"type": "string",
"description": "Filter on aggregated results (e.g., 'COUNT(sys_id)>5')"
},
"sysparm_order_by": {
"type": "string",
"description": "Order results by field or aggregate (e.g., 'state' or 'COUNT(sys_id)')"
},
"sysparm_display_value": {
"type": "string",
"description": "Return display values (true), actual values (false), or both (all)",
"enum": [
"true",
"false",
"all"
]
}
},
"required": [
"PCID",
"tableName"
]
}
