Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

On this Page

Table of Contents
maxLevel2
excludeOlder Versions|Additional Resources|Related Links|Related Information


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.

Insert excerpt
Configuring NetSuite SOAP Accounts
Configuring NetSuite SOAP Accounts
nopaneltrue

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

Note

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

Example: 0
Default value: 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

Multiexcerpt include macro
nameSnap Execution
pageSOAP Execute

Multiexcerpt include macro
nameExecution_Detail_Write
pageSOAP Execute

Examples



Expand
titleUpdate an employee record using the Netsuite Upsert Snap

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:

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


Expand
titleUpsert Snap with the 'Route records to appropriate views' and the 'Pass through' properties selected

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:

Insert excerpt
NetSuite Add
NetSuite Add
nopaneltrue

Insert excerpt
NetSuite SOAP Snap Pack
NetSuite SOAP Snap Pack
nopaneltrue