Jira

Prerequisites

• API Token
• Domain
• Email

Setting up the Jira connector

No	Item	Required	Example	Notes
1	API Token	Yes		Jira API Token. See the docs for more information on how to generate this key.
2	Domain	Yes	domainname.atlassian.net	The Domain for your Jira account, e.g. zipstackio.atlassian.net
3	Email	Yes		The user email for your Jira account.
4	Projects	No	PROJ1 PROJ2	List of Jira project keys to replicate data for.
5	Start Date	No	2021-03-01T00:00:00Z	The date from which you want to replicate data from Jira, use the format YYYY-MM-DDT00:00:00Z. Note that this field only applies to certain streams, and only data generated on or after the start date will be replicated. For more information, refer to the documentation.
6	Expand Issue Changelog	No		Expand the changelog when replicating issues.
7	Render Issue Fields	No		Render issue fields in HTML format in addition to Jira JSON-like format.
8	Enable Experimental Streams	No		Allow the use of experimental streams which rely on undocumented Jira API endpoints. See https://docs.zipstack.com/integrations/sources/jira#experimental-tables for more info.

Tables in the Jira connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	projects	33	id	Full Refresh		API Reference
2	jql	3
3	issue_link_types	5	id	Full Refresh
4	issue_comments	11	id	Full Refresh, Incremental	updated
5	dashboards	10	id	Full Refresh		API Reference
6	issues	19	id	Full Refresh, Incremental	updated	API Reference
7	pull_requests	6
8	project_components	14	id	Full Refresh
9	issue_notification_schemes	7	id	Full Refresh
10	permissions	4	key	Full Refresh		API Reference
11	sprints	9	id	Full Refresh		API Reference
12	workflow_status_categories	5	id	Full Refresh
13	avatars	7	id	Full Refresh		API Reference
14	screen_tabs	2	id	Full Refresh
15	jira_settings	9	id	Full Refresh
16	board_issues	8	id	Full Refresh, Incremental	updated
17	issue_resolutions	4	id	Full Refresh
18	users	14	accountId	Full Refresh		API Reference
19	labels	1	label	Full Refresh		API Reference
20	issue_type_schemes	5	id	Full Refresh
21	issue_custom_field_contexts	5	id	Full Refresh
22	workflow_statuses	6	id	Full Refresh
23	project_email	2	projectId	Full Refresh
24	issue_comment_properties	2
25	filter_sharing	5	id	Full Refresh
26	issue_field_configurations	4	id	Full Refresh
27	audit_records	11
28	issue_security_schemes	6	id	Full Refresh
29	workflow_scheme_drafts	13
30	issue_worklogs	13	id	Full Refresh, Incremental	updated
31	screen_schemes	5	id	Full Refresh
32	workflow_transition_rules	4
33	permission_schemes	7	id	Full Refresh
34	issue_priorities	6	id	Full Refresh
35	issue_type_screen_schemes	3	id	Full Refresh
36	boards	6	id	Full Refresh		API Reference
37	workflows	4	id	Full Refresh		API Reference
38	project_types	5		Full Refresh
39	issue_remote_links	6	id	Full Refresh
40	project_versions	17	id	Full Refresh
41	dynamic_modules	1
42	issue_type_properties	2
43	screens	4	id	Full Refresh		API Reference
44	issue_navigator_settings	2		Full Refresh
45	workflow_schemes	13	id	Full Refresh
46	application_roles	13	key	Full Refresh
47	time_tracking	3	key	Full Refresh
48	sprint_issues	9	id	Full Refresh, Incremental	updated
49	issue_watchers	4		Full Refresh
50	issue_custom_field_options_apps	4
51	project_categories	4	id	Full Refresh
52	project_permission_schemes	4	id	Full Refresh
53	screen_tab_fields	2	id	Full Refresh
54	groups	2	groupId	Full Refresh		API Reference
55	filters	14	id	Full Refresh		API Reference
56	issue_types	10
57	project_avatars	7	id	Full Refresh
58	server_info	10
59	issue_custom_field_options	4
60	workflow_scheme_project_associations	2
61	issue_properties	2	key	Full Refresh
62	issue_votes	4		Full Refresh
63	webhooks	4
64	workflow_transition_properties	3
65	issue_fields	10	id	Full Refresh
66	users_groups_detailed	14	accountId	Full Refresh

Table: projects

No	Column Name	Type	Notes
1	components	VARCHAR
2	roles	VARCHAR
3	description	VARCHAR
4	isPrivate	BOOLEAN
5	uuid	VARCHAR
6	deletedBy	VARCHAR
7	issueTypes	VARCHAR
8	archived	BOOLEAN
9	projectCategory	VARCHAR
10	permissions	VARCHAR
11	id	VARCHAR	Primary Key
12	assigneeType	VARCHAR
13	projectTypeKey	VARCHAR
14	archivedBy	VARCHAR
15	key	VARCHAR
16	email	VARCHAR
17	archivedDate	VARCHAR
18	retentionTillDate	VARCHAR
19	avatarUrls	VARCHAR
20	favourite	BOOLEAN
21	lead	VARCHAR
22	url	VARCHAR
23	insight	VARCHAR
24	expand	VARCHAR
25	deleted	BOOLEAN
26	simplified	BOOLEAN
27	versions	VARCHAR
28	deletedDate	VARCHAR
29	issueTypeHierarchy	VARCHAR
30	name	VARCHAR
31	self	VARCHAR
32	style	VARCHAR
33	properties	VARCHAR

Table: jql

No	Column Name	Type	Notes
1	visibleFieldNames	VARCHAR
2	visibleFunctionNames	VARCHAR
3	jqlReservedWords	VARCHAR

Table: issue_link_types

No	Column Name	Type	Notes
1	inward	VARCHAR
2	name	VARCHAR
3	self	VARCHAR
4	id	VARCHAR	Primary Key
5	outward	VARCHAR

Table: issue_comments

No	Column Name	Type	Notes
1	renderedBody	VARCHAR
2	visibility	VARCHAR
3	author	VARCHAR
4	created	VARCHAR
5	updateAuthor	VARCHAR
6	self	VARCHAR
7	jsdPublic	BOOLEAN
8	id	VARCHAR	Primary Key
9	body	VARCHAR
10	updated	VARCHAR	Incremental sync key
11	properties	VARCHAR

Table: dashboards

No	Column Name	Type	Notes
1	owner	VARCHAR
2	view	VARCHAR
3	popularity	INTEGER
4	name	VARCHAR
5	description	VARCHAR
6	rank	INTEGER
7	self	VARCHAR
8	id	VARCHAR	Primary Key
9	sharePermissions	VARCHAR
10	isFavourite	BOOLEAN

Table: issues

No	Column Name	Type	Notes
1	schema	VARCHAR
2	created	VARCHAR
3	editmeta	VARCHAR
4	fieldsToInclude	VARCHAR
5	changelog	VARCHAR
6	transitions	VARCHAR
7	renderedFields	VARCHAR
8	expand	VARCHAR
9	projectKey	VARCHAR
10	names	VARCHAR
11	operations	VARCHAR
12	versionedRepresentations	VARCHAR
13	self	VARCHAR
14	id	VARCHAR	Primary Key
15	fields	VARCHAR
16	projectId	VARCHAR
17	updated	VARCHAR	Incremental sync key
18	key	VARCHAR
19	properties	VARCHAR

Table: pull_requests

No	Column Name	Type	Notes
1	repositories	VARCHAR
2	id	VARCHAR
3	pullRequests	VARCHAR
4	branches	VARCHAR
5	updated	VARCHAR
6	_instance	VARCHAR

Table: project_components

No	Column Name	Type	Notes
1	leadUserName	VARCHAR
2	description	VARCHAR
3	project	VARCHAR
4	leadAccountId	VARCHAR
5	lead	VARCHAR
6	isAssigneeTypeValid	BOOLEAN
7	realAssigneeType	VARCHAR
8	name	VARCHAR
9	self	VARCHAR
10	realAssignee	VARCHAR
11	id	VARCHAR	Primary Key
12	assigneeType	VARCHAR
13	assignee	VARCHAR
14	projectId	INTEGER

Table: issue_notification_schemes

No	Column Name	Type	Notes
1	expand	VARCHAR
2	scope	VARCHAR
3	name	VARCHAR
4	self	VARCHAR
5	description	VARCHAR
6	id	INTEGER	Primary Key
7	notificationSchemeEvents	VARCHAR

Table: permissions

No	Column Name	Type	Notes
1	name	VARCHAR
2	description	VARCHAR
3	type	VARCHAR
4	key	VARCHAR	Primary Key

Table: sprints

No	Column Name	Type	Notes
1	originBoardId	INTEGER
2	goal	VARCHAR
3	endDate	VARCHAR
4	name	VARCHAR
5	self	VARCHAR
6	id	INTEGER	Primary Key
7	state	VARCHAR
8	startDate	VARCHAR
9	completeDate	VARCHAR

Table: workflow_status_categories

No	Column Name	Type	Notes
1	colorName	VARCHAR
2	name	VARCHAR
3	self	VARCHAR
4	id	INTEGER	Primary Key
5	key	VARCHAR

Table: avatars

No	Column Name	Type	Notes
1	owner	VARCHAR
2	isDeletable	BOOLEAN
3	fileName	VARCHAR
4	urls	VARCHAR
5	isSystemAvatar	BOOLEAN
6	isSelected	BOOLEAN
7	id	VARCHAR	Primary Key

Table: screen_tabs

No	Column Name	Type	Notes
1	name	VARCHAR
2	id	INTEGER	Primary Key

Table: jira_settings

No	Column Name	Type	Notes
1	allowedValues	VARCHAR
2	defaultValue	VARCHAR
3	name	VARCHAR
4	id	VARCHAR	Primary Key
5	type	VARCHAR
6	value	VARCHAR
7	key	VARCHAR
8	desc	VARCHAR
9	example	VARCHAR

Table: board_issues

No	Column Name	Type	Notes
1	expand	VARCHAR
2	created	VARCHAR
3	self	VARCHAR
4	boardId	INTEGER
5	id	VARCHAR	Primary Key
6	fields	VARCHAR
7	updated	VARCHAR	Incremental sync key
8	key	VARCHAR

Table: issue_resolutions

No	Column Name	Type	Notes
1	name	VARCHAR
2	self	VARCHAR
3	description	VARCHAR
4	id	VARCHAR	Primary Key

Table: users

No	Column Name	Type	Notes
1	avatarUrls	VARCHAR
2	displayName	VARCHAR
3	accountType	VARCHAR
4	active	BOOLEAN
5	timeZone	VARCHAR
6	groups	VARCHAR
7	locale	VARCHAR
8	accountId	VARCHAR	Primary Key
9	emailAddress	VARCHAR
10	expand	VARCHAR
11	name	VARCHAR
12	self	VARCHAR
13	key	VARCHAR
14	applicationRoles	VARCHAR

Table: labels

No	Column Name	Type	Notes
1	label	VARCHAR	Primary Key

Table: issue_type_schemes

No	Column Name	Type	Notes
1	isDefault	BOOLEAN
2	defaultIssueTypeId	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	id	VARCHAR	Primary Key

Table: issue_custom_field_contexts

No	Column Name	Type	Notes
1	name	VARCHAR
2	description	VARCHAR
3	id	VARCHAR	Primary Key
4	isGlobalContext	BOOLEAN
5	isAnyIssueType	BOOLEAN

Table: workflow_statuses

No	Column Name	Type	Notes
1	name	VARCHAR
2	self	VARCHAR
3	description	VARCHAR
4	iconUrl	VARCHAR
5	id	VARCHAR	Primary Key
6	statusCategory	VARCHAR

Table: project_email

No	Column Name	Type	Notes
1	emailAddress	VARCHAR
2	projectId	VARCHAR	Primary Key

Table: issue_comment_properties

No	Column Name	Type	Notes
1	value	VARCHAR
2	key	VARCHAR

Table: filter_sharing

No	Column Name	Type	Notes
1	role	VARCHAR
2	project	VARCHAR
3	id	INTEGER	Primary Key
4	type	VARCHAR
5	group	VARCHAR

Table: issue_field_configurations

No	Column Name	Type	Notes
1	isDefault	BOOLEAN
2	name	VARCHAR
3	description	VARCHAR
4	id	INTEGER	Primary Key

Table: audit_records

No	Column Name	Type	Notes
1	summary	VARCHAR
2	changedValues	VARCHAR
3	objectItem	VARCHAR
4	created	VARCHAR
5	authorKey	VARCHAR
6	eventSource	VARCHAR
7	description	VARCHAR
8	associatedItems	VARCHAR
9	id	INTEGER
10	category	VARCHAR
11	remoteAddress	VARCHAR

Table: issue_security_schemes

No	Column Name	Type	Notes
1	name	VARCHAR
2	self	VARCHAR
3	description	VARCHAR
4	defaultSecurityLevelId	INTEGER
5	id	INTEGER	Primary Key
6	levels	VARCHAR

Table: workflow_scheme_drafts

No	Column Name	Type	Notes
1	originalDefaultWorkflow	VARCHAR
2	description	VARCHAR
3	issueTypes	VARCHAR
4	originalIssueTypeMappings	VARCHAR
5	defaultWorkflow	VARCHAR
6	updateDraftIfNeeded	BOOLEAN
7	draft	BOOLEAN
8	name	VARCHAR
9	self	VARCHAR
10	lastModifiedUser	VARCHAR
11	id	INTEGER
12	lastModified	VARCHAR
13	issueTypeMappings	VARCHAR

Table: issue_worklogs

No	Column Name	Type	Notes
1	issueId	VARCHAR
2	visibility	VARCHAR
3	timeSpent	VARCHAR
4	author	VARCHAR
5	created	VARCHAR
6	started	VARCHAR
7	timeSpentSeconds	INTEGER
8	updateAuthor	VARCHAR
9	self	VARCHAR
10	comment	VARCHAR
11	id	VARCHAR	Primary Key
12	updated	VARCHAR	Incremental sync key
13	properties	VARCHAR

Table: screen_schemes

No	Column Name	Type	Notes
1	issueTypeScreenSchemes	VARCHAR
2	screens	VARCHAR
3	name	VARCHAR
4	description	VARCHAR
5	id	INTEGER	Primary Key

Table: workflow_transition_rules

No	Column Name	Type	Notes
1	postFunctions	VARCHAR
2	validators	VARCHAR
3	conditions	VARCHAR
4	workflowId	VARCHAR

Table: permission_schemes

No	Column Name	Type	Notes
1	expand	VARCHAR
2	permissions	VARCHAR
3	scope	VARCHAR
4	name	VARCHAR
5	self	VARCHAR
6	description	VARCHAR
7	id	INTEGER	Primary Key

Table: issue_priorities

No	Column Name	Type	Notes
1	statusColor	VARCHAR
2	name	VARCHAR
3	self	VARCHAR
4	description	VARCHAR
5	iconUrl	VARCHAR
6	id	VARCHAR	Primary Key

Table: issue_type_screen_schemes

No	Column Name	Type	Notes
1	name	VARCHAR
2	description	VARCHAR
3	id	VARCHAR	Primary Key

Table: boards

No	Column Name	Type	Notes
1	projectKey	VARCHAR
2	name	VARCHAR
3	self	VARCHAR
4	id	INTEGER	Primary Key
5	type	VARCHAR
6	projectId	VARCHAR

Table: workflows

No	Column Name	Type	Notes
1	description	VARCHAR
2	statuses	VARCHAR
3	id	VARCHAR	Primary Key
4	transitions	VARCHAR

Table: project_types

No	Column Name	Type	Notes
1	descriptionI18nKey	VARCHAR
2	color	VARCHAR
3	icon	VARCHAR
4	key	VARCHAR
5	formattedKey	VARCHAR

Table: issue_remote_links

No	Column Name	Type	Notes
1	application	VARCHAR
2	globalId	VARCHAR
3	self	VARCHAR
4	id	INTEGER	Primary Key
5	relationship	VARCHAR
6	object	VARCHAR

Table: project_versions

No	Column Name	Type	Notes
1	releaseDate	VARCHAR
2	description	VARCHAR
3	project	VARCHAR
4	archived	BOOLEAN
5	expand	VARCHAR
6	operations	VARCHAR
7	overdue	BOOLEAN
8	name	VARCHAR
9	self	VARCHAR
10	moveUnfixedIssuesTo	VARCHAR
11	userReleaseDate	VARCHAR
12	id	VARCHAR	Primary Key
13	userStartDate	VARCHAR
14	projectId	INTEGER
15	released	BOOLEAN
16	startDate	VARCHAR
17	issuesStatusForFixVersion	VARCHAR

Table: dynamic_modules

No	Column Name	Type	Notes
1	modules	VARCHAR

Table: issue_type_properties

No	Column Name	Type	Notes
1	value	VARCHAR
2	key	VARCHAR

Table: screens

No	Column Name	Type	Notes
1	scope	VARCHAR
2	name	VARCHAR
3	description	VARCHAR
4	id	INTEGER	Primary Key

Table: issue_navigator_settings

No	Column Name	Type	Notes
1	label	VARCHAR
2	value	VARCHAR

Table: workflow_schemes

No	Column Name	Type	Notes
1	originalDefaultWorkflow	VARCHAR
2	description	VARCHAR
3	issueTypes	VARCHAR
4	originalIssueTypeMappings	VARCHAR
5	defaultWorkflow	VARCHAR
6	updateDraftIfNeeded	BOOLEAN
7	draft	BOOLEAN
8	name	VARCHAR
9	self	VARCHAR
10	lastModifiedUser	VARCHAR
11	id	INTEGER	Primary Key
12	lastModified	VARCHAR
13	issueTypeMappings	VARCHAR

Table: application_roles

No	Column Name	Type	Notes
1	defaultGroups	VARCHAR
2	hasUnlimitedSeats	BOOLEAN
3	groupDetails	VARCHAR
4	groups	VARCHAR
5	remainingSeats	INTEGER
6	selectedByDefault	BOOLEAN
7	platform	BOOLEAN
8	numberOfSeats	INTEGER
9	userCount	INTEGER
10	userCountDescription	VARCHAR
11	name	VARCHAR
12	key	VARCHAR	Primary Key
13	defined	BOOLEAN

Table: time_tracking

No	Column Name	Type	Notes
1	name	VARCHAR
2	key	VARCHAR	Primary Key
3	url	VARCHAR

Table: sprint_issues

No	Column Name	Type	Notes
1	sprintId	INTEGER
2	expand	VARCHAR
3	issueId	VARCHAR
4	created	VARCHAR
5	self	VARCHAR
6	id	VARCHAR	Primary Key
7	fields	VARCHAR
8	updated	VARCHAR	Incremental sync key
9	key	VARCHAR

Table: issue_watchers

No	Column Name	Type	Notes
1	self	VARCHAR
2	watchers	VARCHAR
3	isWatching	BOOLEAN
4	watchCount	INTEGER

Table: issue_custom_field_options_apps

No	Column Name	Type	Notes
1	id	INTEGER
2	value	VARCHAR
3	config	VARCHAR
4	properties	VARCHAR

Table: project_categories

No	Column Name	Type	Notes
1	name	VARCHAR
2	self	VARCHAR
3	description	VARCHAR
4	id	VARCHAR	Primary Key

Table: project_permission_schemes

No	Column Name	Type	Notes
1	name	VARCHAR
2	self	VARCHAR
3	description	VARCHAR
4	id	VARCHAR	Primary Key

Table: screen_tab_fields

No	Column Name	Type	Notes
1	name	VARCHAR
2	id	VARCHAR	Primary Key

Table: groups

No	Column Name	Type	Notes
1	groupId	VARCHAR	Primary Key
2	name	VARCHAR

Table: filters

No	Column Name	Type	Notes
1	owner	VARCHAR
2	subscriptions	VARCHAR
3	jql	VARCHAR
4	favouritedCount	INTEGER
5	description	VARCHAR
6	favourite	BOOLEAN
7	isWritable	BOOLEAN
8	expand	VARCHAR
9	name	VARCHAR
10	viewUrl	VARCHAR
11	self	VARCHAR
12	searchUrl	VARCHAR
13	id	VARCHAR	Primary Key
14	sharePermissions	VARCHAR

Table: issue_types

No	Column Name	Type	Notes
1	avatarId	INTEGER
2	hierarchyLevel	INTEGER
3	scope	VARCHAR
4	name	VARCHAR
5	self	VARCHAR
6	description	VARCHAR
7	entityId	VARCHAR
8	id	VARCHAR
9	iconUrl	VARCHAR
10	subtask	BOOLEAN

Table: project_avatars

No	Column Name	Type	Notes
1	owner	VARCHAR
2	isDeletable	BOOLEAN
3	fileName	VARCHAR
4	urls	VARCHAR
5	isSystemAvatar	BOOLEAN
6	isSelected	BOOLEAN
7	id	VARCHAR	Primary Key

Table: server_info

No	Column Name	Type	Notes
1	healthChecks	VARCHAR
2	baseUrl	VARCHAR
3	deploymentType	VARCHAR
4	scmInfo	VARCHAR
5	serverTime	VARCHAR
6	buildDate	VARCHAR
7	serverTitle	VARCHAR
8	version	VARCHAR
9	buildNumber	INTEGER
10	versionNumbers	VARCHAR

Table: issue_custom_field_options

No	Column Name	Type	Notes
1	optionId	VARCHAR
2	disabled	BOOLEAN
3	id	VARCHAR
4	value	VARCHAR

Table: workflow_scheme_project_associations

No	Column Name	Type	Notes
1	projectIds	VARCHAR
2	workflowScheme	VARCHAR

Table: issue_properties

No	Column Name	Type	Notes
1	value	VARCHAR
2	key	VARCHAR	Primary Key

Table: issue_votes

No	Column Name	Type	Notes
1	hasVoted	BOOLEAN
2	voters	VARCHAR
3	self	VARCHAR
4	votes	INTEGER

Table: webhooks

No	Column Name	Type	Notes
1	jqlFilter	VARCHAR
2	id	INTEGER
3	events	VARCHAR
4	expirationDate	INTEGER

Table: workflow_transition_properties

No	Column Name	Type	Notes
1	id	VARCHAR
2	value	VARCHAR
3	key	VARCHAR

Table: issue_fields

No	Column Name	Type	Notes
1	schema	VARCHAR
2	navigable	BOOLEAN
3	orderable	BOOLEAN
4	custom	BOOLEAN
5	scope	VARCHAR
6	name	VARCHAR
7	clauseNames	VARCHAR
8	id	VARCHAR	Primary Key
9	key	VARCHAR
10	searchable	BOOLEAN

Table: users_groups_detailed

No	Column Name	Type	Notes
1	avatarUrls	VARCHAR
2	displayName	VARCHAR
3	accountType	VARCHAR
4	active	BOOLEAN
5	timeZone	VARCHAR
6	groups	VARCHAR
7	locale	VARCHAR
8	accountId	VARCHAR	Primary Key
9	emailAddress	VARCHAR
10	expand	VARCHAR
11	name	VARCHAR
12	self	VARCHAR
13	key	VARCHAR
14	applicationRoles	VARCHAR

External Resources

• Documentation
• Application Roles
• Filter Sharing
• Issue Fields
• Issue Field Configurations
• Issue Custom Field Contexts
• Issue Link Types
• Issue Navigator Settings
• Issue Notification Schemes
• Issue Priorities
• Issue Properties
• Issue Remote Links
• Issue Resolutions
• Issue Security Schemes
• Issue Type Schemes
• Issue Type Screen Schemes
• Issue Votes
• Issue Watchers
• Jira Settings
• Permission Schemes
• Project Avatars
• Project Categories
• Project Components
• Project Email
• Project Permission Schemes
• Project Types
• Project Versions
• Screen Tabs
• Screen Tab Fields
• Screen Schemes
• Time Tracking
• Usersgroupsdetailed
• Workflow Schemes
• Workflow Statuses
• Workflow Status Categories
• Board Issues
• Issue Comments
• Issue Worklogs
• Sprint Issues

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.