This article describes data source functionality in the Table Grid Editor for Jira Cloud#Grid Custom Field#.
The data sources allow specifying how to connect the grid to an external data, located on a remote web-service. You can reuse a connection in multiple grids.
| Info |
|---|
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. #Grid Custom Field#. |
Data source configuration
You can add a Data source under the Data Source Sources tab in the table grid configuration.
Available fields:
Name - a name of your data source connection
...
You can test a connection to the data source using using a Test Connection button.
The data loads in a preview and you can check if it's correct.
| Anchor | ||||
|---|---|---|---|---|
|
...
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. |
| Info |
|---|
JSONPath square brackets operate on the object or array addressed by the previous path fragment. Indices always start by 0. |
...