CSV Get Rows

the csv get rows action is designed to extract data from a csv file based on user defined configurations this action allows precise control over which rows and columns to retrieve from the csv file overview action name csv get rows key must be unique, consisting of alphanumeric characters and underscores only purpose extract specific rows and/or columns from a csv file adding the csv get rows action steps to add the action open your playbook in the turbine canvas from the add panel, drag and drop the csv get rows action into your canvas click on the action block to configure it provide a unique title and key for the action title the display name for the action (for example, csvgetrows transactiondata) key a system generated unique identifier for the action (editable but must follow the naming convention alphanumeric and underscores only) proceed to configure the input parameters as detailed below configuration inputs the following input parameters are required or optional for configuring this action attachment (required) description select the attachment (csv file) from which the rows will be retrieved input method use the select a property button to map the file id offset (optional) description defines the starting row index from which to retrieve data default 0 header row is ignored limit (optional) description specifies the maximum number of rows to return default 0 (return all rows starting from the offset) continue on error (optional) description determines whether the action should continue processing if an error occurs default false options true continue processing even if an error occurs false halt processing on error return columns (optional) description specifies the columns to include in the result click add array item to add the array default it includes all columns if not specified omit columns (optional) description specifies the columns to exclude from the result click add array item to add the array default it includes all columns if not specified outputs the csv get rows action provides the following outputs rows description a list of rows retrieved from the csv file based on the input configurations data type array of objects metadata description metadata about the csv file, including the number of rows retrieved, total rows, and any errors encountered data type object use case example scenario you have a large csv file containing transaction records you want to skip the first 10 rows (header or metadata) retrieve the next 100 rows only include the columns "transactionid" and "amount" configuration attachment select your transaction csv file offset 10 limit 100 return columns add "transactionid" add "amount" expected output the action will return 100 rows starting from the 11th row, containing only the "transactionid" and "amount" columns notes if both return columns and omit columns are specified, omit columns will take precedence over return columns ensure the input file is a valid csv format to avoid processing errors error handling common errors include invalid file attachments, incorrect column names, or misconfigured offset/limit values use the continue on error option to control the behavior in case of errors