request_tables
Fetch multiple ServiceNow tables in one request with per-table queries, fields, and limits, then cache the combined response so query_cache can join them.
Instructions
Fetch several tables in one request, each with its own query, fields and limit. All of them are stored in one cached response, so query_cache can join them. Returns the row count and columns of each table, any warnings and the cache_name. Example arguments: {"instance": "dev", "tables": [{"table": "sys_user_group", "fields": ["sys_id", "name"], "limit": 1000}, {"table": "sys_group_has_role", "query": "role.name=itil", "fields": ["group", "role", "group.name"], "limit": 5000}]}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | Yes | The tables to fetch, each with its own query, fields and limit. Each table can appear only once: combine conditions with ^OR or IN instead. | |
| refresh | No | Skip the local cache and ask the instance again. Leave false to reuse a recent response. | |
| instance | Yes | Name of a configured instance, as returned by list_instances. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source | Yes | ||
| sections | Yes | ||
| warnings | Yes | ||
| row_count | Yes | ||
| cache_name | Yes | ||
| elapsed_ms | Yes | ||
| executed_at | Yes |