ANS-1810 · WEB SERVICES & INTEGRATIONS
How to Synchronize Multi-Select Fields from Salesforce to NetSuite in Boomi
Learn how to configure Boomi profiles and scripts to accurately transfer multi-select field data between Salesforce and NetSuite.
Short answer
To synchronize multi-select field values from Salesforce to NetSuite in Boomi, implement a script to split incoming values into separate XML elements. Configure both the Salesforce response and NetSuite upsert request profiles by setting 'Max Occurs' to 'unbounded' and 'Looping Options' to 'Occurrences' for the relevant field.
Scenario
Organizations integrating Salesforce and NetSuite often encounter challenges when synchronizing multi-select fields. The default Boomi profile configurations may not correctly handle multiple selected values, leading to incomplete or incorrect data transfer between the two systems.
Solution
To successfully synchronize multi-select field values from Salesforce to NetSuite using Boomi, follow these steps:
Implement a custom script within Boomi to process the incoming multi-select field values. This script should split the concatenated values into individual XML elements, ensuring each selection is treated as a distinct item. Refer to Boomi documentation for guidance on scripting for XML element manipulation.
Modify the relevant Boomi profiles for the field being synchronized. This involves adjusting both the Salesforce response profile and the NetSuite upsert request profile.
For the specific field, configure the following settings:
Max Occurs:unboundedLooping Options:Occurrences
Note: For the Salesforce profile, these options are typically configured in the
Data Elementstab. For the NetSuite profile, the location for these settings may vary depending on the field configuration, but they are commonly found in theData Elementstab or, in some specific custom field scenarios, thetypetab.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support