This recipe is reading files from CSV, but when i insert new records in my csv, for each is not taking those new records and moving on to one step forward, its not reading my new records, I want each record to be worked individually, How to resolve this?

harendra — Mon, 03 Jan 2022 20:05:21 GMT

Re: This recipe is reading files from CSV, but when i insert new records in my csv, for each is not taking those new records and moving on to one step forward, its not reading my new records, I want each record to be worked individually, How to resolve this?

jblanchett — Tue, 04 Jan 2022 05:07:45 GMT

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.

topic This recipe is reading files from CSV, but when i insert new records in my csv, for each is not taking those new records and moving on to one step forward, its not reading my new records, I want each record to be worked individually, How to resolve this? in Workato Pros Discussion Board

This recipe is reading files from CSV, but when i insert new records in my csv, for each is not taking those new records and moving on to one step forward, its not reading my new records, I want each record to be worked individually, How to resolve this?

Re: This recipe is reading files from CSV, but when i insert new records in my csv, for each is not taking those new records and moving on to one step forward, its not reading my new records, I want each record to be worked individually, How to resolve this?