BE_JSONPath ( json ; path )
Query json structure using an XPath like syntax.
Notes and Limitations :
This function doesn't support wildcard path matching, and has a very limited precision when retrieving floating point numbers. If you're looking for something more flexible please consider this :
The existing BE plugin based JSON functions will be deprecated in a future release. It's undecided if they'll be replaced with something else or not, we haven't found a good set of viable replacements.
Version : 2.1
json : the json to parse.
path : the path to the data you want.
Result : Returns the value at path.
BE_JSONPath ( $json ; "$.key" )
BE_JSONPath ( $json ; "$.obj.key" )
BE_JSONPath ( $json ; "$.arr" )
BE_JSONPath ( $json ; "$.obj.arr" )
BE_JSONPath ( $json ; "$.obj.arr.key" )