Sublists are an important part of many NetSuite record types. Editable Sublists can be added to a NetSuite REST destination.

Adding a Sublist

1. Create or Open an Integration with a NetSuite REST destination
2. On the Target tab, select at least one Role Type
3. On the Target tab of the integration click Add Child and Action Lines
4. Role Type – Select the Role Type containing the desired Sublist
5. Filter – By default both Sublists and transformations are shown in the list, but the filters can narrow down the returned results
6. Expand the collection containing the desired Sublist
7. Check the box next to the Sublist that is needed in the mapping
8. Click Ok to save

Duplicating a Sublist

1. Create or Open an Integration with a NetSuite REST destination
2. On the Target tab, select at least one Role Type
3. On the Target tab of the integration click Add Child and Action Lines
4. Expand the collection containing the desired Sublist
5. Check the box next to the Sublist that is needed in the mapping
6. Click the duplicate button on the Sublist to duplicate

7. Click Ok to save the duplication
8. On the Integration tab, select the duplicated Sublist lines

Replacing a Sublist

NetSuite supports replacing all records in the Sublist with the provided values by using the Replace Sublist option. This can be useful if child records are frequently removed from the source.

1. Create or Open an Integration with a NetSuite REST destination
2. On the Target tab, select at least one Role Type
3. On the Target tab of the integration click Add Child and Action Lines
4. On the parent collection of the Sublist that will be replace, check the box in the Replace Sublist column
5. Click Ok to save the setting

Updating a Sublist

1. Create or Open an Integration with a NetSuite REST destination
2. Ensure the Sublist has been added
3. Switch to the Integration tab
4. Target Lines – Select the parent Record Type
5. Update Existing – Check the box for update existing
6. Group By – Select the unique field(s) for each parent record

7. Target Lines – Select the Sublist Record Type
8. Update Existing – Check the box for update existing
9. Group By – Add the following groupings
   1. Parent Fields – Select the same grouped field(s) from step 6
   2. Sublist Fields – Select the field(s) that identify a unique Sublist record (Note: these fields don’t need to be mapped to the target if you are also using a lookup)
   3. Lookup Fields (Optional) -If some of the Sublist fields aren’t aren’t mapped to the target because they are ids that require a lookup, you will also need to map the lookup field.