Mqtt definition

Configuration
1

hello.
is there anyone that can help me to get the data right.
i have mqtt sensors that give me [{“temp”:124}] can someone help HOW to get just 12,4 out of this string ?

2

Post the MQTT Sensor’s configuration.

3

here is the sensor config

  • name: “Panntemp”
    state_topic: “panntemp”
    payload_available: “temp”
    unique_id: “plc.dl240.in.panna_inne”
    unit_of_measurement: ‘°C’
    qos: 0
4

Go to Developer Tools > States, find sensor.panntemp and tell me its current state value.

5

sensor.panntemp

Panntemp [{“temp”:426},{“temp”:424},{“temp”:426}] unit_of_measurement: °C friendly_name: Panntemp

6

:thinking:

...
    unique_id: "plc.dl240.in.panna_inne"
    value_template: "{{ value | from_json[0].temp }}"
    unit_of_measurement: "°C"
    qos: 0

or

...
    unique_id: "plc.dl240.in.panna_inne"
    value_template: "!regex_replace '\"temp\":(\d+)', '\\1' {{ value }}"
    unit_of_measurement: "°C"
    qos: 0
7

the first example result in : Invalid config for [mqtt]: invalid template (TemplateSyntaxError: expected token ‘end of print statement’, got ‘[’) for dictionary value @ data[‘mqtt’][‘sensor’][1][‘value_template’]. Got ‘{{ value | from_json[0].temp }}’. (See /config/configuration.yaml, line 12).

8

the second example result in : Error loading /config/configuration.yaml: while scanning a double-quoted scalar
in “/config/mqtt.yaml”, line 64, column 24
found unknown escape character ‘d’
in “/config/mqtt.yaml”, line 64, column 52

9

Add this line to the sensor’s configuration.

    value_template: '{{ (value | from_json)[0].temp }}'
1 Like
10

YES it works!!! many many thanks

1 Like
11

You’re welcome!

Please consider marking my post above with the Solution tag. It will automatically place a check-mark next to the topic’s title which signals to other users that this topic has been resolved. This helps users find answers to similar questions.

For more information about the Solution tag, refer to guideline 21 in the FAQ.

12

hi again 123. do you think you can help me with this also?
i also have some binary_sensors the same way.
data looks like this [{“data”:“true”}] i like to get the true or false value out.

binary_sensor:

 - name: "burner" 
   state_topic: "burner"
   unique_id: "plc.dl240.in.x32_brannare_till"
   value_template: "{{ value_json[0].burner[1].temperatur }}"      #dont work
   qos: 0

and current state of sensor.burner “unknown”

13

If the received value is this:

[{"data":"true"}]

then I suggest trying the following template:

value_template: '{{ (value | from_json)[0].data | bool }}'
14

that dont work.
received value is this:
[{“data”:true}]

and current state of sensor.burner “unknown”

15 
 - name: "burner" 
   state_topic: "burner"
   unique_id: "plc.dl240.in.x32_brannare_till"
   value_template: "{{ iif((value | from_json)[0].data | bool, 'ON', 'OFF') }}"
   qos: 0
16

YES again you did it it works many many thanks man!!!

1 Like