JSON Functions
All functions > JSON
All functions in the JSON category.
| Function | Description |
|---|---|
JSON_PARSE() | Returns the given string as a JSON expression. |
TRY_JSON_PARSE() | Returns the given string as a JSON expression, or NULL if the string is not valid JSON. |
JSON_PARSE_AS() | Returns the value of a JSON expression represented as a string in the given type. |
JSON_EXTRACT() | Returns the value of the given JSON path in the given JSON expression. |
JSON_EXTRACT_SCALAR() | Returns the scalar value of the given JSON path in the given JSON expression. |
JSON_FORMAT() | Returns the given JSON expression as a string. |
JSON_ARRAY_COUNT() | Returns the number of elements in a JSON array. |
JSON_KEYS() | Returns the keys of a JSON object as an array of strings. |
JSON_TYPE() | Returns the type of a JSON value as a string. |
Summary
- Functions in JSON: 9
This documentation is automatically generated from the FeatureMesh registry.