Concepts

When fields are provided in separate columns in a record, it can be desirable to transform those fields into a JSON object. That JSON object can then be sent out over MQTT, or to any other messaging system that processes JSON objects.

Data can be formatted in various ways according to your needs (for more information see "binaryFormat").

The "tableFieldsToJson" transform action is used to create a JSON object from column fields and store the JSON object in the same record and table.

You can define a transform using the "createTransform", "alterTransform", or "describeTransform" JSON actions (for additional information on transform actions, see Advanced transforms concepts).