topic Re: Having issue mapping "many" cardinality data structure to feature service in ArcGIS GeoEvent Server Questions

Having issue mapping "many" cardinality data structure to feature service

MichaelKarikari1 — Mon, 26 Apr 2021 17:36:43 GMT

Attempting to process the an incoming json post but ran into an issue with nested json array. Im unable to use field mapping to take the nest elements of observations to a flat geodefinition used for a feature service output.

Issue is only with JSON array section, as the nest json for survey result are able to different feature service with flat geodefinition.

Any insight on what I may have wrong or limitations I may be hitting?

MichaelKarikari1_0-1619458587623.png

Re: Having issue mapping "many" cardinality data structure to feature service

EricIronside — Fri, 30 Apr 2021 19:58:51 GMT

Hey @MichaelKarikari1

First off there appears to be an error in the JSON array you posted (extra comma at the end of the array data just before the closing ']', but I'll assume that is just an editing error when you created the sample.

Pulling in a JSON sample similar to yours, I was able to use a field mapper to map the two grouped array values out to a flat schema (see FieldMapper settings below). But this assumes your array will always be the same size.

EricIronside_0-1619812537566.png

If your array is always going to be different sizes or if you would like to convert each array item into a separate event, you will want to use the Multicardinal Field Splitter Processor. This processor element will create a new GeoEvent for each array member, flattening the schema in the process.

Re: Having issue mapping "many" cardinality data structure to feature service

MichaelKarikari1 — Sun, 02 May 2021 02:58:46 GMT

Yup you are correct, the "," is due to the fact that json is only an excerpt of a larger post. And appreciate you pointing me to this processor. This is exactly what I needed!