JSONPath() Usage Examples

This section describes an example of using JSONPath().

If the sensor data (cv.Payload) or the argument of the action to be executed in the trigger condition (tv.Data) is in JSON format, you can use JSONPath() to refer to the value.

Sample Data

{ "store": {
    "book": [ 
      { "category": "reference",
        "author": "Nigel Rees",
        "title": "Sayings of the Century",
        "price": 8.95
      },
      { "category": "fiction",
        "author": "Evelyn Waugh",
        "title": "Sword of Honour",
        "price": 12.99
      },
      { "category": "fiction",
        "author": "Herman Melville",
        "title": "Moby Dick",
        "isbn": "0-553-21311-3",
        "price": 8.99
      },
      { "category": "fiction",
        "author": "J. R. R. Tolkien",
        "title": "The Lord of the Rings",
        "isbn": "0-395-19395-8",
        "price": 22.99
      }
    ],
    "bicycle": {
      "color": "red",
      "price": 19.95
    }
  }
}

For example, if you want to refer to store -> bicycle -> color , use

cv.Payload.store.bicycle.color

But if you use JSONPath() you can write

JSONPath("$.store.bicycle.color", cv.Payload)

It can also be written as

The first argument of JSONPath path

Example of the first argument path of JSONPath

For more information on JSONPath, see the Goessner.net reference here.