Read an incident by number

Fetch a specific incident using its human-readable number (for example INC0012345). This is the most common lookup used in integrations and support workflows.

The query filters the incident table using sysparm_query semantics.

-- Query a single incident by incident number
SELECT *
FROM get_table_rows
WITH(
  TableName='incident',
  Query='number=INC0012345'
)