replaceFieldInJSON

This operator replaces the value of a Field in a JSON object with a new value.

Operator Usage in Easy Mode

1. Click + on the parent node.

2. Enter the Replace field in Jsonoperator 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 contains the JSON object.

5. In the Path field, enter the field path whose value needs to be updated in the JSON object.

6. In the New Field Value field, choose the value of the updated field.

7. Click Run to view the result.

8. Click Cancel to discard the operator form.

Usage Details

Text LQL Command replaceFieldInJson(inputTable: TableReference, jsonColumn: ColumnReference, path: String, newFieldValue: ColumnReference)

Input Parameters:

inputTable(TableReference): The table containing the data to run this operator on.
jsonColumn(ColumnReference): The column that contains JSON object.
path(String): Field path whose value needs to be updated in JSON object.
newFieldValue(ColumnReference): Updated value.

Output
This operator will update the value of the provided key in the existing JSON object.