ServiceNow Delete

On this Page

Snap type:

Write


Description:

This Snap connects to the particular instance provided by ServiceNow, deletes the records by the IDs (fetched from the incoming documents) from the given table, and returns the response 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 ID.
  • Expected output:  Deletes a record.


Prerequisites:

[None]


Support and limitations:Works in Ultra Tasks.
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

ErrorThis 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]

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 pass the record ID of ServiceNow record to be deleted from a specified table using a ServiceNow Delete Snap.

 

In the pipeline execution:

Mapper Snap maps ServiceNow record's ID (sys_id) to the input fields of ServiceNow Delete Snap:

ServiceNow Delete Snap deletes the specified 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 deleted record: 

Snap Pack History

 Click to view/expand
Release Snap Pack VersionDateType  Updates
November 2024main29029 StableUpdated and certified against the current SnapLogic Platform release.

August 2024

main27765

 

Stable

Upgraded the org.json.json library from v20090211 to v20240303, which is fully backward compatible.

May 2024

main26341

 

Stable

Updated and certified against the current SnapLogic Platform release.

February 2024main25112 StableUpdated and certified against the current SnapLogic Platform release.
November 2023435patches24712 Latest

The Batch Size field is now relabeled to Page size in ServiceNow Query and ServiceNow Insert Snaps.

November 2023main23721 StableUpdated and certified against the current SnapLogic Platform release.
August 2023main22460 StableUpdated and certified against the current SnapLogic Platform release.

May 2023

main21015 

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023main19844 StableUpgraded with the latest SnapLogic Platform release.
November 2022main18944 StableUpgraded with the latest SnapLogic Platform release.
August 2022main17386 StableUpgraded with the latest SnapLogic Platform release.
4.29main15993 StableUpgraded with the latest SnapLogic Platform release.
4.28main14627 StableAdded a new account type ServiceNow OAuth2 that enables OAuth2 authentication for all the ServiceNow Snaps.
4.27main12833 StableUpgraded with the latest SnapLogic Platform release.
4.26main11181 StableUpgraded with the latest SnapLogic Platform release.
4.25 Patch425patches10014 Latest

Enhanced the ServiceNow Query Snap with the Retry mechanism that includes the following fields:

  • Number Of Retries: Specifies the number of attempts the Snap should make to perform the selected operation in case of connection failure or timeout.
  • Retry Interval (seconds)Specifies the minimum number of seconds the Snap must wait before each retry attempt.
4.25main9554
 
StableUpgraded with the latest SnapLogic Platform release.
4.24main8556
StableUpgraded with the latest SnapLogic Platform release.
4.23main7430
 
StableUpgraded with the latest SnapLogic Platform release.
4.22main6403
 
StableUpgraded with the latest SnapLogic Platform release.
4.21snapsmrc542

 

Stable

Adds support for ServiceNow Madrid, New York, and Orlando versions.

4.20snapsmrc535
 
Stable

The ServiceNow Query Snap enhances its scope to include both autogenerated and custom fields.

4.19 Patch servicenow8260 Latest
  • Fixes an issue with the ServiceNow Insert Snap wherein the output provides zero counts if it includes any error records.
  • Fixes an issue with the ServiceNow Update Snap wherein 403 error occurs while fetching schema.
4.19snaprsmrc528
 
Stable

The Snap Pack supports the Madrid release of ServiceNow.

4.18snapsmrc523
 
StableUpgraded with the latest SnapLogic Platform release.
4.17ALL7402
 
Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17snapsmrc515
 
Latest
  • Added Batch Size property to ServiceNow Insert and ServiceNow Query Snaps, that enables you to configure the number of documents that you want to process per batch. You can configure the Batch Size for Ultra Tasks as well. 
  • Added the Snap Execution property to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.
4.16 Patch servicenow6897 Latest

ServiceNow Snaps will not support parsing logic for JSON version. All JSON versions must be replaced with JSON2.

4.16snapsmrc508
 
StableUpgraded with the latest SnapLogic Platform release.
4.15snapsmrc500
 
StableUpgraded with the latest SnapLogic Platform release.
4.14snapsmrc490
 
StableUpgraded with the latest SnapLogic Platform release.
4.13

snapsmrc486

 
StableUpgraded with the latest SnapLogic Platform release.
4.12

snapsmrc480

 
StableUpgraded with the latest SnapLogic Platform release.
4.11snapsmrc465
 
Stable

Added Jakarta support to the Snap Pack.

4.10

snapsmrc414

 
StableUpgraded with the latest SnapLogic Platform release.
4.9.0 Patch servicenow3065 Latest

Addressed an issue with a query against SNOW showing duplicates that aren't present outside of SnapLogic.

4.9snapsmrc405
 
StableUpgraded with the latest SnapLogic Platform release.
4.8

snapsmrc398

 
StableUpgraded with the latest SnapLogic Platform release.
4.7.0 Patch servicenow2183 Latest

Pass through option support added for table API in ServiceNow Query.

4.7

snapsmrc382

 
StableUpgraded with the latest SnapLogic Platform release.
4.6.0 Patch servicenow1884 Latest

Implemented an option to keep the pre-4.6 behavior of ServiceNow Query Snap; Resolved an issue of extra blank line in the ServiceNow Query result set.

4.6snapsmrc362
 
StableUpgraded with the latest SnapLogic Platform release.
4.5.1

snapsmrc344

 
Stable
  • Support for Helsinki added.
  • Fixed an error in record insertion for ServiceNow Insert Snap.
  • Enhanced error reporting in ServiceNow Delete Snap when sys_id is invalid.
4.5

snapsmrc344

 Latest
  • Support for Geneva added.
  • Resolved an issue in ServiceNow Insert & Update Snap to ensure correct target schema generation for the tables.
  • Resolved an issue in ServiceNow Query Snap that occurred when validating account details.
  • Resolved an issue in ServiceNow Insert Snap that occurred when record insertion.


4.4.1- StableUpgraded with the latest SnapLogic Platform release.
4.4- StableUpgraded with the latest SnapLogic Platform release.