Non-json mqtt values

[oernii]

Hi, I have some devices which return raw strings values, in mqtt sub it looks like this:

2020-10-14T13:36:31+0200 stat/nodemcu02_B3D47D/POWER OFF
2020-10-14T13:36:43+0200 stat/nodemcu02_B3D47D/POWER ON
2020-10-14T13:40:00+0200 stat/nodemcu02_B3D47D/POWER OFF
2020-10-14T13:40:02+0200 stat/nodemcu02_B3D47D/POWER ON
2020-10-14T13:42:51+0200 stat/nodemcu02_B3D47D/POWER OFF
2020-10-14T13:43:00+0200 stat/nodemcu02_B3D47D/POWER ON

mqtt2influxdb seems trying to parse that as JSON:

2020-10-14 13:40:13,994 DEBUG: mqtt_on_message stat/nodemcu02_B3D47D/POWER b'OFF'
2020-10-14 13:40:13,995 ERROR: parse json: Expecting value: line 1 column 1 (char 0) topic: stat/nodemcu02_B3D47D/POWER payload: b'OFF'
2020-10-14 13:40:16,638 DEBUG: mqtt_on_message stat/nodemcu02_B3D47D/POWER b'ON'
2020-10-14 13:40:16,639 ERROR: parse json: Expecting value: line 1 column 1 (char 0) topic: stat/nodemcu02_B3D47D/POWER payload: b'ON'

mqtt:
  host: 192.168.1.1
  port: 1883

influxdb:
  host: 192.168.1.1
  port: 8086
  database: temp

points:
  - measurement: movement
    topic: stat/+/POWER
    fields:
      value: $.payload
    #  type: "string"
    tags:
      id: $.topic

[dgoadby]

I just discovered this too.

[kapitan-iglu]

Same problem here:

2023-01-23 22:55:27,346 DEBUG: mqtt_on_message zigbee2mqtt/trv-obyvacka/window_open_internal b'quarantine'
2023-01-23 22:55:27,346 ERROR: parse json: Expecting value: line 1 column 1 (char 0) topic: zigbee2mqtt/trv-obyvacka/window_open_internal payload: b'quarantine'

Config:

  - measurement: trv_states
    topic: zigbee2mqtt/+/window_open_internal
    fields:
      value: $.payload
# same error with this config too:
#    value:
#      value: $.payload
#      type: "string"
    tags:
      id: $.topic[1]
      type: $.topic[2]

mqtt2influxdb version: 1.5.2

Any suggestions or workaround?

Thank you!

[hubpav]

@oernii Okay, thanks for the suggestion!

Maybe this commit will make you happy:
e40670e

It is part of a bigger rewrite:
https://github.com/hardwario/mqtt2influxdb/commits/main/

Not yet on PyPI. But feedback is appreciated. Also, see README.md. Thanks. P.

[hubpav]

Now, the v2 is live on PyPI: https://pypi.org/project/mqtt2influxdb/

Feedback is welcome!