Introducing JSON terminology

A JSON structure can contain scalar data types such as numbers, Booleans, or strings, and also structured data as arrays or objects. In a similar way to XML, JSON can also store hierarchical data.

The objects are represented as a collection of name_of_field:value_of_field pairs and you can have an array of these elements represented by a list, enclosed by [] characters.

The following example is an extract taken from the samples that come with PDI:

{ "store": {     "book": [         { "category": "reference",          "author": "Nigel Rees",          "title": "Sayings of the Century",          "price": 8.95        },        { "category": "fiction",          "author": "Evelyn Waugh",          "title": "Sword of Honour",          "price": 12.99        },        { "category": "fiction", "author": "Herman ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.