Update Dynamo db table using react

Question

I have a dynamodb table, with columns as id (partition key) and date. I am trying to update the date where id=2, but I am getting below error as response:

message: "The provided key element does not match the schema"
__type: "com.amazon.coral.validate#ValidationException"

Below is my code:

import * as AWS from 'aws-sdk'
AWS.config.update({
    region: 'us-east-1',
    accessKeyId: 'MY_ACCESS_KEY',
    secretAccessKey: 'MY_SECRET_KEY'
});
const docClient = new AWS.DynamoDB.DocumentClient()

export const updateData = (tableName : any, id : any, date : any) => {
        let params = {
            TableName: tableName,
            Key:{
                "id": id
            },
            UpdateExpression: `set date = :date`,
            ExpressionAttributeValues: {":date": date},
        };
        docClient.update(params, function(err, data) {
            if (!err) {
                console.log(data);
            }else{
                console.log(err)
            }
        })
    }

I am calling function like this:

updateData("mytable","2","2023-01-10")

I anyone confirm what I am doing wrong here?

What's the type of the id key the DynamoDB table? String or Number? — fedonev
– fedonev, Commented Jan 18, 2023 at 8:03

Leeroy Hannigan · Accepted Answer · 2023-01-18 11:40:36Z

2

date is a reserved keyword in DynamoDB

You need to use ExpressionAttributeNames param:

        let params = {
            TableName: tableName,
            Key:{
                "id": id
            },
            UpdateExpression: `set #date = :date`,
            ExpressionAttributeValues: {":date": date},
            ExpressionAttributeNames: {"#date":"date"}
        };

As for the exception, ensure that your tables partition key is id and if type String, and that the table does not have a sort key, otherwise you need to add the sort key also.

answered Jan 18, 2023 at 11:40

Leeroy Hannigan

20.5k4 gold badges23 silver badges46 bronze badges

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

1 Comment

Ranjan Kumar Over a year ago

Thanks Lee, I was facing issue because of the sort key. Now it's resolved.

Collectives™ on Stack Overflow

Update Dynamo db table using react

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related