FileStorage action - Get lines from CSV file (batch)

The Get lines from CSV file batch action allows you to retrieve a batch of lines from a CSV file in Workato FileStorage. This action returns 1,000 CSV lines by default and can fetch up to 50,000 records. Only files stored with a CSV column schema can be fetched.

Get lines from CSV file in FileStorage action

Input fields

Field	Description
File path	Enter the full path of the CSV file. For example: samplepath/path1/file1.csv. The file must already exist, and only files with a CSV column schema can be fetched.
Batch size	Specify the number of lines to retrieve in a single fetch. This field defaults to 1,000 and can be increased to a maximum of 50,000 records. The number of records are auto-adjusted depending on size.
Batch offset	Specify the offset from which to start fetching records. The default offset is 0. Adjust the offset incrementally to fetch all records in manageable batches.

Output fields

Field	Description
File name	The name of the CSV file.
File path	The complete path of the CSV file.
Batch size	The number of lines retrieved per fetch.
Batch offset	The offset value from which the batch starts.