![Page 1: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/1.jpg)
JSON, XML, and GML
Made Easy
1
![Page 3: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/3.jpg)
Agenda
● JSON, XML, & GML
overview
● Easy XML
– Tree navigation
● Automatic JSON– Auto schema scan
● Schemaless GML– Reading GML / WFS
without a schema
![Page 4: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/4.jpg)
Why JSON, XML, & GML?
• Commonly used in exchange formats,
open standards, web services
• Language of the web and REST APIs
• Supports loose integration across diverse
applications
• Critical for cross-platform and mobile
applications
![Page 5: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/5.jpg)
JSON, XML, and GML in FME
• Read and write 40+
XML, GML, and JSON
based formats.
• Extract, format,
template, map,
update, and many
other transformations.
![Page 6: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/6.jpg)
Working with JSON, XML, and GML
is easier than ever in FME 2016.
![Page 7: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/7.jpg)
Challenge:
Reading XML
Use XML, they said.
It will be fun, they said.
![Page 8: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/8.jpg)
New in FME 2016: Tree Navigation
![Page 9: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/9.jpg)
XML Reading
with Tree
Navigation
1. Add an XML Reader.
• Set Feature Paths
mode.
• Browse to source
XML data.
2. Select the node you
want to become a
feature type.
![Page 10: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/10.jpg)
XML Reading with Tree Navigation
![Page 11: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/11.jpg)
XML Reading with Tree Navigation
![Page 12: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/12.jpg)
XML Reading with Tree Navigation
![Page 13: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/13.jpg)
XML Reading with Tree Navigation
![Page 14: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/14.jpg)
Demo: Read XML and convert
to spatial geometries
![Page 15: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/15.jpg)
Challenge:
Reading JSON
JSON jargon
has you
jumbled?
![Page 16: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/16.jpg)
JSON Reading
with
Schema Scan
Automatically parse
common forms of JSON
into FME attributes.
![Page 17: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/17.jpg)
JSON Reading with Schema Scan
• No need to write JSON
Query
• Flattens JSON into features
• Geometry: GeoJSON or
OGCWKT formats
• JSON Query still available
when needed
![Page 18: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/18.jpg)
FME 2016 reads both objects and arrays
![Page 19: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/19.jpg)
Demo: Look how easy
it is to read JSON!
![Page 20: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/20.jpg)
GML / WFS Reading
Challenge:
GML is hard to read
without a schema.
Solution:
Ignore schema mode lets
you read almost any GML.
* Schema is still required to validate or write GML.
![Page 21: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/21.jpg)
GML / WFS Reading: Ignore Schema
FME 2016 smoothly skips parser errors
![Page 22: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/22.jpg)
FME can even read new GML formats like GeoSciML (data from British Geological Survey)
GML / WFS Reading: Ignore Schema
![Page 23: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/23.jpg)
Demo: Read WFS
with no schema
![Page 24: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/24.jpg)
• Easier to extract value from XML, GML, and JSON.
• Tree navigation makes it easier to pick XML elements
and build workflows.
• Auto Schema Scan Mode means you can read JSON
without configuring anything.
• You don’t need a schema to read GML / WFS data if
you use Ignore Schema mode.
![Page 25: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/25.jpg)
Resources• safe.com/webinar
• Ways to Make XML Easy
• Manipulating GML Files
• Common JSON Problems
• blog.safe.com
knowledge.safe.com
![Page 26: Excellence Center for FME - JSON, XML, and GML …...New in FME 2016: Tree Navigation XML Reading with Tree Navigation 1. Add an XML Reader. • Set Feature Paths mode. • Browse](https://reader034.vdocuments.us/reader034/viewer/2022042803/5f47229e8ff6b52a440cb5ca/html5/thumbnails/26.jpg)
Thank you!
Questions?