I have the below structure JSON data coming from event hub, and I am trying to process the same using Azure Stream Analytics.
I have tried some of the methods to extract the array elements from that JSON structure, but all the query method has been showing one or the other errors.

If I try flattening the “JSON” using CTE and some functions, the query throws errors like the functions are not supported.

Any suggestion available to retrieve the below “JSON” data using Azure stream analytics?

[
{
“User”:
[
{
“status”: “Active”,
“userId”: “11000”,
“username”: “[email protected]”,
“firstName”: “test01”,
“lastName”: “test02”,
“email”: “[email protected]”,
“Manager”: “Test04”,
“HumanResource”: “Test 03”
}
]
}
]

Regards,
Sandeep