Settings
| Setting | What it is |
|---|---|
| CSV text | The text of the file — File — Read hands it over with this name. |
| Delimiter | "auto" or "," or ";" or "\t" or "|" |
| First row is a header | On: every row is an object keyed by the header names. Off: every row is a list of values. |
| Encoding | UTF-8 drops a byte-order mark. Latin-1 reads the text as bytes, for older exports. |
| Convert types | Numbers and true/false become real values when they round-trip exactly. Leading zeros and long numbers always stay text. |
Technical details
| Key | Value |
|---|---|
text | any JSONits `{{ }}` must give a string |
delimiter | "auto" or "," or ";" or "\t" or "|", by default "auto" |
headers | true/false, by default true |
encoding | "utf-8" or "latin1", by default "utf-8" |
convertTypes | true/false, by default false |
Output
| Field | Type |
|---|---|
rows | array |
headersColumn names | array |
rowCount | number |
delimiterDelimiter used | string |
Sample output, and the expression for each field
- delimiter","
- headers
- [0]"name"
- rowCount1
- rows
- [0]
- name"Ada"
- [0]
Errors
When a step of this node stops a run, the run page shows a code. Look it up:
Example step
The step as a flow file holds it. Replace each value in <…>.
{
"config": {
"convertTypes": false,
"delimiter": "auto",
"encoding": "utf-8",
"headers": true,
"text": "<csv text>"
},
"label": "Parse",
"type": "csv.parse",
"version": 1
}