Skip to main content Skip to complementary content

Retrieving the transformed data from NetSuite

Procedure

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

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!