Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • JSON Transformer
NodeNode / Manipulator

JSON Transformer

Structured Data JSON Streamable
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    table with JSON
    A table with JSON column to transform
Output ports
  1. Type: Table
    table with JSON
    Table with the transformed JSON values

Extension

The JSON Transformer node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    JSON Transformer Examples
    JSON
    Examples for some basic JSON transformations using the JSON Transformer node.
    dr_snglr > Public > JSON Transformer Examples
  2. Go to item
    JSON Transformer Examples
    JSON
    Examples for some basic JSON transformations using the JSON Transformer node.
    javfranram > Public > JSON Transformer Examples
  3. Go to item
    Example of Visualization with Custom JavaScript D3.js Code
    D3.js JavaScript Heatmap
    +2
    In this example we visualize same data from CSV and JSON formats in an heatmap. We also i…
    knime > Examples > 07_Scripting > 04_JavaScript > 01_D3_JS-Example
  4. Go to item
    MongoDB Nodes
    MongoDB Database
    This workflow shows the functionality of the MongoDB nodes. It requires you to set up a l…
    knime > Examples > 01_Data_Access > 02_Databases > 18_MongoDB_nodes
  5. Go to item
    JSON file for KUMU
    JSON concat Kumu Graph
    This workflow generates a JSON file in an acceptable format for KUMU.io.
    ehsant > Public > JSON file for KUMU
  6. Go to item
    Job Scheduling on WebPortal
    REST API KNIMEServer
    +2
    This workflow provides access to the scheduling functionality of KNIME Server via the Web…
    knime > Examples > 09_Enterprise > 01_Server > 03_Using_KNIMEServer_REST_API > 09_Schedule_Jobs_via_WebPortal_on_KNIME_Server
  7. Go to item
    Job Scheduling on WebPortal
    REST API KNIMEServer
    +2
    This workflow provides access to the scheduling functionality of KNIME Server via the Web…
    rolandburger > Public > KNIME Server > 09_Schedule_Jobs_via_WebPortal_on_KNIME_Server
  8. Go to item
    Job Scheduling on WebPortal
    REST API KNIMEServer
    +2
    This workflow provides access to the scheduling functionality of KNIME Server via the Web…
    arnaud_heitzman > Public > 09_Schedule_Jobs_via_WebPortal_on_KNIME_Server
  9. Go to item
    Slack Post
    Slack
    Slack API call: https://api.slack.com/methods/chat.postMessage Sends a message to a slack…
    swebb > Slack > Slack Post
  10. Go to item
    bit.ly API, UTM Tagging and QR code creation.
    Qr code Qrcode Short url
    +1
    A multifuncion workflow built for a professional need (digital marketing). Gathers landin…
    walkergv77 > Public > Bulk Create QR codes, Short URL and UTM Tagging
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits