Bots From Extension: servicenow_v2
ServiceNow - Read, Write and Update ServiceNow tables
This extension provides 15 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. |
| retry_on_keywords | Text | Comma separated list of keywords to retry on. Case insensitive |
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 |
|---|---|---|---|
| table | Text | incident | 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 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. |
| retry_on_keywords | Text | Comma separated list of keywords to retry on. Case insensitive |
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:get-ci-relations
Bot Position In Pipeline: Sink
Get CMDB CI relationships (cmdb_rel_ci) for CIs in the input dataset. Expects 'parent_sys_id' and/or 'child_sys_id' columns; optional 'depth' (default 1) recursively expands the discovered CIs while tracking visited CIs to avoid loops.
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 |
|---|---|---|---|
| parent_sys_id_col | Text | parent_sys_id | Input column holding parent CI sys_ids. Ignored if the column is absent. |
| child_sys_id_col | Text | child_sys_id | Input column holding child CI sys_ids. Ignored if the column is absent. |
| depth | Text | 1 | Levels of the relationship graph to traverse. 1 (default) returns only relationships directly attached to the input CIs. Higher values expand the CIs discovered at each level; already visited CIs are never re-expanded. |
| relationship_types | Text | Comma separated relationship type names or sys_ids to keep. All types are returned when not specified. |
|
| max_relations | Text | 0 | Maximum number of relationships to return across all levels. 0 (default) means no limit. |
| concurrent_workers | Text | 10 | Number of concurrent workers used to query CIs at each level. |
| batch_size | Text | 1000 | Number of relationship records to fetch per page. |
| retry_count | Text | 0 | Number of times to retry a failed request. By default, retry is disabled. |
| retry_interval | Text | 15 | Seconds to wait before retrying a failed request. |
| display_value | Text | true | Return display values instead of raw values. Ex: true, false, all. |
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-by-sys-ids
Bot Position In Pipeline: Sink
Query ServiceNow table records by sys_id. Expects input with sys_id column.
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 |
|---|---|---|---|
| sys_id_col | Text | sys_id | Column name that contains the sys_id of the ServiceNow record. |
| table_name | Text | cmdb_ci | ServiceNow table name. |
| concurrent_workers | Text | 10 | Number of concurrent workers to use for the query. |
Bot #snowv2:query-table
Bot Position In Pipeline: Sink
Get data from specified ServiceNow table (CMDB or others), 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.
Example Pipelines Using this Bot
Bot #snowv2:query-table-stream
Bot Position In Pipeline: Sink
Stream data from specified ServiceNow table (CMDB or others), use CFXQL to filter the data. Paginated data is streamed to a pstream or kafka topic.
This bot expects Full CFXQL.
Bot translates the Query to native query of the Data source supported by this extension.
Bot @snowv2:tables-count
Bot Position In Pipeline: Sink
Get row counts for specified ServiceNow tables. Expects 'table' column from input dataset with table names; Optional 'concurrent_workers' (default 5) can be provided for parallel counting.
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_column_name | Text | table | Name of the column in input dataset that contains ServiceNow table names |
| concurrent_workers | Text | 5 | Number of concurrent workers to use for parallel counting |
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 |
|---|---|---|---|
| table | Text | incident | ServiceNow table name. |
| 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. |
| retry_on_keywords | Text | Comma separated list of keywords to retry on. Case insensitive |
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 ServiceNow 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. |
| retry_on_keywords | Text | Comma separated list of keywords to retry on. Case insensitive |