This Snap connects to the particular instance provided by ServiceNow, updates the records into the given table based upon the given clause, 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,record ID,and record details.
This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See ServiceNow Account or 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]
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 update a record in a ServiceNow table using a ServiceNow Update Snap.
In the pipeline execution:
maps ServiceNow record details (that must be updated) to the input fields of ServiceNow Update Snap:
ServiceNow Update Snap updates the 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 updated record:
Snap Pack History
Click to view/expand
Release
Snap Pack Version
Date
Type
Updates
November 2024
main29029
Stable
Updated 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 2024
main25112
Stable
Updated and certified against the current SnapLogic Platform release.
Updated and certified against the current SnapLogic Platform release.
August 2023
main22460
Stable
Updated and certified against the current SnapLogic Platform release.
May 2023
main21015
Stable
Upgraded with the latest SnapLogic Platform release.
February 2023
main19844
Stable
Upgraded with the latest SnapLogic Platform release.
November 2022
main18944
Stable
Upgraded with the latest SnapLogic Platform release.
August 2022
main17386
Stable
Upgraded with the latest SnapLogic Platform release.
4.29
main15993
Stable
Upgraded with the latest SnapLogic Platform release.
4.28
main14627
Stable
Added a new account type ServiceNow OAuth2 that enables OAuth2 authentication for all the ServiceNow Snaps.
4.27
main12833
Stable
Upgraded with the latest SnapLogic Platform release.
4.26
main11181
Stable
Upgraded with the latest SnapLogic Platform release.
4.25 Patch
425patches10014
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.25
main9554
Stable
Upgraded with the latest SnapLogic Platform release.
4.24
main8556
Stable
Upgraded with the latest SnapLogic Platform release.
4.23
main7430
Stable
Upgraded with the latest SnapLogic Platform release.
4.22
main6403
Stable
Upgraded with the latest SnapLogic Platform release.
4.21
snapsmrc542
Stable
Adds support for ServiceNow Madrid, New York, and Orlando versions.
4.20
snapsmrc535
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.19
snaprsmrc528
Stable
The Snap Pack supports the Madrid release of ServiceNow.
4.18
snapsmrc523
Stable
Upgraded with the latest SnapLogic Platform release.
4.17
ALL7402
Latest
Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.
4.17
snapsmrc515
Latest
AddedBatch Sizeproperty 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.16
snapsmrc508
Stable
Upgraded with the latest SnapLogic Platform release.
4.15
snapsmrc500
Stable
Upgraded with the latest SnapLogic Platform release.
4.14
snapsmrc490
Stable
Upgraded with the latest SnapLogic Platform release.
4.13
snapsmrc486
Stable
Upgraded with the latest SnapLogic Platform release.
4.12
snapsmrc480
Stable
Upgraded with the latest SnapLogic Platform release.
4.11
snapsmrc465
Stable
Added Jakarta support to the Snap Pack.
4.10
snapsmrc414
Stable
Upgraded 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.9
snapsmrc405
Stable
Upgraded with the latest SnapLogic Platform release.
4.8
snapsmrc398
Stable
Upgraded 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
Stable
Upgraded 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.6
snapsmrc362
Stable
Upgraded 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
-
Stable
Upgraded with the latest SnapLogic Platform release.
4.4
-
Stable
Upgraded with the latest SnapLogic Platform release.