JSON Adapter is now fully released for production use

As of this version the BETA testing phase of the JSON Adapter is finished and the JSON Adapter can now be used with live data. Since the structure of JSON files requires some understanding, five detailed examples are provided to explain the special features of JSON processing with FlowHeater. In addition, a tutorial video is available that goes through these examples and demonstrates how easy it makes the conversion of JSON files. The examples only deal with converting JSON and CSV files, but this is simply for purposes of illustration. The same principles these demonstrate can of course be applied to JSON import and export to and from other FlowHeater Adapters, such as SQL databases or REST web service calls using the REST API Adapter.

Follow this link to the JSON examples: Examples of general JSON to CSV conversion

And follow this link to watch the video: General JSON processing video

Release notes for version 4.4.4 on November 11, 2024

Designer enhancements

Three time-saving functions have been added to the Designer. Let's start with the function that will save you the most effort. A Heater can now be copied into several connections (pipes). The handling is very easy: You copy the Heater via the context menu, select some connections and open the context menu of the selection by a right click select the ‘Insert’ menu item.

Heaters for which a note has been saved are now marked with an "i" in the top left-hand corner. This means that you can see immediately on the Designer that further information is available.

With larger Definitions and longer work, it often happens that Heaters move off the Designer window and are only visible by scrolling. If this occurs, you can now use the context menu in the Designer to move these Heaters back into the Designer window using the “Adjust Heater to layer” function. Depending on where the Heaters are currently located, the nearest window margin is used.

InMemory Adapter with more SQL aggregation functions

Until now, only “Select Count(*)” could be used with InMemory Adapter tables via the SQL Heater. As of this version, the InMemory Adapter is extended with three further SQL aggregate functions. The following four SQL functions can now be used in the SQL Heater:

COUNT(*), SUM([fieldname]), MIN([fieldname]) and MAX([fieldname]

Connection enhancement of database Adapters

In certain database Adapters (MySQL Adapter, Oracle, PostgreSQL) the TCP port specification used for establishing a connection can now be dynamically specified with a FlowHeater Parameter. This means that all connection-specific settings can now be mapped using FlowHeater Parameters. If an external parameter file is used to save the FlowHeater Parameters, this information is now used during a connection test.

Corrections (bug fixes)

• MySQL Adapter, problem with UTF8 characters when using a MariaDB database
  
  
• XML Adapter, no parameters could be written to the ROOT element