Overview

Snap type:

Write

Description:

This Snap provides the ability to update records of an object in NetSuite. 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 Mapper or Structure Snap.
This Snap dispatches a request per incoming document.

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 update 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.

Prerequisites:

A valid NetSuite Account.

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.

Object

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

Default value: Account
Example: Customer

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.

Custom record

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

Request timeout

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

Default value: 0
Example: 0

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

Troubleshooting

Examples

The following example illustrates the usage of NetSuite Update Snap. In this example, using the following pipeline, we update an employee record with the new field values and add a new custom field to it.

In the pipeline execution:

Mapper (Data) Snap maps the employee data that needs to be updated to the input fields of NetSuite Update Snap:

NetSuite Update Snap updates the existing field values for employee records (based on the unique internal ID) and specifies a custom field, custentity7, to be added to the employee record:

When the NetSuite Update Snap is saved, it generates the input schema automatically. The following is the data preview of the NetSuite Update Snap:

Creating and Updating Accounts in NetSuite

In this example, you use the NetSuite Create Snap to create a NetSuite account record, whose schema contains custom fields. You then update the object using the NetSuite Update Snap.

Download this pipeline.

You use the Mapper Snap to supply the NetSuite Create Snap with the details needed to create a record:

The Mapper Snap provides a document containing the data required to create an account, organized as pairs of key-value attributes:

You now run the data through the NetSuite Create Snap, which you configure to create an account:

The Snap creates your account using the values you provided through the Mapper Snap, and displays the details associated with the task:

You now decide to update the account you just created, and use a Mapper Snap to map attributes in the newly-created account to the new values that you want to assign to them:

The Mapper Snap maps the key-value pairs using your inputs, and offers them to the downstream NetSuite Update Snap:

Once execution completes, the NetSuite Update Snap updates the account you had created in the previous steps, and displays the results of the operation:

NetSuite Update

Overview

Settings

Troubleshooting

Examples

Creating and Updating Accounts in NetSuite

Downloads