Query Panel

The Query Panel is present at the bottom of the app-builder, this is where you create queries to interact with connected datasources. You can perform API requests, query databases, or transform or manipulate data with JavaScript & Python.

The Query Panel has two sections:

• Query Manager on the right that includes a list of all the created queries
• Query Editor is used to configure the selected query

Query Manager

Query Manager will list all the queries that has been created in the application. Query Manager is used to:

Search

On the top of the query manager is search box that can be used to search for a specific query.

Add

Add button is used to add more queries in the application. When Add button is clicked, the Query Editor will show you a list of options for creating a query from: Rest API, connected datasources, ToolJet Database, JavaScript Code, Python Code or Add a new datasource.

Delete

Delete button will delete the selected query, the button will only show up when you hover over the query name.

Edit

Edit button is used edit the name of the selected query, the button will only show up when you hover over the query name.

Query Editor

Query editor used to configure the query parameters, preview or transform the data return by the query.

Topbar

On the top of the query panel there are a few options:

Query Name editor

Edit the name of the query by clicking on the edit button next to the default query name.

Preview

Preview gives you a quick look at the data returned by the query without triggering the query in the app.

The Preview of data is returned in two different formats:

Raw

JSON

Save

Save is used to save the changes whenever a change is made in query.

Run

Run is used to trigger the query, running the query will interact with the application unlike Preview.

Query Parameters

Query Parameters are the values required for the query to return a response from the server. Parameters include endpoints, methods, or operations. Query Parameters are different for each datasource.

Transformation

Transformations can be enabled on queries to transform the query results. ToolJet allows you to transform the query results using two programming languages JavaScript & Python. Check the detailed documentation on Transformations.

Advanced options

Run this query on application load?

Enabling this option will fire the query every time the app is loaded.

Request confirmation before running the query?

Enabling this option show a confirmation modal to confirm Yes or No if you want to fire that query.

Show notification on success?

Enabling this option show a success toast notification when the query is successfully triggered.

Event Handlers

Event Handler are used to add some action when a particular event happens. You can add event handlers to the query for the following events:

• Query Success
• Query Failure

info

Learn more about Event Handlers and Actions.