Overview

Snap type:

Write

Description:

This Snap provides the ability to create or update records in NetSuite by defining an object. The fields that can be set on the object are provided on the input view of the Snap and can be mapped using an upstream Data or Structure Snap. The Snap batches up to 100 records per request.

Expected upstream Snaps: Any Snap that provides a document output view, such as Mapper or Structure or a JSON Generator Snap.
Expected downstream Snaps: [None] or any Snap that has a document input view, such as Filter or Mapper or JSON Formatter.
Expected input: This Snap provides schema on its input view for the selected object that can then be used in a Mapper Snap to map the required fields.
Expected output: This Snap provides the result of the upsert (update and insert) operation for the given criteria on the output view. Errors can be routed to the error view if enabled or cause the Snap to fail during execution.

Note: Empty number values should be given as 0.0, not as null.

Prerequisites:

None

Support and limitations:

Works in Ultra Pipelines.
Supports only NetSuite Web Services-supported objects.
For information on the supported objects, see https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2019_2/schema/record/account.html.

Views:

Input	This Snap has exactly one document input view.
Output	This Snap has at most one document output view.
Error	This Snap has at most one document 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.

Batch Size

Required. The maximum number of input documents to batch in a single request. Set to 1 to make a separate request for each input document.

Default value: 100

Object

Required. The NetSuite Object type to update. For example, to search for records of a custom record type, select Custom Record from the available options..

To use the AdvInterCompnayJournalEntry object in NetSuite, particularly in a OneWorld or multi-subsidiary environment, you must configure a custom role with the appropriate permissions, including Transactions Make Journal Entry (Full).

NetSuite's application requires the Oneworld extension for utilizing these subsidiary relationships, and Snap integration should use WSDL 2019_1 or later versions.

Default value: Account
Example: Customer

Custom record

Conditional. Custom record type to update. This is applicable and required only if Custom Record is selected for an Object.

Route records to appropriate views

If selected, the Snap parses the response and routes resulting records to the output view or the error view depending on the resulting status: success or failure.
If not selected, the Snap would not parse the response and write the document(s) to the output view or the error view per each batch.

Default value: Not selected

Pass through

Required. If selected, the Snap passes the input document to the output view under the 'original' key. If not selected, the input document is not passed through to the output view. The error view always has an input document in each error document whether this property is selected or not. This property matters only if the "Route records to appropriate views" property is selected.

Default value: Selected

Request timeout

Required. The timeout for the web service call (in seconds). 0 indicates no timeout.

Default value: 0
Example: 10

Maximum request attempts

Required. Specifies the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response.

Default value: 3

Retry request interval

Required. Specifies the interval (in seconds) between two successive requests. A retry happens only when the previous attempt resulted in an exception.

Default value: 2

Examples

The following example will illustrate the usage of the Upsert Snap. In this example, we update an employee record using the NetSuite Upsert Snap.

In the pipeline execution:

Mapper (Data) Snap maps the employee details to the input fields of NetSuite Upsert Snap:
NetSuite Upsert Snap updates an employee record using the Employee object:
After the pipeline executes, the NetSuite Upsert Snap shows the following data preview:

Following example will illustrate the usage of Upsert Snap with the "Route records to appropriate views" and the "Pass through" properties selected.
In this example, there are three input documents: one of the records is updated and the two records fails with errors.

Input documents to the Snap are following:

The output document at the output view is as following:

The error documents at the error view are as following:

NetSuite Upsert List

Overview

Settings

Examples