Reading, transforming, and writing data in NetSuite - 7.3

Netsuite

EnrichVersion
Cloud
7.3
EnrichProdName
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
EnrichPlatform
Talend Studio
task
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

Procedure

  1. Double-click the first tNetsuiteInput to open its Basic settings view.
  2. In the Endpoint, API version, E-mail, Password, Role, Account, and Application ID fields, enter the information required to access NetSuite.
  3. 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.

  4. Define a search condition.
    1. Click the [+] button below the Search conditions table to add one row.
    2. Click the cell of the Field column and select internalId from the drop-down list.
    3. Click the cell of the Operator column and select List - Any Of from the drop-down list.
    4. In the cell of the Value column, enter java.util.Arrays.asList("1") to retrieve only the record whose internalId is set to 1.
  5. Connect the first tNetsuiteInput to tMap using a Row > Main connection.
  6. Double-click tNetsuiteOutput to open its Basic settings view.
  7. In the Endpoint, API version, E-mail, Password, Role, Account, and Application ID fields, enter the information required to access NetSuite.
  8. In the Action list, select insert to insert the transformed data into NetSuite.
  9. Click the [...] button next to the Record Type field, and in the dialog box that opens select Location to write the location type information into NetSuite.
  10. Click the [...] button next to Edit schema to open the schema editor. You can see the schema has already been prefilled. Keep only the columns that are relevant to your operation and delete others. In this example, keep the column Name, Parent, IncludeChildren, IsInactive, TranPrefix, Logo, MakeInventoryAvailable, MakeInventoryAvailableStore, CustomFieldList, and ExternalId.
  11. Connect tMap to tNetsuiteOutput using a Row > *New Output* (Main) connection. In the pop-up dialog box, enter the name of the output connection, out in this example. Then click Yes to let tMap get the schema of the target component tNetsuiteOutput.
  12. Double-click tMap to open its Map Editor and configure data flow mappings.
    1. In the out output table, set the value of the Name column by entering "Paris" in the corresponding Expression column field.
    2. Drag and drop the Parent column in the row1 input table onto the Expression column of the corresponding row in the out output table.
    3. Do the same to drag and drop other columns IncludeChildren, IsInactive, TranPrefix, Logo, MakeInventoryAvailable, MakeInventoryAvailableStore, CustomFieldList, and ExternalId in the row1 input table onto the Expression column of the corresponding row in the out output table.