Applies a patch or a merge patch on the input JSON column.
When a (merge) patch cannot be applied, missing values will be generated, node execution will not fail.
See also the node: JSON Diff.
Given {"a":"b","c":{"d":"e","f": "g"} } let us assume the target is {"a":"z","c":{"d":"e"} } (changing a's value to z and
removing f). To achieve this, either the following patch should be applied:
[{"op":"replace","path":"/a","value":"z"},{"op":"remove","path":"/c/f"}] or
this merge and patch: {"a":"z","c":{"f": null} }
The following operators (op) are supported for patch:
add(path,value)remove(path)replace(path,value)move(from,path)copy(from,path)test(path,value)
The merge and patch format reconstructs the parts that need to be changed (changes included), all else can be omitted.
It uses the fge/json-patch implementation.
To refer to flow variables, use the $${TflowVarName}$$ syntax (where T is S for String type, D for floating point numbers and I for integer numbers).
To refer to columns (boolean, numeric, String, JSON), use the $columnName$ syntax.
References to (0-based) row index ($$ROWINDEX$$), row count ($$ROWCOUNT$$) and row keys ($$ROWID$$) can also be used in values.
Options
Popular Successors
- Generic JavaScript View (JavaScript)5 %
- JSON Path3 %
- JSON to Table3 %
- POST Request3 %
- Column Filter3 %
- Concatenate3 %
Column Appender3 %Column Rename3 %- MongoDB Connector3 %
Table Row To Variable Loop Start2 %- Column Expressions (legacy)2 %
Loop End2 %CASE Switch Data (End)2 %- JSON Writer2 %
Variable to Table Column1 %- Table Row to Variable1 %
- Loop End1 %
- Recursive Loop End1 %
- Ungroup1 %
- XML to JSON1 %
- Container Output (JSON)1 %
- Catch Errors (Data Ports)1 %
CSV Writer1 %- Java Snippet1 %
- Constant Value Column1 %
- Missing Value1 %
- Rule Engine1 %
- End IF1 %
- Parallel Chunk End1 %
- External Tool1 %
- JSON Transformer1 %
JSON Writer1 %- MongoDB Save1 %
- MongoDB Update1 %
- DELETE Request1 %
- PATCH Request1 %
- PUT Request1 %
- CSV Writer< 1 %
- Chunk Loop Start< 1 %
- Column Appender< 1 %
- Cross Joiner< 1 %
Row Filter (deprecated)< 1 %- GroupBy< 1 %
- Column Splitter< 1 %
- String Manipulation< 1 %
- String Manipulation (Variable)< 1 %
- CASE Switch End< 1 %
- DB Writer< 1 %
- Excel Writer< 1 %
- JSON Column Combiner< 1 %
- JSON Row Combiner and Writer< 1 %
- JSON Row Combiner< 1 %
- Container Output (Table)< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- JSON Diff< 1 %
- JSON Schema Validator< 1 %
- JSON to XML< 1 %
- MongoDB Writer< 1 %
- Python Script (legacy)< 1 %
- XPath< 1 %
- Variable to Table Column< 1 %
- String Replacer< 1 %
- Extract Table Spec< 1 %
Database Writer< 1 %- Group Loop Start< 1 %
Joiner< 1 %OAuth< 1 %- Save File Locally< 1 %
- Wait...< 1 %
Variable to Table Column< 1 %Table Writer< 1 %- Column Combiner< 1 %
- Number to String< 1 %
- RowID< 1 %
- Ruleset Editor< 1 %
- Interactive Table (legacy)< 1 %
- DB Insert< 1 %
Table to HTML< 1 %- Active Branch Inverter< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %- Read Images< 1 %
Database Update< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Logistic Regression Predictor< 1 %
- Perl Scripting< 1 %
Cell Splitter< 1 %- Double to Integer< 1 %
Row Splitter (deprecated)< 1 %- Table Transposer< 1 %
- Scatter Plot (legacy)< 1 %
- Random Matcher< 1 %
- Bar Chart (JavaScript)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Bag Of Words Creator< 1 %
Strings To Document< 1 %- Weka Predictor (3.7)< 1 %
- Table View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- JSON Path (Dictionary)< 1 %
- Columns to JSON< 1 %
MongoDB Writer< 1 %- GET Request< 1 %
- XSLT< 1 %
- Form Encoded HTTP Entity Creator< 1 %
Views
- This node has no views
Workflows
01_Configure_Default_Usernames_Roles_and_PasswordsKNIME Hub- 01_D3_JS-ExampleKNIME Hub
- 09_Schedule_Jobs_via_WebPortal_on_KNIME_ServerKNIME Hub
- 09_Schedule_Jobs_via_WebPortal_on_KNIME_ServerKNIME Hub
- 18_MongoDB_nodesKNIME Hub
- Show all 66 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.