query_fluent_records
Read-only
Run a read-only query against any ServiceNow table using an encoded query string and get matching records as JSON. Configure fields, limits, and pagination for targeted results.
Instructions
Run a read-only query against a ServiceNow table via the Table REST API (SDK v4.8.0+). Returns matching records as a JSON envelope. Requires instance authentication (auto-injected from session, or pass auth explicitly). Provide table and an encoded query (e.g. "active=true^priority<=2").
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| auth | No | Credential alias to use for authentication with instance (auto-injected from session if not provided) | |
| view | No | UI view to determine which fields to return (sysparm_view) | |
| debug | No | Print debug output | |
| limit | No | Maximum records per page (sysparm_limit). Default 100. | |
| query | Yes | Encoded query string (sysparm_query), e.g. "active=true^priority<=2" | |
| table | Yes | ServiceNow table name to query (e.g. incident, sys_user) | |
| fields | No | Comma-separated list of fields to return (sysparm_fields), e.g. "number,short_description,priority" | |
| offset | No | Starting offset (sysparm_offset). Default 0. | |
| select | No | Dot/bracket path to extract from the output (SDK v4.10.0+), e.g. "records[0].sys_id". Implies machine-readable output; an unresolved path yields null rather than an error. | |
| noCount | No | Skip total count calculation for better performance (sysparm_no_count) | |
| timeout | No | Per-request timeout in milliseconds for each page fetch. Default 30000. | |
| displayValue | No | Return display values (sysparm_display_value): "true", "false", or "all" for both. Default "false". | |
| queryCategory | No | Query category for extended queries (sysparm_query_category) | |
| queryNoDomain | No | Ignore domain separation when querying (sysparm_query_no_domain) | |
| workingDirectory | No | Absolute path to the Fluent project for this call. Overrides the initialized session and FLUENT_MCP_WORKING_DIR. | |
| excludeReferenceLink | No | Exclude reference link metadata (sysparm_exclude_reference_link). Default true. |