Getting JSON Array Element in Azure Stream Analytics Using CROSS APPLY
Problem: How can I extract data from JSON array in the Azure Stream Analytics query? Answer: Let’s say we have a simple JSON input data like below. [ { ‘DeviceId’:’TXE012345′, ‘Time’:’2018-10-15T16:01:00.0000000Z’, ‘Temp’:70, ‘Humidity’:10, ‘AreaCount’:12, ‘ActType’:2, ‘ColInfo’:[ { ‘X’:2, ‘Y’:4, ‘Z’:6, ‘A’:8, ‘B’:10 } ], ‘sensor_01’:7, ‘sensor_02’:139, ‘sensor_03’:15, ‘sensor_04’:330 } ] And we want to have […]