tNetSuiteV2019Connection Standard properties

Property Type

Select the way the connection details will be set.

• Built-In: The connection details will be set locally for this component. You need to specify the values for all related connection properties manually.

• Repository: The connection details stored centrally in Repository > Metadata will be reused by this component. You need to click the [...] button next to it and in the pop-up Repository Content dialog box, select the connection details to be reused, and all related connection properties will be automatically filled in.

API version

Select the version of the NetSuite API you are connecting to.

Account

Enter your NetSuite web services account number (also called account ID).

Login type

Select the login type: Basic or Token-based.

E-mail and Password

Enter your user credentials to access the NetSuite SOAP service.

To enter the password, click the [...] button next to the password field, and then in the pop-up dialog box enter the password between double quotes and click OK to save the settings.

These two fields are available when Basic is selected from the Login type drop-down list.

Role ID

Enter your NetSuite role ID.

This field is available when Basic is selected from the Login type drop-down list.

Enter the NetSuite application ID generated for your account.

An application ID is required starting from NetSuite version 2015 and above. You can find your application ID or create a new one on NetSuite's Manage Integration page.

This field is available when Basic is selected from the Login type drop-down list.

Enter the consumer key and consumer secret generated in your NetSuite account.

These two fields are available when Token-based is selected from the Login type drop-down list.

Enter the token ID and token secret generated in your NetSuite account.

These two fields are available when Token-based is selected from the Login type drop-down list.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

Global Variables 

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string.

NB_LINE: the number of rows processed. This is an After variable and it returns an integer.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio User Guide.

Usage rule

This component is more commonly used with other NetSuiteV2019 components.