Go to app
Academy
What's new?
Tray UAC
Developer
Connectors
Templates
Help Center
Back
CSV Editor
Overview
Operations (sample payloads)
Operations
CSV Editor Operations
Latest version:
7.0
Changelog
Add Column
Add a new column to the CSV.
Add Row
Add a new row to the end of the CSV
Add Rows
Add multiple rows to the end of the CSV
Create CSV
Create a temporary CSV for use within the current workflow execution. You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.
Create CSV From File
Create a temporary CSV for use within the current workflow execution from an existing file. You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.
Create CSV From XLSX File
Create a temporary CSV for use within the current workflow execution from an existing XLSX file. You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.
Create CSV From XML File
Create a temporary CSV for use within the current workflow execution from an existing XML file. You can perform operations on this CSV within a single workflow execution, but will need to export the CSV at the end otherwise it will be deleted.
Delete a CSV
Delete a specific CSV created in Current Run and Account scope.
Delete column
Delete a specific column in the CSV.
Delete columns
Delete multiple column in the CSV.
Delete Row
Delete a specific row in the CSV.
Delete Rows
Delete a number of rows in the csv.
Delete Rows By Filter
Delete all rows that match a specific filter.
Duplicate
Create a copy of a specific CSV
Duplicate Column
Duplicate a specific column in the CSV.
Export CSV
Export an in memory CSV into a file for persistence and use elsewhere.
Export File
Export an in memory CSV data into a plain text file using a template configuration
Export JSON
Export an in memory CSV into a JSON file for persistence and use elsewhere.
Find Row
Find the first row in the table that matches a specific filter.
Find Rows By Filter
Find rows in the table that match a specific filter.
Format CSV
Change the characters (such as delimiter and escape character) used in a CSV. This operation may be required for CSVs with embedded new lines and quote character in cell values.
Generate columns from object
Generate a list of column descriptions from a JSON object (ignoring nested arrays and objects), and provide optional column type definitions to change the types of some fields.
Get Cell
Return the data in a specifc cell in the CSV.
Get Column Count
Return the number of columns that are available in an in memory CSV.
Get column from rows
Return a single column from a number of rows from in the CSV.
Get Row
Return all columns from single row in the CSV.
Get Row Count
Return the number of rows that are available in an in memory CSV. This doesn't take into account content.
Get Rows
Return all columns from a number of rows from in the CSV.
Import Data
Import an external CSV file into an existing in memory CSV
Join CSVs
Join two CSVs together based on a common field, using a left, inner or outer join. Indexes will automatically be created on for the columns chosen.
Parse Text
Parse raw CSV text into a list of rows
Rename Column
Rename a specific column in the CSV.
Rename Columns
Rename a number column in the CSV.
Sort CSV
Sorts a CSV.
Update by Function
Update a single column in multiple rows using a function
Update Cell
Update a specific cell in the CSV
Update Rows by Filter
Set new values in all rows matching given filters, in the CSV
Previous
Operations (sample payloads)
