BE_JSONPath_Deprecated
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 :
https://github.com/geistinteractive/JSONCustomFunctions
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
Parameters :
json : the json to parse.
path : the path to the data you want.
Result : Returns the value at path.
Examples :
BE_JSONPath ( $json ; "$.key" )
BE_JSONPath ( $json ; "$.obj.key" )
BE_JSONPath ( $json ; "$.arr[0]" )
BE_JSONPath ( $json ; "$.obj.arr[0]" )
BE_JSONPath ( $json ; "$.obj.arr[0].key" )