2

I have set of data: id, name, height and weight.

I am sending this data to aws iot in json format. From there I need to update the respective columns in a dynamo db hence I have created 3 rules to update name, height and weight keeping id as partition key.

But when I send the message only one column is getting updated. If I disable any 2 rules then the remaining rule works fine. Therefore every time I update, columns are getting overwritten.

How can I update all three columns from the incoming message?

ChrisWue
  • 18,612
  • 4
  • 58
  • 83
Darshu Bc
  • 526
  • 5
  • 22

2 Answers2

3

Another answer: in your rule, use instead the "dynamoDBv2" action -- which "allows you to write all or part of an MQTT message to a DynamoDB table. Each attribute in the payload is written to a separate column in the DynamoDB database ..."

dynamoDBv2 action: writes each attribute in the payload to a separate column in the DynamoDB database.

BobK77
  • 81
  • 4
  • 1
    More infomation about this can be found here: https://docs.aws.amazon.com/iot/latest/developerguide/dynamodb-v2-rule.html – Deividi Silva Jan 08 '18 at 19:42
1

The answer is: You can't do this with the IoT gateway rules themselves. You can only store data in a single column through the rules (apart from the hash and sort key).

A way around this is to make a lambda rule which calls for example a python script which then takes the message and stores it in the table. See also this other SO question.

ChrisWue
  • 18,612
  • 4
  • 58
  • 83