JIRA
The Qlik JIRA connector lets you bring data about your projects and issues from JIRA, inside your apps.
Ways to access your data
To access your JIRA data, you need to authenticate the connector with your JIRA account credentials. After you create a connection and select JIRA as your data source, you are asked to log in with your credentials.
Creating a data source connection
Loading data from tables
After you authenticate the connector with your account credentials, you can use the following tables to select and load data.
In Qlik Sense, some tables are only available in the Data load editor, and are not available in the Add data interface. They are indicated below by the DLE Only column.
| Table | Available in | Description |
|---|---|---|
| Projects | Datenmanager and Dateneditor | Use this to get a list of projects visible to the authenticated user. |
| Issues | Datenmanager and Dateneditor | Use this to get all the issues for a specific project. |
| Comments | Dateneditor | Use this to get all comments made for an issue. |
| History | Dateneditor | Use this to get the history of an issue. |
| Fields | Dateneditor | Use this to get a list of fields visible to the authenticated user. |
| Worklog | Dateneditor | Use this to get a worklog listing for an issue. |
To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*) in the dialog. The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.
Creating a connection and selecting data
Working with the JIRA API quota limits
The Qlik Web Connectors use the JIRA API to extract data from JIRA and load it into your Qlik Sense app. While reloading your JIRA-based app, you might receive an error message that the connector has reached the JIRA API rate limit and that all subsequent API calls will fail until the connector falls back under the throttling limit. If you receive this error message, then you have exceeded one of the API rate limits.
Reference - JIRA API documentation
You can refer to the JIRA API documentation to learn more about the requirements and restrictions imposed by the JIRA API.
Troubleshooting
You receive an error message that you have reached the API rate limit
Mögliche Ursache
You have exceeded the API limits that are imposed by the JIRA API.
Vorgeschlagene Aktion
To reduce the impact of reaching API rate limits, develop your app with the following in mind:
- Extract only the data you need.
- Reload one JIRA-based application at a time.
- Ensure that loops in your script that make API calls do not result in infinite loops.