2024 is the year of the connector - vote here

Explore the Jira API data model

See how the various Jira endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD

Pulling data from the Jira API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Jira API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Board

Documentation: https://developer.atlassian.com/cloud/jira/software/rest/api-group-board/#api-rest-agile-1-0-board-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Type string - -
ProjectID long Project → ID -
Self string - -

FieldDefinition

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
Key string - -
Navigable boolean - -
Orderable boolean - -
Searchable boolean - -
Custom boolean - -
LastUsedType string - -
LastUsedDate datetime - -
SchemaCustom string - -
CustomID long - -
SchemaItems string - -
SchemaSystem string - -
SchemaType string - -

Group

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-groups/#api-rest-api-3-group-bulk-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
GroupID guid - -

Issue

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Updated datetime - -
Created datetime - -
Duedate datetime - -
Statuscategorychangedate datetime - -
Timespent decimal - -
Aggregatetimespent decimal - -
Aggregatetimeoriginalestimate decimal - -
Timeestimate decimal - -
Timeoriginalestimate decimal - -
Summary string - -
ProjectID long Project → ID -
IssueTypeID long IssueType → ID -
PriorityID long IssuePriority → ID -
StatusID long Status → ID -
AssigneeID string User → AccountID -
CreatorID string User → AccountID -
ReporterID string User → AccountID -
WatchCount long - -
IsWatching boolean - -
Self string - -

IssuePriority

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-priorities/#api-group-issue-priorities

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
StatusColor string - -
IconUrl string - -
IsDefault boolean - -
Self string - -

IssueType

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-types/#api-rest-api-3-issuetype-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
AvatarID long - -
HierarchyLevel long - -
IconUrl string - -
Subtask boolean - -
Self string - -

Project

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-projects/#api-rest-api-3-project-search-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
LeadUserID string User → AccountID -
ProjectCategoryID long ProjectCategory → ID -
Simplified boolean - -
IsPrivate boolean - -
Style string - -
Self string - -

ProjectCategory

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-project-categories/#api-rest-api-3-projectcategory-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
Self string - -

Status

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-status/#api-rest-api-3-statuses-search-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
StatusCategory string - -
IconUrl string - -
IsDefault boolean - -
ScopeProjectID long Project → ID -
ScopeType string - -
Self string - -

User

Documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-users/#api-rest-api-3-users-search-get

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
TimeZone string - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
AccountID string - -
AccountType string - -
DisplayName string - -
EmailAddress string - -
Key string - -
Self string - -
Active boolean - -

BoardFeature

Documentation: https://developer.atlassian.com/cloud/jira/software/rest/api-group-board/#api-rest-agile-1-0-board-boardid-features-get

Column Type Relates to Notes
RemoteID string - -
BoardRemoteID string Board → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BoardID long Board → ID -
Feature string - -
State string - -
LocalisedName string - -
LocalisedDescription string - -
LearnMoreLink string - -
ImageUri string - -
FeatureCategory string - -
ToggleLocked boolean - -

Epic

Documentation: https://developer.atlassian.com/cloud/jira/software/rest/api-group-board/#api-rest-agile-1-0-board-boardid-epic-get

Column Type Relates to Notes
RemoteID string - -
BoardRemoteID string Board → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Summary string - -
Done boolean - -
BoardID long Board → ID -
Self string - -

Sprint

Documentation: https://developer.atlassian.com/cloud/jira/software/rest/api-group-sprint/#api-group-sprint

Column Type Relates to Notes
RemoteID string - -
BoardRemoteID string Board → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
State string - -
Goal string - -
StartDate datetime - -
EndDate datetime - -
CompleteDate datetime - -
BoardID long Board → ID -
Self string - -

IssueSprint

Column Type Relates to Notes
RemoteID string - -
IssueRemoteID string Issue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SprintID long Sprint → ID -
IssueID long Issue → ID -

IssueCustomField

Column Type Relates to Notes
RemoteID string - -
IssueRemoteID string Issue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Iterator long - -
FieldID string FieldDefinition → ID -
DecimalValue decimal - -
StringValue string - -
DateValue datetime - -
IntegerValue long - -
AccountID string User → AccountID -
IssueID long Issue → ID -

UserGroup

Column Type Relates to Notes
RemoteID string - -
UserRemoteID string User → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
UserID string User → AccountID -
GroupID guid - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Jira data Interactive ERD Querying Jira using regular SQL