# \#jsonpath **URL:** https://community.openhab.org/tag/jsonpath/841.md [Latest](https://community.openhab.org/latest.md) · [Categories](https://community.openhab.org/categories.md) · [Tags](https://community.openhab.org/tags.md) --- ## [MQTT JSONPATH transformation filter not working as expected](https://community.openhab.org/t/mqtt-jsonpath-transformation-filter-not-working-as-expected/165270)
**Author:** [@froyde](https://community.openhab.org/u/froyde)\ **Replies:** 8\ **Last updated:** [August 3, 2025, 3:29pm UTC](https://community.openhab.org/t/mqtt-jsonpath-transformation-filter-not-working-as-expected/165270 "2025-08-03T15:29:33Z")
Platform information: Hardware: IntelNUC, 16GB, 4 Cored OS: Ubuntu 22.04.LTS Java Runtime Environment: 17.0.14 openHAB version: 4.3.5 (official docker build) What is the environment / scene of my configuration issue… --- ## [How to parse an array into simple values?](https://community.openhab.org/t/how-to-parse-an-array-into-simple-values/163361)
**Author:** [@Siemer](https://community.openhab.org/u/Siemer)\ **Replies:** 4\ **Last updated:** [March 28, 2025, 10:29pm UTC](https://community.openhab.org/t/how-to-parse-an-array-into-simple-values/163361 "2025-03-28T22:29:09Z")
Platform information: Pi4B, openhabian 4.3.2 I try to get info from this MQTT payload, but I don’t succeed. { "value" : \[ { "active\_battery\_service" : true, "current" : 0.0, "id" : "com.victronenergy.veb… --- ## [JSONPath - pull first item only](https://community.openhab.org/t/jsonpath-pull-first-item-only/163083)
**Author:** [@jwiseman](https://community.openhab.org/u/jwiseman)\ **Replies:** 5\ **Last updated:** [March 14, 2025, 11:27am UTC](https://community.openhab.org/t/jsonpath-pull-first-item-only/163083 "2025-03-14T11:27:24Z")
Anybody know the syntax to pull the first object before the comma vs. it pulling the entire object which is a duplicate of the first one? The error I’m getting: JsonPath expressions with more than one result are only s… --- ## [Syntax API JSONPath - pull last line, 2nd value - EDITED](https://community.openhab.org/t/syntax-api-jsonpath-pull-last-line-2nd-value-edited/161921)
**Author:** [@jwiseman](https://community.openhab.org/u/jwiseman)\ **Replies:** 7\ **Last updated:** [January 23, 2025, 3:52pm UTC](https://community.openhab.org/t/syntax-api-jsonpath-pull-last-line-2nd-value-edited/161921 "2025-01-23T15:52:49Z")
I’m looking to pull the last line, 2nd value, from this API. Can someone provide a general JSONPath Syntax to get the last line, 2nd value? EDITED - The last value changes every day, a new entry is added. colintalkscr… --- ## [JSONPath control light for ESPresense](https://community.openhab.org/t/jsonpath-control-light-for-espresense/156803)
**Author:** [@bananajoe86](https://community.openhab.org/u/bananajoe86)\ **Replies:** 2\ **Last updated:** [June 20, 2024, 4:02pm UTC](https://community.openhab.org/t/jsonpath-control-light-for-espresense/156803 "2024-06-20T16:02:47Z")
Hey guys, I´m now using RBG light with ESPresense via MQTT. State = espresense/rooms/eingang/led\_1 Command = espresense/rooms/eingang/led\_1/set the JSON output = {“state”:“ON”,“brightness”:255,“color”:{“r”:255,“g”:15… --- ## [JSONPath Transformation get string not number](https://community.openhab.org/t/jsonpath-transformation-get-string-not-number/35952)
**Author:** [@ddragoev](https://community.openhab.org/u/ddragoev)\ **Replies:** 4\ **Last updated:** [February 5, 2024, 3:12pm UTC](https://community.openhab.org/t/jsonpath-transformation-get-string-not-number/35952 "2024-02-05T15:12:09Z")
Hi, I’m getting some data via HTTP Binding and because json is returned I’m trying to get a temperature as a number using JSONPath Transformation. The HTTP server is returning the following string: {“software\_version”… --- ## [Suppress jsonpath transform logger](https://community.openhab.org/t/suppress-jsonpath-transform-logger/153569)
**Author:** [@DubZ](https://community.openhab.org/u/DubZ)\ **Replies:** 7\ **Last updated:** [January 31, 2024, 9:09pm UTC](https://community.openhab.org/t/suppress-jsonpath-transform-logger/153569 "2024-01-31T21:09:11Z")
Hi, it’s all about the warning jsonpath transformation is doing in the mqtt binding channel configuration. First, I know “all” the regex discussions in the past here and I have looked and read them up. But they doesnt w… --- ## [JSONPATH Transformation and zigbee2mqtt - ColorLightbulb](https://community.openhab.org/t/jsonpath-transformation-and-zigbee2mqtt-colorlightbulb/149581)
**Author:** [@Hugel](https://community.openhab.org/u/Hugel)\ **Replies:** 2\ **Last updated:** [September 13, 2023, 6:42pm UTC](https://community.openhab.org/t/jsonpath-transformation-and-zigbee2mqtt-colorlightbulb/149581 "2023-09-13T18:42:08Z")
Hello openHab-Community! I am a long time openHab user and usually i get all answers i am searching for so i can move forward. But this time i have no idea what i can do. My setup: RaspberryPi 4, 4GB RAM OS: Debian 1… --- ## [JSONPATH transformation failed from MQTT events from Shelly Plus 2PM with Shelly Addon](https://community.openhab.org/t/jsonpath-transformation-failed-from-mqtt-events-from-shelly-plus-2pm-with-shelly-addon/147141)
**Author:** [@dipa](https://community.openhab.org/u/dipa)\ **Replies:** 7\ **Last updated:** [June 8, 2023, 7:05am UTC](https://community.openhab.org/t/jsonpath-transformation-failed-from-mqtt-events-from-shelly-plus-2pm-with-shelly-addon/147141 "2023-06-08T07:05:51Z")
Hi Openhab Community, I have a problem with JSONPATH transformation. I have the following setup: Openhabian 3.4.4 on a Rpi 4 MQTT Broker from Openhabian running on the Pi Shelly Plus 2PM with a Shelly Plus Addon wher… --- ## [JSONPath in DSL Rules](https://community.openhab.org/t/jsonpath-in-dsl-rules/146718)
**Author:** [@LeeC77](https://community.openhab.org/u/LeeC77)\ **Replies:** 2\ **Last updated:** [May 26, 2023, 7:52am UTC](https://community.openhab.org/t/jsonpath-in-dsl-rules/146718 "2023-05-26T07:52:08Z")
Hi I’m trying to use JSONPath in a DSL rule to sum the a value from a set of records returned in a JSON response to a URL call. The syntax of the JSON path command I’m using is var newvalue = (transform("JSONPATH"… --- ## [JSONPATH transform help](https://community.openhab.org/t/jsonpath-transform-help/146506)
**Author:** [@pieter\_s\_top](https://community.openhab.org/u/pieter_s_top)\ **Replies:** 4\ **Last updated:** [May 6, 2023, 5:26am UTC](https://community.openhab.org/t/jsonpath-transform-help/146506 "2023-05-06T05:26:56Z")
If have trouble getting the state to update to item from mqtt. topic from mqtt is : '{“state”:“OFF”,“color”:null} On the thing configuration of a Generic MQTT, i enter the following at the Incoming Value Transformation… --- ## [Jsonpath help - condition in path mqtt binding](https://community.openhab.org/t/jsonpath-help-condition-in-path-mqtt-binding/145213)
**Author:** [@Jacek\_Kaczmarczyk](https://community.openhab.org/u/Jacek_Kaczmarczyk)\ **Replies:** 3\ **Last updated:** [March 13, 2023, 3:34pm UTC](https://community.openhab.org/t/jsonpath-help-condition-in-path-mqtt-binding/145213 "2023-03-13T15:34:49Z")
Need your help with proper channel setup for extracting right value i can receive many jsons on one mqtt topic ;( - the clue is to split based on “id:” field and capture some of the fields belonging to given id. i Cre… --- ## [Http binding: items don't receive values although JSONPATH is correct](https://community.openhab.org/t/http-binding-items-dont-receive-values-although-jsonpath-is-correct/144467)
**Author:** [@lagom](https://community.openhab.org/u/lagom)\ **Replies:** 11\ **Last updated:** [February 18, 2023, 4:06pm UTC](https://community.openhab.org/t/http-binding-items-dont-receive-values-although-jsonpath-is-correct/144467 "2023-02-18T16:06:15Z")
Hello community, I tried to setup the fire index information from swedish SMHI (SMHI Open Data API Docs - Fire risk Forecasts) to fill some items with relevant indexes. The .things file looks like this: Thing http:url… --- ## [JSONPATH numeric filtering not working](https://community.openhab.org/t/jsonpath-numeric-filtering-not-working/143653)
**Author:** [@ollo](https://community.openhab.org/u/ollo)\ **Replies:** 9\ **Last updated:** [February 6, 2023, 3:45pm UTC](https://community.openhab.org/t/jsonpath-numeric-filtering-not-working/143653 "2023-02-06T15:45:42Z")
Hi, I’m trying to use JSONPATH numeric filtering on a HTTP bindings channel. While I can do string filtering, numeric filtering is not working. JSONPATH:$..\[?(@.price=='15')\] works and returns the JSON element of inte… --- ## [JSONPATH Transform on dynamic json - spams WARN in log](https://community.openhab.org/t/jsonpath-transform-on-dynamic-json-spams-warn-in-log/143294)
**Author:** [@JensA](https://community.openhab.org/u/JensA)\ **Replies:** 3\ **Last updated:** [January 15, 2023, 8:06am UTC](https://community.openhab.org/t/jsonpath-transform-on-dynamic-json-spams-warn-in-log/143294 "2023-01-15T08:06:46Z")
OH 3.3.x I have my first MQTT thing connected to Openhab, awesome :slight\_smile: But I have some issue with parsing the incoming data. Problem: the JSON content varies! When the sensor thingy starts it delivers a full … --- ## [OH3: iterate through JSON](https://community.openhab.org/t/oh3-iterate-through-json/142017)
**Author:** [@Max\_G](https://community.openhab.org/u/Max_G)\ **Replies:** 2\ **Last updated:** [December 13, 2022, 9:57pm UTC](https://community.openhab.org/t/oh3-iterate-through-json/142017 "2022-12-13T21:57:58Z")
openHABian 3.3.0 on rPi4 with 4GB I just installed the TR064 binding for my Fritzbox. I eventually figured how to get the call list. It can contain multiple calls in one json string; like so: \[ {"loc… --- ## [Only String channel possible with Jsonpath?](https://community.openhab.org/t/only-string-channel-possible-with-jsonpath/140855)
**Author:** [@davorin](https://community.openhab.org/u/davorin)\ **Replies:** 3\ **Last updated:** [November 10, 2022, 12:08pm UTC](https://community.openhab.org/t/only-string-channel-possible-with-jsonpath/140855 "2022-11-10T12:08:11Z")
Good morning Received my Shelly 3EM today and as the Shelly binding is unusable (dunno why it is listed in the bindings then ;o) I use the HTTP binding to get the JSON via the Shelly API. So when calling http://10.0.10… --- ## [OpenHAB3 http binding + jsonpath](https://community.openhab.org/t/openhab3-http-binding-jsonpath/111294)
**Author:** [@anon88690086](https://community.openhab.org/u/anon88690086)\ **Replies:** 21\ **Last updated:** [October 2, 2022, 7:17pm UTC](https://community.openhab.org/t/openhab3-http-binding-jsonpath/111294 "2022-10-02T19:17:47Z")
Platform information: Hardware: VM, 2 core CPU, 2 GB RAM OS: Debian 10.7 Java Runtime Environment:11.0.9.1 openHAB version: 3.0.0 Issue of the topic: old 2.5 config didn’t work with 3.0 I have a device that returns … --- ## [OH3 changes JSON value](https://community.openhab.org/t/oh3-changes-json-value/129248)
**Author:** [@FabianDirli](https://community.openhab.org/u/FabianDirli)\ **Replies:** 5\ **Last updated:** [September 13, 2022, 9:50am UTC](https://community.openhab.org/t/oh3-changes-json-value/129248 "2022-09-13T09:50:13Z")
Hello, I’m getting from MQTT a valid JSON string. If I store this value in a string item, OH changes every : to a =. The problem now is that i cannot use the JSONPATH transformer to get out a the needed value. For exam… --- ## [Forecast.solar read data values from json](https://community.openhab.org/t/forecast-solar-read-data-values-from-json/133544)
**Author:** [@Christian\_Thiele](https://community.openhab.org/u/Christian_Thiele)\ **Replies:** 12\ **Last updated:** [September 7, 2022, 12:53pm UTC](https://community.openhab.org/t/forecast-solar-read-data-values-from-json/133544 "2022-09-07T12:53:20Z")
I would like to read in the values from the forecast.solar website in order to determine the sun’s strongest hours of the day. The JSON looks something like this: { "result":{ "watts":{ "2022-02-21 07… --- ## [JSONPATH transformations on nodejs-poolController not working via MQTT](https://community.openhab.org/t/jsonpath-transformations-on-nodejs-poolcontroller-not-working-via-mqtt/137951)
**Author:** [@fifo](https://community.openhab.org/u/fifo)\ **Replies:** 12\ **Last updated:** [August 12, 2022, 12:11pm UTC](https://community.openhab.org/t/jsonpath-transformations-on-nodejs-poolcontroller-not-working-via-mqtt/137951 "2022-08-12T12:11:40Z")
I am having an issue obtaining a specific value from an item that gets its value via MQTT from nodejs poolController. Most of the items work with no issue as seen below. When I come to the status items, for example, the … --- ## [JSON path](https://community.openhab.org/t/json-path/137663)
**Author:** [@egesia](https://community.openhab.org/u/egesia)\ **Replies:** 4\ **Last updated:** [July 27, 2022, 12:49pm UTC](https://community.openhab.org/t/json-path/137663 "2022-07-27T12:49:31Z")
Hi, is there a way to get the JSON path of an channel or item? I would like to correct (multiply \*0.975) the value of a thermometer but I can’t find the path in OH3 paperUI. It should be something like $.device.status.… --- ## [stateTransformation: invalid path](https://community.openhab.org/t/statetransformation-invalid-path/137203)
**Author:** [@kobold](https://community.openhab.org/u/kobold)\ **Replies:** 1\ **Last updated:** [July 7, 2022, 12:02pm UTC](https://community.openhab.org/t/statetransformation-invalid-path/137203 "2022-07-07T12:02:26Z")
Hi, in the json I would like to get the element “detector” to use this with the http binding to switch this to 0 or 1. I thought I could access the property with the following but it results in an invalid path: stateTr… --- ## [JSONPATH and different content of json payload](https://community.openhab.org/t/jsonpath-and-different-content-of-json-payload/137132)
**Author:** [@smarthomepch](https://community.openhab.org/u/smarthomepch)\ **Replies:** 2\ **Last updated:** [July 4, 2022, 1:20pm UTC](https://community.openhab.org/t/jsonpath-and-different-content-of-json-payload/137132 "2022-07-04T13:20:17Z")
Platform information: Hardware: RPi 4 OS: Raspbian Java Runtime Environment: which java platform is used and what version openHAB version: 3.3.0 in docker Hi, I have a small problem which trying to solve with no su… --- ## [Transform not working in a scheduled rule](https://community.openhab.org/t/transform-not-working-in-a-scheduled-rule/136910)
**Author:** [@technarf](https://community.openhab.org/u/technarf)\ **Replies:** 1\ **Last updated:** [June 27, 2022, 3:37pm UTC](https://community.openhab.org/t/transform-not-working-in-a-scheduled-rule/136910 "2022-06-27T15:37:47Z")
Hi, I’m very new in the OpenHAB world and I’m stuck with a transform function. I have Groovy and JSONPath Transformation Service installed. I also have add jsonpath in the addons.cfg To do simple, I have a rule, whic… --- ## [Problems parsing JSONPATH expressions from LoRaWAN sensor via MQTT](https://community.openhab.org/t/problems-parsing-jsonpath-expressions-from-lorawan-sensor-via-mqtt/136266)
**Author:** [@SoerenG](https://community.openhab.org/u/SoerenG)\ **Replies:** 6\ **Last updated:** [May 31, 2022, 5:08am UTC](https://community.openhab.org/t/problems-parsing-jsonpath-expressions-from-lorawan-sensor-via-mqtt/136266 "2022-05-31T05:08:26Z")
Hello, after updating my OH installation to the recent 3.2 version I am currently in progress of integrating a pump control using 2 LoRaWAN sensors for measuring the current water level in two wells. I’m using TTN at t… --- ## [JSONPATH stop working on OH 3.2](https://community.openhab.org/t/jsonpath-stop-working-on-oh-3-2/136174)
**Author:** [@isoparme](https://community.openhab.org/u/isoparme)\ **Replies:** 3\ **Last updated:** [May 26, 2022, 7:33am UTC](https://community.openhab.org/t/jsonpath-stop-working-on-oh-3-2/136174 "2022-05-26T07:33:57Z")
Hi , suddenly JSONPATH look like won’t working,(before it work correctly) val String test = '\[{ "device": { "location": "Outside", "status": { "temperature": 23.2 }}}\]' val newValue = transform("JSONPATH", "$.device.loc… --- ## [Help with JSON Path - Amber Electric](https://community.openhab.org/t/help-with-json-path-amber-electric/134798)
**Author:** [@NyanLuke](https://community.openhab.org/u/NyanLuke)\ **Replies:** 4\ **Last updated:** [April 4, 2022, 8:58pm UTC](https://community.openhab.org/t/help-with-json-path-amber-electric/134798 "2022-04-04T20:58:42Z")
Platform information: Hardware: IBM Thinkpad - i5/8gbRAM/128gb SSD OS: Debian Java Runtime Environment: openjdk 11.0.10 openHAB version: 3.0.1 Issue of the topic: Hi all. Thank you in advance for any help. I am tryin… --- ## [Cambridge Audio Azure 551- openHAB integration](https://community.openhab.org/t/cambridge-audio-azure-551-openhab-integration/131107)
**Author:** [@RafalO](https://community.openhab.org/u/RafalO)\ **Replies:** 5\ **Last updated:** [March 9, 2022, 12:44pm UTC](https://community.openhab.org/t/cambridge-audio-azure-551-openhab-integration/131107 "2022-03-09T12:44:04Z")
Hello, I have managed to integrate openHAB with Cambridge Audio azure 551. Below is my UI You can find all details (including programs) of my project at: --- ## [HTTP JSONPATH migration](https://community.openhab.org/t/http-jsonpath-migration/129954)
**Author:** [@stfn82](https://community.openhab.org/u/stfn82)\ **Replies:** 3\ **Last updated:** [February 20, 2022, 12:56pm UTC](https://community.openhab.org/t/http-jsonpath-migration/129954 "2022-02-20T12:56:11Z")
I found some old code from the previous http binding which I haven’t migrated to the new http binding: # Tasmota Release Status (cached twice a day) tasmotaRelease.url=https://api.github.com/repos/arendst/Sonoff-Tasmota… [Next page](https://community.openhab.org/tag/jsonpath/841.md?match_all_tags=true&page=1&tags%5B%5D=jsonpath)