The “CSV by Workato” connector has two actions. Parse CSV Action with the CSV connector will let you parse an existing CSV into an Array that you can do things with, like iterate through in a for each (repeat action) loop. Compose CSV works the other way, it turns a list into a CSV.
If want to take a CSV as input, process CSV rows in some manner and have a CSV as output, one method is:
1. Create Variable List
2. Parse CSV
3. For each row in CSV, do whatever it is you want to do, then add to the end of variable list
4. Back outside of the for each loop, Compose CSV from list
You could use the Lists Connector rather than the Variable connector to create the list. The List Connector is simpler. The advantage of the variable connector is you can add items to a list from multiple sources or manage the list in different for each loops.
