{"title":"JSON Row Combiner","nodeType":"Manipulator","id":"*C1zA3UfdJepeh0eb","factoryName":"org.knime.json.node.combine.row.RowCombineJsonNodeFactory","factoryId":"org.knime.json.node.combine.row.RowCombineJsonNodeFactory","path":["Structured Data","JSON"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>All of the values in the selected JSON column are combined into a single JSON structure. Depending on the <b>Place resulting JSON</b> setting, the combined rows are either placed <b>Under root key</b> (as the value of that key) or <b>At top level</b> in the output. You can use <b>Additional properties</b> to add custom key/value pairs next to the combined JSON. The <b>Combine rows as</b> option controls whether the rows are collected into an <b>Array</b> or into an <b>Object with key</b> (using a key column to name each entry). For example, when combining rows as an array under a root key with additional properties, the output looks like this:\n <br /></p><pre>{\n  &#34;JSON key&#34;: [\n    { &#34;json&#34;: &#34;from Row1&#34; },\n    { &#34;json&#34;: &#34;from Row2&#34; }\n  ],\n  &#34;custom key&#34;: &#34;custom value&#34;\n}</pre>\n            All columns and rows will be removed or collapsed to a single cell.\n\n        \n        ","shortDescription":"Appends JSON values in the rows to a single JSON value.","keywords":[],"deprecated":false,"streamable":false,"tags":["Structured Data","JSON"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6Q0NBNDY1QjlFRjUwMTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6Q0NBNDY1QkFFRjUwMTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDQ0E0NjVCN0VGNTAxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpDQ0E0NjVCOEVGNTAxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PiwyEcAAAAG9SURBVHjapFM7jwFRGD3DIh5B4VWIhsIWWwlRKDWIQuIPzJ9Qa1V6Wplmk91KpVFSSZbEZsMWgsY7EuKV2Xsvd2KWZtck32Ryz2POd+93BQAyHnie6EuW/+chCAI0vxe32y2KxSIikQi8Xi9isRgKhQIajQZOp9OtyTnAOcFgMEAymUSv14PNZlNVMBhEOBxGJpOB1Wq9TUD/nEgkFLHdbofD4VAMNpsNhsMhSqUS9vu9kkDDnUwmE/r9PiOLoohyuQy/34/xeKyYHA4HjEYjRKNRpuEG9EswGAwflJROp5HNZilZqlQqQrfbFcj6K8UsFgtWqxUCgcA31yktEMIzJcXjcUYi9XaFvdOWuMF8PvepWriQWJnNZm6g9EnEMsVo7xdMvmfwRUlcTCp1haXozrdaLY59Xg8Sc5vNZvD5fJhOpwwgJDEUCokejwd6vR71eh2dTocZkI184TplDna7HfL5PHQ6HbRaLZbLJSOv12ssFgslmcvlQq1Wg9FoVM8BOQXkcjm43W525lxwLaZpJEli4ruTSJ/j8Yh2u41qtYpms4nJZAKn08mGjM6HSkwS3Bj89TIJj17nHwEGAG6J4rlEdAQXAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Table with JSON","description":"Table with a JSON column"}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"JSON value","description":"A single JSON value"}],"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":"JSON column","description":"The JSON column providing the values for the array.","optional":false},{"name":"New column name","description":"Name of the new (single, JSON) column in the output table.","optional":false},{"name":"Combine rows as","description":"Configure how to collect the JSON values.\n<ul><li><b>Array</b> : The rows are collected into a JSON array.</li><li><b>Object with key</b> : The rows become an object within another object with the keys specified by the selected column&#39;s values (will fail if there are duplicates).</li></ul>","optional":false},{"name":"Object key column","description":"The column providing the keys for the object when collecting into object. The rows become an object within another object with the keys specified by the selected column&#39;s values (will fail if there are duplicates). Select &#34;RowID&#34; to use the Row IDs as object keys.","optional":false},{"name":"Place resulting JSON","description":"How to structure the resulting JSON output.\n<ul><li><b>Under root key</b> : Place the resulting JSON under a root key alongside optional additional properties.</li><li><b>At top level</b> : Generate resulting JSON as top level object.</li></ul>","optional":false},{"name":"Root object key","description":"Key under which to place the resulting JSON.","optional":false},{"name":"Additional properties","description":"Additional key/value pairs to add to the root object.\n<ul><li><b>Key</b> : Additional property key.</li><li><b>Value</b> : Additional property 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":"*xCgldu0u0nsCPEFk","factoryName":"org.knime.json.node.writer.JSONWriterNodeFactory","probability":0.24561403508771928},{"id":"*zOsWiRPweohTpd8S","factoryName":"org.knime.json.node.output.JSONOutputNodeFactory","probability":0.08771929824561403},{"id":"*3IccdLfpFEAp9yoz","factoryName":"org.knime.json.node.jsonpath.multi.JSONPathNodeFactory","probability":0.05263157894736842},{"id":"*wcERuaxFYqiU2d-0","factoryName":"org.knime.json.node.patch.apply.JSONPatchApplyNodeFactory","probability":0.05263157894736842},{"id":"*2xUDt4Z24aku4wiS","factoryName":"org.knime.json.node.totable.JSONToTableNodeFactory","probability":0.05263157894736842},{"id":"*OFhUBYYlMMQ7ZM3F","factoryName":"org.knime.base.node.flowvariable.tablerowtovariable.TableToVariableNodeFactory","probability":0.03508771929824561},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.03508771929824561},{"id":"*eOn8ibZnxIkY7XhT","factoryName":"org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory","probability":0.03508771929824561},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.03508771929824561},{"id":"*ZgYyOm1P9VJVBE9e","factoryName":"org.knime.base.node.preproc.joiner.Joiner2NodeFactory","probability":0.03508771929824561}]}