Routes: CSV File Reader

The CSV File Reader Route

The CSV File Reader route node is used to read CSV files and convert them into JSON messages. Each row of the CSV is transformed into one JSON message object.

This node does not parse the CSV line itself. That is done by the CSV Parser routing node.

The code block below documents the format for the CSV File Reader route node.

"route0":{
	"type": "csvfilereader",
	"dependencies":["listener"],
	"rowsPerParse": 10000,
	"skip_first_row":true,
	"donePath":"c:/users/user1/source/json_esb/done"
}

The rowsPerParse property is used to indicate how many rows to read at a time. This allows for parsing CSV files with millions of rows, without overloading the ASB or the system memory.

The skip_first_row property is used when the CSV files have header rows present, this skips reading them if set to true.

The donePath is the filesystem path to move the CSV file to, once the ASB has finished reading it.