{"title":"JSON Row Combiner and Writer","nodeType":"Sink","id":"*xXV75_xSTeUq_uHc","factoryName":"org.knime.json.node.combine.row.CombineAndWriteJsonNodeFactory","factoryId":"org.knime.json.node.combine.row.CombineAndWriteJsonNodeFactory","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 and written to a file. 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 file. 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). (The JSON content in the file can be pretty-printed.) 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            \n        \n        ","shortDescription":"Combines the values from a JSON column to a single JSON file.","keywords":[],"deprecated":false,"streamable":false,"tags":["Structured Data","JSON"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6Q0NBNDY1QkRFRjUwMTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6Q0NBNDY1QkVFRjUwMTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpDQ0E0NjVCQkVGNTAxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpDQ0E0NjVCQ0VGNTAxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PtixA/gAAAHESURBVHjapFMxb0FRFP7ey1uIoBEq6UsNGE3EZKoJMUj8Abuk8QsM7VCTycIqXZq2k8ksYTIYVEIHPIlKiEiIILfvPK68ig7Vk5z33r3nO9/9zrnnSQAY/mESPRi7jEMQBIi/BVerFfL5PILBIGRZRigUQi6XQ71ex263+6ng1Pr9PqLRKLrdLiwWi+br9RrVahWDwQCdTgeJROI8AZ0ciUTQ6/W0RKvVCpvNBqPRqK2XyyWGwyGKxSIkSdqXQLVwJyBPTqVSKJVKcLvdGI1GRzWbzQaKosDn80FUGygQx+FNDRUIFI/HkUwmCfxcLpeFdrtN+y8UM5lMmM/n8Hg8n+KZzrLxeCyEw2ENpPobj6nJ71QSJ5hOp7dnr5FISMnNtXz1+PRwx/fVZEYKFosFJ2cigbmfkoy+lHsV9KpTEDObzWg2m5zgA4dJPOvZbJaUML/fz2KxGFN7wdLpNAsEAszr9TK14UzTqp8sbnw7k8lop5Hs2WzGT4bD4UCtVoNESac9oHWhUNAGiifo3el0QlUDl8sFYY9nRwX8e7vdotVqoVKpoNFoYDKZwG63a0NG82EwGPazoye45GeSTmv/q30LMAB3LfvPVCeZowAAAABJRU5ErkJggg==","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":[],"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 resulting JSON.","optional":false},{"name":"Output file location","description":"Location to save the file (can also be a URL).","optional":false},{"name":"If output file already exists","description":"How to handle output file already existing.\n<ul><li><b>Fail</b> : Prevent node from executing.</li><li><b>Overwrite file</b> : Replace the file if it exists.</li></ul>","optional":false},{"name":"Format","description":"Format for the resulting JSON.\n<ul><li><b>Dense</b> : No whitespace.</li><li><b>Pretty print</b> : Use multiple lines and indentation.</li></ul>","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":"Column which provides keys when collecting rows into JSON object.","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":"*3NQQr85BlBv-7K30","factoryName":"org.knime.base.filehandling.deletefiles.DeleteFilesNodeFactory","probability":1.0}]}