CSV Converter
Introduction
This task takes the list of records as input and converts them into CSV file type output.
Description
After you complete the configuration for the CSV converter task, a set of data slots gets generated for further use in the automation:
CSV data: It is the input data fed by the CSV Parser.
Steps to configure
Drag and Drop the CSV Converter task in the automation and click on it. The following form will appear on the screen.
Add name and an appropriate description for reference.
To provide input data to the CSV converter, click the drop-down button and select the data slot. Using content fields are a way to set up different kind of fields to the admin's forms.
Select the data slot on the left, drag and drop the desired data into the content input field to process further.
After adding data from the data slot click on save to successfully save the configuration done so far.
Now click on output meta to provide a sample file to the task. It will generate a data slot for the next step. Output meta is the type resolution for the result of a component. Each component can provide either static or dynamic metadata for the payload and attributes, isolated from each other.
Add the sample file, or simply drag and drop the file. Add the file name and file type. A filename or is a name used to uniquely identify a computer file in a directory structure. A file type is a name given to a specific kind of file.
Click on upload and then you will get all the fields that the particular file has.
Click on save to complete the CSV converter configuration.
Additional Properties
CSV Converter
The Additional Properties for CSV Converter are as follow:
You can select the following as per the requirement. Furthermore, you can enable or disable/ select singly or double in case of the quote and choose a particular delimiter. Property filed contains various elements that can be used to perform the CSV file process. Value field
is used as a common format to exchange tabular data between spreadsheets and relational database. In a JavaScript action, you can parse CSV data using the csv library.
Name | Description |
|---|---|
Delimiter | The delimiter property specifies the character to be used while parsing the CSV file. There are currently three delimiters - COMMA, SEMICOLON, PIPE. Default value: Comma |
escapeDisabled | escapeDisabled and escape char work hand-in-hand. Then you need to disable it to use escapeChar. Default value: Disabled |
escapeChar | The escape character is used while parsing CSV files. The only double backslash is supported. Leave this property empty if no escape character is used in the input CSV data. Default value: Double Backslash |
IgnoreEmptylines | Neglect empty lines Default value: Disabled |
QuoteDisabled | QuoteDisabled and quote work together while adding a quote to the provided file. Otherwise, you can keep it disabled. Default value: Disabled |
Quote | The quote character property specifies the character to be used for a quote. Add quotes [you needs to select either single or double quotes] Default value: Double Quote |
Related articles