The "jsonToDifferentTableFields" transform action can be used to take specified properties from a JSON object in one table and store them as separate fields in a record in a separate table.
When the payload of an MQTT message contains a JSON object, it is often desirable to store its properties into user-defined fields in the table. This allows SQL and other traditional database APIs to query the data.
All types of data embedded in JSON strings can be converted to field data according to your needs (see "binaryFormat").
You define a transform using the "transformSteps" property in the "createIntegrationTable" and "alterIntegrationTable" actions.
The
"jsonToDifferentTableFields"transform inserts records into the specified table, but it does synchronize subsequent updates or deletes to the target table. Likewise, if you delete the source integration table, it does not delete the target table.