MQTT V3 Plug-in Reference

Handling JSON Documents

FairCom Edge V3 includes advanced abilities to process JSON documents sent over MQTT. You have complete control over what gets extracted and how it is transformed. We are ready to help you configure FairCom Edge to process your JSON documents — no matter how complex.

FairCom Edge can automatically extract data from JSON documents sent over MQTT. The data is automatically persisted in the database and can be sent automatically to ThingWorx. All database data is easily integrated with SQL databases through the built-in ODBC and JDBC interfaces. It is also easily integrated with IT applications through the built-in REST API.

This section contains examples of what you can do.

In This Chapter Extracting Data from a JSON Document Mapping JSON Array of Homogeneous Simple Values to a Separate Table Mapping JSON Array of Homogeneous Objects to a Separate Table Mapping JSON Array of Homogeneous Simple Values to Separate Columns in the Same Table