Jira

Availability: Airbyte Cloud: ✅, Airbyte OSS: ✅
Support Level: Certified
Latest Version: 0.10.2
Definition Id: 68e63de2-bb83-4c7e-93fa-a8a9051e3993

This page contains the setup guide and reference information for the Jira source connector.

Prerequisites

• API Token
• Domain
• Email

Setup guide

Step 1: Set up Jira

1. To get access to the Jira API you need to create an API token, please follow the instructions in this documentation.

Step 2: Set up the Jira connector in Airbyte

For Airbyte Cloud:

1. Log into your Airbyte Cloud account.
2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
3. On the source setup page, select Jira from the Source type dropdown and enter a name for this connector.
4. Enter the API Token that you have created. API Token is used for Authorization to your account by BasicAuth.
5. Enter the Domain for your Jira account, e.g. airbyteio.atlassian.net.
6. Enter the Email for your Jira account which you used to generate the API token. This field is used for Authorization to your account by BasicAuth.
7. Enter the list of Projects (Optional) for which you need to replicate data, or leave it empty if you want to replicate data for all projects.
8. Enter the Start Date (Optional) from which you'd like to replicate data for Jira in the format YYYY-MM-DDTHH:MM:SSZ. All data generated after this date will be replicated, or leave it empty if you want to replicate all data. Note that it will be used only in the following streams: Board Issues, Issue Comments, Issue Properties, Issue Remote Links, Issue Votes, Issue Watchers, Issue Worklogs, Issues, Pull Requests, Sprint Issues. For other streams it will replicate all data.

Supported sync modes

The Jira source connector supports the following sync modes:

• Full Refresh - Overwrite
• Full Refresh - Append
• Incremental - Append
• Incremental - Append + Deduped

Supported Streams

This connector outputs the following full refresh streams:

• Application roles
• Avatars
• Boards
• Dashboards
• Filters
• Filter sharing
• Groups
• Issue fields
• Issue field configurations
• Issue custom field contexts
• Issue custom field options
• Issue link types
• Issue navigator settings
• Issue notification schemes
• Issue priorities
• Issue properties
• Issue remote links
• Issue resolutions
• Issue security schemes
• Issue transitions
• Issue type schemes
• Issue type screen schemes
• Issue types
• Issue votes
• Issue watchers
• Jira settings
• Labels
• Permissions
• Permission schemes
• Projects
• Project avatars
• Project categories
• Project components
• Project email
• Project permission schemes
• Project roles
• Project types
• Project versions
• Screens
• Screen tabs
• Screen tab fields
• Screen schemes
• Sprints
• Time tracking
• Users
• UsersGroupsDetailed
• Workflows
• Workflow schemes
• Workflow statuses
• Workflow status categories

This connector outputs the following incremental streams:

• Board issues
• Issue comments
• Issue worklogs
• Issues
• Sprint issues
• PullRequests

If there are more endpoints you'd like Airbyte to support, please create an issue.

Experimental Tables

The following tables depend on undocumented internal Jira API endpoints and are therefore subject to stop working if those endpoints undergo major changes. While they will not cause a sync to fail, they may not be able to pull any data. Use the "Enable Experimental Streams" option when setting up the source to allow or disallow these tables to be selected when configuring a connection.

• Pull Requests (currently only GitHub PRs are supported)

Troubleshooting

Check out common troubleshooting issues for the Jira connector on our Airbyte Forum here.

Rate Limiting & Performance

The Jira connector should not run into Jira API limitations under normal usage. Please create an issue if you see any rate limit issues that are not automatically retried successfully.

CHANGELOG

Version	Date	Pull Request	Subject
0.10.2	2023-10-26	31896	Provide better guidance when configuring the connector with an invalid domain
0.10.1	2023-10-23	31702	Base image migration: remove Dockerfile and use the python-connector-base image
0.10.0	2023-10-13	#31385	Fixed aggregatetimeoriginalestimate, timeoriginalestimate field types for the Issues stream schema
0.9.0	2023-09-26	#30688	Added createdDate field to sprints schema, Removed Expand Issues stream from spec
0.8.0	2023-09-26	#30755	Add new streams: Issue custom field options, IssueTypes, Project Roles
0.7.2	2023-09-19	#30675	Ensure invalid URL does not trigger Sentry alert
0.7.1	2023-09-19	#30585	Add skip for 404 error in issue properties steam
0.7.0	2023-09-17	#30532	Add foreign key to stream record where it misseing
0.6.3	2023-09-19	#30515	Add transform for invalid date-time format, add 404 handling for check
0.6.2	2023-09-19	#30578	Fetch deleted and archived Projects
0.6.1	2023-09-17	#30550	Update Issues expand settings
0.6.0	2023-09-17	#30507	Add new stream IssueTransitions
0.5.0	2023-09-14	#29960	Add boardId to sprints stream
0.3.14	2023-09-11	#30297	Remove requests and pendulum from setup dependencies
0.3.13	2023-09-01	#30108	Skip 404 error for stream IssueWatchers
0.3.12	2023-06-01	#26652	Expand on leads for projects stream
0.3.11	2023-06-01	#26906	Handle project permissions error
0.3.10	2023-05-26	#26652	Fixed bug when board doesn't support sprints
0.3.9	2023-05-16	#26114	Update fields info in docs and spec, update to latest airbyte-cdk
0.3.8	2023-05-04	#25798	Add sprint info to sprint_issues and sprints streams for team-managed projects
0.3.7	2023-04-18	#25275	Add missing types to issues json schema
0.3.6	2023-04-10	#24636	Removed Connector Domain Pattern from Spec
0.3.5	2023-04-05	#24890	Fix streams "IssuePropertyKeys", "ScreenTabFields"
0.3.4	2023-02-14	#23006	Remove caching for Issues stream
0.3.3	2023-01-04	#20739	fix: check_connection fails if no projects are defined
0.3.2	2022-12-23	#20859	Fixed pagination for streams issue_remote_links, sprints
0.3.1	2022-12-14	#20128	Improved code to become beta
0.3.0	2022-11-03	#18901	Adds UserGroupsDetailed schema, fix Incremental normalization, add Incremental support for IssueComments, IssueWorklogs
0.2.23	2022-10-28	#18505	Correcting max_results bug introduced in connector stream
0.2.22	2022-10-03	#16944	Adds support for max_results to users stream
0.2.21	2022-07-28	#15135	Adds components to fields object on issues stream
0.2.20	2022-05-25	#13202	Adds resolutiondate to fields object on issues stream
0.2.19	2022-05-04	#10835	Change description for array fields
0.2.18	2021-12-23	#7378	Adds experimental endpoint Pull Request
0.2.17	2021-12-23	#9079	Update schema for filters stream + fix fetching filters stream
0.2.16	2021-12-21	#8999	Update connector fields title/description
0.2.15	2021-11-01	#7398	Add option to render fields in HTML format and fix sprint_issue ids
0.2.14	2021-10-27	#7408	Fix normalization step error. Fix schemas. Fix acceptance-test-config.yml. Fix streams.py.
0.2.13	2021-10-20	#7222	Source Jira: Make recently added configs optional for backwards compatibility
0.2.12	2021-10-19	#6621	Add Board, Epic, and Sprint streams
0.2.11	2021-09-02	#6523	Add cache and more streams (boards and sprints)
0.2.9	2021-07-28	#5426	Changed cursor field from fields.created to fields.updated for Issues stream. Made Issues worklogs stream full refresh.
0.2.8	2021-07-28	#4947	Source Jira: fixing schemas accordinately to response.
0.2.7	2021-07-19	#4817	Fixed labels schema properties issue.
0.2.6	2021-06-15	#4113	Fixed user stream with the correct endpoint and query param.
0.2.5	2021-06-09	#3973	Added AIRBYTE_ENTRYPOINT in base Docker image for Kubernetes support.
0.2.4			Implementing base_read acceptance test dived by stream groups.
0.2.3			Implementing incremental sync. Migrated to airbyte-cdk. Adding all available entities in Jira Cloud.