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.