Integrate JSON Using FME

plus
Start a Free Trial

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

10 Common JSON Problems - SOLVED!

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

JSON Example viewed in the FME Workbench
A simple JSON transformation workflow in FME Workbench

Efficient Workflow Authoring

Configure JSON workflows in FME Form'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.

JSON Validator Tool Comparisons

Streamline Web Service Workflows

Configure JSON workflows in FME Form'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.

7 Reasons to Love XML and JSON

JSON-diagram



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.


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 Form FME Flow FME Flow Hosted Windows 64-bit Linux Mac
Reader Professional Edition & Up checkmark checkmark checkmark checkmark checkmark
Writer Professional Edition & Up checkmark checkmark checkmark checkmark checkmark

Try FME Form

No credit card necessary. Start integrating data today!