Azure Stream Analytics query language get value by key from array of key value pairs -
i trying extract specific value array property in stream analytics query language. my data looks follows: "context": { "custom": { "dimensions": [{ "macaddress": "ma" }, { "ipaddress": "ipaddr" }] } } i trying obtain result has "macaddress", "ipaddress" column titles , "ma", "ipaddr" rows. i achieving this query: select getrecordpropertyvalue(getarrayelement(mysource.context.custom.dimensions, 0), 'macaddress') macaddress, getrecordpropertyvalue(getarrayelement(mysource.context.custom.dimensions, 1), 'ipaddress') ipaddress, i trying use cross apply far no luck. below cross apply query: select flat.arrayvalue.macaddress macaddress, flat.arrayvalue.ipaddress ipaddress [ffapi-track-events] mysource cross apply getarrayelements(mysource.context.custom.dimensions)