JSON functions

These are json functions that can be useful in transforming your json data.

json-string represents the string version of json.
json-element represents either the the json object or json array.
json-object and json-array represent different collections.
json-null represents a null element of json.

Example data

Upload to the workspace json an input record such as:

{
    "name": {
        "fname": "Joltie",
        "lname": "Root",
        "mname": null
    },
    "coordinates": [
        12.56,
        45.789
    ],
    "numbers": [
        1,
        2.1,
        3,
        null,
        4,
        5,
        6,
        null
    ],
    "moves": [
        { "a": 1, "b": "X", "c": 2.8},
        { "a": 2, "b": "Y", "c": 232342.8},
        { "a": 3, "b": "Z", "c": null},
        { "a": 4, "b": "U"}
    ],
    "integer": 1,
    "double": 2.8,
    "float": 45.6,
    "aliases": [
        "root",
        "joltie",
        "bunny",
        null
    ]
}

Below is an example malformed json described as malformed_json that is missing a comma.

    {
      a : 1,
      b : 2.0,
      c : test
      d : true
    }

CDAP Documentation

JSON functions

Example data

Related content