AWS DynamoDB query failed due to attribute having certain characters

Question

data = table.query(KeyConditionExpression = Key('id').eq('fasfas'),
                   FilterExpression=Attr(u'Absolute humidity[g/kg].3').eq(1))

Error:

ClientError: An error occurred (ValidationException) when calling the Query operation: Invalid FilterExpression: Syntax error; token: "humidity", near: "Absolute humidity ["

How can I make it work using boto3 as it works fine on website?

P.S. it also doens't work with underscores.

Answer 1

your parameter is not matching the datatype or a required parameter is missing such as range and hash key.

For more details you can go through the documentation

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Programming.Errors.html