@nicholas, could you please share with us the file?

Sorry, the Attachment button is not working for me (I think my employer blocks pop-ups?)

But I can attempt to paste the contents directly

Hi,

Edited to add: Unless the JSON contains Geometry in a recognised format such as GeoJSON or OGC-WKT then you will have to build the geometry using appropriate Transformers in FME. So, with this in mind...

If you want to read in the Custom Markers and Markers as individual feature types then you could set the parameters on the JSON (JavaScript Object Notation) as follows:

Based on the supplied JSON snippet this will add two feature types to your canvas:

Custom Markers containing 17 features and Markers containing 1721 features.

In order to create the geometries you will need a CoordinateSystemSetter to set the appropriate coordinate system (I assumed LL84 here). You could set the CoordinateSystem directly on the reader, but I prefer to do this on the canvas as it's then more visible to the user and not hidden in the Navigator panel.

To create the Custom Markers you then need to connect a VertexCreator to create the points.

To create the Markers line feature you will need to create point geometries first, again using a VertexCreator. This can then be followed by a Sorter to sort into Ascending Time order (Point with oldest date and time, will become start of the line). A LineBuilder can then be added to join all these points together and create a single line.

Hope this helps?

Simon

I have now figured out how to attach the JSON file

Bus 6.json

Hi,

Thanks for attaching the JSON file. Did you require any further help or clarification with the JSON reader?

Thanks,

Simon

My best practice with JSON is to read it as text file, validate and format it (JSONValidator/JSONFormatter) and then process it (JSONExtractor/JSONFragmenter).