Transform is a utility component in workflow that helps you change, filter, or search through JSON data by setting up specific instructions. It only works with JSON data and based on a tool called JSONata to perform these tasks. To use Transform effectively, you need to understand how JSONata works.

Understanding JSON and JSONata

What is JSON?

JSON (JavaScript Object Notation) is a simple format used to store and share data. It's like a digital way to write down lists and objects in a way that computers can easily read and understand. Think of it as a structured way to organize information.

Basic Example of JSON

Here's a simple example of JSON representing a person:

{
  "name": "John Doe",
  "age": 30,
  "isStudent": false
}

What is JSONata?

JSONata is a tool that helps you work with JSON data. It allows you to search, filter, and transform JSON data easily.

Why Use JSONata?

• Easy Search: Quickly find specific information in a large dataset.
• Data Transformation: Change the structure of your data to fit your needs.

Examples of JSONata Expressions

Let's use a sample JSON dataset of a bookstore to understand how JSONata works.

Sample JSON Dataset