Using JSONata to configure Custom Reports

Step-by-Step Guide

In this example, we will process data retrieved from an API, calculate additional attributes (like the birth decade), and generate a visual chart.

Use a REST node to fetch data from an API endpoint. For example:

{
  type: 'rest',
  url: 'https://randomuser.me/api/?results=3

  children:  [
      {type: 'json'}
   ]
}

This will generate data for 3 people.

Toggle debug mode to view additional buttons for inspecting the report context.
Use the Inspect option in your browser developer tools to access the console.
Explore the JSON context at various levels:
- Root context: Contains global data sources and metadata.
- Node context: Contains data specific to the current processing node.

Start Small: Begin with simple queries to understand the structure of your data.
Leverage Debug Mode: Use the debug tools to trace errors and verify transformations.
Utilize Functions: JSONata provides a wide range of built-in functions for advanced data manipulation.
Reuse and Optimize: Store reusable queries in variables to simplify and optimize transformations.

Function	Description	Example
`$map`	Maps a function to each element in an array.	`$map(data, $p -> $p.name)`
`$filter`	Filters elements based on a condition.	`$filter(data, $p -> $p.age > 20)`
`$merge`	Merges objects into a single object.	`$merge([$a, $b])`
`$distinct`	Returns unique values from an array.	`$distinct(data)`
`$sort`	Sorts an array.	`$sort(data)`
`$count`	Counts elements in an array.	`$count(data)`