check_json(value: string) -> string

Check that the argument value is a valid JSON document.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• String

Examples

make_col c:check_json(string(payload))

Make a new column, of type string, which is "" if payload is valid JSON or contains a reason that it could not be parsed.

make_col check: check_json('{"k1": "v1", "k1": "v2"}')

Make a new column containing the results of check_json on the specified string. In this case, the check column will contain the message duplicate object attribute "k1", pos 17.