Failure to parse incoming JSON

Question

Hello everyone,

I am trying to parse a json event in geoevent 10.7.1 using a field mapper, in order to flatten the structure and be able to access the indexed objects, yet i keep failling.

Here's how my field mpper looks like :

So, instead of getting the simple structure as defined in my target geoevent definition, i keep getting the initial structure.

Any ideas please ?

@RJSunderman EricIronside,

DanielCota1 ‎

JakeSkinner · Accepted Answer

Hi @kavi88,

I believe the issue is how you're specifying the array.  Try data.slots[0].id.

Here's what worked for me:

* Flattened the output GeoEvent Definition using the following script
* Created a Field Mapper as below:

JeffSilberberg · Accepted Answer

Take your source data and run it through https://jsonlint.com/.  You will see that you have an array inside the data object but the data object is not an array.

So data.slots[0].id looks like it might make more sense...  But I also have issues when working with arrays inside GeoEvent so let us know..