{"title":"JSON Path (Dictionary)","nodeType":"Manipulator","id":"*2Nt0avhANQZN1ULo","factoryName":"org.knime.json.node.jsonpath.dict.JSONPathDictNodeFactory","factoryId":"org.knime.json.node.jsonpath.dict.JSONPathDictNodeFactory","path":["Structured Data","JSON"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

Collects the parts specified by JSONPath s from a JSON column. For those parts that cannot be found or have incompatible types, missing values will be returned.

\n Example input table:\n
\n \n column namepathtypebookyear$.book[*].yearList(Double)invalidyear$.book[2].yearDoubletimeline$.book[?(@.year==1999)].titleStringpaths$..*List(Path)\n Example input:\n\n 
{"book": [\n    {"year": 1999,\n     "title": "Timeline",\n     "author": "Michael Crichton"},\n    {"year": 2000,\n     "title": "Plain Truth",\n     "author": "Jodi Picoult"}\n]}\n
\n The results look like this:\n\n bookyearinvalidyeartimeline{1999, 2000}?Timeline\n The \n paths\n column contains the following\nvalues (String list): \n $['book']\n , \n $['book'][0]\n , \n $['book'][1]\n ,\n\n $['book'][0]['year']\n , \n $['book'][0]['title']\n , \n $['book'][0]['author']\n ,\n\n $['book'][1]['year']\n , \n $['book'][1]['title']\n , \n $['book'][1]['author']\n \n \n ","shortDescription":"Collect parts of JSON documents based on JSONPath queries specified in the second input port.","keywords":[],"deprecated":false,"streamable":false,"tags":["Structured Data","JSON"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MkFFRDY1QjFFRjRGMTFFNUJCQTVFNkU1RjA4Rjk4QjMiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MkFFRDY1QjJFRjRGMTFFNUJCQTVFNkU1RjA4Rjk4QjMiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoyQUVENjVBRkVGNEYxMUU1QkJBNUU2RTVGMDhGOThCMyIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoyQUVENjVCMEVGNEYxMUU1QkJBNUU2RTVGMDhGOThCMyIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pntj9KMAAAGlSURBVHjahJK/T8JQEMevLxpSIAFC2lFwQ00HInFlcjJMdDSabg4OhMTBJqZAnA1/A5OJCW76Bzi5EwdccJbwm2qEtN41PGxLkUu+ad+9+37u9foE+AsRdREKhc5jsdheKpWycrlcK5vNviSTSb1YLH5TkW3b4A5h8dxBPaH5AM3gViaTAUVRPk3TPCqXyx0/YGvR+RnN+2SIx+OAHSEcDjsANEK325Xm8/lrqVTaxVrTDWCoS27WNA0ajcaXruu3uK7yU8xmMxgMBvJ4PL4CXzA0n1JRoVAAVVVhMpk84vtNs9msYP6B9qLRKAyHQxiNRmd+gCDL8g8WbddqNZAkiQpVHJiCewZsjirjx4xEIk4XEplpWH6JouhZUx0B2gTgZtTJunb4uSs5AtwTACfNAVqQOZFIQL/fDwTcod57vZ4DwGkHdscBBuYZTttEwDFj7I3++WIGIAiC58kvkD9P9wDq9foHXqDDdDp9jb+sTbnpdOoxWpblWfN9CJo2pUn5fN7mwXM+VdYBwNnEIsMw3IDVun8AS8iyW1BsAPB1Z93d+BVgABGfGMXjzXwaAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data with JSON","description":"Table containing JSON column."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"JSONPaths","description":"Table containing JSONPath, type and output column name definitions."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Extracted columns","description":"Table with extracted columns appended."}],"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 name of the JSON column to extract content from the first input table.","optional":false},{"name":"Remove source column","description":"When checked, the source column will be removed from the output table.","optional":false},{"name":"JSONPath","description":"The name of the JSONPath column from the second input table.","optional":false},{"name":"Type of column","description":"The name of the type column from the second input table. The content should be one of these values in each row: Base64 , Boolean , Double , Integer , Json , Long , String , Path . List(*) and Set(*) wrappers are also supported (e.g. List(Double) ).","optional":false},{"name":"Output name","description":"The name of the new output column from the second input table. In case of conflict, a new column name will be generated.","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":"*OrsWDmrgrJ2VEX6h","factoryName":"org.knime.base.node.preproc.unpivot2.Unpivot2NodeFactory","probability":0.15},{"id":"*aItro4n6xSMUuxg-","factoryName":"org.knime.base.node.preproc.ungroup.UngroupNodeFactory","probability":0.15},{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.1},{"id":"*AApA5VHd41CVDe7u","factoryName":"org.knime.base.node.meta.looper.LoopEndNodeFactory","probability":0.05},{"id":"*AB2v7bC0nru1GHKf","factoryName":"org.knime.json.node.toxml.JSONToXMLNodeFactory","probability":0.05},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.05},{"id":"*n3KemxSzYJ3CC2Od","factoryName":"org.knime.base.node.flowcontrol.trycatch.genericcatch.DataPortCatchNodeFactory","probability":0.05},{"id":"*rqhXsa-dMez9coq4","factoryName":"org.knime.base.node.preproc.transpose.TransposeTableNodeFactory","probability":0.05},{"id":"*U2yr96FW5vuqtLuk","factoryName":"org.knime.python2.nodes.script.Python2ScriptNodeFactory","probability":0.05},{"id":"*_zMUh-EpYjdvFKW9","factoryName":"org.knime.base.node.preproc.columnappend.ColumnAppenderNodeFactory","probability":0.05}]}