Sample app to convert CSV data to JSON and insert into database.

Copy .env.sample to .env and add your relevant configuration values.

$ npm install

# development
$ npm run start

# watch mode
$ npm run start:dev

# production mode
$ npm run start:prod

Converts a CSV string from the request body to JSON.

Example Request:

name.firstName, name.lastName, age, address.line1, address.line2, address.city, address.state, gender\nRohit, Prasad, 35, A-563 Rakshak Society, New Pune Road, Pune, Maharashtra, male

Response:

[
  {
    "name.firstName": "Rohit",
    "name.lastName": "Prasad",
    "age": 35,
    "address.line1": "A-563 Rakshak Society",
    "address.line2": "New Pune Road",
    "address.city": "Pune",
    "address.state": "Maharashtra",
    "gender": "male"
  }
]

Reads a CSV file from a path specified in the configuration, converts it to JSON, and inserts the data into a database.

Response:

{
  "count": 100000
}

# unit tests
$ npm run test

# e2e tests
$ npm run test:e2e

# test coverage
$ npm run test:cov

1. CSV file is expected to have UTF-8 encoding
2. First Name and Last Name are mandatory
3. Separator (,) can not be used in values

Nest is MIT licensed.