Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Up to 100,000 records can be processed with the freeware version!
Flowheater Chart
JSON Adapter

JSON Adapter - Processing JavaScript object notation files

The JSON Adapter permits JSON (JavaScript object notation) files to be read and/or written from within FlowHeater.

JSON was originally designed for use with JavaScript. However, the JSON format has since established itself as a compact file format for simple data exchanges between various systems. When used in conjunction with the HTTP REST API Adapter, complex logical constructs can be mapped without resorting to complicated programming. See the examples below.

General tab

Adapter JSON - GeneralAdapter JSON - GeneralJSON filename: Enter here the file name of the JSON file to be read or written. A path specification (absolute or relative) is optional. Any relative path originates from the folder that contains the FlowHeater Definition (the .FHD file).

Overwrite an existing file: This option is only available on the WRITE side (for export). If this option is checked, the file will be overwritten each time it is exported. When unchecked, the content is appended to an existing JSON file.

 

 

 

Fields / Data types tab

Adapter JSON - Fields / Data typesAdapter JSON - Fields / Data typesThis tab allows you to define the JSON structure that is desired or retrieve such from an existing JSON file.

Refresh from file: This button will retrieve the structure from an existing JSON file.

JSON type: Select the JSON field type. The following values are available:

Value: The value is formatted based on the selected FlowHeater data type.

Object: The sub-nodes are defined as a JSON object enclosed in curly brackets “{}”.

Array: The sub-nodes are defined as a JSON object enclosed in square brackets “[]”.

Default value: This value is applied if no specific value is assigned to the field.

Note: The selected FlowHeater data type is taken into account when formatting the output.

Adapter settings in the Format tab

The use of the Format tab is described in detail under general information about the usage of Adapters

The following examples are available for the JSON Adapter

 

FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.