This format will write lines of JSON (without square brackets and commas) to downstream. downstreamFormat: Option to set what JSON array format is needed by downstream.Change to true if a null object is needed. Default false will keep 'null' as string. nullObject: How to parse if a csv cell contains 'null'.Change to true if you are confident no inline line breaks (like line break in a cell which has multi line text). This will prevent eol characters from being used within a row (even inside a quoted field). alwaysSplitAtEOL: Always interpret each line (as defined by eol like ) as a row.will use built-in number parser to convert value of the field1 column to number. checkType: This parameter turns on and off whether check field type.' content ' will be trimmed to 'content'.

trim: Indicate if parser trim off spaces surrounding column content.

'hello, world' won't be split into two columns while parsing.

quote: If a column contains delimiter, it is able to use quote character to surround the column content.

Use an array to give a list of potential delimiters e.g. Use 'auto' if delimiter is unknown in advance, in this case, delimiter will be auto-detected (by best attempt).

delimiter: delimiter used for separating columns.

output: The format to be converted to.Getting connectin parameters from config. After it is completed with the ‘done’ event, we can start writing the converted results into a file.Ĭonst copyFrom = require('pg-copy-streams').fromĬonst inputFile = path.join(_dirname, '/data/customer.csv')Ĭonst outputFile = path.join(_dirname, '/data/customer.json')

The json file creating happens as a callback function. This is because writeFileSync() is a synchronous function and the query gets executed only after completing the json file creation. The key is to call executeQuery() after calling writeFileSync(). See Bulk Loading Postgres with Node.js for further information on how to load data into Postgres. We are getting the connection details from config.json.

Csvtojson