What are JSON and BSON?
JSON (JavaScript Object Notation) is a human-readable lightweight data-interchange format as defined by the JSON specification. It is used to transmit and store data across web based applications.
BSON (Binary JavaScript Object Notation) is a binary encoded representation of JSON as defined by the BSON specification.
As BSON is a binary format, it is machine-readable only, so you may therefore wish to convert BSON data to JSON data in order to view and debug the contents, or to extract the JSON data for another system to use.
You can convert BSON to JSON in Liquid Studio in two ways:
- Using the Liquid Studio Conversion Wizard to create a new JSON file.
- Using the Liquid Data Mapper to convert incoming BSON data to JSON data.
Convert BSON to JSON using the Liquid Studio Conversion Wizard
From the Tools->Convert menu, select Convert BSON to JSON:
This will run the Convert BSON to JSON Wizard.
Next select the BSON file you wish to convert and specify the JSON file you wish to create:
Click Finish and the JSON file will be created and automatically opened in Liquid Studio:
Note, if the BSON contains errors you will see an error dialog with a description of the error.
Convert BSON to JSON using Liquid Data Mapper
Liquid Data Mapper is a powerful data mapping tool that enables you to integrate, map and transform your data between multiple data sources and targets without writing a single line of code.
To convert BSON to JSON data as part of the data transform, you need to drag a "BSON to JSON" component onto the canvas and connect a binary data provider such as a "Read Binary File" component as an input and a text receiver such as a "JSON Data Source" as an output.
You would then have a strongly typed interface with which to manipulate the JSON data.
