Use cases
Use cases for the table to JSON transform method
The purpose of the "tableFieldsToJson" transform method is to take data from fields within an integration table, extract these values, and assemble them into a JSON document. This JSON document is typically stored in a designated field within the same or another table, or prepared for export.
The primary use case is to create a JSON document from fields in an inserted record so the FairCom server can automatically publish it to MQTT subscribers or REST endpoints. This approach delivers data to external systems or services that consume JSON data. It facilitates data exchange, supports API integrations, prepares data for NoSQL databases, and enables flexible data presentation or logging.