Already have an account? Sign in

JIRA (v15-10-2015)

Last updated: 9/15/2026

JIRA (v15-10-2015) end of life

This version of JIRA reached end of life on July 15, 2019 and is no longer functioning.

Upgrade to the latest version (v2) to continue replicating data.

JIRA feature snapshot

A high-level look at Stitch's JIRA (v15-10-2015) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Sunset on July 15, 2019	Supported by	Stitch
Stitch plan	Standard	API availability	Not available
Singer GitHub repository	Not applicable
REPLICATION SETTINGS
Anchor Scheduling	Unsupported	Advanced Scheduling	Unsupported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Unsupported	Column selection	Unsupported
Select all	Unsupported
TRANSPARENCY
Extraction Logs	Unsupported	Loading Reports	Supported

JIRA table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 15-10-2015 of this integration.

jira_projects & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

jira_projects Attributes

While we try to include everything JIRA has here, this may not be a full list of attributes. Refer to JIRA's documentation for a full list and description of each attribute.

Project ID (id)
avatarurls
description
expand
key
lead__active
lead__avatarurls
lead__displayname
lead__key
lead__name
lead__self
name
projecttypekey
projectkeys*
self

jira_project_categories

Replication Method: Full Table

Primary Key: id
Contains Nested Structures?: No

The jira_project_categories table contains info about the categories assigned to the projects in your JIRA account.

Table Info & Attributes

jira_project_categories Attributes

While we try to include everything JIRA has here, this may not be a full list of attributes. Refer to JIRA's documentation for a full list and description of each attribute.

Project Category ID (id)
self
name
description

jira_project_roles

Replication Method: Full Table

Primary Key: id
Contains Nested Structures?: Yes

The jira_project_roles table contains info about the roles that can be assigned to projects in your JIRA account.

Table Info & Attributes

jira_project_roles & Nested Structures

jira_project_roles Attributes

While we try to include everything JIRA has here, this may not be a full list of attributes. Refer to JIRA's documentation for a full list and description of each attribute.

Project Role ID (id)
self
name
description
roles__actors*

jira_project_types

Replication Method: Full Table

Primary Key: key
Contains Nested Structures?: No

The jira_project_types table contains info about the project types defined in your JIRA account.

Table Info & Attributes

jira_project_types Attributes

While we try to include everything JIRA has here, this may not be a full list of attributes. Refer to JIRA's documentation for a full list and description of each attribute.

Project Type Key (key)
formattedkey
description18nkey
icon
color

jira_resolutions

Replication Method: Full Table

Primary Key: id
Contains Nested Structures?: No

The jira_resolutions table contains info about the resolutions in your JIRA account.

Table Info & Attributes

jira_resolutions Attributes

While we try to include everything JIRA has here, this may not be a full list of attributes. Refer to JIRA's documentation for a full list and description of each attribute.

Resolution ID (id)
self
name
description

jira_users

Replication Method: Full Table

Primary Key: key
Contains Nested Structures?: No

The jira_users table contains info about the users in your JIRA account.

Table Info & Attributes

jira_users Attributes

While we try to include everything JIRA has here, this may not be a full list of attributes. Refer to JIRA's documentation for a full list and description of each attribute.

User Key (key)
active
avatarurls
displayname
emailaddress
key
locale
name
self
timezone

jira_issues

Replication Method: Incremental

Primary Key: id
Contains Nested Structures?: Yes

The jira_issues table contains info about the issues in your JIRA account.

Table Info & Attributes

jira_issues & Nested Structures

Accounting for Deleted Issues

When an issue is hard-deleted in JIRA, the record for the issue will remain in your data warehouse. This happens because of the Replication Method the jira_issues table uses and how JIRA’s API functions.

The jira_issues table is incrementally replicated based on the updated_at column. This means that rows with values in this column that are greater than or equal to the last recorded MAX value will be selected for replication. If a record is hard-deleted, there won’t be a value to check and thus no way to detect changes to the record.
JIRA’s API doesn’t include a flag to indicate deletes.

The suggested workaround (although it may be a bit cumbersome) is to use the fields__status__name column - which indicates the current status of an issue - to track deletes. Before deleting the issue, you could change the status to something that would only indicate a delete and then use that status as a filter in your queries.

jira_issues Attributes

While we try to include everything JIRA has here, this may not be a full list of attributes. Refer to JIRA's documentation for a full list and description of each attribute.

Issue ID (id)
self
key
expand
changelog
description
attachment*
subtasks*
labels*
fixversions*
comments*
Creator Info
Status Info
Summary
Votes
Reporter
Priority
Issue Type

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here