I have a Dynamo table ExchangeTrade
with partition key id
. I'd like to return a list of items from ExchangeTrade
where the field userId
is set to a selected string.
I have validated the following cli command:
aws dynamodb scan \
--table-name ExchangeTrade \
--filter-expression "userId = :userValue" \
--expression-attribute-values '{":userValue":{"S":"userIdValue"}}'
However, I can't get this to work in retool. The scan will run but returns 0 items. When I run the cli command on local I get 6 items. Both the cli and retool have the same scanned count when run.
My config using the JSON editor:
{"TableName": "ExchangeTrade",
"FilterExpression": "userId = :userValue",
"ExpressionAttributeValues": {":userValue":{"S":"userIdValue"}}}
My config using the visual editor:
I'm not sure what I've done wrong or how to proceed from here. Any help is appreciated, thanks in advance!