AWS DynamoDB error: ValidationException: One or more parameter values were inval...
source link: https://www.kevinhooke.com/2022/11/15/aws-dynamodb-error-validationexception-one-or-more-parameter-values-were-invalid-condition-parameter-type-does-not-match-schema-type/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
AWS DynamoDB error: ValidationException: One or more parameter values were invalid: Condition parameter type does not match schema type
Executing a query against a Global Secondary Index I got this error:
ValidationException: One or more parameter values were invalid: Condition parameter type does not match schema type
Using the NodeJS Document api, my query looked like this:
let params = {
"TableName": "exampletable",
"IndexName": "example-createdate-index",
"KeyConditionExpression": "exampleattr1 = :exampleattr1",
"ExpressionAttributeValues": {
":exampleattr1": { "S": "0" }
},
"ProjectionExpression": "createdate, exampletext",
"ScanIndexForward": false
}
return docClient.query(params).promise();
The error is saying that one of my query parameter types does not match the values in the schema. I know this value is a String so this looks correct. Following recommendations on this question, it’s suggested to not pass the param type as “S” and let the Document api work out the type itself.Remove the “S” and just passed the value and now it’s working as expected.
CategoriesKev's BlogTagsaws, aws dynamodb, aws lambda
Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
Comment *
Name *
Email *
Website
Save my name, email, and website in this browser for the next time I comment.
Notify me of follow-up comments by email.
Notify me of new posts by email.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Post navigation
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK