Failure to parse incoming JSON

[kavi88]

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 solution]

Hi @kavi88,

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

Here's what worked for me:

1. Flattened the output GeoEvent Definition using the following script
2. Created a Field Mapper as below:

[JeffSilberberg · Accepted solution]

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.. 

---

[kavi88]

hello JeffSilberberg , JakeSkinner,

Thank you so much for your fast reply. it's now working as i want it !