Appending list not working for AWS DynamoDB using Python boto3

Question

I'm trying to append a value to a DynamoDB table entry:

{
 "id": "1",
 "history": [
  "638380895-8"
 ],
 "currentbooks": "",
 "email": "[email protected]",
 "name": "Osborne Comford"
}

I'm trying to write the code to add a string entry to 'history' array.

Following is my python code:

usersTable = dynamodb.Table("users")
booksTable = dynamodb.Table("books")
bookisbn = event['isbn']
response = usersTable.update_item(
    Key={
        'id': userid,
    },
    UpdateExpression="set history=list_append(history, :s)",
    ExpressionAttributeValues={ 
        ':s': bookisbn

    },
    ReturnValues="UPDATED_NEW"
)

It's giving me the error:

"errorMessage": "An error occurred (ValidationException) when calling the UpdateItem operation: Invalid UpdateExpression: Incorrect operand type for operator or function; operator or function: list_append, operand type: S"

rdas · Accepted Answer · 2021-05-22 10:52:52Z

3

list_append works with 2 lists:

list_append(list1, list2)

You need to pass the update expression along with the type of the element that you're adding i.e. "L" for a list:

response = usersTable.update_item(
    Key={
        'id': userid,
    },
    UpdateExpression="set history=list_append(history, :isbn)",
    ExpressionAttributeValues={ 
        ':isbn': {"L": [ { "S" : isbn } ]} # ensure you pass a list

    },
    ReturnValues="UPDATED_NEW"
)

See the docs for example.

edited May 22, 2021 at 10:52

answered May 22, 2021 at 10:31

rdas

21.4k6 gold badges39 silver badges48 bronze badges

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

3 Comments

rdas Over a year ago

Updated. Try again.

Mathew Dony Over a year ago

Still giving me the error: "errorMessage": "An error occurred (ValidationException) when calling the UpdateItem operation: Invalid UpdateExpression: Incorrect operand type for operator or function; operator or function: list_append, operand type: M",

rdas Over a year ago

Forgot about the type for isbn itself. Updated.

Mathew Dony · Accepted Answer · 2021-05-23 03:03:44Z

0

    response = usersTable.update_item(
    Key={
        'id': userid,
    },
    UpdateExpression="set history=list_append(history,:isbn)",
    ExpressionAttributeValues={ 
        ':isbn': [bookisbn]

    },
    ReturnValues="UPDATED_NEW"
)

This is the correct solution...

answered May 23, 2021 at 3:03

Mathew Dony

4556 silver badges14 bronze badges

Collectives™ on Stack Overflow

Appending list not working for AWS DynamoDB using Python boto3

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related