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.
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.
Saul Macht
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!
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.
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
Amanda Wong
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.
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