This operator parse the JSON column that contains nested stringify JSON into JSON object.

Operator Usage in Easy Mode

  1. Click + on the parent node.
  2. Enter the parseJsonoperator in the search field and select the operator from the Results to open the operator form.
  3. In the Input Table drop-down, enter or select a table from which to source the data.
  4. In the Json Column field, choose the column that needs to be parsed.
  5. Click Run to view the result.
  6. Click Cancel to discard the operator form.

Usage Details

parseJson(inputTable: TableReference, jsonColumn: ColumnReference)

Input Parameters:

inputTable(TableReference): The table containing the data to run this operator on.
jsonColumn(ColumnReference): The column that needs to be parsed.

Output
This operator will parse JSON columns that contain nested stringify JSON into JSON objects.

Example

Input Parameters:

  • Keynestedlevel1 inside level2 has a stringifyJSON object.

Operator usage

  • We try to parse the nested field nestedlevel1which contains a stringify nested json.

Output:

  • We get the stringifyJSON object being parsed in proper JSON

© Devo Technology Inc. All Rights Reserved.