Template sensor from json via mqtt?

Configuration
1

I’ve got some weather data coming in via mqtt (via rtl_433’s mqtt output format) it’s listed below. How can I do the sensor yaml section to pull the temp and battery life onto a sensor? The topic for mqtt isn’t different per sensor ID, but the ID is in the Json.

Any ideas? I think I need an IF statement in to check the Id piece first and if it’s the one for the sensor entry, then report the temp, (and the battery as an attribute?) then repeat for the next sensor with changing the ID if check. ?

Greenbrier433/projpi {“time”:“2019-05-25 19:22:32”,“model”:“LaCrosse-TX141Bv2”,“id”:190,“temperature_C”:0.9,“battery_ok”:1,“test”:“No”}
Greenbrier433/projpi {“time”:“2019-05-25 19:22:33”,“model”:“LaCrosse-TX141Bv2”,“id”:111,“temperature_C”:-16.3,“battery_ok”:1,“test”:“No”}

2

Take a look here

1 Like
3

Those are the Oregon sensors.
I split mine into different files (inside sensors directory):
OregonRain.yaml

- platform: mqtt
  state_topic: 'home/rtl_433'
  name: 'Rain Total'
  unit_of_measurement: 'in'
  value_template: >
    {% if value_json is defined and value_json.id == 151 %}
      {{ value_json.rain_total }} 
    {% else %}       
      {{ states('sensor.rain_total') }}
    {% endif %}
    
- platform: mqtt
  state_topic: 'home/rtl_433'
  name: 'Rain Rate'
  unit_of_measurement: 'in/hr'
  value_template: >
    {% if value_json is defined and value_json.id == 151 %}
      {{ value_json.rain_rate }} 
    {% else %}       
      {{ states('sensor.rain_rate') }}
    {% endif %}

OregonTemp.yaml

- platform: mqtt
  state_topic: "home/rtl_433"
  name: "Outdoor Humidity"
  unit_of_measurement: '%'
  value_template: >
    {% if value_json is defined and value_json.id == 55 %}
      {{ value_json.humidity }}
    {% else %}
      {{ states('sensor.outdoor_humidity') }}
    {% endif %}
    
- platform: mqtt
  state_topic: "home/rtl_433"
  name: "Outdoor Temperature"
  unit_of_measurement: '°C'
  value_template: >
    {% if value_json is defined and value_json.id == 55 %}
      {{ value_json.temperature_C }}
    {% else %}
      {{ states('sensor.outdoor_temperature') }}
    {% endif %}

OregonWind.yaml

- platform: mqtt
#wind gust
  state_topic: "home/rtl_433"
  name: "Wind Gust"
  unit_of_measurement: 'm/s'
  value_template: >
    {% if value_json is defined and value_json.id == 187 %}
      {{ value_json.gust }}
    {% else %}
      {{ states('sensor.wind_gust') }}
    {% endif %}    
    
- platform: mqtt
  state_topic: 'home/rtl_433'
  name: 'Wind Direction'
  unit_of_measurement: ''
  value_template: >-
    {% if value_json is defined and value_json.id == 187 %}
      {% set wd = value_json.direction | int %}
      {% if wd <= 11 or wd > 348 %}North
      {% elif wd >11 and wd <=34 %}North North East
      {% elif wd >34 and wd <=56 %}North East
      {% elif wd >56 and wd <=79 %}East North East
      {% elif wd >79 and wd <=101 %}East
      {% elif wd >101 and wd <=124 %}East South East
      {% elif wd >124 and wd <=146 %}South East
      {% elif wd >146 and wd <=169 %}South South East
      {% elif wd >169 and wd <=191 %}South
      {% elif wd >191 and wd <=214 %}South South West
      {% elif wd >214 and wd <=236 %}South West
      {% elif wd >236 and wd <=259 %}West South West
      {% elif wd >259 and wd <=281 %}West
      {% elif wd >281 and wd <=304 %}West North West
      {% elif wd >304 and wd <=326 %}West North West
      {% elif wd >326 and wd <=348 %}North North West
      {% endif %}
    {% else %}       
      {{ states('sensor.wind_direction') }}
    {% endif %}