Skip to content

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
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.







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
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.







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.