Skip to main content Skip to complementary content

Reading, transforming, and writing data in NetSuite

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.

Did this page help you?

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

Leave your feedback here