Best way to transform MQTT payload for FROST import

[joachimmueller]

I try to import a MQTT stream from another NON FROST MQTT source. The payload looks like

{
  "uuid": "16508b11-4349-48f7-be51-1227b7888585",
  "number": "3770040",
  "shortname": "RHEDE",
  "state": "Deutschland",
  "region": "Niedersachsen",
  "agency": "Standort Meppen",
  "water": {
    "shortname": "DEK" 
  },
  "timeseries": {
    "uuid": "076ce109-94d6-4755-8062-8d79b1cdd4ce",
    "shortname": "W",
    "longname": "Wasserstand",
    "unit": "cm",
    "equidistance": 1.0,
    "measurement": {
      "timestamp": "2024-08-29T09:11:00+02:00",
      "value": 669.0
    }
  }
}

How can I transform the payload into a form, FROST understands?

[hylkevds]

Usually one would use a little script that listens on one side, and transforms the data to push it on the other side.
It would need a function to search the correct Datastream to push to, and maybe to create that Datastream if it doesn't exist. It doesn't look like this payload has enough information to also create Things/Sensors, so those would have to be generated beforehand.

Storing those uuids in the properties would allow for an efficient search for the correct Thing/Datastream.