JSON

JSON (JavaScript Object Notation) is a lightweight data interchange format that's easy for humans to read and write, and simple for machines to parse and generate. It uses a text-based structure with key-value pairs and arrays to represent data. JSON is language-independent and widely used for transmitting data in web applications.

Now, to extract key-value pairs from this JSON object in Pentaho Data Integration, you would typically use the "JSON Input" step.

{
  "customer": {
    "id": 1001,
    "name": "John Doe",
    "email": "[e-mail]",
    "active": true
  }
}

In the JSON Input step, the datastream field name, path and data type are defined.

Name	Path	Type
id	$.customer.id	Integer
name	$.customer.name	String
email	$.customer.email	email
active	$.customer.active	Boolean

Here's a brief explanation of the JsonPath notation used:

$ represents the root of the JSON document

.customer navigates to the "customer" object

.id, .name, .email, and .active access the respective fields within the "customer" object

Workshops

Read JSON

x

x

x

Second Tab