Changing JSON Payload

Ignition Modules
1

I have a MQTT device that is publishing a a few topics, each with a changing JSON payload that really should represent different devices and values. The MQTT engine is not parsing this, but rather is showing a single item, as does MQTT Explorer.

Below are a couple of sample payloads. Is there a way to get a better “tree” from this?

{"payload":"{\"transferPoint\":\"E010\",\"definition\":{\"machineNumber\":\"GSAT\",\"machineDescription\":\"Air Dryer (MEX)\",\"orderNumber\":\"39297500\",\"typeNumber\":\"No value available for the provided type (internal type number from plc is 0)!\",\"typeIndexNumber\":\"No value available for the provided type (internal type number from plc is 0)!\",\"typeDescription\":\"No value available for the provided type!\",\"kindOfProductData\":{\"id\":0},\"revisionState\":\"No value available for the provided type/variant (variant number from plc is 0)!\",\"shift\":\"24.10.2025 06:00:00\",\"shiftOperators\":[],\"additionalData\":{\"K9002\":\"PartIndependentData\"},\"measuredValuesDefinition\":{\"measuredValueDefinitions\":[{\"characteristicNumber\":\"1\",\"characteristicDescription\":\"MS ElectricEnergy\",\"characteristicType\":0,\"decimalPlaces\":1,\"unitDescription\":\"kWh\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"2\",\"characteristicDescription\":\"MS Current_L1\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"3\",\"characteristicDescription\":\"MS Current_L2\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"4\",\"characteristicDescription\":\"MS Current_L3\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"5\",\"characteristicDescription\":\"UPS ElectricEnergy\",\"characteristicType\":0,\"decimalPlaces\":1,\"unitDescription\":\"kWh\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"6\",\"characteristicDescription\":\"UPS Current_L1\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"7\",\"characteristicDescription\":\"UPS Current_L2\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"8\",\"characteristicDescription\":\"UPS Current_L3\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"9\",\"characteristicDescription\":\"AirConsumption\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"Nm3/h\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}}]}},\"values\":{\"timestamp\":\"2025-10-24T13:11:36.665Z\",\"partNumber\":\"NOT-DEFINED\",\"measurementId\":0,\"sampleStart\":false,\"additionalData\":{},\"measuredValuesList\":[{\"orginalValue\":2.4375362,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":2.4375362},\"attribute\":0},{\"orginalValue\":5.3771744,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":5.3771744},\"attribute\":0},{\"orginalValue\":3.480147,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":3.480147},\"attribute\":0},{\"orginalValue\":3.3272114,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":3.3272114},\"attribute\":0},{\"orginalValue\":-0.16874453,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":-0.16874453},\"attribute\":0},{\"orginalValue\":3.6688256,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":3.6688256},\"attribute\":0},{\"orginalValue\":0.0,\"originalAttribute\":255,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":0},\"attribute\":255},{\"orginalValue\":0.0,\"originalAttribute\":255,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":0},\"attribute\":255},{\"orginalValue\":0.0,\"originalAttribute\":255,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":0},\"attribute\":255}]},\"mscId\":10002023050909250100000000000000000933,\"uniqueMachineName\":\"GSAT\",\"creationDate\":\"2025-10-24T13:11:36.670Z\"}","serializeClassName":"ams.zpointcs.server.bc.mdebde.event.remote.ProductDataProcessedDtoEventV2","messageVersion":-1,"protocolVersion":1,"subject":"GSAT.MODULE_10","correlationTimestamp":0,"created":"2025-10-24T13:11:36.671Z"}

{"payload":"{\"transferPoint\":\"E010\",\"definition\":{\"machineNumber\":\"GSAT\",\"machineDescription\":\"Air Dryer (MEX)\",\"orderNumber\":\"39297500\",\"typeNumber\":\"No value available for the provided type (internal type number from plc is 0)!\",\"typeIndexNumber\":\"No value available for the provided type (internal type number from plc is 0)!\",\"typeDescription\":\"No value available for the provided type!\",\"kindOfProductData\":{\"id\":0},\"revisionState\":\"No value available for the provided type/variant (variant number from plc is 0)!\",\"shift\":\"24.10.2025 06:00:00\",\"shiftOperators\":[],\"additionalData\":{\"K9002\":\"PartIndependentData\"},\"measuredValuesDefinition\":{\"measuredValueDefinitions\":[{\"characteristicNumber\":\"1\",\"characteristicDescription\":\"MS ElectricEnergy\",\"characteristicType\":0,\"decimalPlaces\":1,\"unitDescription\":\"kWh\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"2\",\"characteristicDescription\":\"MS Current_L1\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"3\",\"characteristicDescription\":\"MS Current_L2\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"4\",\"characteristicDescription\":\"MS Current_L3\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"5\",\"characteristicDescription\":\"UPS ElectricEnergy\",\"characteristicType\":0,\"decimalPlaces\":1,\"unitDescription\":\"kWh\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"6\",\"characteristicDescription\":\"UPS Current_L1\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"7\",\"characteristicDescription\":\"UPS Current_L2\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"8\",\"characteristicDescription\":\"UPS Current_L3\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"A\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}},{\"characteristicNumber\":\"9\",\"characteristicDescription\":\"AirConsumption\",\"characteristicType\":0,\"decimalPlaces\":2,\"unitDescription\":\"Nm3/h\",\"additionalData\":{\"K9014\":\"GSBCEPM\",\"K9013\":\"Absolute\"},\"metaData\":{\"NameOfInterchangePoint\":\"E010\"}}]}},\"values\":{\"timestamp\":\"2025-10-24T13:13:24.978Z\",\"partNumber\":\"NOT-DEFINED\",\"measurementId\":0,\"sampleStart\":false,\"additionalData\":{},\"measuredValuesList\":[{\"orginalValue\":2.1098897,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":2.1098897},\"attribute\":0},{\"orginalValue\":4.160653,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":4.160653},\"attribute\":0},{\"orginalValue\":3.436386,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":3.436386},\"attribute\":0},{\"orginalValue\":3.1830044,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":3.1830044},\"attribute\":0},{\"orginalValue\":-0.16944693,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":-0.16944693},\"attribute\":0},{\"orginalValue\":3.6377754,\"originalAttribute\":0,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":3.6377754},\"attribute\":0},{\"orginalValue\":0.0,\"originalAttribute\":255,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":0},\"attribute\":255},{\"orginalValue\":0.0,\"originalAttribute\":255,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":0},\"attribute\":255},{\"orginalValue\":0.0,\"originalAttribute\":255,\"kNumberList\":{\"list\":[{\"definition\":{\"kNumber\":\"K9013\"},\"value\":{\"value\":\"Absolute\"},\"available\":true},{\"definition\":{\"kNumber\":\"K9014\"},\"value\":{\"value\":\"GSBCEPM\"},\"available\":true}]},\"additionalValues\":[],\"value\":{\"value\":0},\"attribute\":255}]},\"mscId\":10002023050909250100000000000000000933,\"uniqueMachineName\":\"GSAT\",\"creationDate\":\"2025-10-24T13:13:24.983Z\"}","serializeClassName":"ams.zpointcs.server.bc.mdebde.event.remote.ProductDataProcessedDtoEventV2","messageVersion":-1,"protocolVersion":1,"subject":"GSAT.MODULE_10","correlationTimestamp":0,"created":"2025-10-24T13:13:24.984Z"}

Thanks!

2

Based on the structure of this JSON, the payload value is a long string. This is why Engine is displaying it as a String. If that is supposed to be JSON, you should remove the backslashes escaping the double-quotes inside the payload value.

3

This should help as well: How do I managing MQTT messages with changing payload JSON structure at MQTT Engine - MQTT Modules for Ignition 8.1 - Confluence

4

thanks, appreciate the pointer.