ServiceNow Insert

Owned by Kalpana Malladi
Last updated: Jan 23, 2024 by Gouri Bhagchandani

On this Page

Snap type:

Write


Description:

This Snap connects to the particular instance provided by ServiceNow, inserts the incoming records into the given table, and returns the response (all the fields pertaining to the record) as a document stream.

  • Expected upstream Snaps: Any Snap that provides a document output view such as a Mapper Snap.
  • Expected downstream Snaps: [None] or any Snap that has a document input view such as a Filter or a Data or a JSON Formatter.
  • Expected input:  A Table Name and record details.
  • Expected output:  Inserts a record.


Prerequisites:

[None]


Support and limitations:

Works in Ultra Tasks.

In Ultra Pipelines, set the Page size as 1 for the Snap to process one document/record at a time.

Account: 

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring ServiceNow Accounts for information on setting up this type of account.


Views:
Input

This Snap has exactly one input view.

Output

This Snap has exactly one output view.

Error

This Snap has at most one error view and produces zero or more documents in the view.

Settings

Label


Required. The name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline.

Table name


Required. The name of the table in the instance. The table name is suggestible but requires an account setting for the suggestions to appear.


Only accounts that have the 'Personalize dictionary' role can see the field labels associated with each table in the ServiceNow data dictionary. Therefore, accounts used with Snaps in this Snap Pack must have the ‘Personalize dictionary’ permission if you want to view the Table name suggestions..

Example: incident

Default value: [None]

Page size

Required. Number of documents for processing in a single batch.

Minimum Value: 1

Maximum Value: 500

Default Value: 500

Set the value as 1 when using the Snap in an Ultra Pipeline.

Number of retries

Specifies the maximum number of retry attempts when the Snap fails to write.

Example: 3

Minimum value: 0

Default value: 0

Retry interval (seconds)

Specifies the minimum number of seconds the Snap must wait before each retry attempt.

Example: 3

Minimum value: 1

Default value: 1

Snap execution

Select one of the three modes in which the Snap executes. Available options are:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.
  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.


 Example

The example assumes that you have configured & authorized a valid ServiceNow account (see Configuring ServiceNow Accounts) to be used with this Snap. 

The following pipeline shows how you can insert a new record in a ServiceNow table using a ServiceNow Insert Snap.

 

In the pipeline execution: 

Mapper Snap maps ServiceNow record details to the input fields of ServiceNow Insert Snap:

ServiceNow Insert Snap inserts the new record in the catalog_category_request table: 

After a successful validation of the Snap, you will see a data preview that shows details of the inserted record: