Avro to JSON Converter

Tags

History

Avro is a compact and efficient binary file format used for serializing data during transmission. The schema of Avro files are specified in JSON.

JavaScript Object Notation (JSON), pronounced as Jason, is the most common data interchange format on the web. Douglas Crockford first released the JSON specification in the early 2000s. It is a simple format that is easier to comprehend than XML. It is also smaller in size because it does not have closing tags. A wide variety of programming languages can parse JSON files. They also support the serialization of data structures to JSON. You can copy JSON text to JavaScript and start using them without any modifications.

Settings Explained

Indent
This setting governs whether or not the Output is indented. The indented Output is easier to comprehend. On the other hand, a non-indented output is compact. The smaller size is best for transmission over the network. So, we often minify JSON by removing non-essential whitespace.
- Indentation On
```
{
    "name": "John Doe",
    "age": 69
}
```
- Indentation Off
```
{"name":"John Doe","age":69}
```
Keys In Quotes
A valid JSON must have double quotes around the keys (or property names). Unless the keys include special characters, double quotes are unnecessary when used directly inside JavaScript. Turn off this setting if you want to omit quotes around keys.
- Keys In Quotes On
```
{"name":"John Doe","age":69}
```
- Keys In Quotes Off
```
{name:"John Doe",age:69}
```
Camel Case Property Names
Case of properties is changed using this strategy.
Use this option only when cleaning a JSON structure because changing the keys will cause failures in applications that use this JSON format.
- None
```
No case Change
```
- Lower Case
```
lower case change
```
- Upper Case
```
UPPER CASE CHANGE
```
- Camel Case
```
camelCaseChange
```
- Pascal Case
```
PascalCaseChange
```
- Title Case
```
Title Case Change
```
- Snake Case
```
snake_case_change
```
- Kebab Case
```
kebab-case-change
```
- Sentence Case
```
Sentence case change
```

Expanded Braces

Braces are written on a new line (C# style) when this option is selected. Turning the option off puts the Braces on the same line (Java/JavaScript style).

Expanded Braces On

{
  "name": "John Doe",
  "age": 25,
  "addresses":
  [
    {
      "city": "Phoenix",
      "country": "Arizona"
    },
    {
      "city": "Miami",
      "country": "Florida"
    }
  ]
}

Expanded Braces Off

{
  "name": "John Doe",
  "age": 25,
  "addresses": [
    {
      "city": "Phoenix",
      "country": "Arizona"
    },
    {
      "city": "Miami",
      "country": "Florida"
    }
  ]
}

Format Embedded JSON

When this option is selected, JSON embedded or escaped within string values is processed, expanded & converted to nodes.

Format Embedded JSON On

{
  "name": "John Doe",
  "age": 25,
  "addresses": [
    {
      "city": "Phoenix",
      "country": "Arizona"
    },
    {
      "city": "Miami",
      "country": "Florida"
    }
  ]
}

Format Embedded JSON Off

{
  "name": "John Doe",
  "age": 25,
  "addresses": "[{\"city\":\"Phoenix\",\"country\":\"Arizona\"},{\"city\":\"Miami\",\"country\":\"Florida\"}]"
}

Date Format Handling
Even though there is no standard for representing dates in JSON, two popular formats have emerged. The ISO Date Format is the most widely used. If you are using a .NET stack, quite possibly you are using the Microsoft Date Format.
- ISO Date Format
```
{"systemTime":"2014-01-01T23:28:56.782Z"}
```
- Microsoft Date Format
```
{"systemTime":"\/Date(1388618936782)\/"}
```