Skip to main content

Table to JSON transform method

FairCom Edge's transform method for converting specified fields in the current integration table into a JSON document stored in another field in the same table

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.