How to update in AWS DynamoDb in NodeJs?

Question

I have a code which is updating an existing AWS DynamoDb item,
I am using the update method of the AWS DynamoDb SDK,
I am getting an error while updating the item -

{ ValidationException: ExpressionAttributeValues contains invalid key: Syntax error; key: "tamt"
message: 'ExpressionAttributeValues contains invalid key: Syntax error; key: "tamt"',
  code: 'ValidationException',
  statusCode: 400,
  retryable: false,

Following is my code -

module.exports.updateCart = async (constants, connection, requestBody) => {
    let table = constants.tables.user_cart;

    let params = {
        TableName: table,
        Key:{
            "cart_id": requestBody.cart_id
        },
        UpdateExpression: "set currency = :curr, product_type = :ptype, total_amount = :tamt,"
        +"total_quantity = :tqty, created_date = :cdate, expiry = :exp, items = :items",
        ExpressionAttributeValues:{
            "curr": requestBody.currency,
            "ptype": requestBody.product_type,
            "tamt": requestBody.total_amount,
            "tqty": requestBody.total_quantity,
            "cdate": requestBody.created_date,
            "exp": requestBody.expiry,
            "items" : requestBody.items
        },
        ReturnValues:"UPDATED_NEW"
    };
    console.log("Params => \n", params);

    let update = util.promisify(connection.update).bind(connection);
    let results = await update(params);
    return results;
}

Following is the console log of Params -

{
    TableName: 'someTable',
    Key: {
        cart_id: 'someId'
    },
    UpdateExpression: 'set currency = :curr, product_type = :ptype, total_amount = :tamt, total_quantity = :tqty, created_date = :cdate, expiry = :exp, items = :items',
    ExpressionAttributeValues: {
        curr: 'USD',
        ptype: 'SPECIAL',
        tamt: 50,
        tqty: 1,
        cdate: 1558499016,
        exp: 1558499016,
        items: items: [{
            name: 'someName',
            amount: 50,
            quantity: 1,
            category: 'some Category'
        }]
    },
    ReturnValues: 'UPDATED_NEW'
}

RequestBody -

{
    product_type: 'SPECIAL',
    user_id: 1234,
    total_amount: 50,
    total_quantity: 1,
    currency: 'USD',
    items: [{
        name: 'someName',
        amount: 50,
        quantity: 1,
        category: 'some Category'
    }],
    created_date: 1558499016,
    expiry: 1558499016,
    cart_id: 'someId'
}

I double checked, total_amount field on the table is of Number type,
What could be the issue?

Ref -
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GettingStarted.NodeJs.03.html#GettingStarted.NodeJs.03.03

Reza Nasiri · Accepted Answer · 2019-05-22 12:04:57Z

1

the keys in ExpressionAttributeValues should start with a :

ExpressionAttributeValues:{
        ":curr": requestBody.currency,
        ":ptype": requestBody.product_type,
        ":tamt": requestBody.total_amount,
        ":tqty": requestBody.total_quantity,
        ":cdate": requestBody.created_date,
        ":exp": requestBody.expiry,
        ":items" : requestBody.items
    },

answered May 22, 2019 at 12:04

Reza Nasiri

1,4351 gold badge9 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to update in AWS DynamoDb in NodeJs?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related