Hello World, i'm trying to parse some data in Stream Analytics but i don't seem to be successfull.
This is what i send into my IoT Hub:
look below
I want to access the Channel1_Temp and MyVariable2.
In my Query Sample the Data Locks like:
Can someone please help me to write the Query ?
Would be highly appreciated!
Thank you!
Julian
*Edit: I dont know why the formatting got all messed up. Sorry for that.
{ "body": { "MessageType": "TagValues", "WagoProtocol": "1.5.0", "CollectionId": 0, "TagData": [ { "Time": "2021-03-13T09:45:56.419+01:00", "Values": { "Channel1_Temp": 20.44740104675293, "MyVariable2": 22478 } }, { "Time": "2021-03-13T09:45:58.468+01:00", "Values": { "Channel1_Temp": 20.44740104675293, "MyVariable2": 22560 } }, { "Time": "2021-03-13T09:46:00.469+01:00", "Values": { "Channel1_Temp": 20.44740104675293, "MyVariable2": 22640 } } ] }, "enqueuedTime": "Sat Mar 13 2021 09:46:22 GMT+0100 (Mitteleuropäische Normalzeit)", "properties": { "MessageType": "TagValues", "ProtocolVersion": "1.5.0" } }
