{"title":"XML to JSON","nodeType":"Manipulator","id":"*eyEk_DTTp2oTl6Ah","factoryName":"org.knime.json.node.fromxml.XMLToJSONNodeFactory","factoryId":"org.knime.json.node.fromxml.XMLToJSONNodeFactory","path":["Structured Data","JSON"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Reads values from an XML column and converts them into JSON format.</p><ul><li>If there are <b>multiple pieces of text</b> around inner elements, they are translated into elements of a JSON array.</li><li>Text content inside XML elements is stored under a specified key (default key is <code>text</code> ).</li><li>If enabled, XML <b>attributes</b> are converted to JSON keys with an <code>&#64;</code> prefix.</li><li>If enabled, XML <b>processing instructions</b> are converted to JSON keys with a <code>?</code> prefix.</li></ul>\n            \n            <b>Example</b>\n            :\n            <br />\n            <br />\n            The XML\n\n            <pre>                <code>&lt;a&gt;Hello &lt;b&gt;world&lt;/b&gt;!&lt;/a&gt;</code>\n            </pre>\n            becomes:\n\n            <pre>                <code>{\n   &#34;a&#34;: [\n     &#34;Hello &#34;,\n     {\n       &#34;b&#34;: {\n         &#34;text&#34;: &#34;world&#34;\n       }\n     },\n     &#34;!&#34;\n   ]\n}</code>\n            </pre>\n            \n        \n        ","shortDescription":"Converts XML values to JSON values.","keywords":[],"deprecated":false,"streamable":true,"tags":["Structured Data","JSON","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODdGRkYzODFFRjU5MTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODdGRkYzODJFRjU5MTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo4N0ZGRjM3RkVGNTkxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4N0ZGRjM4MEVGNTkxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pn+ESHcAAAE+SURBVHjajJOxboMwEIbPqAMSsCJasXTqUzDwFFHVkTVSH6BLs3ehGwx9iIi3YI8yRn0FUBigde9cHzKO03LSLxPnvv/MnREAIFFCSlrwQdCjFLAyblA7MkFQaLPdteTflDkS1DP/eNUwrUCnccmIDaoLgmDePGiDwwqDR0ohOEkSaVa/51P8YXCH6hnO81xtSutVpQVJPhXGG8NFUci2bb+c3aZko2FcQCB8jKLoIU1TKMsSxnFUU7gYIy2ukyE8oiDLMgV3XQce/0kVNczVhdY8RYJJcRwr2DTgitcukNpH+JMMKGwDMGGrifM+wnsyGIZhYSBc1VyNRfgdNfR9r2BaPavTTpAb3DTNCQ221CM28cwr6riyF1HX9UcYhk++75/xVb6FnvlilGs+pqqqbqdpejENFrn/mXH8CDAA3SLpkqCOhfIAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"table with XML","description":"Table with an XML column."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"table with JSON","description":"Table containing the converted JSON column."}],"dynInPorts":[],"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":"Input column","description":"Column containing XML values","optional":false},{"name":"Output handling","description":"Select how the output JSON column should be handled.\n<ul><li><b>Append</b> : Adds a new JSON column.</li><li><b>Replace</b> : Replaces the original column with the JSON column.</li></ul>","optional":false},{"name":"New column name","description":"Name of the new (JSON) column","optional":false},{"name":"Text body translated to JSON with key","description":"This key will be used for XML text content to be represented in JSON","optional":false},{"name":"Translate comments","description":"When checked, comments (such as &lt;!-- comment --&gt;) will be translated with key: #comment, otherwise they are omitted in the JSON output","optional":false},{"name":"Translate processing instructions","description":"When checked, processing instructions (such as &lt;?do?&gt;) will be translated with prefix ?, otherwise they are omitted in the JSON output","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202605291551","bundleName":"JSON related functionality for KNIME","bundleSymbolicName":"org.knime.json","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":[{"id":"*2xUDt4Z24aku4wiS","factoryName":"org.knime.json.node.totable.JSONToTableNodeFactory","probability":0.3203125},{"id":"*3IccdLfpFEAp9yoz","factoryName":"org.knime.json.node.jsonpath.multi.JSONPathNodeFactory","probability":0.28125},{"id":"*AB2v7bC0nru1GHKf","factoryName":"org.knime.json.node.toxml.JSONToXMLNodeFactory","probability":0.03125},{"id":"*xCgldu0u0nsCPEFk","factoryName":"org.knime.json.node.writer.JSONWriterNodeFactory","probability":0.0234375},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.0234375},{"id":"*wcERuaxFYqiU2d-0","factoryName":"org.knime.json.node.patch.apply.JSONPatchApplyNodeFactory","probability":0.0234375},{"id":"*zOsWiRPweohTpd8S","factoryName":"org.knime.json.node.output.JSONOutputNodeFactory","probability":0.015625},{"id":"*2Nt0avhANQZN1ULo","factoryName":"org.knime.json.node.jsonpath.dict.JSONPathDictNodeFactory","probability":0.015625},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.015625},{"id":"*Xxi6agi_HN4F-Gnk","factoryName":"org.knime.json.node.patch.create.JSONPatchCreateNodeFactory","probability":0.015625}]}