AnsweredAssumed Answered

How to take a NS Multi-Select field and push that data into SalesForce?

Question asked by lucascooper81 on Feb 2, 2017

Hi all, I'm new to Boomi and I'm trying to get a connection up and running between our NetSuite environment and SalesForce.


I'm getting an error when I try to bring over a NetSuite Multi-Select field into a SalesForce multi-select field. I'm sure the issue is formatting but I haven't figured out a way to get it to work successfully.


Error: Embedded message: Process terminating -- some documents reached an exception which is set to halt all documents: There was an error syncing customers. Please see the Process Log for details.


When I go look at the connection data I see this message <?xml version="1.0" encoding="UTF-8" standalone="no"?><Account><id/><success>false</success><errors><error><statusCode>DUPLICATE_VALUE</statusCode><message>OBJ: Account - Duplicate external id specified: 11654</message></error></errors></Account>


My assumption is that instead of trying to do one load it's breaking the one Customer Account into four records to upload, one for each multi-select value.


If anyone has overcome this and could help out I'd greatly appreciate it.


Thank you!