how make update query in Aws DynamoDB using nodeJS

Question

I need to update one item of DynamoDB, here is my Code.

const Aws = require('aws-sdk');
const endPoint= 'http://dynamodb.us-east-2.amazonaws.com';
const IAm_user_Key=process.env.IAM_USER_KEY;
const IAm_user_Secret=process.env.IAM_USER_SECRET;

Aws.config.update({ accessKeyId:IAm_user_Key,secretAccessKey:IAm_user_Secret,region:'us-east-2',endpoint:endPoint });

var docClient = new Aws.DynamoDB.DocumentClient();
var table = "cards";

var params={
        TableName:table,
        key:{ "cardid":clientData.data.cardid},
        AttributeValue:{"data":clientData.data}
  }

docClient.update(params, function(err, data) {
            if (err) {
                console.error("Unable to add item. Error JSON:", JSON.stringify(err, null, 2));
            } else {
                console.log("Added item:", JSON.stringify(data, null, 2));
            }
        })

I am facing issues while running this code here my error.

Unable to update item. Error JSON: {
"message": "Missing required key 'Key' in params", "code": "MissingRequiredParameter",
"time": "2019-07-20T07:47:06.490Z" }

But you can see I have Key object in params but still struggling for this.

If you want to put, you should use docClient.update instead of docClient.put. Refer to docs.aws.amazon.com/sdk-for-javascript/v2/developer-guide/… for more information. It looks like you're passing update params to the put method. — Armin
– Armin, Commented Jul 20, 2019 at 21:29
@Armin Sorry my mistake, I edit my question I need to docClient.update instead of put — Amit Shakya
– Amit Shakya, Commented Jul 21, 2019 at 9:42

Amit Shakya · Accepted Answer · 2019-07-21 10:38:05Z

4

I read docs too many times but there is a silly mistake, I found it is just typo error "key" in params should be "Key" K in uppercase only and this is working.

answered Jul 21, 2019 at 10:38

Amit Shakya

9943 gold badges16 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ramesh Murugesan Over a year ago

I made a same mistake :D

Aravind Reddy Over a year ago

I have the same issue, but my Key is in caps :(

Chhin Vanchhai · Accepted Answer · 2021-02-26 08:42:53Z

0

The problem is in Key, You need to use primary key to find which row will you update in Table Like SQL such as Primary Key. IN DynamoDB Primary Key = PK+SK example if your: PK = 'cardid' AND SK = 'name'

var params={
        TableName:table,
        Key:{ "cardid":clientData.data.cardid, 'name': req.body.name},
        AttributeValue:{"data":clientData.data}
  }

answered Feb 26, 2021 at 8:42

Chhin Vanchhai

11 bronze badge

Collectives™ on Stack Overflow

how make update query in Aws DynamoDB using nodeJS

2 Answers 2

2 Comments

The problem is in Key, You need to use primary key to find which row will you update in Table Like SQL such as Primary Key. IN DynamoDB Primary Key = PK+SK example if your: PK = 'cardid' AND SK = 'name'

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

The problem is in Key, You need to use primary key to find which row will you update in Table Like SQL such as Primary Key. IN DynamoDB Primary Key = PK+SK example if your: PK = 'cardid' AND SK = 'name'

Comments

Your Answer

Sign up or log in

Post as a guest

Related