Skip to end of banner
Go to start of banner

NetSuite Async Add List

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 23 Current »

In this article

Overview

You can use this Snap to insert a list of records in NetSuite asynchronously. The Snap returns a job ID after a successful operation.

netsuite-async-add-list.png

Snap Type

The NetSuite Async Add List Snap is a Write-type Snap.

Prerequisites

None

Support for Ultra Pipelines

Works in Ultra Pipelines only when the batch size is 1.

Limitations and Known Issues

None.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

 

  • Min: 1

  • Max: 1

  • Mapper

  • Copy

Requires a list of records to insert in NetSuite asynchronously.

Output

Document

 

  • Min: 1

  • Max: 1

  • Mapper

  • File Reader

Inserts a list of records in NetSuite.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop Pipeline Execution: Stops the current Pipeline execution if the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon ((blue star)): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ((blue star) ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( (blue star) ): Indicates that you can add fields in the field set.

  • Remove icon ( (blue star)): Indicates that you can remove fields from the field set.

  • Upload icon ((blue star) ): Indicates that you can upload files.

Field Name

Field Type

Description

Label*

 

Default ValueNetSuite Async Add List
Example: Async Add List

String

Specify 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*

 

Default Value200
Example: 50

String

Specify the maximum number of input documents to upload in a single request.

  • You must set this field to 1 to make a separate request for each input document.

  • The maximum batch size is 400.

Object*

 

Default ValueAccount
Example: AccountingPeriod

Dropdown List

Specify the NetSuite record type.

Custom record

 

Default Value: N/A
Example: MyCustomRecord

String/Suggestion

Specify the custom record type only if you select CustomRecord as the object.

Get async results

 

Default ValueSelected

Checkbox

When you select this checkbox, the Snap checks the submitted job status and fetches the results when finished.

When you deselect this checkbox, the Snap submits a job and produces job ID information at the output view.

Request timeout (seconds)*

 

Default Value0
Example: 5

Integer

Specify the timeout in seconds for the webservice call, in seconds. '0' indicates no timeout.

Maximum attempts*

 

Default Value3
Example: 5

Integer

Specify the number of requests to attempt if a request fails.

Retry interval (seconds)*

 

Default Value2
Example: 5

Integer

Specify the number of seconds to wait before retrying a failed request.

Snap execution

 

Default ValueExecute only
Example: Validate & Execute

Dropdown list

Select one of the following three modes in which the Snap executes:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Troubleshooting

Error

Reason

Resolution

Failed with error code: DUP_ENTITY.

This entity already exists.

Verify that the incoming data is valid and sufficient for the request.

Unsupported Snap configuration.

Set the batch size property to one for Ultra Task.

Batching is not supported in an Ultra Task.

Validation error for Batch size.

The number (2000) is greater than the allowed maximum of 400.

Batch size should be less than or equal to 400.

Examples

Add Records in Bulk to NetSuite Asynchronously

This example demonstrates how to insert records in NetSuite.

aync-add-list-pipeline-image.png

Download this pipeline.

Step 1: Configure the Sequence Snap to generate a sequence of numbers for 4 documents.

sequence-config.png

Step 2: Configure the Mapper Snap with the fields (as highlighted in the image below) from the Target Schema when the Object is Customer in the NetSuite Async Add List Snap.

mapper2-config.png

Step 3: Configure the NetSuite Asyc Add List Snap with Customer as the Object. On validation, the Snap displays the success message for each record with the fields inserted in NetSuite.

The Snap routes the duplicate records to the error view.

NetSuite Async Add List Configuration

NetSuite Async Add List Output

ns-async-add-list-config.png

ns-async-add-list-output.png

Downloads

  1. Download and import the Pipeline into SnapLogic.

  2. Configure Snap accounts, as applicable.

  3. Provide Pipeline parameters, as applicable.

  File Modified
You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.
No files shared here yet.
  • Drag and drop to upload or browse for files
  • Snap Pack History

     Click to view/expand
    ReleaseSnap Pack VersionDateTypeUpdates
    May 2024main26341 Stable

    Updated the following NetSuite SOAP Snap names for usability based on the functionality of the Snaps:

    February 2024436patches25953 Latest

    Upgraded Apache CXF from version 3.4.2 to 3.6.3 to prevent vulnerability issues.

    February 2024436patches25995 Latest

    Updated the default and maximum batch size for NetSuite Add List and NetSuite Async Add List Snaps as follows:
    NetSuite Add List:
    Default batch size: 100
    Maximum batch size: 200

    NetSuite Async Add List:
    Default batch size: 200
    Maximum batch size: 400

    February 2024436patches25852 Latest

    Added the following Snaps to the NetSuite SOAP Snap Pack:

    • NetSuite Add List: Adds a list of records in bulk to NetSuite.

    • NetSuite Async Add List: Inserts a list of records in NetSuite asynchronously, and the Snap returns a job ID after a successful operation.

    February 2024436patches25801 Latest

    Fixed an issue with NetSuite Upsert Snap that displayed a null pointer exception when the account had insufficient permissions. Now the Snap displays a configuration exception when the customFieldRecord is null.

    February 2024main25112 StableUpdated and certified against the current SnapLogic Platform release.
    November 2023main23721 Stable

    The existing NetSuite Snap Pack is renamed to NetSuite SOAP due to the introduction of the NetSuite REST Snap Pack.

    August 2023

    main22460

     


    Stable

    Updated and certified against the current SnapLogic Platform release.

    May 2023433patches21878 Latest

    The Snap Pack now supports Customer-Subsidiary and Vendor-Subsidiary relationship Object types.

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

    May 2023

    main21015 

    Stable

    Upgraded with the latest SnapLogic Platform release.

    February 2023main19844 StableUpgraded with the latest SnapLogic Platform release.
    November 2022main18944 Stable

    The following Snaps now handle lineage properly when used in an Ultra Pipeline: NetSuite Get Item Availability, NetSuite Delete, and NetSuite GetList.

    August 2022main17386 StableUpgraded with the latest SnapLogic Platform release.
    4.29 Patch429patches16915 Latest

    Fixed an issue with NetSuite Search Snap where the Snap displayed the Could not translate an element declaration element exception intermittently when multiple search Snaps are executed simultaneously.

    4.29main15993 StableUpgraded with the latest SnapLogic Platform release.
    4.28main14627 StableUpgraded with the latest SnapLogic Platform release.
    4.27 Patch427patches13080 LatestFixed an XML parsing issue with stripping empty elements for the NetSuite Snaps.
    4.27 Patch427patches13072 Latest

    Fixed an issue in the NetSuite Search Snap where the Snap failed when the body is not present in the SOAP request.

    4.27main12833 StableUpgraded with the latest SnapLogic Platform release.
    4.26main11181 StableUpgraded with the latest SnapLogic Platform release.
    4.25main9554
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.24 Patch424 patches8891 Latest

    Introduced the new Snap NetSuite Call RESTlet that enables calling RESTlet scripts using token-based authentication. This Snap provides the functionality of the NetSuite RESTlet framework that supports the HTTP methods (GET, DELETE, POST, PUT) and MIME types.

    4.24main8556
    StableUpgraded with the latest SnapLogic Platform release.
    4.23main7430
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.22main6403
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.21snapsmrc542

     

    Stable
    • Removed the obsolete Sandbox Account check box from the NetSuite Token Account.

    • Removed the now redundant Custom WSDL URL Domain field from the NetSuite Token Account to support NetSuite's transition to automatic account-specific domain identification.

    4.20 Patch netsuite8799 Latest

    Updates the NetSuite Create, Update, Upsert, and Async Upsert Snaps to use the Classification type instead of Class, to resolve schema generation issues. While the Class type remains available in the NetSuite Search and Async Search Snaps for backwards compatibility, use of the Classification type is recommended.

    4.20

    snapsmrc535

     
    StableUpgraded with the latest SnapLogic Platform release.
    4.19snaprsmrc528
     
    Stable

    Certified the NetSuite Snap Pack against the NetSuite version 2019.1. This does not impact existing Pipelines.

    4.18 Patch netsuite7879 Latest

    Fixed the NetSuite Snaps where the Snaps intermittently fail to reach, cache, and view the NetSuite WSDL and XSD files.

    4.18 Patch netsuite7779 Latest

    Fixed an issue with the NetSuite Update Snap and the NetSuite Create Snap wherein the Snaps are unable to properly handle null values for the standard and the custom fields.

    4.18snapsmrc523
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.17ALL7402
     
    Latest

    Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

    4.17snapsmrc515
     
    Latest
    • Deprecated the NetSuite Credential account type.

    • Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

    4.16 Patch netsuite6911 Latest

    Fixed an issue with running multiple Pipelines by lazy-fetching custom fields metadata.

    4.16snapsmrc508
     
    Stable

    Custom fields are not displayed in the updated NetSuite Create, Update, Upsert, Search, Async Upsert, or Async Search Snaps. They are visible only for Snaps where you have configured custom fields with SnapLogic 4.15 or earlier releases. With the updated NetSuite Snaps, you must connect a Mapper Snap as an upstream Snap to map custom fields.


    4.15snapsmrc500
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.14snapsmrc490
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.13

    snapsmrc486

     
    StableUpgraded with the latest SnapLogic Platform release.
    4.12 Patchnetsuite4888 Latest

    Increased the maximum timeout to two minutes when parsing the WSDL file to fix an issue where the Netsuite Snap Pack is unable to parse XML schema information from the given WSDL file.

    4.12

    snapsmrc480

     
    StableUpgraded with the latest SnapLogic Platform release.
    4.11 Patch netsuite4382 Latest

    Resolved an issue with the NetSuite Search, Create and Update Snaps that now show the custom field suggestions in the drop down.

    4.11 Patch netsuite4296 Latest

    Resolved an issue with NetSuite Update and Search Snaps where Custom fields are not populated on the Snaps.

    4.11snapsmrc465
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.10

    snapsmrc414

     
    StableUpgraded with the latest SnapLogic Platform release.
    4.9.0 Patch netsuite3227 Latest

    Addressed an issue with retry disabled if the reason field contains INVALID_KEY_OR_REF

    4.9.0 Patch netsuite3112 Latest

    Addressed an issue in NetSuite Upsert where List/Record type is sent as MultiSelectCustomFieldRef.

    4.9.0 Patch netsuite3015 Latest

    Added Thread Safety to the creation of Soap Request Message for the NetSuite Search Snap.

    4.9snapsmrc405
     
    StableUpgraded with the latest SnapLogic Platform release.
    4.8.0 Patch netsuite2839 Latest

    Provided a new property for custom WSDL support for NetSuite

    4.8.0 Patch netsuite2704 Latest

    Fixed performance issue on NetSuite Snap Pack which was caused by the WSDL imports.

    4.8

    snapsmrc398

     
    Stable
    • Route records to appropriate views and Pass through properties added to the Netsuite Upsert, Delete and GetList Snaps.
    • Introduced the NetSuite Get Async Result, NetSuite Check Async Status, NetSuite Async Delete, NetSuite Async Get, NetSuite Async Upsert, NetSuite Async Search Snaps in this release.
    • Info tab added to accounts.
    4.7

    snapsmrc382

     
    StableUpgraded with the latest SnapLogic Platform release.
    4.6.0 Patch netsuite1855 
    • Resolved an issue with the NetSuite Search Snap intermittently generating a "The body is not present in the SOAP request" error.
    4.6snapsmrc362
     
    Stable
    • Maximum request attempts and Retry request interval options added to the NetSuite Upsert, Get, Get List, Create, Search, Delete and Update Snaps.
    • NetSuite Get Item Availability Snap was introduced in this release.
    • Resolved an issue in NetSuite Snap Pack that caused Snaps to fail with read timeout errors.
    • Enhanced the NetSuite Snaps to support custom fields on the following object types: VendorBill, VendorBillItem, VendorBillExpense, ExpenseReportExpense, PurchaseOrderExpense. Additionally, Address on Contact, Customer, Partner, Vendor, Job, & Employee are also supported when using WSDL version 2014.2 or later.
    • Enhanced the NetSuite Search Snap to support the general object types Item and Transaction, rather than just their more specific subtypes.
    • Resolved an issue with the NetSuite Upsert Snap that was incorrectly handling some failed requests as successful requests. Any response containing at least one error status is now written to the error view instead of the output view.
    4.5.1

    netsuite1565

     
    Stable
    • Updated the Search Snap to support advanced search. This enables you to execute a saved search using its ID & search for relevant records in it. 
    • Fixed an error in NetSuite Update Snap that restricted access to a custom field in the addressbook sublist of a contact object.
    4.5

    snapsmrc344

    Stable
    • Item and Inventory Item added as options for the Object property in NetSuite Search.
    • Token Based Authentication for SuiteTalk web services added.
    • Resolved an issue in NetSuite Snaps to ensure appropriate handling and display of error messages during failure.
    • Resolved an issue in NetSuite Snaps that occurred when different values were entered for a custom field.
    • Resolved an issue in NetSuite Search Snap to ensure all records are returned when the input search criteria is empty.
    • NetSuite Snaps are enhanced to support the APIs from 2016 (version 2016). Starting from SnapLogic 4.5 release, only APIs from 2014 or later are supported.
    • MIGRATION IMPACT: Note that the accounts have changed for NetSuite. The existing NetSuite account was renamed to NetSuite Credentials Account; the properties of WSDL Release and WSDL Patch were added and the Testdrive account option was removed. A NetSuite Token Account was also added.
    4.4.1
     Stable
    • SnapLogic's pre-assigned NetSuite Application ID is now in every header sent for NetSuite Calls.
    • Resolved an issue with a memory leak in this Snap Pack.
    • Resolved an issue that occurred while collecting JSON schema information.
    • Resolved an issue with setting a custom field to blank in the Update, Create, and Upsert Snaps.
    • Resolved an issue with not being able to clear standard fields that have a value in Update and Upsert Snaps.
    • Resolved an issue with "custom field" suggest showing an error when using a standard type with only one active custom field definition.
    • Resolved an issue with NetSuite Search Snap not producing contact address info as output.
    • In validation/preview mode only, WSDL versions are checked for consistency between the Snap and the Account.
    4.4.0
     Stable
    • Resolved an issue with NetSuite Search Snap ignoring criteria from an input document if any custom field criteria was specified in the Snap.
    • Support for Custom Records added.
    • Support for additional object types added.
    • Support for custom fields for all Transaction types added.
    • Support for custom fields of type Checkbox (boolean) added to the Search, Create, and Update Snaps.
    • Support for custom fields of type Date and Decimal added to the Create and Update Snaps.
    • Resolved an issue with the consistency of the output schema when Search returned more than one page.
    4.3.2
     Stable
    • Resolved an issue with custom fields not appearing in the Update Snap.
    • Resolved an issue with NetSuite Create with custom field not showing in the output payload.
    • Improved performance of the NetSuite Snap Pack.
    4.2.2
     StableSnaps tested against NetSuite server version 2015.2.


    Related Content

    • No labels