How to initialize grid with an external data source?

This article shows how to initialize the table grid with an external data source.

You can connect an external data source with your data to the grid using grid configuration.

In order to initialize a grid with an external data source you should do the following steps:

1. Navigate to Data Source tab on the grid configuration page 



2. Select a data source you've already connected from the drop-down

We've added Jira fields as a default option of the data source in the list. Now you don't need to connect your Jira database as a separate data source. It's connected by default.

3. Specify SQL query or JSONPath depending on the data source type

REST data source

SQL data source

REST data source

SQL data source

 

4. Execute the query to get the data preview

REST data source

SQL data source

REST data source

SQL data source

 

Try the example REST data source with users' data https://jsonplaceholder.typicode.com/users

 

Example of the data retrieved from the Jira Server database.

 

5. Configure columns mapping

Select columns from the data source to load information into previously created grid columns. 

 

REST data source

SQL data source

REST data source

SQL data source

 

 

6. Save changes


 

Congratulations! Now you know how to initialize the grid with an external data source.

Â