BE_JSONPath

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" )

Have more questions? Submit a request

0 Comments

Article is closed for comments.