How to sync Salesforce addresses to NetSuite as a list
I am trying to sync address info from a Salesforce Account to a NetSuite Customer. The Salesforce addresses (Billing and Shipping) have their own fields on the Account record (see below.) I need to pivot these so they are sent to NetSuite as an address list with two addresses. What would be the best method to solve for this? Looking at Line Itemizer and it takes comma delimited values and outputs a list. Not sure how I would get these into comma delimited values if that’s the best solution.
Thanks
Page 1 / 1
Hi @TavDev
For us to have more info, post screenshots showing the NetSuite Zap step fields you are trying to configure in EDIT mode so we can see the field types.
NOTE: You can map 1+ dynamic variables in a Zap field.
Thanks, @Troy Tessalone.
The NetSuite fields are below. I’ve done basically the same work to create an Order in NS and the Line Itemizer worked great. The difference though is that data was coming in as multiple records and not a single record to be mapped to many. That screenshot is included as well.
@TavDev
From your screenshot of the address fields, we can’t tell if those fields are part of a Line Items section or not.
If not as part of line items, then simply click the [+] button in the field to map variables from a previous Zap step.
Thanks, @Troy Tessalone.
The Address fields are definitely an array of lines within the Address book list. Perhaps this screenshot shows that better?
