Create Sensor from MQTT JSON from power meter ADW300

Configuration
,
1

Hello,
I’m not familar to deal withe JSON beacuse I’m new in Home Assitant.
I want to create seperate sensors in Home Assistant for my power meter witch communicate by MQTT.

By the MQTT Explorer I get the follwing Data from the power meter:

{“data”:[{“tp”:1748120962627,“point”:[{“id”:0,“val”:“24032006080001”},{“id”:1,“val”:234.8},{“id”:2,“val”:234},{“id”:3,“val”:235.5},{“id”:4,“val”:405.9},{“id”:5,“val”:406.5},{“id”:6,“val”:407.2},{“id”:7,“val”:1.08},{“id”:8,“val”:1.39},{“id”:9,“val”:1.91},{“id”:10,“val”:-0.108},{“id”:11,“val”:-0.041},{“id”:12,“val”:-0.09},{“id”:13,“val”:-0.24},{“id”:14,“val”:-0.203},{“id”:15,“val”:-0.305},{“id”:16,“val”:-0.426},{“id”:17,“val”:-0.934},{“id”:18,“val”:0.23},{“id”:19,“val”:0.307},{“id”:20,“val”:0.435},{“id”:21,“val”:0.964},{“id”:22,“val”:0.471},{“id”:23,“val”:0.135},{“id”:24,“val”:0.206},{“id”:25,“val”:0.248},{“id”:26,“val”:50},{“id”:27,“val”:38},{“id”:28,“val”:168.55},{“id”:29,“val”:416.29},{“id”:30,“val”:0.73},{“id”:31,“val”:189.01},{“id”:32,“val”:0},{“id”:33,“val”:“d8:bc:38:7f:d1:2c”},{“id”:34,“val”:1},{“id”:35,“val”:1}]}]}

For example:
{“id”:13,“val”:-0.24} is the total active power in kW
{“id”:28,“val”:168.55} is the forward active enrgy consumption in kWh
{“id”:29,“val”:416.29} is the reversing active enrgy consumption in kWh

Inspired by the forum I tried sevral mqtt sensor configurations in the /homeassistant/configuration.yaml but get no values.
I would be great if somone could give me one example for the sensor configuration.
Thanks

2

Start by adding what you tried and show the path in MQTT Explorer, e.g. screenshot.

3

Screenshot 2025-05-25 125825
Screenshot 2025-05-25 1258253532×1672 217 KB

Example configuration.yaml entry

mqtt:
sensor:

  • name: “Gesamtleistung”
    state_topic: “Sensor/ADW300/Gesamtleistung1”
    unit_of_measurement: ‘kW’
    value_template: “{{ value_json[‘data’].[‘point’].[‘id’].[‘13’].[‘val’] }}”

My Problem is the value Template, i do not now the right syntax.

4

When you paste json etc. please format it correctly as this is unusable due to incorrect hyphenation.

image
image641×103 2.73 KB

there are lists in the json so you have to direct it to the correct element in the list. If your target-data is stable in the same element then you can use this, else it wil lbe more complex and you would need to load on a higher level and add a separate template sensor with more logic
try this in devtools > template

{% set vj = {
  "data": [
    {
      "tp": 1748120962627,
      "point": [
        {
          "id": 0,
          "val": "24032006080001"
        },
        {
          "id": 1,
          "val": 234.8
        },
        {
          "id": 2,
          "val": 234
        }
      ]
    }
  ]
} %}
{{ vj.data.0.point.0.val }}