This article describes data source functionality in the Table Grid Editor for Jira Cloud.The data sources allow to specify how to connect the grid to an external data, located on a remote web service. You can reuse a connection in multiple grids.
The Data sources type is REST. We support only JSON for processing data.
You can access remote REST API using data sources in the Table Grid Editor for Jira Cloud.
Data source configuration
You can add a Data source under Data Source tab in the table grid configuration.
Available fields:
Name - name of your data source connection
Description - optional description of the data source for your reference. It will be displayed below the title in the Data source list. It's useful in case you want to specify
URL - URL address of the web service you want to connect to the grid.
Path - You can specify the path to JSON array in case you want to load a specific array from the JSON.
Headers - allows adding header fields. You can use them in case the data source requires HTTP authentication.
You can test a connection to the data source using Test Connection button.
The data loads in a preview and you can check if it's correct.
Path to JSON array
You can specify direct path to an array inside the JSON with the help of JSONPath expressions. Data may be interactively found and extracted out of JSON structures.
JSONPath expressions always refer to a JSON structure. Since a JSON structure is usually anonymous and doesn't necessarily have a "root member object" JSONPath assumes the abstract name $ assigned to the outer level object.
JSONPath expressions can use the dot–notation
$.store.book[0].title
Overview of the JSONPath syntax elements
| JSONPath | Description |
| $ | the root object/element |
| @ | the current object/element |
| . or [] | child operator |
| n/a | parent |
| * | wildcard. All objects/elements regardless their names. |
| [] | subscript operator. In JSON it is the native array operator. |
| ?() | applies a filter (script) expression. |
| () | script expression, using the underlying script engine. |
JSONPath square brackets operate on the object or array addressed by the previous path fragment. Indices always start by 0.
Check out our video on how to add a data source connection.
You can now initialize the gird with the data source.