To manage or retrieve records in ServiceNow® through its REST Tables API, add a step with a ServiceNow connection command.
To enable these commands, an IT admin first creates a ServiceNow connector.
Create record
To insert a record in a table, use a Create record command.
Properties
| Property |
Detail |
| Table name |
Enter the name of the table to save the record in. |
| Fields |
Enter the fields to update. |
Outputs
| Output |
Output type |
| Record |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error during execution |
Delete record
To delete a record from a table, use a Delete record command.
Properties
| Property |
Detail |
| Table name |
Enter the name of the table to delete the record from. |
| Sys ID (record ID) |
Enter the unique identifier of the record to delete. |
Outputs
None
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error during execution |
Get record
To retrieve a record based on its ID from a table, use a Get record command.
Properties
| Property |
Detail |
| Table name |
Enter the name of the table to retrieve the record from. |
| Sys ID (record ID) |
Enter the unique identifier of the record to retrieve. |
Outputs
| Output |
Output type |
| Record |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error during execution |
Get records
To retrieve multiple records from a table, use a Get records command.
Properties
| Property |
Detail |
| Table name |
Enter the name of the table to retrieve records from. |
| Fields |
Enter a comma-separated list of the field names to return in the response. To return all fields, leave blank. |
| Query |
Enter an encoded query used to filter the result set. To separate different filters, use ^, such as active=true^sys_id=1235^ORDERBYsys_id. |
Outputs
| Output |
Output type |
| Records (JSON) |
File |
| Records (CSV) |
File |
| Total records |
Integer |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error during execution |
Update record
To update a record with the request body, use an Update record command.
Properties
| Property |
Detail |
| Table name |
Enter the name of the table the record is located in. |
| Sys ID (record ID) |
Enter the unique identifier of the record to update. |
| Fields |
Enter the fields to update. |
Outputs
| Output |
Output type |
| Record |
JSON |
Exit codes
| Code |
Type |
Detail |
| 0 |
Success |
Success |
| 1 |
Error |
There was an error during execution |