Category Archives: JSON

Pretty-print and remove whitespace for large JSON data

What do you do if you need to compact a JSON document but the file has more than 400 MB and 20 Million lines? Or the other way around, you have a large document and it is impossible to read because it has no formatting? So you need a JSON editor which can do two things for you. The editor can… Read more »

My editor layout for working with JSON schema files

JSONBuddy offers a lot of functionality while you are editing a JSON schema file. It is even not always easy to have all of the information visible on the screen. So here is the editor layout I am using whenever I have a JSON schema file open in JSONBuddy: This way I have a lot of entry helpers and additional information… Read more »

Generate sample data from JSON schema

      No Comments on Generate sample data from JSON schema

tl;dr Use JSONBuddy or XML ValidatorBuddy to generate a live preview of JSON sample data while editing your JSON schema. JSONBuddy has already some powerful features to support you in creating JSON schema documents. You can check your JSON schema at any time for syntax errors. You can validate your JSON schema to see if your schema can be parsed and used… Read more »

Convert JSON to XML from the command line

      No Comments on Convert JSON to XML from the command line

You can use the command-line tool included in the XML ValidatorBuddy package to convert JSON to XML. This allows you to quickly convert any number of JSON files and also to create a scheduled task which runs as a batch process (on your server). As usual the command-line tool needs a configuration XML to run the conversion. You can specify… Read more »

Coming next: JSON Schema documentation

      No Comments on Coming next: JSON Schema documentation
POI JSON schema tree diagram

To extend the support for the JSON standard, JSONBuddy will get a brand new view to parse and display any JSON schema as a good looking and clearly arranged tree diagram. The screen-shot below shows the POI (point of interest) JSON schema as it is partly displayed in the new view: The first version allows to fully expand and collapse tree… Read more »

JSON Schema editing – An introduction

      No Comments on JSON Schema editing – An introduction
auto completion for json schema

You might have noticed that JSON has become a quite popular text format over the last years. Especially for everyone who is working in a Java environment. But how do you check your JSON instance documents in a convenient and standardized way like you can do for any XML file? For this purpose JSON Schema was introduced. In order to… Read more »

How to convert Excel or Word to JSON

      No Comments on How to convert Excel or Word to JSON

The short answer is unzip the .xslx or .docx documents saved from Word or Excel, which are just ZIP archives with some XML data inside, and convert them in XML Validator Buddy using the “Convert XML to JSON” command 🙂 Please take a look at “XML to JSON conversions” to learn more about the powerful XML to JSON functionalities of… Read more »

JSON well-formed checking

      No Comments on JSON well-formed checking
check json well-formed

Whenever you create some JSON output and want to make sure that the generated data is really parsable you can take the XML ValidatorBuddy editor to quickly check one or many JSON files with just a few clicks. Select the JSON documents you want to check in the built-in File Explorer window of XML ValidatorBuddy and use the “Check if JSON well-formed”… Read more »

XML – JSON converter

      No Comments on XML – JSON converter
XML to JSON options dialog

Starting with release 4.0 of XML ValidatorBuddy the editor also offers an XML to JSON converter. You can do conversions from XML to JSON and also from JSON to XML with a single click. To convert multiple XML files use the built-in File Explorer window and select the documents you want to convert. Afterwards start the conversion with the “Convert XML to JSON” command… Read more »