On this Page
| Table of Contents | ||||
|---|---|---|---|---|
|
Snap type: | Write | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
Description: | This Snap asynchronously inserts or updates a list of record(s) in NetSuite database. If the Get async results property is selected, the Snap submits a job, checks the job status and gets the results. Individual records in the results will be routed to the output view or the error view depending on whether or not they are upserted successfully. Input documents are passed through if the Pass through property is selected. Input documents are always routed the error view if the results contain any error. If the Get async results property is deselected, the Snap submits a job and returns a job ID at the output view. This job ID information may be supplied to NetSuite Check Async Status and NetSuite Get Async Results Snaps to check the submitted job status and to download the results.
Note: Empty number values should be given as 0.0, not as null. | |||||||||
| Prerequisites: | Make sure the data to be added maps correctly to the fields where it is being directed and is of the correct data type. | |||||||||
| Support and limitations: | Ultra pipelines: May work in Ultra
| |||||||||
| 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: |
| |||||||||
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: 1000 | |||||||||
Object | Required. NetSuite record type. Default value: Account | |||||||||
Custom Record | Custom record type (required if CustomRecord is selected for Object). Default value: None | |||||||||
Custom fields |
| |||||||||
Required. Custom field definition in NetSuite. Default value: None | Required. Custom field value. Can either be a variable from the input view, an expression or a static value. Default value: None | |||||||||
Get async results | If selected, the Snap submits a job, checks the job status and gets the results when finished. If not selected, the Snap submits a job and produces a job ID information at the output view. Default value: Selected | |||||||||
Pass through | Required. If selected, the Snap passes the input document to the output view under the 'original' key. Default value: Selected | |||||||||
Request time out | Required. Timeout for the web service call (in seconds). 0 indicates no timeout. Default value: 0 | |||||||||
Maximum request attempts | Required. The maximum number of requests to attempt in case of failure. Default value: 3 | |||||||||
Retry requests interval | Required. Specifies the interval between two successive SOAP requests. A retry happens only when the previous attempt resulted in an exception. Default value: 2 | |||||||||
| ||||||||||
Execute during preview
| This property enables you to execute the Snap during the Save operation so that the output view can produce the preview data. When enabled, the SOAP request will be executed and the response will be written to the output view of the Snap. Default value: Not selected | |||||||||
Example
|
| |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
Troubleshooting
| Multiexcerpt include macro | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Example
This pipeline inserts and updates the records into the NetSuite object 'Account'.
The JSON Generator Snap passes the values to be inserted into the records.
The Mapper Snap maps the values to be inserted and updated to the records on the NetSuite object.
.png?version=1&modificationDate=1490243661308&cacheVersion=1&api=v2)
The NetSuite Async Upsert Snap inserts and updates the records on the NestSuite object 'Account'.
Successful execution of the pipeline displays the below output preview:
.png?version=1&modificationDate=1490243665806&cacheVersion=1&api=v2)
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|