• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Solutions Articles
  • Forums/Discussions
  • Submitted Tickets
New Topic
Discussions Recipe Building Recipe Building Questions
C

CCC Integrator

started a topic over 3 years ago
Answered

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?


Best Answer
A
Amanda Wong said over 3 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.

​​

image

Answer

Amanda Wong

said over 3 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.

​​

image

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato