Setting up an Integration to NetSuite REST

Published: Jan 29, 2025

Setting up an Integration to NetSuite REST

Published: Jan 29, 2025

Target Tab

  1. Create an integration
  2. Click on the Target tab
  3. Target – Select NetSuite REST
  4. Destination – Select a NetSuite connection
  5. Role Types – Select the Role Type(s) to be used for the destination
  6. Ignore Duplicate Detection – Determines the behavior when the lookup for update existing finds multiple matches
    • Unchecked – If the lookup for a record to update finds multiple records it will return an error.
    • Checked – If the lookup for a record to update finds multiple records it will update the first record found.
  7. Save Output to File – Mark this checkbox if the Role Type data should be sent to a file that can then be downloaded. 
  8. Add Child and Action Lines – Opens a dialog box to add related Sublists and Transformations to the integration.
  9. Target Lines – Displays the lines that will be available to be mapped on the Integration tab

Integration Tab

  1. Click on the Integration tab
  2. Target Lines – From the dropdown list select the lines that will be mapped
  3. For Delete – When this checkbox is marked, records that already exist will be deleted
  4. Update Existing – When this checkbox is marked, records that already exist will be updated with any changes
  5. Update Blank Data – When this checkbox is marked, blank source data will overwrite existing data on mapped fields
  6. Source Grouping tab – Select which source(s) to group by and the function for the source
  7. Target Integration tab – This is where the Source data is mapped to the Target data
  8. Additional Columns tab – NOTE: there will be a separate section for each type of Additional Column
  9. Once the Target field(s) are mapped to a Source(s), the Save button becomes active allowing the user to save the Integration Process

Content
Target Tab Integration Tab

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters