The "tableFieldsToJson" transform maps table fields to JSON properties. When SQL or REST inserts a record into a table, this transform prepares tabular data for delivery as an MQTT message. Specifically, it extracts data from table fields and populates the message's JSON payload.
When SQL or FairCom's JSON API inserts a record into an integration table, it is often desirable for the server to automatically transform data in user-defined fields into a JSON object in the source_payload field for delivery as an MQTT message or pushed to a REST endpoint of a software application.
All types of field data can be transformed and embedded in JSON strings (see "binaryFormat").
You define a transform using the "transformSteps" property in the "createIntegrationTable" and "alterIntegrationTable" actions.