JSON Load

image_pdfimage_print

This load type allows writing tabular data in a JSON-file. In the simple standard case, the target data format is fix and predefined by the name of the source columns. Only the name root element can be configured. A more flexible JSON output structure can be achieved by defining a JSON template.

Main settings:

Data Source:

 

Target Connection:

A connection of type JsonFile.

Mode:

The following modes exist:

create

Create a new file, delete an existing file if existing.

add

Create a new file if not existing, add data to an existing file.

Root:

The name of the JSON root element.
If not indicated default name is “data”.

Advanced settings:

Json template:

A Json expression describing the output structure for one source row. It contains placeholders for the source columns in the form #{<ColumnName>}
Example:
{"bookstore":{
"books":{ "#{Category}":[{"name": "#{Title}", "Author": "#{Author}","Price": #{Price}}
]}}}

Input columns:
"Category";"Author";"Title";"Price"
"fiction";"Evelyn Waugh";"Sword of Honour";"12.99"

Result:
{"bookstore": {"books": {"fiction": [{
"Price": 12.99,
"name": "Sword of Honour",
"Author": "Evelyn Waugh"
}]}}}

 

 

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...