files.read_csv
Read data from CSV
Properties
| Name | Type | Description | Required |
|---|---|---|---|
| file | string | Filename. Can contain a regexp or glob expression | yes |
| encoding | string | Encoding to use for reading the file Default: "utf-8" | no |
| fields (List of columns to use) | string[] | List of columns to use for extract Minimal Length: 1 | no |
| skip | number | Number of lines to skip Default: 0Minimum: 0 | no |
| delimiter | string | Delimiter to use for splitting the csv records Default: ","Minimal Length: 1Maximal Length: 1 | no |
| batch_size | number | Number of records to read per batch Default: 1000Minimum: 1 | no |
| quotechar | string | A one-character string used to quote fields containing special characters, such as the delimiter or quotechar, or which contain new-line characters. It defaults to ‘ Default: "\""Minimal Length: 1Maximal Length: 1 | no |
Additional Properties: not allowed
Example
file: archive.csv
delimiter: ;
fields[]: List of columns to use
List of columns to use for extract
Items
field name
Item Type: string
Example
- fname
- lname