How to Retrieve Jira Data using Bold BI API Connector

This article will guide you on how to retrieve various data from Jira using the Bold BI API connector. We will cover the following topics:

1. Default fields from Jira
2. Additional custom field data
3. Retrieving data using Raw Query mode
4. Retrieving all issues in a specific project
5. Retrieving all work logs for specific issues and projects

Default Fields from Jira

Bold BI JIRA connector supports the following default fields:

• Project
• Issue Type
• Summary
• Description
• Component
• Priority
• Attachment
• Labels
• Assignee
• Reporter
• Fix Version
• Status (A workflow step)
• Resolution
• Created
• Updated
• Due Date

Additional Custom Field Data

To import custom field data associated with the project and issue type, follow the documentation here.

All Dates as Timestamp

Jira data source connector returns timestamp values as string by default. You can manually change it to timestamp by following the image below.

Retrieving Data using Raw Query Mode

To retrieve data for a list of all projects from Jira using the “Raw Query” mode in Bold BI, use the API shared in the image below.

Retrieving All Issues in a Specific Project

To get all the issues for a particular project from the Jira data source using JQL mode, configure the project name in the JQL query and get the data. Refer to the image below for an example.

Example: project = projectName

Retrieving All Work Logs for Specific Issues and Projects

To retrieve data for all worklogs for a specific issue from Jira using the “Raw Query” mode in Bold BI, use the API shared in the image below.

Example: GET /rest/api/2/issue/{issueIdOrKey}/worklog

References

• Bold BI Jira Connector Documentation