I’ve been looking for days trying to reach a solution to this problem, finally gave in! (plus i’m only a month in to Openhab)
I’ve flashed a Sonoff Basic with Tasmota and connected a SDS011 via serial and MQTT is reporting:
{“Time”:“2019-05-14T21:23:38”,“SDS0X1”:{“PM2.5”:2.9,“PM10”:4.7}}
I’m using Paper UI to add the thing and using JSONPATH to transform for the value.
It works fine for PM10 using the below transformation:
JSONPATH:$.SDS0X1.PM10
However when I try and transform for the PM2.5 it fails.
Transformation:
JSONPATH:$.SDS0X1.PM2.5
Log Viewer:
2019-05-14 22:46:09.504 [WARN ] [l.generic.ChannelStateTransformation] - Executing the JSONPATH-transformation failed: Invalid path ‘$.SDS0X1.PM2.5’ in ‘{“Time”:“2019-05-14T22:46:09”,“SDS0X1”:{“PM2.5”:3.6,“PM10”:5.9}}’
I suspect its the decimal point in ‘2.5’
I’ve looked for how to remove the decimal in Tasmota and cannot work that one out, looked for how to handle decimals in JSONPATH with no joy.
Thanks for getting back. Unfortunately we have the same error:
2019-05-15 09:45:38.116 [WARN ] [l.generic.ChannelStateTransformation] - Executing the JSONPATH-transformation failed: Invalid path ‘$.SDS0X1.PM2.5’ in ‘{“Time”:“2019-05-15T09:45:37”,“SDS0X1”:{“PM2.5”:2.0,“PM10”:9.1}}’
Its still not playing ball. error as follows:
2019-05-15 17:50:29.520 [WARN ] [l.generic.ChannelStateTransformation] - Transformation service REGEX(.PM2.5" for pattern (.),.*) not found!
Thanks for the help.
Its still not working, for some reason the log entry doesn’t show all the char’s
the latest log for Regex(.PM2.5":(.),.):
2019-05-15 18:29:00.718 [WARN ] [l.generic.ChannelStateTransformation] - Transformation service REGEX(.PM2.5"\ for pattern (.),.) not found!
Config:
the sensor is connected via serial into a sonoff with Tasmota.
MQTT.fx is reporting the following:
tele/AirQual/SENSOR
{“Time”:“2019-05-15T18:37:21”,“SDS0X1”:{“PM2.5”:2.3,“PM10”:6.3}}
The Thing is set up as generic MQTT and the channel is set up as TEXT (and I’ve tried Number) and as follows:
The “standard” format for transformations everywhere else is <transform name>(<argument>) where <transform name> is the name of the transfomation add-on (e.g. REGEX, JSONPATH, MAP) and <argument> is the argument (e.g. mymap.map, $.SDS0X1.PM10, .PM2.5":(.),.*, etc).
For the MQTT2 binding, the developer decided to do his own thing and use a colon instead of the ().
PM10 I can tranform by JSONPATH:$.SDS0X1.PM10
And it works.
PM2.5 don’t work in this way.
I found this topic and I try to do it like you wrote.
Regex transformation is installed.
Item type connected for PM2.5 channel is Regex type.
I try put in channel REGEX:.*PM2\.5\"\:(.*),.*
and I have in logs
2019-11-01 20:40:53.272 [WARN ] [eneric.internal.generic.ChannelState] - Incoming payload '20.8,"PM10":35.1},"PressureUnit":"hPa"' not supported by type 'NumberValue'
(where 20.8 is my PM2.5 value).
When I try put REGEX:.*PM2\.5\".(.*),.* I have in logs
2019-11-01 20:43:06.814 [WARN ] [eneric.internal.generic.ChannelState] - Incoming payload '18.7,"PM10":28.3},"PressureUnit":"hPa"' not supported by type 'NumberValue'
(log is the same like before - 18.7 is my PM2.5 value).
What I am doing wrong? I am new in OH.
My MQTT Bindind is 2.4.0.
Can you help me with this?
I fixed fences in previous post.
I try use for PM2.5 this JSONPATH:$.SDS0X1.PM2.5
But I received in logs
2019-11-01 21:58:15.912 [WARN ] [eneric.internal.generic.ChannelState] - Incoming payload '{"Time":"2019-11-01T21:58:16","Switch1":"OFF","BME280":{"Temperature":3.5,"Humidity":82.1,"Pressure":982.7},"SDS0X1":{"PM2.5":22.1,"PM10":39.4},"PressureUnit":"hPa","TempUnit":"C"}' not supported by type 'NumberValue'
What is the type of your Item? Are you using a Unit of Measure such as Number:Pressure? MQTT doesn’t currently support units of measurement. Just use Number.
I try to use JSONPATH:$.SDS0X1.PM2\.5 but still I have in logs
2019-11-01 22:35:06.096 [WARN ] [eneric.internal.generic.ChannelState] - Incoming payload '{"Time":"2019-11-01T22:35:06","Switch1":"OFF","BME280":{"Temperature":3.4,"Humidity":82.4,"Pressure":982.2},"SDS0X1":{"PM2.5":20.4,"PM10":30.5},"PressureUnit":"hPa","TempUnit":"C"}' not supported by type 'NumberValue'
Type of item for PM10 and PM2.5 is Number. I don’t use in those items any Units. When I have Item with pressure I use type Number Pressure and it works normally.
I left Domoticz and started with OH. It’s nice but on first look it’s hard to understand.
OK, this might be running into a bug in the 2.4 binding. It is recommended to run a later version of the binding anyway so at this point my only suggestion is to upgrade to OH 2.5 M4.
I updated OH to 2.5.0 M4-1.
After this I needed to delete channels and add it again.
When I put JSONPATH:$.SDS0X1.PM2\.5 into transformation field I have in logs:
2019-11-02 23:56:20.971 [WARN ] [t.generic.ChannelStateTransformation] - Executing the JSONPATH-transformation failed: Invalid path '$.SDS0X1.PM2.5' in '{"Time":"2019-11-02T23:56:19","Switch1":"OFF","BME280":{"Temperature":7.7,"Humidity":90.9,"Pressure":971.8},"SDS0X1":{"PM2.5":19.8,"PM10":30.4},"PressureUnit":"hPa","TempUnit":"C"}'
Because of the . in the 2.5. . has a special meaning in JSONPATH. without figuring out how to escape it the JOSNPATH is asking for the 5 element under the PM2 element under the SDS0X1 element. What we want is the PM2.5 element under the SDS0X1 element. So all the stuff we’ve asked you to do is to figure out how to make the JOSNPATH treat the last . as part of the element name, not as part of the path.
It is possible the JSONPATH library used by OH supports bracket notation. Try
Selects the property property in the object object.
Note: Use the latter notation if the name of the property includes special characters (for example, spaces), or begins with a character other than A..Za..z_ .
