Read Summary of Mqtt Topics

[Starfoxfs]

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/

??

[cymplecy]

Do you know about using the # wildcard?

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

[Starfoxfs]

Ah thanks, Big Big thanks

[Starfoxfs]

Ok, another problem

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, ... }

[cymplecy]

Try using a join node set to manual

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