Output
ServiceNow Output
Creates records in a ServiceNow table, or — Upsert — updates the records whose key fields match and creates the rest, then passes the rows on.
When to use it
Use it to raise incidents from monitoring exports, load assets into the CMDB, or keep users in step with HR data.
In a pipeline
File InputRename ColumnServiceNow Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Sync servers into the CMDB
- Target Table=cmdb_ci_server
- Write Mode=Upsert
- Key columns=serial_number
| serial_number | name | os |
|---|---|---|
| SN-001 | web-01 | Linux |
| SN-002 | db-01 | Linux |
| serial_number | name | os |
|---|---|---|
| SN-001 | web-01 | Linux |
| SN-002 | db-01 | Linux |
Worth knowing
- Columns are sent as fields of the same name; ServiceNow ignores names it does not know.
- Upsert on sys_id updates that record directly; on other keys it looks the record up first.
- ServiceNow has no transactions: an error stops the node, and the records before it stay written. Replace is not offered. Previews never write.