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.
Add DynamoDB Scan Action

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.