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

Reads a well formed XML document. An XPath query can be specified to read only a portion of the file. In this case the output will be the nodes in the document that match the XPath query.

\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 a XML File.","keywords":[],"deprecated":false,"streamable":true,"tags":["Structured Data","XML","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RDgyMTc5RUU1RTNFMTFFNTkzNTNCNDkxMTdGQUY2MkYiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6RDgyMTc5RUY1RTNFMTFFNTkzNTNCNDkxMTdGQUY2MkYiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpEODIxNzlFQzVFM0UxMUU1OTM1M0I0OTExN0ZBRjYyRiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpEODIxNzlFRDVFM0UxMUU1OTM1M0I0OTExN0ZBRjYyRiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PrNvYCwAAAB7SURBVHjavFKLCsAgCEzpv/10V5HibI5lsAOxFM8nMHM5Ae4GAAA3yRNMKEn9kjEi6W4sh0DbT1SEE2tPz0CJ4Pc1elQz0VQraNb1qCP/0gIRDaedSRR0v4YWwBP924j0/aYlRLbAkt1rW43YJfEwC0F2iNUfxi4uAQYAhn1UC1T33cUAAAAASUVORK5CYII=","views":[],"inPorts":[],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Read Table","description":"The complete XML document in a single data cell or the nodes matching the XPath query if XPath filtering is checked."}],"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":"Use XPath filter","description":"Enable XPath filtering to extract specific elements from the XML document.","optional":false},{"name":"XPath query","description":"Only nodes of the document which match this XPath query will be read. Each matching node is read in a single data cell. Note that XPath requires to explicitly denote namespaces. E.g. to read only the body of a XHTML document you can use the XPath query: /dns:html/dns:body where dns is the prefix of the namespace defined in the Namespaces elements. A limited XPath syntax is supported. Only absolute paths to nodes can be defined. Among the XPath operators the |-Operator is supported. It can be used to read for example the head and the body of a XHTML document in single cells: /dns:html/dns:head | /dns:html/dns:body","optional":false},{"name":"Fail if XPath not found","description":"If checked, execution will fail if no match is found for the given XPath in any of the files. If unchecked and not found, the result will be an empty table.","optional":false},{"name":"Namespaces","description":"The prefixes and the namespaces used in the XPath query. For example when querying XHTML documents with the XPath Query:\n
\n//pre:h1\n
\nthe following namespace must be defined:\n
\nPrefix: pre\n
\nNamespace: http://www.w3.org/1999/xhtml\n
\n","optional":false},{"name":"Incorporate namespace of the root element","description":"

This option is useful when you do not have the default namespace of your document at hand.

\n

If checked, the namespace of the root element is added to the Namespaces table during runtime.

","optional":false},{"name":"Prefix of root's namespace","description":"

Define a prefix for the root namespace in case it is incorporated.

\n

For the example of XHTML documents the namespace of the root element is http://www.w3.org/1999/xhtml so that with the root's prefix of dns you can leavethe Namespaces table empty.

","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:09:48+00:00"}],"kudosCount":1,"bundleInformation":{"bundleVersion":"5.12.0.v202604300910","bundleName":"XML related functionality for KNIME","bundleSymbolicName":"org.knime.xml.filehandling","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.xml","featureName":"KNIME XML-Processing","featureVersion":"5.12.0.v202604300910","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*Uj1RwEYxAESCvnlT"},"frequentSuccessors":[]}