Python dynamodb ExpressionAttributeValues contains invalid key: Syntax error; key:

Question

Trying to do an update_item which is supposed to create new attributes if it doesn't find existing ones (according to documentation) but I am getting a Sytax error.

I have been wracking my brain all day trying to figure out why I am getting this and I can't seem to get past this. Thank you for any help

Error I am getting:

ClientError: An error occurred (ValidationException) when calling the UpdateItem operation:
   ExpressionAttributeValues contains invalid key: Syntax error; key: "var4"

MyCode:

dynamodb = boto3.resource('dynamodb')
table = dynamodb.Table('contacts')
    table.update_item(
    Key={'email': emailID},
    UpdateExpression=SET last_name = :var0, address_1_state = :var1, email_2 = :var2, phone = :var3, phone_2 = :var4

    ExpressionAttributeValues={
     'var0': 'Metzger', 
     'var1': 'CA', 
     'var2': 'none', 
     'var3': '949 302-9072', 
     'var4': '818-222-2311'
    }
    )

did you modify your code section after the answer was posted? the answer code looks identical to the code given in the question... — fIwJlxSzApHEZIl
– fIwJlxSzApHEZIl, Commented Feb 20, 2021 at 3:36
The change was in the key names. For example from 'var0' to ':var0' (added the two dots) — Paulo
– Paulo, Commented Mar 17, 2021 at 12:35

darkprinx · Accepted Answer · 2020-01-05 08:20:52Z

28

just change the section like the following -

 ExpressionAttributeValues={
     ':var0': 'Metzger', 
     ':var1': 'CA', 
     ':var2': 'none', 
     ':var3': '949 302-9072', 
     ':var4': '818-222-2311'
    }

Hope the code will work then :)

answered Jan 5, 2020 at 8:20

darkprinx

6915 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Python dynamodb ExpressionAttributeValues contains invalid key: Syntax error; 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