JSON Parser Processor

When one of the incoming fields contains JSON, extract and parse it using a JSON parser.

The JSON. parse() method parses a JSON string, constructing the JavaScript value or object described by the string.

Processor Configuration #

Input JSON Column #

Provide the column name for which JSON data will be parsed.

Schema #

Select Infer Schema option to infer the schema from the JSON or select Specify Schema option to specify the schema under the JSON Schema field.

JSON Schema #

Specify JSON schema.

Example: field1 INT, Country string, is_valid boolean, field2 DECIMAL(8,2)

Allow unquoted JSON field names #

Check mark the option to allow parsing of unquoted JSON field names.

Allow single quoted JSON field names #

Check mark the option to allow parsing of single quoted JSON field names.

Keep all incoming columns #

This checkbox enables user to keep incoming fields along with the parsed JSON in the output.

For example: An incoming CSV file has the following fields:

Bob, 35, {"City": "Berlin", "CompanyName": "BMW" }

If this checkbox is checked, the output schema will be:

Bob, 35, Berlin, BMW

Additional properties can be added using ADD CONFIGURATION link.