CSV Processor

The CSV Processor connector allows you to create or import CSV files and process them in a number of different ways such as adding, removing, formatting, sorting etc.

When you create a CSV using the CSV Processor it will only be available to modify during the current workflow run. If you want to use it across workflow runs, you need to export it to a persistent file at the end so it can be re-imported on the next run. The reason for this is that it allows for much larger CSV files to be created/processed using the connector than would normally be possible.


Basic use of the CSV processor

The first thing to do with the CSV processor is to create a new CSV or import an existing CSV for manipulation within the workflow. The create CSV operations will return a unique ID which needs to be used in all other steps that want to manipulate the data within the CSV. Make sure that each subsequent CSV step you add to your workflow is connected up to the ID of the first create CSV step.

Use the ID property from the create CSV step in all other CSV operaitons

Create a CSV from an existing file

The default operation allows you to create a temporary CSV from an existing CSV File. You need to supply the URL of the file which will be imported and can be used as header names.

It also allows you to override the type and format settings for specific columns by adding them to the Column Types property.

Create a new CSV

The standard create CSV operation allows you to create a CSV with a certain number (and type) of columns and some default blank rows. Use this to create a specific type of CSV with certain column types that can be formatted/sorted later and then import an existing CSV file into it.

Last updated 20th February 2018