Import CSV into DynamoDB

example.csv

index.js

const fs = require('fs')
const parse = require('csv-parse/lib/sync')
const AWS = require('aws-sdk')

AWS.config.update({region: 'ap-southeast-2'});
const docClient = new AWS.DynamoDB.DocumentClient()

const contents = fs.readFileSync('./<filename>.csv', 'utf-8')
// If you made an export of a DynamoDB table you need to remove (S) etc from header
const data = parse(contents, {columns: true})

data.forEach((item) => {
        if(!item.maybeempty) delete item.maybeempty //need to remove empty items
        docClient.put({TableName: '<Table>', Item: item}, (err, res) => {
                if(err) console.log(err)
        })      
})

package.json

{
  "name": "dydbimport",
  "version": "1.0.0",
  "main": "index.js",
  "license": "MIT",
  "dependencies": {
    "aws-sdk": "^2.153.0",
    "csv-parse": "^2.0.0"
  }
}

Hi,

When processing the file, I get an error for 'Type mismatch':

'One or more parameter values were invalid: Type mismatch for key externalId expected: N actual: S'

How do you define the data type in the CSV or overcome this error altogether?

Thanks

@rubenberna - I have had an integer column which was part of an index.
I have modified the above to

data.forEach((item) => {
  if(!item.maybeempty) delete item.maybeempty //need to remove empty items
  item.added = parseInt(item.added); // <-- Changed this to Integer solved the Type mismatch error
  docClient.put({TableName: 'ReviewTable', Item: item}, (err, res) => {
    if(err) console.log(err)
  })      
})

node_modules\csv-parse\lib\sync.js:30
    throw err;
    ^

Error: Invalid opening quote at line 2

This should now be ...

const {parse} = require('csv-parse/sync');