ServiceNow · Schema

AggregateResult

The aggregate statistics result. Structure varies based on the requested aggregate types and group-by fields.

AutomationCloud ServicesDigital WorkflowsEnterprise PlatformIT Service ManagementITSMProcessesT1Workflow AutomationWorkflows

Properties

Name Type Description
stats object Contains the computed aggregate values organized by field name and aggregate type.
group_by array When group-by fields are specified, contains an entry for each unique group with its aggregate values.
View JSON Schema on GitHub

JSON Schema

servicenow-aggregate-aggregate-result-schema.json Raw ↑
{
  "type": "object",
  "description": "The aggregate statistics result. Structure varies based on the requested aggregate types and group-by fields.",
  "properties": {
    "stats": {
      "type": "object",
      "description": "Contains the computed aggregate values organized by field name and aggregate type.",
      "example": "example_value",
      "properties": {
        "count": {
          "type": "string",
          "description": "The total count of records matching the query."
        }
      }
    },
    "group_by": {
      "type": "array",
      "description": "When group-by fields are specified, contains an entry for each unique group with its aggregate values.",
      "example": [],
      "items": {
        "type": "object"
      }
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "AggregateResult"
}