DynamoDB Scan Action

Execute DynamoDB Scan query completely serverless via Thingsup IoT Platform. Create custom query from MQTT Rules Engine or HTTP APIs.

It provides a way to perform a scan in DynamoDB. Before adding DynamoDB Scan Action, user has to define a AWS Connection. User need to provide following parameters to add DynamoDB Scan Action.

TableName

User's DynamoDB Tablename

Function

JavaScript code to Scan "DynamoDB".
"payload" object and "params" object is available in this code. params object should hold key-value data pairs as mentioned in AWS Doc. "payload" object is supplied from Action Trigger like Rules, Action Command etc.
Any params passed through Function will override parameters passed through form.

Connection ID

Connection ID of AWS Connection.

Limit

User can set limit here.

ExpressionAttributeValues

User can provide a ExpressionAttributeValues here. Check AWS Doc for more information.

ExpressionAttributeNames

User can provide a ExpressionAttributeNames here. Check AWS Doc for more information.

FilterExpression

User can provide a FilterExpression here. Check AWS Doc for more information.

ProjectionExpression

User can provide a ProjectionExpression here. Check AWS Doc for more information.

//Example 1
//Let "id" and "name" are the column names inside DynamoDB table.
//It contains a entry having id=1 and name="abc"
//Following are the fields you need mention in form to get the entry from table id having value 1.

{"#a":"id"}   //ExpressionAttributeNames
{":id" : 1}   //ExpressionAttributeValues
#a = :id      //FilterExpression

//Example 2
//Let "id" and "name" are the column names inside DynamoDB table.
//It contains a entry having id=1 and name="abc"
//Following are the fields you need mention in form to get the entries from table id having value greater than 1.

{"#a":"id"}   //ExpressionAttributeNames
{":id" : 1}   //ExpressionAttributeValues
#a > :id      //FilterExpression

//you can use limit parameter to set limit.

Please note the following points:

"payload" object is supplied from Action Trigger like Rules, Action Command etc.
Data Response of Scan will be available as Action Response.

PreviousDynamoDB Query Action NextDynamoDB DeleteItem Action

Last updated 3 years ago

Was this helpful?

//Example 1 //Let "id" and "name" are the column names inside DynamoDB table. //It contains a entry having id=1 and name="abc" //Following are the fields you need mention in form to get the entry from table id having value 1. {"#a":"id"} //ExpressionAttributeNames {":id" : 1} //ExpressionAttributeValues #a = :id //FilterExpression

//Example 2 //Let "id" and "name" are the column names inside DynamoDB table. //It contains a entry having id=1 and name="abc" //Following are the fields you need mention in form to get the entries from table id having value greater than 1. {"#a":"id"} //ExpressionAttributeNames {":id" : 1} //ExpressionAttributeValues #a > :id //FilterExpression //you can use limit parameter to set limit.