JSON Writer

The node takes the JSON documents of the selected column and writes them, each in a separate file, into a directory. It will append the paths of the written files to the input table as well as the corresponding write status (created, unmodified, overwritten). This node can access a variety of different file systems. More information about file handling in KNIME can be found in the official File Handling Guide.

Options

Folder
The folder to write the JSON files to.
Create missing folders
If enabled, missing folders in the specified path will be created automatically.
If exists
Specify the behavior of the node in case the output file already exists.
  • Fail: Will issue an error during the node's execution (to prevent unintentional overwrite).
  • Overwrite: Will replace any existing file.
  • Ignore: Will ignore if a file already exists and continues the copying process.
JSON column
Column containing the JSON to write.
Remove JSON column
If checked, the column containing the JSON is removed from the output table.
Compress JSON files (gzip)
If checked, the JSON files will be compressed to gzip.
File generation mode
Select how output file names should be determined.
  • Generate: Generate file names using a pattern with an incrementing counter.
  • From column: Use file names from a selected column.
File names
The file names will be generated using the provided pattern. The pattern must contain a single "?" symbol. This symbol will, during execution, be replaced by an incrementing counter to make the filenames unique. The file extension will be detected automatically and must not be specified.
File name column
Column containing the file names under which the corresponding JSON files will be stored.

Input Ports

Icon
Input table containing at least one JSON column.
Icon
The file system connection.

Output Ports

Icon
Input table with an additional path column that contains the paths of the written files, as well as another String column which holds the write status (created, unmodified, overwritten).

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.