Java Script Object Notation (JSON) is a format used to describe data and is widely used in applications, web services, Electronic Data Interchange (EDI), and much more. GoAnywhere MFT can create JSON files using information stored in a database or pulled from other files like CSV or Excel spreadsheets. Additionally, data can be extracted from JSON files and loaded into databases or converted into other file formats. GoAnywhere MFT supports JSON objects, arrays, and fields as well as multi-level or nested elements that represent relationships.
Reading JSON
The data read from JSON documents can be imported into one or more database tables. JSON data can also be translated into other formats including Excel, delimited text and fixed-width. The following user-specified options are available when reading JSON files in GoAnywhere MFT:
- Parse multi-level JSON documents
- Specify field names and types
- Data trim options
- Formatting options for dates and numbers
- Null substitute values
- Skip invalid records
- Pass in variables (at runtime) to override attributes
Writing JSON
JSON documents can be created from data which is retrieved from one or more database tables. Additionally, JSON documents can be created from data which is translated from other file formats including Excel, delimited text and fixed-width text.
GoAnywhere MFT can create JSON documents using a variety of user-specified options:
- Create multi-level JSON documents
- Create objects, arrays, and fields
- Formatting options for dates and numbers
- Null substitute values
- Data trim options
- Indention option for tidy output
- Pass in variables (at runtime) to override attributes
After a JSON document is generated, GoAnywhere MFT can post it to a RESTful Web Service or transfer it to other remote servers.