DriveWorks Pro 22

XPathJsonGet

XPathJsonGet

Finds the value at a given path in a JSON string.

Syntax

XPathJsonGet([Input Data],[Path])

Where:

Input Data is the input data on which to search.

Path is the path to find in the given data object.

Examples

Example JSON

The examples below use the following JSON data stored in a constant.

{
    "books": [
     {
         "title": "Harry Potter",
         "price": 29.99,
     }, 
     {
         "title": "Learning JSON",
         "price": 39.95
     }
   ]
}
        

Examples

The examples below show JSON data stored in a constant being parsed with XPathJsonGet() using a path expression.

[
    {
        "title":"Harry Potter",
        "price":29.99},
    {
        "title":"Learning JSON",
        "price":39.95
    }
]                        

{
        "title":"Harry Potter",
        "price":29.99
}                        

Harry Potter                        

{
        "title":"Learning JSON",
        "price":39.95
}                        

[
        29.99,
        39.95
]                        

{
        "title":"Learning JSON",
        "price":39.95
}                        

See also

This function relates to the Send HTTP Request task.

XPathGet

XPathXMLGet