Map Array in Stream Analytics

Question

Is it possible to map an array contained in a message via the geospatial functions?

{
"id": "<msgid>",
"location": {50.2, 30.3},
"geofences": [{"name": xxx, "polygon": <polygon1>},{"name": "yyy", "polygon": <polygon2>}]
}

I.e. to get all names the location is inside? But not as separate messages but in this one.

Answer 1

Hello @IngoBusse-2268 ,

Thanks for the question . Just wanted to check if you have tried the option of something like .

SELECT location,
GetArrayElement(geofences, 0) AS fence1,
GetArrayElement(geofences, 1) AS fence2,
GetArrayElement(geofences, 2) AS fence3
FROM ...

Use GetarrayElement https://learn.microsoft.com/en-us/stream-analytics-query/getarrayelement-azure-stream-analytics.

Thanks Himanshu

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members