FME and JSON

FME has a number of transformers that can work with JSON data within FME including the following transformers.

FME also has support for GeoJSON, TopoJSON, CityJSON and ESRI JSON. These are profiles of JSON that extend the JSON specification for a specific requirement for example adding geometry support. These work in the same way as JSON but have additional rules around how objects like geometry or topology are encoded. These can be used with the relevant reader or in the transformers above.

JSONFlattener - Overview

Converts a JSON document into a feature adding all of the attributes to the feature.

When flattening an array FME will try and flatten the structure however if the nesting is complex or deep it can leave the resulting feature difficult to work with. It can thus be easier to use a combination of the JSONFragmenter and the JSONFlattener to turn a JSON document into features in a manageable fashion.

JSONFragmenter - Overview

If a JSON document contains an array of elements splits these into individual features.

JSONExtractor - Overview

Extract values from a JSON feature into specified attributes using JSON Query language.

JSONFormatter - Overview

Formats JSON to make it human readable or to linerize it for system to system use.

JSONTemplater - Overview

Allows the population of an existing JSON template with values from a feature.

JSONValidator - Overview

Validates that a JSON document is valid.

JSONUpdater - Overview

Allows an existing JSON document to be updated