External source sync allows you to bring information from external tools into a single, centralized table within Airtable. This article covers how to sync Jira issues found in specific filters to an Airtable base.
If you haven’t set up a sync before, we recommend first reading the Sync - Basic setup article to become familiarized with how sync works.
Add a new synced table
Start by clicking the + symbol next to your list of tables. Then, under “Sync data from”, select the “Jira” option.
Select a Jira account
Select an existing Jira account (if you’ve already connected to Jira), or link to a new Jira account. Once you link to the account, select the “Site” that you want to use to create the synced table - all of your existing sites will be available as options to select. Lastly, choose which issue “Filter’ to use for creating Airtable records.
Select fields to sync
After clicking next, you’ll be presented with two sync options; you can sync:
-
All fields from the source view (Jira), including any fields added by Jira in the future.
-
Specific fields from the source view (Jira).
If you choose to sync specific fields you’ll be shown a menu where you can toggle each individual field that you want to sync from Jira.
Field data that can be synced from Jira
Below is a list of all of the field data that is provided by Jira that can be synced to Airtable:
Issue Key
Summary
Description
Status
Project
Issue Type
Created
Updated
Components
Story Points
Fix versions
Priority
Labels
Time Spent
Aggregate
Time Spent |
Time Remaining
Aggregate Time Remaining
Original Estimate
Due Date
Linked Issues
Assignee
Parent
Environment
Affects Versions
Epic Name
Sprint
Reporter
Flagged
Story Point Estimate
Start Date
Issue Color |
Create synced table
Before creating your synced table, there are Settings options that will allow you to choose how often you want to sync, and how to handle records that are deleted or hidden from the source (Jira). These options are:
- The frequency of syncing. Right now, the options are manual syncing and automatic syncing which happens around every 5 minutes.
- Whether or not deleted records (issues in the selected Jira filter) should be removed from the Airtable table. By default, deleted events will be removed.
Once you’ve selected your desired settings, click the “Create table” button. The sync operation will retrieve all issues in the selected Jira filter and generate Airtable records.
FAQs
What type of access will Airtable have to Jira?
Airtable will only have access to the issues and filters that the user who connected the Jira sync has access to.
What happens to the sync if the Jira account used becomes deactivated?
The sync will stop working if the connected Jira account is deactivated.
How is data transmitted from Jira?
The data that we retrieve from Jira’s API is transmitted securely via HTTPS and is not used for any purpose other than syncing data to the table.
Can custom fields in Jira be used in the Sync?
Custom fields are not yet supported.