Extracting value from json

Configuration
1

Hi! I’m trying to create a RESTful Sensor which reads the value from a POST response,
however I cannot figure out how to create a value template to filter out the value off “full_code”:

any ideas?

{
“jsonrpc”: “2.0”,
“result”: {
“timestamp”: 1632563710,
“pallet_stations”: [
{
“emergency”: false,
“in_service”: true,
“capacity”: 750,
“description”: “1”,
“full_text”: “True”,
“pallet_type_code”: 1,
“full_code”: 1,
“entry_ok”: true,
“empty_code”: 0,
“station_type_code”: 0,
“pallet_type_text”: “EUR”,
“sw_ver”: “”,
“passive”: true,
“empty_text”: “False”,
“load_id”: “”,
“connected”: false,
“locked”: false,
“station_type_text”: “Passive 945mm”,
“id”: “1”
}
]
},
“id”: 4
}

2

value_template: "{{ value_json.result.pallet_stations[0].full_code }}"

Here’s a handy tool for finding such paths:

https://jsonpathfinder.com/

3

Thank you! It worked. And thanks for the link :+1: