• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Formula Mode Questions
S

Saul Macht

started a topic over 5 years ago
Answered

How to transform list/array data pill to rows of strings

I have used "Append items to list" and got a list data pill output. However, I want to send the output via email. How can I do this? For example, my list contains 3 records that contain 4 fields each. 


I want the output in email to look like:

A1,B1,C1,D1

A2,B2,C2,D2

A3,B3,C3,D3


Thanks!


Best Answer
A
Amanda Wong said over 5 years ago

Hi Saul, one way to format your list data pill into string is to use .format_map in formula mode. You can customize the formatting with data labels or simply get the data values, entirely up to you to configure. Data values have a special formatting with the case sensitive API name enclosed by symbols as follows: %{apiname}. You can find out the API names of your data by looking at output data available in the job reports.


image



See definition of format_map: http://docs.workato.com/formulas/array-list-formulas.html#formatmap

See solution article on how to use: https://support.workato.com/support/solutions/articles/1000250369-how-to-combine-array-elements-into-a-single-string-format-map





Answer

Amanda Wong

said over 5 years ago

Hi Saul, one way to format your list data pill into string is to use .format_map in formula mode. You can customize the formatting with data labels or simply get the data values, entirely up to you to configure. Data values have a special formatting with the case sensitive API name enclosed by symbols as follows: %{apiname}. You can find out the API names of your data by looking at output data available in the job reports.


image



See definition of format_map: http://docs.workato.com/formulas/array-list-formulas.html#formatmap

See solution article on how to use: https://support.workato.com/support/solutions/articles/1000250369-how-to-combine-array-elements-into-a-single-string-format-map





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 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count