CSV Reader

Impure

Reads a CSV file from a given file path or raw string content and emits rows for processing.

Pure Function

No

Execute Inputs

Execution

INPUT

Execution Input.

Execute Outputs

Process Row

OUTPUT

Fires for each row with parsed data.

Loops

Complete

OUTPUT

Fires when the entire CSV is successfully processed.

Data Inputs

File Path

INPUT

Path to a CSV file on disk.

Delimiter

INPUT

The character separating values.

Has Header

INPUT

Whether the first row is treated as column headers.

Skip Lines

INPUT

Number of lines to skip before reading.

Encoding

INPUT

Specifies the character encoding used to read the file. Set to 'auto' to attempt to automatically detect the encoding, or provide a specific encoding such as UTF-8, UTF-16BE, UTF-16LE, UTF-16, Windows-1252, or ISO-8859-1 for example.

Data Outputs

Row Data

OUTPUTstring map

A dictionary mapping column names to row values.

Multiple

Row Number

OUTPUTinteger

The current row number in the CSV.

Multiple

Total Rows

OUTPUTinteger

Total number of rows processed.

Multiple

Column Names

OUTPUTstring array

List of column names.

Multiple

Settings

Normalize Headers

BOOLEAN

If true, headers will be normalized to lower snake case and remove non ASCII characters.

Default: false

Skip Empty Lines

BOOLEAN

Whether to skip empty lines.

Default: true

Trim Whitespace

BOOLEAN

Whether to trim whitespace from values.

Default: true

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing