Type Conversion Functions
The functions on this page are used to convert data from one type to another in the GSQL query language.
parse_json_array()
Description
Converts a string into a JSON array. The string must be properly formatted, or the function will generate a run-time error. To be properly formatted, besides having the proper nesting and matching of curly braces { }
and brackets [ ]
, each value field must be one of the following:
-
a string
-
a number
-
a boolean
-
a JSONOBJECT - Each key of a key-value pair must be a string in double quotes.
-
a JSON array
parse_json_object()
Description
Converts a string into a JSON object. The string must be properly formatted, or the function will generate a run-time error. To be properly formatted, besides having the proper nesting and matching of curly braces { }
and brackets [ ]
, each value field must be one of the following:
-
a string
-
a number
-
a boolean
-
a JSONOBJECT - Each key of a key-value pair must be a string in double quotes, and the quotes need to be escaped with a backlash-escape
\
. However, if you are supplying the string in GraphStudio as a parameter, you do not need the backlash-escape since string values are not enclosed in double quotes. -
a JSON array