{"title":"JSON Reader","nodeType":"Source","id":"*MJ89ZgBFq7ZpdhvG","factoryName":"org.knime.json.node.filehandling.reader.JSONReaderNodeFactory","factoryId":"org.knime.json.node.filehandling.reader.JSONReaderNodeFactory","path":["Structured Data","JSON"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

This node reads the .json file and parses it as JSON value.

\n \n

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.

\n \n \n ","shortDescription":"Reads .json files to JSON values.","keywords":[],"deprecated":false,"streamable":true,"tags":["Structured Data","JSON","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MjU0QTUxOTZFRjRFMTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MjU0QTUxOTdFRjRFMTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoyNTRBNTE5NEVGNEUxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoyNTRBNTE5NUVGNEUxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pg6mOmQAAAGxSURBVHjapFPPSwJBFJ5ZTUkFBamTqB0SSz1I0l9gJ/GkRyvWU4cOInRZCIv6A/wbPAnReqs/oFO3iCjoVOdE/MUmKm3f21xZZ72EA9/um3nv++bNezOSrutsFUhsxeG0TjjnprkOnLjd7mO/378TiUR+MpnMSzqdfggGg0qhUBhREGXA6SMIhIE7kBMgMyvi8ThLpVJfmqbtV6vVD+I6hYxo53uQd4kQCAQYdmQej8cQAJG12+2N6XT6WKlUthCriTU4NcmyLLNGo/GtKMo15pdmFpPJhHW73c3BYHBGhAUBkEsUlM/nWbFYZMPhsAX7XFXVC6zfkM/n87Fer8f6/f6RTYAKRkHZbNYIAlSLr0VHMgU6nU54mYABr9drCsx9IOvw8fF4zGc+3dZGBLwDCQqgs+Kfw/LtzJcrl8vNv+7pPBaLPVPXRIEmcIVKG3MIyKj2WzKZXHO5XCUsHc7abYgYtvUe4IJ4IPAUCoW2HQ4Hr9VqtptHZNMmkYUaoNoaBA4kSXqlnlOwCFHM9hbq9fonCrYXjUaNHUSICS3UwHKckfA2lg1ua+M/xlz5V4ABAJUp6WQ0+1Z8AAAAAElFTkSuQmCC","views":[],"inPorts":[],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"JSON table","description":"Table with the read JSON values"}],"dynInPorts":[{"groupName":"File System Connection","groupDescription":"The file system connection.","types":[{"objectClass":"org.knime.filehandling.core.port.FileSystemPortObject","color":"178ba5","dataType":"File System"}]}],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Type","description":"The selection mode.\n","optional":false},{"name":"Source","description":"The path to the file or folder to select.","optional":false},{"name":"Include subfolders","description":"Whether to include subfolders when selecting multiple files within a folder.","optional":false},{"name":"Filter by file extension","description":"Enable filtering files by their extension (e.g. 'xlsx;xlsm').","optional":false},{"name":"File extensions","description":"Semicolon-separated list of file extensions to include (e.g. 'xlsx;xlsm;xls'). Case-insensitive unless 'Case sensitive (extensions)' is enabled.","optional":false},{"name":"Case sensitive (extensions)","description":"Treat the entered extensions as case sensitive when matching.","optional":false},{"name":"Filter by file name","description":"Enable filtering by file name pattern with wildcards or regular expression.","optional":false},{"name":"File name filter pattern","description":"Pattern for file name filtering. With type 'Wildcard', use '*' and '?'. With type 'Regex', enter a Java regular expression.","optional":false},{"name":"File name filter type","description":"Choose how to interpret the file name pattern: wildcard or regular expression.","optional":false},{"name":"Case sensitive (names)","description":"Make file name filtering case sensitive.","optional":false},{"name":"Include hidden files","description":"Include hidden files in the selection.","optional":false},{"name":"Include special files","description":"Include special file types (workflows etc).","optional":false},{"name":"Filter by folder name","description":"Enable filtering of folders by name pattern before descending into them.","optional":false},{"name":"Folder name pattern","description":"Pattern for folder name filtering. Use '*' and '?' with filter type 'Wildcard'. With type 'Regex', enter a Java regular expression.","optional":false},{"name":"Folder name filter type","description":"Choose how to interpret the folder name pattern: wildcard or regular expression.","optional":false},{"name":"Case sensitive (folders)","description":"Make folder name filtering case sensitive.","optional":false},{"name":"Include hidden folders","description":"Descend into folders that are hidden (if they otherwise pass filters).","optional":false},{"name":"Follow symlinks","description":"Follow symbolic links while traversing folders (only relevant when selecting a folder).","optional":false},{"name":"Output column name","description":"Name of the output column.","optional":false},{"name":"Select with JSONPath","description":"Enable JSONPath filtering to extract a specific part of the read JSON.","optional":false},{"name":"Allow comments in JSON files","description":"When selected, /* ... */ and the line comments // , # are interpreted as comments and get ignored instead of causing errors.","optional":false},{"name":"JSONPath","description":"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.)","optional":false},{"name":"Fail if path not found","description":"If checked, execution will fail if no such part found. If unchecked and not found, the result will be an empty file.","optional":false},{"name":"Skip first data rows","description":"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.","optional":false},{"name":"Limit number of rows","description":"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.","optional":false},{"name":"Append file path column","description":"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.","optional":false}]}],"links":[],"kudos":[{"accountId":"account:user:eb44e36f-94fa-45b8-9584-32b2328e64c4","user":"gallardo","date":"2024-09-02T19:08:10+00:00"}],"kudosCount":1,"bundleInformation":{"bundleVersion":"5.12.0.v202605041104","bundleName":"JSON related functionality for KNIME","bundleSymbolicName":"org.knime.json.filehandling","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.json","featureName":"KNIME JSON-Processing","featureVersion":"5.12.0.v202605291551","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*M6ImzgljvpBKaP13"},"frequentSuccessors":[]}