The "tableFieldsToJson" transform method converts fields in an integration into JSON. You specify which fields in an integration table are input and output fields. The server generates a JSON document, adds a JSON property and value for each input field, and writes the generated JSON document to the output field.
| Section | Description |
|---|---|
| Use cases | You can insert data into the fields of a record in an integration table, and FairCom Edge's delivery engine will automatically send JSON documents to all outputs assigned to the table. For example, the MQTT engine sends a JSON message to the MQTT topic assigned to the table. The REST connector sends a JSON message to the REST endpoint assigned to the table. |
| Concepts | The "tableFieldsToJson" transform action can be used to create a JSON object from column fields and store the JSON object in the same record and table. |
| Tutorials | This section shows how to create a transform that reads data from a table, transforms it into JSON, and stores the JSON in another field in the same table. |
| API reference | The API reference outlines and defines the properties used to utilize the table-to-JSON transform. |