Json parsing using stream analytics

Question

Hi Team,

I am using stream analytics to parse json object and I need to remove some of the columns and rename remaining columns from json object.
Please find below input data and output data needed.

Input Data:
[
{
"timestamp": 1672920559822,
"values": [
{
"id": "CHANNEL1.DEVICE1.TAG1",
"v": 7157,
"q": true,
"t": 1672920550218
},
{
"id": "CHANNEL2.DEVICE2.TAG2",
"v": 7158,
"q": true,
"t": 1672920550218
}
]
}
]

Output Data :

I am able to get sensor id and timestamp with the query but unable to create telemetry column with required information.
Could you please help me with the query how to fetch the details from input stream Values and convert it to required output.

Would be highly appriciated.

Answer 1

This can be achieved with a UDF:
https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-javascript-user-defined-functions

To see a simple example look at this top ic of stackoverflow:
https://stackoverflow.com/questions/60004588/azure-stream-analytics-custom-json-output