Read Summary of Mqtt Topics

General
1

Hi,

is there a way to read the summary of all MQTT Topics in e.g. /AhoyDTU/HM1500/ ....

My Problem is from Shelly EM i get a complete Parsed JSON Objekt with all Data in it from SHELLY/SENSOR/.

Like this:

{
  "Time": "2023-10-25T12:30:32",
  "ENERGY": {
    "TotalStartTime": "2023-01-28T00:00:00",
    "Total": 411.604,
    "Yesterday": 0.103,
    "Today": 0.481,
    "TodaySumImport": 0.481,
    "TodaySumExport": 0,
    "ExportActive": [
      0,
      0
    ],
    "Period": [
      1,
      0
    ],
    "Power": [
      39,
      0
    ],
    "ApparentPower": [
      64,
      0
    ],
    "ReactivePower": [
      17,
      0
    ],
    "Factor": [
      0.6,
      0
    ],
    "Frequency": 50,
    "Voltage": 238,
    "Current": [
      0.24,
      0
    ]
  }
}

From my Hoymiles Inverter i have to configure every single Topic out, because the Ahoy-DTU unit i use has no Summary only Topics for each Data

e.g.

/AHOY/HOYMILES/ch0/YieldDay=500
and so on ...

How can I read with NodeRed all Data in e.g. /AHOY/HOYMILES/

??

2

Do you know about using the # wildcard?

e.g if you subscribe to AHOY/HOYMILES/#
you should get all messages

3

Ah thanks, Big Big thanks :smiley:

1 Like
4

Ok, another problem :smiley:

Now I receive the various data as a number in around 12 data sets.

How can I now assign the topic to each individual data record and combine everything into a Json object at the end?

E.g.

{ YieldTotal: 500, YieldToday: 120, V_AC: 220, ... }

5

Try using a join node set to manual
image

This assumes all 12 data sets come in bursts - adjust the 10secs time to suit

1 Like
6

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.