I suspect this may be an issue with the JSONPATH transformation, it should work.
MQTT binding reports:
Incoming payload 'NULL' not supported by type 'NumberValue'
But I can confirm the configuration saved correctly via the REST api:
"transformationPattern": "JSONPATH:$.[?(@.Id==\"3C01B6078704\")].Temperature"
And I have successfully tested the expression at www.jsonpath.com with and without the escapes.
However, this appears to work via rules?