Source
PARSE_JSON
Interprets an input string as a JSON document, producing a VARIANT value. You can use the PARSE_JSON function when you have input data in JSON format. This function can convert data from JSON format to ARRAY or OBJECT data and store…
How to parse special characters in PARSE_JSON function
Using two or three backslashes will generate a compilation error, and four backslashes will cause two to be stored in the JSON data.
TO_JSON
Converts a VARIANT value to a string containing the JSON representation of the value. Syntax TO_JSON( <expr> ) Copy Arguments exprAn expression of type VARIANT that holds valid JSON information. Returns Returns a value of type VARCHAR.
TRY_PARSE_JSON
Returns a value of type VARIANT that contains a JSON document. If the input is NULL or if an error occurs during parsing, the function returns NULL. This function doesn’t return a structured type.