Actions
Command
DynamoDB Query Action
Execute DynamoDB query completely serverless via Thingsup IoT Platform. Create custom query from MQTT Rules Engine or HTTP APIs.
It provides a way to perform a query on DynamoDB. Before adding DynamoDB Query Action, user has to define a AWS Connection. User need to provide following parameters to add DynamoDB Query Action.
TableName
User's DynamoDB Tablename
Function
- JavaScript code to Query "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.
KeyConditionExpression
ExpressionAttributeValues
ExpressionAttributeNames
FilterExpression
ProjectionExpression
1
//Example 1
2
//Let "id" and "name" are the column names inside DynamoDB table.
3
//It contains a entry having id=2 and name="abc"
4
//Following are the fields you need mention in form to get the entries from table id having value 2.
5
​
6
#a = :id_val //KeyConditionExpression
7
{"#a":"id" } //ExpressionAttributeNames
8
{":id_val":2} //ExpressionAttributeValues
Copied!
Add DynamoDB Query Action
Please note the following points:
- "payload" object is supplied from Action Trigger like Rules, Action Command etc.
- Data Response of Query will be available as Action Response.
Last modified 1yr ago
Copy link