Python Boto3 AWS DynamoDB get item from table without sort key

Question

I am trying to update an item from my DynamoDb table from a AWS Lambda function and I am getting the following error:

"errorMessage": "An error occurred (ValidationException) when calling the UpdateItem operation: The provided key element does not match the schema",

I have not defined a sort key when defining my table, and my partition key is named 'pipeId', and I have used the following code:

dynamodb = boto3.resource('dynamodb')
table = dynamodb.Table('mytable')

response = table.update_item(
    Key={
        'pipeId': pipe_id
        },
    UpdateExpression="set hookId = :r",
    ExpressionAttributeValues={
            ':r': hook_id
        },
    ReturnValues="UPDATED_NEW"
)

Isn't possible to get or update an item without previously setting a sort key ? or am I doing something wrong here ?

I don't see anything about sort key in the error message, so not sure why you are focusing on that. It is saying that pipeId is not actually the primary key of your table. Are you sure it's not PipeID or pipe_id or something? — Mark B
– Mark B, Commented Jan 8, 2019 at 19:28
I was focusing on that because I saw many other topics pointing that this error was because they were providing an incomplete key; And yes, I am using the right table name. @MarkB thank you — rickh
– rickh, Commented Jan 9, 2019 at 10:54

rickh · Accepted Answer · 2019-01-09 11:38:20Z

2

I have found the solution.

The problem was that my primary key is defined as number and I was inserting it as String, like "3219"; but it doesn't convert automatically.

answered Jan 9, 2019 at 11:38

rickh

912 silver badges8 bronze badges

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

1 Comment

AMIC MING Over a year ago

Your Solution woks for me, Thanks for question here

Collectives™ on Stack Overflow

Python Boto3 AWS DynamoDB get item from table without sort key

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