JSON_expr.JSONExtract (JSONPath_expr)
Syntax Elements
-
JSON_expr
- An expression that evaluates to a JSON data type.
-
JSONPath_expr
- An expression to extract information about a particular portion of a JSON instance. For example, $.employees.info[*] provides all the information about each employee.
- The desired information can be any portion of a JSON instance; for example, a name/value pair, object, array, array element, or a value.
- The JSONPath expression must be in JSONPath syntax.
-
JSONPath_expr cannot be NULL. If the expression is NULL, an error is reported.