JSON_PARSE_NULLABLE_ERROR_TO_NULL
Description
The JSON_PARSE_NULLABLE_ERROR_TO_NULL function is used to parse a JSON string into a valid JSON object. If the input JSON string is invalid, it will return NULL without throwing an error. If the input is NULL, it will directly return NULL.
Syntax
JSON_PARSE_NULLABLE_ERROR_TO_NULL( <str> )Aliases
- JSONB_PARSE_NULLABLE_ERROR_TO_NULL
Required Parameters
| Parameter | Description |
|---|---|
<str> | The input string in JSON format to be parsed. |
Return Value
If the input string is a valid JSON, it returns the corresponding JSON object. If the input string is invalid or NULL, it returns NULL.
Examples
- Valid JSON string:
SELECT JSON_PARSE_NULLABLE_ERROR_TO_NULL('{"name": "John", "age": 30}');
+---------------------------------------------------------------+
| JSON_PARSE_NULLABLE_ERROR_TO_NULL('{"name": "John", "age": 30}') |
+---------------------------------------------------------------+
| {"name": "John", "age": 30} |
+---------------------------------------------------------------+
- Invalid JSON string:
SELECT JSON_PARSE_NULLABLE_ERROR_TO_NULL('{"name": "John", "age": }');
+---------------------------------------------------------------+
| JSON_PARSE_NULLABLE_ERROR_TO_NULL('{"name": "John", "age": }') |
+---------------------------------------------------------------+
| NULL |
+---------------------------------------------------------------+
- Input is NULL:
SELECT JSON_PARSE_NULLABLE_ERROR_TO_NULL(NULL);
+---------------------------------------------------------------+
| JSON_PARSE_NULLABLE_ERROR_TO_NULL(NULL) |
+---------------------------------------------------------------+
| NULL |
+---------------------------------------------------------------+