Retrieving the transformed data from NetSuite

Procedure

Double-click the second tNetsuiteInput to open its Basic settings view.
Select the NetSuite component you want to use from the Version drop-down list and click Apply.
In this scenario, NetSuite Deprecated is selected.
In the Endpoint, API version, E-mail, Password, Role, Account, and Application ID fields, enter the information required to access NetSuite.
Click the [...] button next to the Record Type field, and from the dialog box that opens select Location to read the location type information from NetSuite.

The schema corresponding to the location record type is automatically retrieved.
Define a search condition.
1. Click the [+] button below the Search condition table to add one row.
2. Click the cell of the Field column and select name from the drop-down list.
3. Click the cell of the Operator column and select String - Contains from the drop-down list.
4. In the cell of the Value column, enter Paris to retrieve only the record whose name contains Paris.
Double-click tLogRow to open its Basic settings view.
In the Mode area, select Vertical (each row is a key/value list) for better readability of the result.
Connect the second tNetsuiteInput to tLogRow using a Row > Main connection.
Connect the first tNetsuiteInput to the second tNetsuiteInput using a Trigger > OnSubjobOk connection.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!