Retrieving the transformed data from NetSuite - Cloud - 8.0

Netsuite

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Business applications > Netsuite components
Data Quality and Preparation > Third-party systems > Business applications > Netsuite components
Design and Development > Third-party systems > Business applications > Netsuite components
Last publication date
2023-09-14

Procedure

  1. Double-click the second tNetsuiteInput to open its Basic settings view.
  2. Select the NetSuite component you want to use from the Version drop-down list and click Apply.
    In this scenario, NetSuite Deprecated is selected.
  3. In the Endpoint, API version, E-mail, Password, Role, Account, and Application ID fields, enter the information required to access NetSuite.
  4. 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.

  5. 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.
  6. Double-click tLogRow to open its Basic settings view.
  7. In the Mode area, select Vertical (each row is a key/value list) for better readability of the result.
  8. Connect the second tNetsuiteInput to tLogRow using a Row > Main connection.
  9. Connect the first tNetsuiteInput to the second tNetsuiteInput using a Trigger > OnSubjobOk connection.