CSV File
Reference
Reads and writes data from a csv file.
Categories: [helpers]
Version: 1
Actions
Read from File
Reads data from a csv file.
Properties
| Name | Type | Control Type | Description |
|---|---|---|---|
| File | FILE_ENTRY | FILE_ENTRY | The object property which contains a reference to the csv file to read from. |
| Delimiter | STRING | TEXT | Character used to separate values within the line red from the CSV file. |
| Enclosing Character | STRING | TEXT | Character used to wrap/enclose values. It is usually applied to complex CSV files where |
values may include delimiter characters.| | Header Row | BOOLEAN | SELECT | The first row of the file contains the header names. | | Include Empty Cells | BOOLEAN | SELECT | When reading from file the empty cells will be filled with an empty string. | | Page Size | INTEGER | INTEGER | The amount of child elements to return in a page. | | Page Number | INTEGER | INTEGER | The page number to get. | | Read as String | BOOLEAN | SELECT | In some cases and file formats, it is necessary to read data specifically as string, otherwise some special characters are interpreted the wrong way. |
Output
Type: ARRAY
Properties
| Type | Control Type |
|---|---|
| {} | OBJECT_BUILDER |
Write to CSV File
Writes the data records into a CSV file. Record values are assembled into line and separated with arbitrary character, mostly comma. CSV may or may not define header line.
Properties
| Name | Type | Control Type | Description |
|---|---|---|---|
| Line Structure Definition | [{}] | ARRAY_BUILDER | Define a sequence of fields that will form a line. The values for these fields will consistently repeat in the same order defined here across all lines. |
| Filename | STRING | TEXT | Filename to set for binary data. By default, “file.csv” will be used. |
Output
Type: FILE_ENTRY
Properties
| Type | Control Type |
|---|---|
| STRING | TEXT |
| STRING | TEXT |
| STRING | TEXT |
| STRING | TEXT |