List Records
list_recordsList records from any ServiceNow table with optional filters, field selection, and pagination to retrieve exactly the data you need.
Instructions
List records from any ServiceNow table with optional filtering, field selection, and pagination
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of records to return | |
| query | No | Encoded query string (e.g., 'active=true^priority=1') | |
| fields | No | Comma-separated list of fields to return | |
| offset | No | Number of records to skip | |
| order_by | No | Field to order results by (prefix with '-' for descending) | |
| table_name | Yes | The ServiceNow table name (e.g., 'sys_user', 'cmdb_ci_server', 'incident') | |
| display_value | No | 'false' (default) returns stored values; 'true' returns labels in place of sys_ids and choice values; 'all' returns {display_value, value} per field, which keeps the sys_id beside the name. query= still filters on stored values, not labels. With 'true' or 'all', dates come back in this identity's time zone and format | false |
| response_format | No | 'detailed' (default) returns each reference field as {link, value}; 'concise' drops the link (an instance URL) and returns the sys_id alone | detailed |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| count | Yes | ||
| records | Yes | ||
| warning | No | ||
| truncated | No | ||
| next_offset | No | ||
| display_note | No |