Celigo question - Trying to sync a Saleforce multi...
# general
i
Celigo question - Trying to sync a Saleforce multi-select list to Netsuite. I've tried using the dynamic lookup option, but it fails every time. Any ideas?
s
Yes, it looks like multi select picklists come out of Salesforce as a semi-colon separated string, but in order to import into NetSuite, they need to be comma-separated. Not sure if there is another way, but you can define a Script Hook (Pre Save Page function) to convert the value like this:
Copy code
function preSavePageFunction(options) {
  const { data, errors } = options
  data.forEach((element, index, array) => array[index].ns_multi = element.SF_Multi__c.split(';').join(','))
  return { data, errors }
}
substituting
SF_Multi__c
for your Salesforce field. It is mapping the values to a new field named
ns_multi
r
@matt.graney
m
@iSuite is that in a custom integration? Or with the Salesforce-NetSuite SmartConnector Integration App