Skip to main content
Question

MQTT Hosted Extractor Keeps Failing on Transformation

  • December 12, 2025
  • 1 reply
  • 28 views

Forum|alt.badge.img+3

We’ve setup an MQTT Hosted Extractor that is recieving a SparkPlug B payload which some times contains a couple of null values, this values cannot be removed from the SparkPlug B payload. We believe that whenever the message contains null values the transformation for the datapoints fails.

No more information is provided on the Transform Error, only the “Failed to transform data: Missing required field value”, could the null values just be ignored so the other values be inserted in the time series? We’re getting several empty time series that were created via the hosted extractor.

1 reply

  • Practitioner
  • December 15, 2025

The “value” field which is meant the contain the datapoint value is missing/empty. You can filter out null values, refer to the second example here if you are creating them from a list(1 transform to many datapoints). If you are creating 1 datapoint per transform, you can type check using the “is” operator.