Json

Json#

JSON functions test, extract and query values held in JSON text — for example checking that a string is valid JSON or reading a scalar or object from it.

Function

Description

ISJSON

Tests whether a string contains valid JSON.

JSON_QUERY

Extracts an object or an array from a JSON string.

JSON_VALUE

Extracts a scalar value from a JSON string.