Integrate JSON Using FME

Use FME's data conversion technology to read and write JSON and move data between it and hundreds of other formats, without writing any code.

Start Free Trial

Read, Parse & Generate JSON

FME is data conversion and integration technology that lets you connect with web-based applications and their data through its advanced support for the JSON format. Use FME to read and parse JSON and convert it to any of the 345+ 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. For instance, prior to converting it to your preferred format, you can split a JSON document into its components, extract subsets of data, and edit values, all without writing any code.

FME also lets you load data from practically any source into cloud-based applications that use JSON to store data, including NoSQL databases. Beyond writing data into proper JSON syntax, FME’s tools let you structure the documents to work with the environment of the target system.

FME Knowledge Article: Getting Started with 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.

 



About JSON

JavaScript Object Notation, or JSON, is an open standard data interchange format that is most commonly used to transmit data between servers and web applications as an alternative to XML.

Common Conversions

FME lets you integrate many applications and file formats. Here are some of the ways our users convert JSON.


Autodesk AutoCAD (DWG)
Microsoft Excel
FME is the data integration platform with the best support for spatial.

Compatibility

The table below outlines how JSON is supported by our different FME products, and on which platform(s) the reader and/or writer runs.

Product OS
FME Desktop FME Server FME Cloud Windows 32-bit Windows 64-bit Linux Mac
Reader Professional Edition & Up
Writer Professional Edition & Up

Try FME Desktop

No credit card necessary. Start integrating data today!
Start Your Free Trial
Learn More