Read, Parse & Generate JSON
Whether you’re reading a JSON feed from a web service or need to keep a NoSQL database updated with constantly changing data, deploying FME technology via its FME Server or FME Cloud product options allows you to automate JSON conversion and migration workflows with capabilities like scheduling and real-time data processing. Use FME to read and parse JSON and convert it to any of the 400+ additional formats it supports including CSV, XML, Excel, SQL Server, and many others. FME has tools for manipulating the contents and structure of a JSON document to fit any schema.
Getting Started with JSON
Advanced JSON Manipulation and Validation
FME is your all-in-one JSON solution with a library of custom tools designed specifically to handle the format. Use it to parse, edit, generate and validate data, to efficiently move it in and out of the JSON schema to suit your exact needs.
FME lets you:
- extract and transform subsets of JSON documents
- update and change values in a document
- validate syntax
- and many other complex manipulations
Watch how FME can be used to interpret JSON returned from the Tesla Vehicle web service and send notifications when the battery needs to be charged
A simple JSON transformation workflow in FME Workbench
Streamline Web Service Workflows
Configure JSON workflows in FME Desktop's intuitive graphical interface, without coding. Workspaces can be reused and are easily adjusted to suit changes in transformation requirements. What once took hours or even days, can now be accomplished in minutes.
The table below outlines how JSON is supported by our different FME products, and on which platform(s) the reader and/or writer runs.
|FME Desktop||FME Server||FME Cloud||Windows 32-bit||Windows 64-bit||Linux||Mac|
|Reader||Professional Edition & Up|
|Writer||Professional Edition & Up|