📄️ As_<Type>
Strict casting VARIANT values to other data types.
📄️ CHECK_JSON
Checks the validity of a JSON document.
📄️ GET_IGNORE_CASE
Extracts value from a VARIANT that contains OBJECT by the field_name.
📄️ GET_PATH
Extracts value from a VARIANT by path_name.
📄️ GET
Extracts value from a Variant that contains ARRAY by index, or a Variant that contains OBJECT by field_name.
📄️ JSON_ARRAY
Creates a JSON array with specified values.
📄️ JSON_EXTRACT_PATH_TEXT
Extracts value from a Json string by path_name.
📄️ JSON_PATH_EXISTS
Checks whether a specified path exists in JSON data.
📄️ JSON_PATH_QUERY_ARRAY
Get all JSON items returned by JSON path for the specified JSON value and wrap a result into an array.
📄️ JSON_PATH_QUERY_FIRST
Get the first JSON item returned by JSON path for the specified JSON value.
📄️ JSON_PATH_QUERY
Get all JSON items returned by JSON path for the specified JSON value.
📄️ JSON_PRETTY
Formats JSON data, making it more readable and presentable. It automatically adds indentation, line breaks, and other formatting to the JSON data for better visual representation.
📄️ JSON_STRIP_NULLS
Removes all properties with null values from a JSON object.
📄️ JSON_TYPEOF
Returns the type of the main-level of a JSON structure.
📄️ OBJECT_KEYS
Returns an Array containing the list of keys in the input Variant OBJECT.
📄️ PARSE_JSON
Interprets input JSON string, producing a VARIANT value