DynamoDB - Delete Item based on ConditionExpression on Sort Key

Question

Is it possible to delete records from dynamodb based on PrimaryKey and ConditionExpression on SortKey?

Following code sample is throwing an exception for me

 DeleteVideoCall = async function (pk, sk) {
    let params = {
        TableName: this._tableName,
        Key: {
            pk: { S: pk.toString() },
            sk: { S: sk.toString() }
        },
        ConditionExpression: "begins_with(sk,:sk)",
        ExpressionAttributeValues: {
            ":sk" : { S: sk.toString() + "_" }
        }
    };

    return this._ddb
        .deleteItem(params)
        .promise()
        .then((data) => {
            console.log(`Video Call '${pk}/${sk}' deleted`);
            return null;
        })
        .catch((error) => {
            console.error(
                `Error deleting video room '${pk}/${sk}' (${error})`
            );
            throw error;
        });
};

I want to delete all records that begins_with sk and . For example if sk is 560622 then delete all records where sk begins_with 560622

with the code above I get this error:

Error deleting video room '10900/560622' (ConditionalCheckFailedException: The conditional request failed)

karjan · Accepted Answer · 2020-11-05 08:22:16Z

1

You can't do that. You need whole key to perform a delete. What you can do:

query items (limit retrieved properties to your PK and SK)
use batch-write to remove multiple items, it also accepts delete requests

answered Nov 5, 2020 at 8:22

karjan

1,0361 gold badge11 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

DynamoDB - Delete Item based on ConditionExpression on Sort Key

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