topic Re: Create a feature from JSON feed with array of attributes in ArcGIS GeoEvent Server Questions

Create a feature from JSON feed with array of attributes

RomanChueh — Tue, 31 Jan 2017 00:44:51 GMT

Is it possible to add/update feature class from a JSON feed below:

{
   "cars": [{
      "manufacturer": "Honda",
      "attribute": [{
            "Label": "Name",
            "value": "Accord"
         }, {
            "Label": "Year",

            "value": 2007
         }, {
            "Label": "Weight",
            "value": 3000
         }]
      }, {

         "manufacturer": "Toyota",
         "attribute": [{
            "Label": "Name",
            "value": "Camery"
          }, {
            "Label": "Year",
            "value": 2010
         }, {
            "Label": "Passengers",
            "value": 5
         }]
    }]
}

A GeoEvent definition was created after I created an Input connector consuming the JSON.

How do I map this GeoEvent so that I can update to a Feature Class through a feature service with fields: Manufacturers, Name, Year, Weight, Passengers?

Thanks

Re: Create a feature from JSON feed with array of attributes

Jean-PierreDEBOOS1 — Wed, 25 Apr 2018 14:13:58 GMT

Hi,

did you find a solution ? i have the same question with my json (https://community.esri.com/thread/213590-parsing-json-for-iot-experimentation)

Re: Create a feature from JSON feed with array of attributes

RomanChueh — Thu, 26 Apr 2018 00:10:25 GMT

No. I didn't find a solution for the problem.

Re: Create a feature from JSON feed with array of attributes

AnninaHirschi_Wyss1 — Thu, 26 Apr 2018 06:36:48 GMT

Did you try to create a "flat" GeoEventDefinition with the attributes that match your Feature Service and then create a field mapper in the service definition? In the input connector you leave what is automatically generated.

It doesn't look like that your json has a geometry, true? If yes, you need to create one as well in your custom definition (with the type geometry and the tag GEOMETRY).

In my case, there is no geometry, so I created the service with the points in Desktop and added the table and the relationship class (1:M) in the GDB before publishing the service. The GeoEvent Service writes the results into that related table.

Would this be suitable use case for you as well?

Re: Create a feature from JSON feed with array of attributes

Jean-PierreDEBOOS1 — Thu, 03 May 2018 17:25:09 GMT

We found a solution. I have no time to explain now but i will try tomorow.

Re: Create a feature from JSON feed with array of attributes

Jean-PierreDEBOOS1 — Mon, 03 Sep 2018 09:10:59 GMT

we find a solution, we explain it there : https://community.esri.com/message/766916-parsing-json-for-iot-experimentation