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?
Best Answer
A
Amanda Wong
said
over 2 years ago
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.
Answer
Amanda Wong
said
over 2 years ago
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.
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?
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
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