August 15, 2023

Reading, transforming, and writing data in NetSuite – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Reading, transforming, and writing data in NetSuite – Docs for ESB 6.x

Reading, transforming, and writing data in NetSuite

  1. Double-click the first tNetsuiteInput to open its Basic
    settings     view.

    components-tnetsuiteinput_s1_tnetsuiteinput.png

  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.

    components-tnetsuiteinput_s1_tnetsuiteoutput.png

  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.

    components-tnetsuiteinput_s1_tnetsuiteoutput_schema.png

  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.

    components-tnetsuiteinput_s1_tmap.png

    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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x