execute_table_operation
Perform CRUD operations on ServiceNow tables to create, read, update, and delete records with query support and batch processing capabilities.
Instructions
CRUD operations on ServiceNow tables via Table API. Supports GET/POST/PUT/PATCH/DELETE with query syntax and batch operations. ā ļø SANDBOX ONLY - reads/modifies data. š”ļø Auto-limits large results. Use pagination for big datasets. š Use {{file:path}} for large data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| operation | Yes | The operation to perform on the table. Required. | |
| table | Yes | The ServiceNow table name (e.g., "incident", "sys_user"). Required. | |
| sys_id | No | System ID for single record operations (GET, PUT, PATCH, DELETE). | |
| sys_ids | No | Array of system IDs for batch operations. | |
| query | No | ServiceNow encoded query string (e.g., "active=true^priority=1"). | |
| fields | No | Comma-separated list of fields to return. | |
| limit | No | Maximum number of records to return (default: 1000). | |
| offset | No | Number of records to skip for pagination. | |
| display_value | No | Return display values for reference fields. | |
| exclude_reference_link | No | Exclude reference link fields from response. | |
| data | No | Record data for POST/PUT/PATCH operations. Can be single object or array for batch operations. Supports {{file:...}} placeholders to load content from local files. | |
| batch | No | Enable batch mode for multiple record operations. | |
| validate_fields | No | Enable field validation warnings to catch typos and invalid field names. Default: true (validation enabled by default). | |
| context_overflow_prevention | No | Enable context overflow prevention to limit large result sets. Default: true. Set to false to disable automatic truncation (use with caution). | |
| strict_fields | No | Strict field filtering - only return requested fields and strip large fields (script, html, css) unless explicitly requested. Default: false. | |
| response_mode | No | Response verbosity: full (all data), minimal (essential only), compact (summarized). Default: full |
Input Schema (JSON Schema)
{
"properties": {
"batch": {
"description": "Enable batch mode for multiple record operations.",
"type": "boolean"
},
"context_overflow_prevention": {
"description": "Enable context overflow prevention to limit large result sets. Default: true. Set to false to disable automatic truncation (use with caution).",
"type": "boolean"
},
"data": {
"description": "Record data for POST/PUT/PATCH operations. Can be single object or array for batch operations. Supports {{file:...}} placeholders to load content from local files.",
"type": "object"
},
"display_value": {
"description": "Return display values for reference fields.",
"enum": [
"true",
"false",
"all"
],
"type": "string"
},
"exclude_reference_link": {
"description": "Exclude reference link fields from response.",
"type": "boolean"
},
"fields": {
"description": "Comma-separated list of fields to return.",
"type": "string"
},
"limit": {
"description": "Maximum number of records to return (default: 1000).",
"type": "number"
},
"offset": {
"description": "Number of records to skip for pagination.",
"type": "number"
},
"operation": {
"description": "The operation to perform on the table. Required.",
"enum": [
"GET",
"POST",
"PUT",
"PATCH",
"DELETE"
],
"type": "string"
},
"query": {
"description": "ServiceNow encoded query string (e.g., \"active=true^priority=1\").",
"type": "string"
},
"response_mode": {
"description": "Response verbosity: full (all data), minimal (essential only), compact (summarized). Default: full",
"enum": [
"full",
"minimal",
"compact"
],
"type": "string"
},
"strict_fields": {
"description": "Strict field filtering - only return requested fields and strip large fields (script, html, css) unless explicitly requested. Default: false.",
"type": "boolean"
},
"sys_id": {
"description": "System ID for single record operations (GET, PUT, PATCH, DELETE).",
"type": "string"
},
"sys_ids": {
"description": "Array of system IDs for batch operations.",
"items": {
"type": "string"
},
"type": "array"
},
"table": {
"description": "The ServiceNow table name (e.g., \"incident\", \"sys_user\"). Required.",
"type": "string"
},
"validate_fields": {
"description": "Enable field validation warnings to catch typos and invalid field names. Default: true (validation enabled by default).",
"type": "boolean"
}
},
"required": [
"operation",
"table"
],
"type": "object"
}