---
title: "Query and transform your data with JSONata"
canonical: "https://support.appfire.com/space/RDD/1549304032/Query%20and%20transform%20your%20data%20with%20JSONata"
format: markdown
---
> Macro (aura-html)


---

## Debug mode

1. Turn on** Debug mode** to view additional buttons for inspecting the report context.
  
2. Right-click in the *Report Description Editor* and select **Inspect** to access the console.
3. 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.

---

## Best practices

- **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.
- **Use the node:type=json:**  Use this as a debugger to output data from context, for example, a JSON node as a child of REST node will print the result of fetching data from the remote.
- **Refine the data:**  Use the path property until you achieve the expected outcome. You can use [https://try.jsonata.org/](https://try.jsonata.org/) to iterate quickly. Once you have your outcome, you can replace it elsewhere for example, in `path` in the rest node, or in an interpolation. Remember the jsonPath expression is just a JSON transformation function.
- **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.

---

## Common functions in JSONata

## JSONata

Explore the full potential of JSONata by visiting their official documentation for detailed guidance and advanced examples: [https://docs.jsonata.org/overview.html](https://docs.jsonata.org/overview.html).