AWS KeyConditionExpression dynamodb query

Question

I'm trying to use the query expression an getting

ATTEMPT EDIT - 1 PASS An error occurred (ValidationException) when calling the Query operation: Invalid KeyConditionExpression: Syntax error; token: "{", near: "{""

This query looks like

aws dynamodb query --table-name name-of-table --key-condition-expression 'id=:91'

I've tried '"id"="91"', ':id=":91"', etc.

id is the partition key so this is also the required attribute needed.

F_SO_K · Accepted Answer · 2018-02-19 15:26:29Z

4

Try this

aws dynamodb query --table-name name-of-table --key-condition-expression 'id = :idval' --expression-attribute-values '{":idval":{"S":"91"}}'

You have to use value substitution on attributes. You can optionally use attribute name substitution.

Note i've assume your id attribute is of type String. Change it to "N" if its a number.

answered Feb 19, 2018 at 15:26

F_SO_K

15k6 gold badges64 silver badges90 bronze badges

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

2 Comments

April_Nara Over a year ago

My query is complicated and this did help. I updated the question with the Exception I now receive.

F_SO_K Over a year ago

May I suggest you roll back the changes to your question, as this answer now makes no sense. If you post this as a new question I will answer it.

Collectives™ on Stack Overflow

AWS KeyConditionExpression dynamodb query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related