DynamoDB UpdateItem Action
Execute DynamoDB UpdateItem query completely serverless via Thingsup IoT Platform. Create custom items from MQTT Rules Engine or HTTP APIs.
It provides a way to update Item in DynamoDB. Before adding DynamoDB UpdateItem Action, user has to define a AWS Connection. User need to provide following parameters to add DynamoDB UpdateItem Action.

TableName

User's DynamoDB Tablename

Function

  • JavaScript code to update "DynamoDB Item".
  • "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.

ConditionExpression

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

UpdateExpression

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

key

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

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.
1
//"id" and "name" are the column names inside DynamoDB table.
2
//It contains a entry having id="2" and name="abc"
3
//Following are the fields you need mention in form to change the name value to "pqr" of id having value 2.
4
5
#b = :id_val //Condition Expression
6
set #a = :x //Update Expression
7
{"id":"2"} //key
8
{ ":x":"pqr" , ":id_val":"2" } //ExpressionAttributeValues
9
{ "#a" : "name","#b":"id" } //ExpressionAttributeNames
10
Copied!
Add DynamoDB UpdateItem Action
Please note the following points:
  • "payload" object is supplied from Action Trigger like Rules, Action Command etc.
  • Data Response of UpdateItem will be available as Action Response.
Last modified 1yr ago
Copy link