I am having a very annoying problem, which i cannot see to find out why it occurs. I use Particle Photon to publish data to Azure IoT Hub. I then use Stream Analytics to get the inputStream and output it to a database. I use the database to expose data to my webapi so i can create a nice webview with angularJS.
Its working for some messages, but after 8 messages i get this message:
Encountered error trying to write 1 event(s): Cannot convert from property ‘temperature’ of type ‘System.String’ to column ‘temperature’ of type ‘System.Double’
My question is… why is the first messeges going through and suddenly after a while my temperature gets converted to a string?
Here are the latest 10 readings: http://sensorapi2030394.azurewebsites.net/api/sensor (this is outputed from stream analytics to DB)