Connecting an external data source
You can connect a grid to an a REST or an SQL data source to fill in a grid with external data.
It is possible to connect a data source manually or by importing it.
Connect the grid to a REST or an SQL data source.
To connect an external data source:
Navigate to ⚙️ → Add-ons → Data Sources.
Select Add Data Source to add a new data source.
Enter the name of your data source in the Name field.
If necessary, add a description of your data source in the Description field.
Choose the data source type in the Datasource Type dropdown. For REST data sources choose REST, for SQL data sources select SQL.
Enter the fields for your data source. For REST data source fields check REST data sources fields. For SQL data sources check SQL data sources.
Press Save.
To connect a data source to the grid you need to add it into the grid configuration under the Data Receiver tab. For more information check Filling a grid with data from REST or SQL data sources.
See also
REST data sources fields
Configuration and usage of the REST data source in the Table Grid Next Generation.
SQL data sources
SQL data sources configuration and usage
Data Mirror
Save the grid data dynamically in the external database.
Data Mirror - Sync Table
Jira fields data source
You can populate the grid with values from other Jira fields.
JSON Path in REST data source
You can specify the direct path to an array inside the JSON with the help of JSONPath expressions. Data may be found and extracted out of JSON structures.
Exporting and importing data source info
You can export or import information about a data source in a .json file. This speeds up the process of adding data sources.
Filling a grid with data from REST or SQL data sources
You can fill your grids with data from an external data source when configuring a grid.