{"title":"Columns to JSON","nodeType":"Manipulator","id":"*S5sWr2sm-SjOA14S","factoryName":"org.knime.json.node.tojson.ColumnsToJsonNodeFactory","factoryId":"org.knime.json.node.tojson.ColumnsToJsonNodeFactory","path":["Structured Data","JSON"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>The columns values are transformed to JSON objects for each row. When there are conflicting keys, the result is undefined, might vary between different versions of KNIME.</p>\n            <br />\n                \n            <p>An example transformation:\n <br />\n From table:</p>\n                \n            MainNumtextmain12Hellomain21World\n                \n            <p>with custom key/values: <tt>const</tt> and <tt>val</tt> , <tt>Main</tt> as data bound key, <tt>Num</tt> with manual <tt>num</tt> key and <tt>text</tt> as automatic:</p>\n                \n            {&#34;main1&#34;:{&#34;text&#34;: &#34;Hello&#34;, &#34;num&#34;: 2, &#34;const&#34;:&#34;val&#34;}}{&#34;main2&#34;:{&#34;text&#34;: &#34;World&#34;, &#34;num&#34;: 1, &#34;const&#34;:&#34;val&#34;}}\n            \n        \n        ","shortDescription":"Converts contents of columns to JSON values row-wise.","keywords":[],"deprecated":false,"streamable":true,"tags":["Structured Data","JSON","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6ODdGRkYzN0RFRjU5MTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6ODdGRkYzN0VFRjU5MTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoxRUJDQzk0RUVGNTkxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo4N0ZGRjM3Q0VGNTkxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pojg2UIAAAEOSURBVHjapFNBboNADLQjDkjAFZGKD/AIfpB7VeUG10h5QL6QU24QqY+o+AWfiPIFIBygdexotyIrEkI70ohdw4zN2osAQDACIkJ4AZb6+C6IOK414gFzq/T3UDEwOcA7s3Ich/5i8CHvRRwEAS1gHt6YRxaD53kQRRFMVqAPWa33OnOaplSW5bf1KJVxYMR7ZPFKModhCEmSQNM0C+tJuWZ7icWdGMRxDF3XQVVV8OwMUPF3L2Kh7/s38ZSBaSbisxgIJg0G7UO9ZvGXGLRtO7sCUBUcmG1d1zexPGcZFEVxYoONdEibzB0kyPP803XdtW3bF/6VH9RDY87A2G0czkaWZcu+73f43+t8FWAAeBvWquFekSYAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table","description":"Table with values."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table with JSON","description":"Table with the row-wise generated 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":"New column name","description":"Name of the new JSON column","optional":false},{"name":"Remove source columns","description":"The source columns include the Data bound key column too (when that is selected)","optional":false},{"name":"Root key type","description":"How to create the root of the JSON value\n<ul><li><b>Unamed root elements</b> : Generate JSON without a wrapping key.</li><li><b>Custom key</b> : Use a constant key for all rows.</li><li><b>Data bound key</b> : Use a column value from each row as the key.</li></ul>","optional":false},{"name":"Custom key name","description":"Specify the constant key to use for the root object.","optional":false},{"name":"Data bound key column","description":"Select the column whose values will be used as the root keys.","optional":false},{"name":"Manual column selection","description":"The predefined key and the actual value in the selected columns will provide the keys and values in the object\n<ul><li><b>Key</b> : The key name.</li><li><b>Value</b> : The key value.</li></ul>","optional":false},{"name":"Automatic column selection","description":"The keys are the column names and the actual value in the selected columns will provide the keys and values in the object","optional":false},{"name":"Custom key/value pairs","description":"Additional key/value pairs within the object\n<ul><li><b>Key</b> : The key name.</li><li><b>Value</b> : The key value.</li></ul>","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":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.09523809523809523},{"id":"*2xUDt4Z24aku4wiS","factoryName":"org.knime.json.node.totable.JSONToTableNodeFactory","probability":0.061224489795918366},{"id":"*C1zA3UfdJepeh0eb","factoryName":"org.knime.json.node.combine.row.RowCombineJsonNodeFactory","probability":0.061224489795918366},{"id":"*jDedZ_onUp4c833B","factoryName":"org.knime.rest.nodes.post.RestPostNodeFactory","probability":0.05442176870748299},{"id":"*wcERuaxFYqiU2d-0","factoryName":"org.knime.json.node.patch.apply.JSONPatchApplyNodeFactory","probability":0.047619047619047616},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.04081632653061224},{"id":"*S5sWr2sm-SjOA14S","factoryName":"org.knime.json.node.tojson.ColumnsToJsonNodeFactory","probability":0.034013605442176874},{"id":"*zOsWiRPweohTpd8S","factoryName":"org.knime.json.node.output.JSONOutputNodeFactory","probability":0.034013605442176874},{"id":"*xsMeCA0QgX92370E","factoryName":"org.knime.json.node.fromtable.TableToJsonNodeFactory","probability":0.034013605442176874},{"id":"*3IccdLfpFEAp9yoz","factoryName":"org.knime.json.node.jsonpath.multi.JSONPathNodeFactory","probability":0.034013605442176874}]}