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 NS Update and Upsert Snaps want you to provide the internalId of the list value rather than resolving the internal id from the actual text value.
E.g. in SFDC we have a subsidiary = ‘Acme, Inc.’ and in NetSuite on the account record there is a Subsidiary list with the same exact value = ‘Acme, Inc.’. If I try and update the ‘Acme, Inc.’ to the Subsidiary value in NS the snap fails. It only works when I provide the ID associated to the list item (let’s say in NS the Internal Id of the value ‘Acme, Inc.’ = 123).
My current workaround is to export the list of values from NS and put that into a CSV (so it has the values and the internal id). But now that means for every list I need a mapping file and then a join on the text values just to get the internal id? There must be a better way… anyone else experience this?