Mqtt json

Apps
, , ,
1

I have an advance flow that uses the MQTT client to receive cheap charging slots from Octopus Energy. The MQTT client is working well and receives data in JSON format example is:-

{ SlotStart: “2024-03-09 20:30:00+00:00”, SlotEnd: “2024-03-09 21:00:00+00:00”, InsertDate: “2024-03-09 21:05:26” }

I would like to do something meaningful with the data like insert into a calendar or scheduler. Can anyone please offer any advice on how I can format the JSON or point me in the right direction.

2

There are various Logic cards that can parse JSON and extract data from it:

image
image712×976 79.9 KB

The “Text” tag is the one provided by the MQTT client (I think it’s called “message”?), “Path” should be a JSONPath expression.