The CSV Read component takes CSV data as input, parses it and creates an output payload in the format specified by the Output Format component property (cp.Output).
CSVRead has an “Input” property (cp.Input), which allows you to select the data source. If you select [Payload], the input payload (cv.Payload) from the previous component is used as the source data of CSV, and if you select [File], the file specified by the [File name] property (cv.Filename) is used as the source data of CSV.
If the input payload (cv.Payload) is a byte sequence or a string, it becomes the source data of CSV as it is, but for other types, it is converted to a string and processed as the source data of CSV.
If “Array” is selected for the “Output Format” component property (cp.Output), an array of strings of CSV fields is put into the output payload (cv.Payload) for each line of the CSV and passed to the next component.
If you select “Object” in the “Output Format” component property (cp.Output), the first line of the CSV is considered as the key, and a JSON Object is generated, and the object is put into the output payload for each function and passed to the next component.
Component Properties
| Name | Required | Description |
|---|---|---|
| Input | True | Specify either payload or file for input. To set the value of cp.Input, use either “Payload” or “File”. |
| Filename | False | Specify the filename for file input |
| Encoding | False | Specify the encoding of the file output (utf-8, shift_jis, euc-jp,iso-2022-jp) |
| Output | True | Specify either array or object as the output format. cp.Output value can set “Array” or “Object”. |
| Start | False | Specify the start line to read as CSV data |
| Length | False | Specify how many lines to read. If -1 is specified, read all lines. |
Need more help with this?
Join our slack community for help