AnsweredAssumed Answered

Parse 2D Arrays in GeoEvent

Question asked by hhosseiniesri-ca-esridist Employee on Jul 25, 2019
Latest reply on Jul 28, 2019 by hhosseiniesri-ca-esridist

Hi everyone,

 

I'm trying to stream real-time data for flights using GeoEvent Server. The format of the response is JSON, so I used Poll an External Website for JSON input connector. However, I'm not able to parse the data properly. The format of the response is like below:

{
     "time": 1564084010,
     "states": [
          ["ac96b8", -90.3411, 39.6066, 10972.8],
          ["ae1fa3", -105.3463, 38.4699, 2026.92],
          [...]
     ]

The response comprises two attributes: time and states. States is a 2D array that has data for icao24, longitude and latitude.

I have already read the post JSON Data Structures - Working with Hierarchy and Multicardinality written
by RJ Sunderman but my problem is that the states array does not have the attribute names, but only attribute values. I was just wondering if there is a way to parse this data in GeoEvent (probably using index of values
instead of attribute name)? Thank you for your help.

Outcomes