ServiceNow Table API Read Only

Use this skill to read data from ServiceNow via the Table API. Do not create or update or delete records.

Configuration

Set these environment variables in the .env file in this folder.

• - SERVICENOWDOMAIN instance domain such as myinstance.service-now.com
• SERVICENOWUSERNAME username for basic auth
• SERVICENOW_PASSWORD password for basic auth

If your domain already includes https:// then use it as is. Otherwise requests should be made to:

CODEBLOCK0

Allowed Operations GET only

Use only the GET endpoints from these files.

• - openapi.yaml for Table API
• references/attachment.yaml for Attachment API
• references/aggregate-api.yaml for Aggregate API
• references/service-catalog-api.yaml for Service Catalog API

List records

• - GET /api/now/table/{tableName}

Get a record by sys_id

• - GET /api/now/table/{tableName}/{sys_id}

Never use POST or PUT or PATCH or DELETE.

Common Query Params Table API

• - sysparmquery encoded query such as active=true^priority=1
• sysparmfields comma separated fields to return
• sysparmlimit limit record count to keep small for safety
• sysparmdisplayvalue true or false or all
• sysparmexcludereferencelink true to reduce clutter

See openapi.yaml for the full list of parameters.

CLI

Use the bundled CLI for all reads. It pulls auth from .env by default. You can override with flags.

Command overview

• - list table lists records from a table
• get table sysid fetches one record by sysid
• batch file.json runs multiple read requests in one call
• attach reads attachments and file content
• stats table aggregates stats
• schema table lists valid field names and types
• history table sys_id reads full comment and work note timeline
• sc endpoint Service Catalog GET endpoints

Auth flags

• - --domain domain instance domain
• --username user
• --password pass

Query flags

Use any of these as --sysparm_* flags.

• - --sysparmquery
• --sysparmfields
• --sysparmlimit
• --sysparmdisplayvalue
• --sysparmexcludereferencelink
• --sysparmsuppresspaginationheader
• --sysparmview
• --sysparmquerycategory
• --sysparmquerynodomain
• --sysparmno_count

Attachment API params

• - --sysparmquery
• --sysparmsuppresspaginationheader
• --sysparmlimit
• --sysparmquery_category

Aggregate API params

• - --sysparmquery
• --sysparmavgfields
• --sysparmcount
• --sysparmminfields
• --sysparmmaxfields
• --sysparmsumfields
• --sysparmgroupby
• --sysparmorderby
• --sysparmhaving
• --sysparmdisplayvalue
• --sysparmquery_category

Service Catalog params

• - --sysparmview
• --sysparmlimit
• --sysparmtext
• --sysparmoffset
• --sysparmcategory
• --sysparmtype
• --sysparmcatalog
• --sysparmtoplevelonly
• --recordid
• --templateid
• --mode

Output

• - --pretty pretty print JSON output
• --out path save binary attachment content to a file

Examples

List recent incidents.

CODEBLOCK1

Query with a filter.

CODEBLOCK2

Fetch a single record.

CODEBLOCK3

Override auth on the fly.

CODEBLOCK4

Attachment metadata and file download.

CODEBLOCK5

Aggregate stats.

CODEBLOCK6

Service Catalog read only GETs.

CODEBLOCK7

Service Catalog endpoints GET only

• - cart
• delivery-address userid
• validate-categories
• on-change-choices entityid
• catalogs
• catalog sysid
• catalog-categories sysid
• category sysid
• items
• item sysid
• item-variables sysid
• item-delegation itemsysid usersysid
• producer-record producerid recordid
• record-wizard recordid wizardid
• generate-stage-pool quantity
• step-configs
• wishlist
• wishlist-item cartitemid
• wizard sysid

Schema Inspection

Use this if you are unsure of a field name.

CODEBLOCK8

Reading Ticket History

Use this to read the full conversation instead of just the current state.

CODEBLOCK9

Specialist presets

Create JSON batch files under specialists/ to run multiple reads at once.

• - specialists/incidents.json

Each entry supports sysparm_* fields plus these items.

• - name label in the batch output
• table target table
• sys_id optional single record fetch

Run a batch preset.

CODEBLOCK10

Output

The Table API returns JSON by default. Results appear under result.

Notes

• - Keep result sizes small with sysparmlimit.
• Use sysparmfields to avoid large payloads.
• This skill is read only by design.

Summary of the Agent Toolkit

• - list and get show the current state of records.
• attach shows files and screenshots.
• stats shows analytics and aggregates.
• sc shows requested item variables.
• schema shows the database map to correct errors.
• history shows the timeline of human conversations.

Observations & Notes (important)

• - Service Catalog endpoints may return empty arrays depending on catalog content and search text — try more specific --sysparm_text terms or increase --sysparm_limit.
• INLINECODE2 is enabled by default for table reads to return human-friendly values (e.g., user names instead of sysids). If you need raw system ids, pass --sysparm_display_value false.
• Keep --sysparm_limit small for agent-initiated queries to avoid large payloads and timeouts. Prefer stats for counts or aggregates instead of downloading many rows.
• Attachments: metadata is available via attach list/attach get; use attach file <sys_id> --out <path> to download binary content for local analysis.
• Schema inspection (schema) avoids guessing field names and is the recommended first step before reading unknown tables.
• History (history) fetches journal entries (comments/worknotes) from sys_journal_field and is useful to read the full conversation thread for a ticket.
• Use --pretty to make JSON outputs readable for human review and to help the agent summarize long results.

Recommended Batch Presets

I recommend these specialist JSON presets under specialists/ to speed up common read workflows. They are safe (read-only) and demonstrate how to combine related reads.

1) specialists/inspect_incident_schema.json — schema inspection for incident:

CODEBLOCK11

2) specialists/incident_history_template.json — history template (replace <SYS_ID> with the target sys_id before running):

CODEBLOCK12

3) specialists/attachments_incident.json — recent attachments for incident table:

CODEBLOCK13

How to use these:

• - For schema: INLINECODE19
• For history: replace <SYS_ID> then node cli.mjs batch specialists/incident_history_template.json --pretty (or run node cli.mjs history incident <SYS_ID> --pretty)
• For attachments: node cli.mjs batch specialists/attachments_incident.json --pretty, then node cli.mjs attach file <sys_id> --out /tmp/file to download a file.

These presets are intentionally read-only and conservative (limits set small). Feel free to ask for additional presets (P1 dashboards, recent changes, escalations).