Browse sources$ls -a sources
Logo of jira
Jira
Optimize project management with Jira data integration
Sync your customers' dataFiber pulls data from your customers' Jira accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of jira
Logo of jira
Logo of jira
Logo of jira
Logo of jira
Logo of jira
Logo of jira
Logo of jira
Logo of jira
Logo of jira
Fiber
postgres-prod
jira_issues
jira_projects
jira_boards
Your customers' Jira accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Jira API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Issues belonging to the Jira account
-- of a particular user.

SELECT *
FROM fiber.jira_issue
WHERE account_id = '{user.jira_id}'
-- Fetch all the Issues belonging to the Jira account
-- of a particular user.

SELECT *
FROM fiber.jira_issue
WHERE account_id = '{user.jira_id}'
Code
CREATE TABLE fiber.jira_issue (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
pkey TEXT,
issuenum DOUBLE PRECISION,
project DOUBLE PRECISION,
reporter TEXT,
assignee TEXT,
creator TEXT,
issue_type TEXT,
summary TEXT,
description TEXT,
environment TEXT,
priority TEXT,
resolution TEXT,
issue_status TEXT,
created TIMESTAMP WITH TIME ZONE,
updated TIMESTAMP WITH TIME ZONE,
duedate TIMESTAMP WITH TIME ZONE,
resolution_date TIMESTAMP WITH TIME ZONE,
votes DOUBLE PRECISION,
watches DOUBLE PRECISION,
time_original_estimate DOUBLE PRECISION,
time_estimate DOUBLE PRECISION,
timespent DOUBLE PRECISION,
workflow_id TEXT,
security DOUBLE PRECISION,
fix_for DOUBLE PRECISION,
component DOUBLE PRECISION
)
CREATE TABLE fiber.jira_issue (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
pkey TEXT,
issuenum DOUBLE PRECISION,
project DOUBLE PRECISION,
reporter TEXT,
assignee TEXT,
creator TEXT,
issue_type TEXT,
summary TEXT,
description TEXT,
environment TEXT,
priority TEXT,
resolution TEXT,
issue_status TEXT,
created TIMESTAMP WITH TIME ZONE,
updated TIMESTAMP WITH TIME ZONE,
duedate TIMESTAMP WITH TIME ZONE,
resolution_date TIMESTAMP WITH TIME ZONE,
votes DOUBLE PRECISION,
watches DOUBLE PRECISION,
time_original_estimate DOUBLE PRECISION,
time_estimate DOUBLE PRECISION,
timespent DOUBLE PRECISION,
workflow_id TEXT,
security DOUBLE PRECISION,
fix_for DOUBLE PRECISION,
component DOUBLE PRECISION
)
Model definition
About this source
Logo of Jira
JiraProject management tool for agile teams to track, plan, and manage projects.atlassian.com/software/jira  ↗
Available resources
    Issues
    Projects
    Boards
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Jira?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Jira and over 200 other APIs. Setup and deploy within minutes.
Logo of jiraIntegrate Jira using Fiber Fiber makes it easy to access third-party data from Jira accounts. Get started in just a few minutes.