amazon web services - AWS IoT Rule does not process escaped JSON strings

Question

Dear Stackoverflow users,

currently I am working with AWS IoT Rules and have found one issue.

Setup:

• An IoT Rule that is subscribed on the Topic a/b/c
• Action - send a message to a Lambda function
• Error Action - send a message to an SQS queue
• SQL Query - SELECT * as mqttMessage, topic() as topicName FROM 'a/b/c'

Issue:

The setup works absolutely fine, if I publish a message in a form of a valid JSON object. Example:

{"input": "test"}

But doesn`t work at all if I publish the same JSON object in a form of an escaped string. Example:

"{"input": "test"}"

Moreover, with an escaped String as an Input, the message just disappear, without being send to an SQS queue.

Could you please explain me what could be the issue and how can I fix it? Thank you.

Kind regards

Oleksii

question from:https://stackoverflow.com/questions/65897730/aws-iot-rule-does-not-process-escaped-json-strings

Answer 1

Waitting for answers