Jira
This page contains the setup guide and reference information for the Jira source connector.
Prerequisites
- API Token
- Domain
Setup guide
Step 1: Set up Jira
- 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:
- Log into your Airbyte Cloud account.
- Click Sources and then click + New source.
- On the Set up the source page, select Jira from the Source type dropdown.
- Enter a name for the Jira connector.
- Enter the API Token that you have created. API Token is used for Authorization to your account by BasicAuth.
- Enter the Domain for your Jira account, e.g.
airbyteio.atlassian.net
. - 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.
- 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.
- 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.
For Airbyte Open Source:
- Navigate to the Airbyte Open Source dashboard.
- Click Sources and then click + New source.
- On the Set up the source page, select Jira from the Source type dropdown.
- Enter a name for the Jira connector.
- Enter the API Token that you have created. API Token is used for Authorization to your account by BasicAuth.
- Enter the Domain for your Jira account, e.g.
airbyteio.atlassian.net
. - 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.
- 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.
- 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:
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:
If there are more endpoints you'd like Airbyte to support, please create an issue.
Entity-Relationship Diagram (ERD)
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.
Reference
Config fields reference
Changelog
Expand to review
Version | Date | Pull Request | Subject |
---|---|---|---|
3.3.0-rc.2 | 2024-11-08 | 38612 | Add substream state migration. Update CDK to v6. |
3.3.0-rc.1 | 2024-10-28 | 38612 | Migrate IssueComments and IssueWorklogs streams to low-code (This change is irreversible) |
3.2.1 | 2024-10-12 | 44650 | Update dependencies |
3.2.0 | 2024-10-10 | 46344 | Update CDK v5 |
3.1.1 | 2024-08-17 | 44251 | Update dependencies |
3.1.0 | 2024-08-13 | 39558 | Ensure config_error when state has improper format |
3.0.14 | 2024-08-12 | 43885 | Update dependencies |
3.0.13 | 2024-08-10 | 43542 | Update dependencies |
3.0.12 | 2024-08-03 | 43196 | Update dependencies |
3.0.11 | 2024-07-27 | 42802 | Update dependencies |
3.0.10 | 2024-07-20 | 42231 | Update dependencies |
3.0.9 | 2024-07-13 | 41842 | Update dependencies |
3.0.8 | 2024-07-10 | 41453 | Update dependencies |
3.0.7 | 2024-07-09 | 41175 | Update dependencies |
3.0.6 | 2024-07-06 | 40785 | Update dependencies |
3.0.5 | 2024-06-27 | 40215 | Replaced deprecated AirbyteLogger with logging.Logger |
3.0.4 | 2024-06-26 | 40549 | Migrate off deprecated auth package |
3.0.3 | 2024-06-25 | 40444 | Update dependencies |
3.0.2 | 2024-06-21 | 40121 | Update dependencies |
3.0.1 | 2024-06-13 | 39458 | Fix skipping custom_field_options entities when schema.items is options |
3.0.0 | 2024-06-14 | 39467 | Update pk for Workflows stream from Id(object) to entityId, name(string, string) |
2.0.3 | 2024-06-10 | 39347 | Update state handling for incremental Python streams |
2.0.2 | 2024-06-06 | 39310 | Fix projects substreams for deleted projects |
2.0.1 | 2024-05-20 | 38341 | Update CDK authenticator package |
2.0.0 | 2024-04-20 | 37374 | Migrate to low-code and fix Project Avatars stream |
1.2.2 | 2024-04-19 | 36646 | Updating to 0.80.0 CDK |
1.2.1 | 2024-04-12 | 36646 | schema descriptions |
1.2.0 | 2024-03-19 | 36267 | Pin airbyte-cdk version to ^0 |
1.1.0 | 2024-02-27 | 35656 | Add new fields to streams board_issues , filter_sharing , filters , issues , permission_schemes , sprint_issues , users_groups_detailed , and workflows |
1.0.2 | 2024-02-12 | 35160 | Manage dependencies with Poetry. |
1.0.1 | 2024-01-24 | 34470 | Add state checkpoint interval for all streams |
1.0.0 | 2024-01-01 | 33715 | Save state for stream Board Issues per board |
0.14.1 | 2023-12-19 | 33625 | Skip 404 error |
0.14.0 | 2023-12-15 | 33532 | Add lookback window |
0.13.0 | 2023-12-12 | 33353 | Fix check command to check access for all available streams |
0.12.0 | 2023-12-01 | 33011 | Fix BoardIssues stream; increase number of retries for backoff policy to 10 |
0.11.0 | 2023-11-29 | 32927 | Fix incremental syncs for stream Issues |
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 missing |
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 accordingly 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. |