Amanda Wong
Hi there, the Append item to list action creates a new list and the List Name allows the user to specify a name for the new list.
The article assumes that you have 2 sets of addresses (Billing and shipping) that you wish to add to a list and recommends the steps detailed in order to transform the 2 sets of addresses into a list data pill that you can input into the NetSuite action.
1) Create list of size=2 for 2 sets of addresses
2) Add Repeat action to make Workato repeat 2 times -- map list field from 'Create list' step output
3) Add Append item to list action and nest under Repeat action in (2) -- specify a list name e.g. Contact Address List
- Create fields to contain your address details from Salesforce to be synced over to Netsuite address fields e.g. Address Type, Street, City.
- Map the pills as follows. The index condition is useful so that you can tell Workato that during the first iteration of the Repeat action i.e. Index=0, Mailing address details will form input.. during the second iteration of the Repeat action i.e. Index=1 not =0, Billing address details will form input.
Still can't find your solution?
Send us a ticket, we will try our best to assist you with your problem
CCC Integrator
RE: How to transform Salesforce Contact/Account shipping and billing Addresses into List
I'm trying to follow the steps in this article: https://support.workato.com/support/solutions/articles/1000250870-how-to-transform-salesforce-contact-account-shipping-and-billing-addresses-into-list
However, when using the "append item to list" action, it requires a list name, but when creating a list there is no option to name it! How do I reference an existing list, then? Or is that article outdated and I need to do this a different way?