JSON Reader

Options

Type

The selection mode.

• File: Select a single file.
• Files in folders: Select a folder and apply filters to select files within it.

Source

The path to the file or folder to select.

Include subfolders

Whether to include subfolders when selecting multiple files within a folder.

Filter by file extension

Enable filtering files by their extension (e.g. 'xlsx;xlsm').

File extensions

Semicolon-separated list of file extensions to include (e.g. 'xlsx;xlsm;xls'). Case-insensitive unless 'Case sensitive (extensions)' is enabled.

Case sensitive (extensions)

Treat the entered extensions as case sensitive when matching.

Filter by file name

Enable filtering by file name pattern with wildcards or regular expression.

File name filter pattern

Pattern for file name filtering. With type 'Wildcard', use '*' and '?'. With type 'Regex', enter a Java regular expression.

File name filter type

Choose how to interpret the file name pattern: wildcard or regular expression.

Case sensitive (names)

Make file name filtering case sensitive.

Include hidden files

Include hidden files in the selection.

Include special files

Include special file types (workflows etc).

Filter by folder name

Enable filtering of folders by name pattern before descending into them.

Folder name pattern

Pattern for folder name filtering. Use '*' and '?' with filter type 'Wildcard'. With type 'Regex', enter a Java regular expression.

Folder name filter type

Choose how to interpret the folder name pattern: wildcard or regular expression.

Case sensitive (folders)

Make folder name filtering case sensitive.

Include hidden folders

Descend into folders that are hidden (if they otherwise pass filters).

Follow symlinks

Follow symbolic links while traversing folders (only relevant when selecting a folder).

Output column name

Name of the output column.

Select with JSONPath

Enable JSONPath filtering to extract a specific part of the read JSON.

Allow comments in JSON files

When selected, /* ... */ and the line comments //, # are interpreted as comments and get ignored instead of causing errors.

JSONPath

The part to select from the input JSON. Using JSONPath preferably with a single result. (For multiple results new rows will be created from them.)

Fail if path not found

If checked, execution will fail if no such part found. If unchecked and not found, the result will be an empty file.

Skip first data rows

Use this option to skip the specified number of valid data rows. This has no effect on which row will be chosen as a column header. Skipping rows prevents parallel reading of individual files.

Limit number of rows

If enabled, only the specified number of data rows are read. The column header row (if selected) is not taken into account. Limiting rows prevents parallel reading of individual files.

Append file path column

Select this box if you want to add a column containing the path of the file from which the row is read. The node will fail if adding the column with the provided name causes a name collision with any of the columns in the read table.

Views

This node has no views

Workflows

• [02.CX] Viber Community Report JSON Parsing WorkflowKNIME Hub
• 00 Install ExtensionsKNIME Hub
• 00 Install ExtensionsKNIME Hub
• 00 Install ExtensionsKNIME Hub
• 00 Install ExtensionsKNIME Hub
• Show all 284 workflows

Links

• No links available

Developers