In this article

Overview

You can use this Snap to add a list of records in bulk to NetSuite.

Snap Type

The NetSuite Add List Snap is a Write-type Snap.

Prerequisites

None.

Support for Ultra Pipelines

Works in Ultra Pipelines only when the batch size is 1.

Limitations and Known Issues

None.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input

Document

Min: 1
Max: 1

Mapper
Copy

Requires a list of documents in bulk to write them in NetSuite.

Output

Document

Min: 0
Max: 1

Mapper
File Reader

Writes documents in bulk in NetSuite.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab:

Stop Pipeline Execution: Stops the current Pipeline execution if the Snap encounters an error.
Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.
Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

Asterisk ( * ): Indicates a mandatory field.
Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.
Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon ( ): Indicates that you can add fields in the field set.
Remove icon ( ): Indicates that you can remove fields from the field set.
Upload icon ( ): Indicates that you can upload files.

Field Name	Field Type	Description
Label* Default Value: NetSuite Add List Example: Add List	String	Specify 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.
Batch size* Default Value: 100 Example: 50	String	Specify the maximum number of input documents to upload in a single request. You must set this field to 1 to make a separate request for each input document. The maximum batch size is 200.
Object* Default Value: Account Example: AccountingPeriod	Dropdown List	Specify the NetSuite record type.
Custom record Default Value: N/A Example: MyCustomRecord	String/Suggestion	Specify the custom record type only if you select CustomRecord as the object.
Routes records to appropriate views Default Value: Deselected	Checkbox	When you select this checkbox, the Snap parses the XML response and routes the resulting records to either output view or error view, depending on the status (success or failure).
Request timeout (seconds)* Default Value: 0 Example: 5	Integer	Specify the timeout for the web service call, in seconds. '0' indicates no timeout.
Maximum attempts* Default Value: 3 Example: 5	Integer	Specify the maximum number of requests to attempt when a request fails.
Retry interval (seconds)* Default Value: 2 Example: 5	Integer	Specify the number of seconds to wait before you retry a failed request.
Snap execution Default Value: Execute only Example: Validate & Execute	Dropdown list	Select one of the following three modes in which the Snap executes: 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.

Troubleshooting

Error	Reason	Resolution
An error occurred when executing the SOAP request.	The test is not a legal value for the Record type.	Verify that the requested data is valid.
Validation error for Batch size.	The number (2000) is greater than the allowed maximum of 200.	Batch size should be less than or equal to 200.

Examples

Add a set of records to NetSuite

This example demonstrates how to add a set of records to NetSuite.

Download this pipeline.

Step 1: Configure the JSON Generator Snap with the records you want to add to NetSuite.

Step 2: Configure the Mapper Snap with the ‘baseCurrency.name’, ‘transactionCurrency.name’, and ‘exchangeRate’ fields from the Target Schema when the Object is the Currency Rate in the NetSuite Add List Snap.

Step 3: Configure the NetSuite Add List with the Currency Rate for the Object. On validation, the Snap displays the success message for each record with the fields that have been inserted.

NetSuite Add List Configuration	NetSuite Add List Output

Download and import the Pipeline into SnapLogic.
Configure Snap accounts, as applicable.
Provide Pipeline parameters, as applicable.

	File	Modified

No files shared here yet.

Snap Pack History

Click to view/expand

Release	Snap Pack Version	Date	Type	Updates
August 2024	main27765	21 Aug 2024	Stable	Updated and certified against the current Snaplogic Platform release.
May 2024	437patches26823	24 Jun 2024	Latest	In a specific scenario where the body is absent in the SOAP request, the NetSuite Search Snap reloads the envelope to prevent the Snap from erroring out.
May 2024	437patches26705	12 Jun 2024	Latest	Added NetSuite Get Server Time Snap to the NetSuite SOAP Snap Pack. This Snap returns the NetSuite server time in GMT, regardless of the user's time zone.
May 2024	main26341	08 May 2024	Stable	Updated the following NetSuite SOAP Snap names for usability based on the functionality of the Snaps: NetSuite Create → NetSuite Add NetSuite Async Delete → NetSuite Async Delete List NetSuite Async Get → NetSuite Async Get List NetSuite Async Upsert → NetSuite Async Upsert List NetSuite Delete → NetSuite Delete List NetSuite Upsert → NetSuite Upsert List
February 2024	436patches25953	23 Apr 2024	Latest	Upgraded Apache CXF from version 3.4.2 to 3.6.3 to prevent vulnerability issues.
February 2024	436patches25995	23 Apr 2024	Latest	Updated the default and maximum batch size for NetSuite Add List and NetSuite Async Add List Snaps as follows: NetSuite Add List: Default batch size: 100 Maximum batch size: 200 NetSuite Async Add List: Default batch size: 200 Maximum batch size: 400
February 2024	436patches25852	10 Apr 2024	Latest	Added the following Snaps to the NetSuite SOAP Snap Pack: NetSuite Add List: Adds a list of records in bulk to NetSuite. NetSuite Async Add List: Inserts a list of records in NetSuite asynchronously, and the Snap returns a job ID after a successful operation.
February 2024	436patches25801	09 Apr 2024	Latest	Fixed an issue with NetSuite Upsert Snap that displayed a `null pointer exception` when the account had insufficient permissions. Now the Snap displays a `configuration exception` when the `customFieldRecord` is `null`.
February 2024	main25112	14 Feb 2024	Stable	Updated and certified against the current SnapLogic Platform release.
November 2023	main23721	08 Nov 2023	Stable	The existing NetSuite Snap Pack is renamed to NetSuite SOAP due to the introduction of the NetSuite REST Snap Pack.
August 2023	main22460	16 Aug 2023	Stable	Updated and certified against the current SnapLogic Platform release.
May 2023	433patches21878	12 Jul 2023	Latest	The Snap Pack now supports Customer-Subsidiary and Vendor-Subsidiary relationship Object types. NetSuite's application requires the Oneworld extension for utilizing these subsidiary relationships, and Snap integration must use WSDL 2019_1 or later versions.
May 2023	main21015	10 May 2023	Stable	Upgraded with the latest SnapLogic Platform release.
February 2023	main19844	09 Feb 2023	Stable	Upgraded with the latest SnapLogic Platform release.
November 2022	main18944	10 Nov 2022	Stable	The following Snaps now handle lineage properly when used in an Ultra Pipeline: NetSuite Get Item Availability, NetSuite Delete, and NetSuite GetList.
August 2022	main17386	11 Aug 2022	Stable	Upgraded with the latest SnapLogic Platform release.
4.29 Patch	429patches16915	26 Jul 2022	Latest	Fixed an issue with NetSuite Search Snap where the Snap displayed the Could not translate an element declaration element exception intermittently when multiple search Snaps are executed simultaneously.
4.29	main15993	14 May 2022	Stable	Upgraded with the latest SnapLogic Platform release.
4.28	main14627	12 Feb 2022	Stable	Upgraded with the latest SnapLogic Platform release.
4.27 Patch	427patches13080	31 Dec 2021	Latest	Fixed an XML parsing issue with stripping empty elements for the NetSuite Snaps.
4.27 Patch	427patches13072	02 Dec 2021	Latest	Fixed an issue in the NetSuite Search Snap where the Snap failed when the body is not present in the SOAP request.
4.27	main12833	13 Nov 2021	Stable	Upgraded with the latest SnapLogic Platform release.
4.26	main11181	14 Aug 2021	Stable	Upgraded with the latest SnapLogic Platform release.
4.25	main9554	08 May 2021	Stable	Upgraded with the latest SnapLogic Platform release.
4.24 Patch	424 patches8891	15 Mar 2021	Latest	Introduced the new Snap NetSuite Call RESTlet that enables calling RESTlet scripts using token-based authentication. This Snap provides the functionality of the NetSuite RESTlet framework that supports the HTTP methods (GET, DELETE, POST, PUT) and MIME types.
4.24	main8556	13 Feb 2021	Stable	Upgraded with the latest SnapLogic Platform release.
4.23	main7430	14 Nov 2020	Stable	Upgraded with the latest SnapLogic Platform release.
4.22	main6403	12 Sep 2020	Stable	Upgraded with the latest SnapLogic Platform release.
4.21	snapsmrc542	09 May 2020	Stable	Removed the obsolete Sandbox Account check box from the NetSuite Token Account. Removed the now redundant Custom WSDL URL Domain field from the NetSuite Token Account to support NetSuite's transition to automatic account-specific domain identification.
4.20 Patch	netsuite8799	13 Apr 2020	Latest	Updates the NetSuite Create, Update, Upsert, and Async Upsert Snaps to use the `Classification` type instead of `Class`, to resolve schema generation issues. While the `Class` type remains available in the NetSuite Search and Async Search Snaps for backwards compatibility, use of the `Classification` type is recommended.
4.20	snapsmrc535	08 Feb 2020	Stable	Upgraded with the latest SnapLogic Platform release.
4.19	snaprsmrc528	14 Nov 2019	Stable	Certified the NetSuite Snap Pack against the NetSuite version 2019.1. This does not impact existing Pipelines.
4.18 Patch	netsuite7879	23 Sep 2019	Latest	Fixed the NetSuite Snaps where the Snaps intermittently fail to reach, cache, and view the NetSuite WSDL and XSD files.
4.18 Patch	netsuite7779	29 Aug 2019	Latest	Fixed an issue with the NetSuite Update Snap and the NetSuite Create Snap wherein the Snaps are unable to properly handle null values for the standard and the custom fields.
4.18	snapsmrc523	10 Aug 2019	Stable	Upgraded with the latest SnapLogic Platform release.
4.17	ALL7402	11 Jun 2019	Latest	Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.
4.17	snapsmrc515	11 Jun 2019	Latest	Deprecated the NetSuite Credential account type. Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.
4.16 Patch	netsuite6911	14 Mar 2019	Latest	Fixed an issue with running multiple Pipelines by lazy-fetching custom fields metadata.
4.16	snapsmrc508	16 Feb 2019	Stable	Custom fields are not displayed in the updated NetSuite Create, Update, Upsert, Search, Async Upsert, or Async Search Snaps. They are visible only for Snaps where you have configured custom fields with SnapLogic 4.15 or earlier releases. With the updated NetSuite Snaps, you must connect a Mapper Snap as an upstream Snap to map custom fields.
4.15	snapsmrc500	15 Dec 2018	Stable	Upgraded with the latest SnapLogic Platform release.
4.14	snapsmrc490	11 Aug 2018	Stable	Upgraded with the latest SnapLogic Platform release.
4.13	snapsmrc486	12 May 2018	Stable	Upgraded with the latest SnapLogic Platform release.
4.12 Patch	netsuite4888	19 Mar 2018	Latest	Increased the maximum timeout to two minutes when parsing the WSDL file to fix an issue where the Netsuite Snap Pack is unable to parse XML schema information from the given WSDL file.
4.12	snapsmrc480	17 Feb 2018	Stable	Upgraded with the latest SnapLogic Platform release.
4.11 Patch	netsuite4382	03 Dec 2017	Latest	Resolved an issue with the NetSuite Search, Create and Update Snaps that now show the custom field suggestions in the drop down.
4.11 Patch	netsuite4296	21 Nov 2017	Latest	Resolved an issue with NetSuite Update and Search Snaps where Custom fields are not populated on the Snaps.
4.11	snapsmrc465	11 Nov 2017	Stable	Upgraded with the latest SnapLogic Platform release.
4.10	snapsmrc414	12 Aug 2017	Stable	Upgraded with the latest SnapLogic Platform release.
4.9.0 Patch	netsuite3227	06 Jul 2017	Latest	Addressed an issue with retry disabled if the reason field contains INVALID_KEY_OR_REF
4.9.0 Patch	netsuite3112	19 Jun 2017	Latest	Addressed an issue in NetSuite Upsert where List/Record type is sent as MultiSelectCustomFieldRef.
4.9.0 Patch	netsuite3015	22 May 2017	Latest	Added Thread Safety to the creation of Soap Request Message for the NetSuite Search Snap.
4.9	snapsmrc405	13 May 2017	Stable	Upgraded with the latest SnapLogic Platform release.
4.8.0 Patch	netsuite2839	06 Apr 2017	Latest	Provided a new property for custom WSDL support for NetSuite
4.8.0 Patch	netsuite2704	28 Feb 2017	Latest	Fixed performance issue on NetSuite Snap Pack which was caused by the WSDL imports.
4.8	snapsmrc398	11 Feb 2017	Stable	Route records to appropriate views and Pass through properties added to the Netsuite Upsert, Delete and GetList Snaps. Introduced the NetSuite Get Async Result, NetSuite Check Async Status, NetSuite Async Delete, NetSuite Async Get, NetSuite Async Upsert, NetSuite Async Search Snaps in this release. Info tab added to accounts.
4.7	snapsmrc382	23 Nov 2016	Stable	Upgraded with the latest SnapLogic Platform release.
4.6.0 Patch	netsuite1855	22 Aug 2016		Resolved an issue with the NetSuite Search Snap intermittently generating a "The body is not present in the SOAP request" error.
4.6	snapsmrc362	13 Aug 2016	Stable	Maximum request attempts and Retry request interval options added to the NetSuite Upsert, Get, Get List, Create, Search, Delete and Update Snaps. NetSuite Get Item Availability Snap was introduced in this release. Resolved an issue in NetSuite Snap Pack that caused Snaps to fail with read timeout errors. Enhanced the NetSuite Snaps to support custom fields on the following object types: VendorBill, VendorBillItem, VendorBillExpense, ExpenseReportExpense, PurchaseOrderExpense. Additionally, Address on Contact, Customer, Partner, Vendor, Job, & Employee are also supported when using WSDL version 2014.2 or later. Enhanced the NetSuite Search Snap to support the general object types Item and Transaction, rather than just their more specific subtypes. Resolved an issue with the NetSuite Upsert Snap that was incorrectly handling some failed requests as successful requests. Any response containing at least one error status is now written to the error view instead of the output view.
4.5.1	netsuite1565	18 May 2016	Stable	Updated the Search Snap to support advanced search. This enables you to execute a saved search using its ID & search for relevant records in it. Fixed an error in NetSuite Update Snap that restricted access to a custom field in the addressbook sublist of a contact object.
4.5	snapsmrc344	18 May 2016	Stable	Item and Inventory Item added as options for the Object property in NetSuite Search. Token Based Authentication for SuiteTalk web services added. Resolved an issue in NetSuite Snaps to ensure appropriate handling and display of error messages during failure. Resolved an issue in NetSuite Snaps that occurred when different values were entered for a custom field. Resolved an issue in NetSuite Search Snap to ensure all records are returned when the input search criteria is empty. NetSuite Snaps are enhanced to support the APIs from 2016 (version 2016). Starting from SnapLogic 4.5 release, only APIs from 2014 or later are supported. MIGRATION IMPACT: Note that the accounts have changed for NetSuite. The existing NetSuite account was renamed to NetSuite Credentials Account; the properties of WSDL Release and WSDL Patch were added and the Testdrive account option was removed. A NetSuite Token Account was also added.
4.4.1		18 Mar 2016	Stable	SnapLogic's pre-assigned NetSuite Application ID is now in every header sent for NetSuite Calls. Resolved an issue with a memory leak in this Snap Pack. Resolved an issue that occurred while collecting JSON schema information. Resolved an issue with setting a custom field to blank in the Update, Create, and Upsert Snaps. Resolved an issue with not being able to clear standard fields that have a value in Update and Upsert Snaps. Resolved an issue with "custom field" suggest showing an error when using a standard type with only one active custom field definition. Resolved an issue with NetSuite Search Snap not producing contact address info as output. In validation/preview mode only, WSDL versions are checked for consistency between the Snap and the Account.
4.4.0		13 Feb 2016	Stable	Resolved an issue with NetSuite Search Snap ignoring criteria from an input document if any custom field criteria was specified in the Snap. Support for Custom Records added. Support for additional object types added. Support for custom fields for all Transaction types added. Support for custom fields of type Checkbox (boolean) added to the Search, Create, and Update Snaps. Support for custom fields of type Date and Decimal added to the Create and Update Snaps. Resolved an issue with the consistency of the output schema when Search returned more than one page.
4.3.2		15 Jan 2016	Stable	Resolved an issue with custom fields not appearing in the Update Snap. Resolved an issue with NetSuite Create with custom field not showing in the output payload. Improved performance of the NetSuite Snap Pack.
4.2.2		07 Aug 2015	Stable	Snaps tested against NetSuite server version 2015.2.

NetSuite Add List