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.

//"id" and "name" are the column names inside DynamoDB table.
//It contains a entry having id="2" and name="abc"
//Following are the fields you need mention in form to change the name value to "pqr" of id having value 2.
#b = :id_val //Condition Expression
set #a = :x //Update Expression
{"id":"2"} //key
{ ":x":"pqr" , ":id_val":"2" } //ExpressionAttributeValues
{ "#a" : "name","#b":"id" } //ExpressionAttributeNames
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.