JSON Reader

About JSON

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. It is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition - December 1999.

https://www.json.org/json-en.html

Properties

Tip: To change Reader properties double click on it.

JSON

JSON Grid

JSON Examples

Without root node

[
  { "id": 1, "Name": "John", "age": 25 },
  { "id": 2, "Name": "Maria", "age": 43 }
]

With root node

{
  "root": [
    { "id": 1, "Name": "John", "age": 25 },
    { "id": 2, "Name": "Maria", "age": 43 }
  ]
}

Complex XML With root node

{
  "root": [
    { "id": 1, "Name": "John", "age": 25, "Change": "Male" },
    { "id": 2, "Name": "Maria", "age": 43 }
  ]
}

JSON Transformation Functions

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on December 15, 2025 • 1 min read • 184 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License