CSV Action
The CSV Action creates and deletes records from a local CSV or TSV file. Use it to store data or log submissions.
Pre-formatted CSV File
This action won't create or format the file by itself, you must provide a path to a pre-existing and pre-formatted file. The file can be as basic as a list of column headers separated by commas set in the very first line, as for example Name,Comment,Date
.
Create Record
Creates a CSV file record.
Setting | Description | Required | Dynamic |
---|---|---|---|
File | The path to the file where the data will be appended. | ✓ | |
Delimeter | The character used to separate columns data, defaults to a comma (, ). | ||
Enclosure | The character used to enclose columns data, defaults to a double-quote (" ). | ||
Advanced | |||
Action Name | The name to reference this action. | ||
Status | Defines if the action is enabled or disabled . | ||
Execution | A composed condition that must be met in order for the action to be executed. | ✓ |
Once the basic configuration has been set, the resource fields will load for mapping. The mapping will determine the value that each resource field will be created or updated with. Each field can be mapped to a static or dynamic value.
Most mapping is optional
In fact, mapping is disabled by default and must be enabled for each field by clicking on the last toggle icon.
Delete Record
Deletes a CSV file record.
Setting | Description | Required | Dynamic |
---|---|---|---|
File | The path to the file where the data will be appended. | ✓ | |
Delimeter | The character used to separate columns data, defaults to a comma (, ). | ||
Enclosure | The character used to enclose columns data, defaults to a double-quote (" ). | ||
Column | The column that will identify the record to be deleted. | ✓ | |
Value | The value that will identify the record to be deleted. | ✓ | ✓ |
Advanced | |||
Action Name | The name to reference this action. | ||
Status | Defines if the action is enabled or disabled . | ||
Execution | A composed condition that must be met in order for the action to be executed. | ✓ |