geasand

Using JSON input - is there a way to use all elements from parent and child objects?

Discussion created by geasand on Nov 13, 2013
Latest reply on Nov 14, 2013 by rsunderman-esristaff
I am using an input connector that is polling a REST endpoint which is delivering JSON. The results are this:

{"driverID":83910282,
"vehicleID":83887977,
"time":1384359889000,
"loc":{
   "lat":18.949661,
    "lng":-70.169067,
    "head":null,
    "time":null,
    "speed":null,
    "latitude":18.949661,
    "longitude":-70.169067,
    "heading":null},
"speed":0,
"head":5,
"odometer":null}


I need the attributes from all the fields, those in the parent and the sub object "loc".

A GeoEvent Definition was automatically created. In that the field "loc' is defined as a group and includes the four fields that are not null in the JSON object "loc".  However, when I direct the output to a CSV file the "loc" field is empty.  Also, you can't edit the group field but you can edit the items in the group but you can't add fields to the group.

In the Input configuration, if I fill in the field "JSON Object Name" with the value 'loc', then I get ONLY the four non-null values in the JSON "loc" object.  I want to get all of the fields.  How do I accomplish that?
Dennis Geasan
GIS Technologies

Outcomes