NetSuite Integration and Lists
Hello. In building out an integration from Salesforce to NetSuite I’ve not been able to find a way to update a value from Salesforce to a list value in NetSuite by leveraging the text. It seems the N...
Forum Discussion
Hi Matt, I know this is an older question, but I also build integrations for our company between Salesforce and NetSuite. Doing a NS search and then using the internal IDs from that is an option, but in my opinion it isn’t very efficient.
Another way of handling this is to use a Conditional snap and read the value from SF (i.e. Acme) and map it to the internal ID that NS is expecting (i.e. 123). Your NS admin should be able to provide the internal IDs for all lists. Also, internal IDs do not change in NS, so you don’t have to worry about constantly maintaining them… unless a new value is added, which isn’t a big deal to add it.
Lastly, in SF, you can edit the API name of a picklist value. Assuming you don’t have any other integrations that may be impacted by this, you can always go to the picklist value (in this example, Acme) and edit the API name to be “123”. Then in your pipeline, you won’t need a Conditional snap at all - instead it will just map directly over to NS as “123”.
Hope this helps!
