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

Snap type:

Read


Description:

This Snap searches records from NetSuite asynchronously. 


This Snap provides the ability to search records of an object in NetSuite by providing criteria. The criteria 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. If the Get async results property is selected, the Snap submits a job, checks the job status and gets the results. If the Get async results property is deselected, the Snap submits a job and returns a job ID at the output view.


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

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

Object


Required. The type of NetSuite record.

Default value: Account

Custom Record


Custom record type

Note
This is required if CustomRecord is selected for Object.

Default value: None

Body fields only


Omits sublist values from search results.

 
Note: Using the default checked state can significantly improve performance.

Default value: Selected  

Advanced


Performs an advanced search. This changes the input schema.
Default value: Not selected
 

Return Search columns


Required. This is relevant only when performing an Advanced search to execute a saved search.  
If selected, executes a saved search, if not selected,  returns full records as opposed to columns. 

NetSuite returns an error when:

  •  selected and the input document does not specify columns
  • not selected and the input does not specify a saved search 

Default value: Selected


Page size


Required. The number of records returned on a single page of search results.

Default value: 1000

Get async results


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


If selected, the Snap passes the input document to the output view under the 'original' key.
Default value: Not selected

Request timeout


Required. Timeout for the web service call (in seconds). 0 indicates no timeout.
Default value: 0  

Maximum requests attempts


Required. The maximum number of requests to attempt in case of failure.

Default value: 3


Retry request 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

Multiexcerpt include macro
nameSnap Execution
pageAnaplan Read


Multiexcerpt include macro
nameSnap_Execution_Introduced
pageAnaplan Read


Troubleshooting

Multiexcerpt include macro
nameNetsuite_Troubleshooting
pageNetSuite Async Get

Example


In this pipeline, we search all the records from a NetSuite object asynchronously using the NetSuite Async Search Snap. We provide the inputs in the upstream Mapper Snap.

 

The upstream Mapper Snap maps the records to be searched on the NetSuite Object. In this example, we gave the input '{ }', which retrieves all the records from the object 'Account'

Note
You may also give your search criteria in the upstream Snap to retrieve a specific record or a set of records.  

The NetSuite Async Snap Searches all the records from the object, 'Account', and displays them in the output preview.

 

Successful execution of the pipeline displays the below output preview:

Note

The output preview displays all the records under the object 'Account' in this case.

 

Insert excerpt
NetSuite Create
NetSuite Create
nopaneltrue

Insert excerpt
NetSuite SOAP Snap Pack
NetSuite SOAP Snap Pack
nopaneltrue