SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with ServiceNow.

• Create an incident
• Create an incident using display values
• Delete an attachment
• Delete an incident
• Download an attachment by ID
• Download attachments
• Download attachments by parent record
• Read all columns of all tables
• Read an incident by ID
• Read an incident by number
• Read any API endpoint (generic request)
• Read attachments by parent record
• Read attachments for an incident
• Read attachments information
• Read columns of a table
• Read data from system tables
• Read display value of a reference field
• Read dropdown labels and values
• Read incident additional comments
• Read incident tasks
• Read incident work notes
• Read incidents
• Read incidents incrementally (by updated date)
• Read incidents using reference fields
• Read list of tables
• Read record labels (tags)
• Read selected columns (performance optimization)
• Read table row count
• Read table using server-side filter
• Update an incident
• Upload an attachment