Bots From Extension: servicenow_v2
ServiceNow - Read, Write and Update ServiceNow tables
This extension provides 11 bots.
Bot @snowv2:append-to-table
Bot Position In Pipeline: Sink
Add a new record to ServiceNow table(CMDB or others).
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| table* | Text | ServiceNow table name | |
| mandatory_cols* | Text | Comma separated list of column names that must be present in input dataset | |
| optional_cols | Text | Comma separated list of column names that may be present in input. They are included in ServiceNow append if present. |
|
| concurrent_append | Text | 5 | Specify number of records to be appended concurrently |
| retry_count | Text | 0 | Specify the retry count to re-establish connection when there is a network timeout. By default, retry is disabled. |
| retry_interval | Text | 15 | Specify the time in seconds to wait before trying to re-establish connection when there is a network timeout. By default, it is set to 15 seconds. |
Bot @snowv2:attach-to-incident
Bot Position In Pipeline: Sink
Attach a specified dataset as an attachment to ServiceNow incident. Incident's 'number' column is expected in the input
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| dataset | Text | Attach specified dataset to the input dataframe incident 'number' | |
| attachment_name | Text | Attachment name, default is same as dataset name with .csv extension | |
| id_field_name | Text | number | Type of value in 'number' field column. Can be one of 'number' or sys_id' |
Bot @snowv2:cmdb-table-relations
Bot Position In Pipeline: Source
Get CMDB Table Relations
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| table* | Text | ServiceNow table name. Multiple table names can be specified as comma separated values. |
Bot @snowv2:create-incident
Bot Position In Pipeline: Sink
Create a new ServiceNow Incident.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| mandatory_cols* | Text | Comma separated list of column names that must be present in input dataset | |
| optional_cols | Text | Comma separated list of column names that may be present in input. They are included if present. | |
| concurrent_append | Text | 5 | Specify number of records to be appended concurrently |
| retry_count | Text | 0 | Specify the retry count to re-establish connection when there is a network timeout. By default, retry is disabled. |
| retry_interval | Text | 15 | Specify the time in seconds to wait before trying to re-establish connection when there is a network timeout. By default, it is set to 15 seconds. |
Bot @snowv2:delete-from-table
Bot Position In Pipeline: Sink
Delete one or more records from ServiceNow table (CMDB or others)
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| table* | Text | Specify ServiceNow table name | |
| sys_id_col* | Text | Specify the input column that has one or more sys_ids of ServiceNow table records | |
| concurrent_delete | Text | 5 | Specify number of records to be deleted concurrently |
Bot #snowv2:list-incidents
Bot Position In Pipeline: Source
List all incidents available in ServiceNow instance, use CFXQL to filter the data.
This bot expects Full CFXQL.
Bot translates the Query to native query of the Data source supported by this extension.
Bot *snowv2:list-tables
Bot Position In Pipeline: Source
List all tables available in ServiceNow instance (CMDB, Incidents or others)
This bot expects a Full CFXQL.
Bot applies the Query on the data that is already loaded from previous bot or from a source.
Bot @snowv2:meta
Bot Position In Pipeline: Source
Get metadata of a specified ServiceNow table (CMDB, Incidents or others)
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| table* | Text | ServiceNow table name. Multiple table names can be specified as comma separated values. |
Bot #snowv2:query-table
Bot Position In Pipeline: Sink
Get data from specified ServiceNow table (CMDB or others), use CFXQL to filter the data. Expects 'table' column from input dataset; Optional 'limit' (default 1000), 'retry_count' (default 0) and 'retry_interval' (default 15) can also be provided.
This bot expects Full CFXQL.
Bot translates the Query to native query of the Data source supported by this extension.
Example Pipelines Using this Bot
Bot @snowv2:update-incident
Bot Position In Pipeline: Sink
Update an existing ServiceNow Incident with new data.
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| id_cols* | Text | Comma separated list of column names uniquely identify a ServiceNow Incident row | |
| data_cols* | Text | Comma separated list of columns that will be updated in the target ServiceNow Incidents | |
| append_for_no_record | Text | no | Create a new record if not present in the table. Provide yes/no |
| concurrent_update | Text | 5 | Specify number of records to be updated concurrently |
| retry_count | Text | 0 | Specify the retry count to re-establish connection when there is a network timeout. By default, retry is disabled. |
| retry_interval | Text | 15 | Specify the time in seconds to wait before trying to re-establish connection when there is a network timeout. By default, it is set to 15 seconds. |
Bot @snowv2:update-table
Bot Position In Pipeline: Sink
Update an existing record in ServiceNow table(CMDB or others).
This bot expects a Restricted CFXQL.
Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot
| Parameter Name | Type | Default Value | Description |
|---|---|---|---|
| table* | Text | ServiceNow table name | |
| id_cols* | Text | Comma separated list of column names uniquely identify a ServiceNow table row | |
| data_cols* | Text | Comma separated list of columns that will be update in the target SreviceNow table | |
| append_for_no_record | Text | no | Create a new record if not present in the table. Provide yes/no |
| concurrent_update | Text | 5 | Specify number of records to be updated concurrently |
| retry_count | Text | 0 | Specify the retry count to re-establish connection when there is a network timeout. By default, retry is disabled. |
| retry_interval | Text | 15 | Specify the time in seconds to wait before trying to re-establish connection when there is a network timeout. By default, it is set to 15 seconds. |