/
NetSuite Upsert List

NetSuite Upsert List

Owned by Lakshmi Manda
Last updated: May 09, 2024 by Lakshmi Manda

On this Page


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:
Account: 

This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See NetSuite Account for information on setting up this type of account.

Views:
InputThis Snap has exactly one document input view.
OutputThis Snap has at most one document output view.
ErrorThis 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.

Example: Customer
Default value: Account