← Pipedream + Jira integrations

Search Issues with JQL with Jira API on Card Due Date Reminder from Pipedream API

Pipedream makes it easy to connect APIs for Jira, Pipedream and 2,800+ other apps remarkably fast.

Trigger workflow on
Card Due Date Reminder from the Pipedream API
Next, do this
Search Issues with JQL with the Jira API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo

Developers Pipedream

Getting Started

This integration creates a workflow with a Pipedream trigger and Jira action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the Card Due Date Reminder trigger
    1. Connect your Pipedream account
    2. Connect your Pipedream account
    3. Select a Board
    4. Select a Time Before
  3. Configure the Search Issues with JQL action
    1. Connect your Jira account
    2. Select a Cloud ID
    3. Configure JQL Query
    4. Optional- Configure Max Results
    5. Optional- Configure Fields
    6. Optional- Select one or more Expand
    7. Optional- Configure Properties
    8. Optional- Configure Fields by Keys
    9. Optional- Configure Fail Fast
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger

Description:Emit new event at a specified time before a card is due.
Version:0.1.3
Key:trello-card-due-date-reminder

Pipedream Overview

Pipedream is an API that allows you to build applications that can connect to
various data sources and processes them in real-time. You can use Pipedream to
create applications that can perform ETL (Extract, Transform, and Load) tasks,
as well as to create data-driven workflows.

Some examples of applications you can build using the Pipedream API include:

  • An application that can extract data from a database, transform it, and then
    load it into another database.
  • An application that can monitor a data source for changes, and then trigger a
    workflow in response to those changes.
  • An application that can poll an API for new data, and then process that data
    in real-time.

Trigger Code

import ms from "ms"; import taskScheduler from "../../../pipedream/sources/new-scheduled-tasks/new-scheduled-tasks.mjs"; import constants from "../../common/constants.mjs"; import trello from "../../trello.app.mjs"; import sampleEmit from "./test-event.mjs"; export default { key: "trello-card-due-date-reminder", name: "Card Due Date Reminder", /* eslint-disable-line pipedream/source-name */ description: "Emit new event at a specified time before a card is due.", version: "0.1.3", type: "source", dedupe: "unique", props: { pipedream: taskScheduler.props.pipedream, trello, db: "$.service.db", http: "$.interface.http", board: { propDefinition: [ trello, "board", ], }, timeBefore: { type: "string", label: "Time Before", description: "How far before the due time the event should trigger. For example, `5 minutes`, `10 minutes`, `1 hour`.", default: "5 minutes", options: constants.NOTIFICATION_TIMES, reloadProps: true, }, }, async additionalProps() { const props = {}; if (this.timeBefore) { props.timer = { type: "$.interface.timer", description: "Poll the API to schedule alerts for any newly created events", default: { intervalSeconds: ms(this.timeBefore) / 1000, }, }; } return props; }, hooks: { async deactivate() { const ids = this._getScheduledEventIds(); if (!ids?.length) { return; } for (const id of ids) { if (await this.deleteEvent({ body: { id, }, })) { console.log("Cancelled scheduled event"); } } this._setScheduledEventIds(); }, }, methods: { ...taskScheduler.methods, generateMeta({ id, name: summary, }, now) { return { id, summary, ts: now, }; }, _getScheduledEventIds() { return this.db.get("scheduledEventIds"); }, _setScheduledEventIds(ids) { this.db.set("scheduledEventIds", ids); }, _getScheduledCardIds() { return this.db.get("scheduledCardIds"); }, _setScheduledCardIds(ids) { this.db.set("scheduledCardIds", ids); }, _hasDeployed() { const result = this.db.get("hasDeployed"); this.db.set("hasDeployed", true); return result; }, emitEvent(card, now) { const meta = this.generateMeta(card, now); this.$emit(card, meta); }, }, async run(event) { const now = event.timestamp * 1000; // self subscribe only on the first time if (!this._hasDeployed()) { await this.selfSubscribe(); } let scheduledEventIds = this._getScheduledEventIds() || []; // incoming scheduled event if (event.$channel === this.selfChannel()) { const remainingScheduledEventIds = scheduledEventIds.filter((id) => id !== event["$id"]); this._setScheduledEventIds(remainingScheduledEventIds); this.emitEvent(event, now); return; } // schedule new events const scheduledCardIds = this._getScheduledCardIds() || {}; const cards = await this.trello.getCards({ boardId: this.board, }); for (const card of cards) { const dueDate = card.due ? new Date(card.due) : null; if (!dueDate || dueDate.getTime() < Date.now()) { delete scheduledCardIds[card.id]; continue; } const later = new Date(dueDate.getTime() - ms(this.timeBefore)); if (scheduledCardIds[card.id]) { // reschedule if card's due date has changed if (card.due !== scheduledCardIds[card.id].dueDate) { await this.deleteEvent({ body: { id: scheduledCardIds[card.id].eventId, }, }); scheduledEventIds = scheduledEventIds .filter((id) => id !== scheduledCardIds[card.id].eventId); } else { continue; } } const scheduledEventId = this.emitScheduleEvent(card, later); scheduledEventIds.push(scheduledEventId); scheduledCardIds[card.id] = { eventId: scheduledEventId, dueDate: card.due, }; } this._setScheduledEventIds(scheduledEventIds); this._setScheduledCardIds(scheduledCardIds); }, sampleEmit, }; 

Trigger Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
PipedreampipedreamappThis component uses the Pipedream app.
PipedreamtrelloappThis component uses the Pipedream app.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
BoardboardstringSelect a value from the drop down menu.
Time BeforetimeBeforestringSelect a value from the drop down menu:5 minutes10 minutes15 minutes30 minutes1 hour2 hours3 hours6 hours12 hours1 day2 days3 days1 week

Trigger Authentication

Pipedream uses API keys for authentication. When you connect your Pipedream account, Pipedream securely stores the keys so you can easily authenticate to Pipedream APIs in both code and no-code steps.

About Pipedream

Integration platform for developers

Action

Description:Search for issues using JQL (Jira Query Language). [See the documentation](https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-jql-get)
Version:0.1.1
Key:jira-search-issues-with-jql

Jira Overview

The Jira API opens up a world of possibilities for automating project management tasks, syncing with other tools, and enhancing data visibility. With Pipedream's integration, you can streamline issue tracking by automatically creating, updating, and searching for issues in Jira, as well as managing projects, sprints, users, and more. This integration not only saves time but also ensures real-time data flow across various platforms, keeping teams in sync and projects on track.

Action Code

import jira from "../../jira.app.mjs"; export default { name: "Search Issues with JQL", description: "Search for issues using JQL (Jira Query Language). [See the documentation](https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-jql-get)", key: "jira-search-issues-with-jql", version: "0.1.1", annotations: { destructiveHint: false, openWorldHint: true, readOnlyHint: true, }, type: "action", props: { jira, cloudId: { propDefinition: [ jira, "cloudId", ], }, jql: { type: "string", label: "JQL Query", description: "The JQL query to search for issues. [See the documentation for syntax and examples](https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/)", }, maxResults: { type: "integer", label: "Max Results", description: "Maximum number of issues to return (default: 50)", optional: true, default: 50, min: 1, max: 5000, }, fields: { type: "string", label: "Fields", description: "Comma-separated list of fields to return for each issue", default: "*all", optional: true, }, expand: { type: "string[]", label: "Expand", description: "Use expand to include additional information about the issues in the response", optional: true, options: [ { label: "Returns field values rendered in HTML format", value: "renderedFields", }, { label: "Returns the display name of each field", value: "names", }, { label: "Returns the schema describing a field type", value: "schema", }, { label: "Returns all possible transitions for the issue", value: "transitions", }, { label: "Returns information about how each field can be edited", value: "editmeta", }, { label: "Returns a list of recent updates to an issue, sorted by date, starting from the most recent", value: "changelog", }, { label: "Returns a JSON array for each version of a field's value, with the highest number representing the most recent version", value: "versionedRepresentations", }, ], }, properties: { type: "string", label: "Properties", description: "A list of up to 5 issue properties to include in the results. This parameter accepts a comma-separated list.", optional: true, }, fieldsByKeys: { type: "boolean", label: "Fields by Keys", description: "Reference fields by their key (rather than ID). The default is `false`.", optional: true, }, failFast: { type: "boolean", label: "Fail Fast", description: "Fail this request early if we can't retrieve all field data", optional: true, }, }, methods: { getMaxResultsPerPage() { return Math.min(this.maxResults, 1000); }, async paginate({ params, maxResults, ...otherArgs }) { const results = []; let nextPageToken; let response; do { response = await this.jira.searchIssues({ ...otherArgs, params: { ...params, ...(nextPageToken && { nextPageToken, }), }, }); const pageResults = response.issues; const pageLength = pageResults?.length; if (!pageLength) { break; } // If maxResults is specified, only add what we need if (maxResults && results.length + pageLength > maxResults) { const remainingSlots = maxResults - results.length; results.push(...pageResults.slice(0, remainingSlots)); break; } else { results.push(...pageResults); } // Also break if we've reached maxResults exactly if (maxResults && results.length >= maxResults) { break; } nextPageToken = response.nextPageToken; } while (nextPageToken && !response.isLast); return results; }, }, async run({ $ }) { try { const issues = await this.paginate({ $, cloudId: this.cloudId, params: { jql: this.jql, maxResults: this.getMaxResultsPerPage(), fields: this.fields, expand: this.expand ? this.expand.join(",") : undefined, properties: this.properties, fieldsByKeys: this.fieldsByKeys, failFast: this.failFast, }, maxResults: this.maxResults, }); $.export("$summary", `Successfully retrieved ${issues.length} issues`); return { issues, }; } catch (error) { throw new Error(`Failed to search issues: ${error.message}`); } }, }; 

Action Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

LabelPropTypeDescription
JirajiraappThis component uses the Jira app.
Cloud IDcloudIdstringSelect a value from the drop down menu.
JQL Queryjqlstring

The JQL query to search for issues. See the documentation for syntax and examples

Max ResultsmaxResultsinteger

Maximum number of issues to return (default: 50)

Fieldsfieldsstring

Comma-separated list of fields to return for each issue

Expandexpandstring[]Select a value from the drop down menu:{ "label": "Returns field values rendered in HTML format", "value": "renderedFields" }{ "label": "Returns the display name of each field", "value": "names" }{ "label": "Returns the schema describing a field type", "value": "schema" }{ "label": "Returns all possible transitions for the issue", "value": "transitions" }{ "label": "Returns information about how each field can be edited", "value": "editmeta" }{ "label": "Returns a list of recent updates to an issue, sorted by date, starting from the most recent", "value": "changelog" }{ "label": "Returns a JSON array for each version of a field's value, with the highest number representing the most recent version", "value": "versionedRepresentations" }
Propertiespropertiesstring

A list of up to 5 issue properties to include in the results. This parameter accepts a comma-separated list.

Fields by KeysfieldsByKeysboolean

Reference fields by their key (rather than ID). The default is false.

Fail FastfailFastboolean

Fail this request early if we can't retrieve all field data

Action Authentication

Jira uses OAuth authentication. When you connect your Jira account, Pipedream will open a popup window where you can sign into Jira and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Jira API.

Pipedream requests the following authorization scopes when you connect your account:

read:jira-workmanage:jira-projectread:jira-userwrite:jira-workmanage:jira-data-providerread:meoffline_accessread:issue-details:jiraread:board-scope:jira-softwareread:webhook:jirawrite:webhook:jiraread:field:jiraread:project:jiradelete:webhook:jirawrite:board-scope:jira-softwareread:board-scope.admin:jira-softwareread:sprint:jira-softwarewrite:sprint:jira-softwareread:field.option:jirawrite:field.option:jiraread:custom-field-contextual-configuration:jira write:custom-field-contextual-configuration:jiramanage:jira-configurationread:jql:jira

About Jira

Jira is the #1 agile project management tool used by teams to plan, track, release, and support great software with confidence

More Ways to Connect Jira + Pipedream

Create a Subscription with Pipedream API on New Event from Jira API
Jira + Pipedream
 
Try it
Create a Subscription with Pipedream API on New Issue Created Event from Jira API
Jira + Pipedream
 
Try it
Create a Subscription with Pipedream API on New Issue Deleted Event from Jira API
Jira + Pipedream
 
Try it
Create a Subscription with Pipedream API on New Issue Updated Event from Jira API
Jira + Pipedream
 
Try it
Delete a Subscription with Pipedream API on New Event from Jira API
Jira + Pipedream
 
Try it
Delete a Subscription with Pipedream API on New Issue Created Event from Jira API
Jira + Pipedream
 
Try it
Delete a Subscription with Pipedream API on New Issue Deleted Event from Jira API
Jira + Pipedream
 
Try it
Delete a Subscription with Pipedream API on New Issue Updated Event from Jira API
Jira + Pipedream
 
Try it
Get Component with Pipedream API on New Event from Jira API
Jira + Pipedream
 
Try it
Get Component with Pipedream API on New Issue Created Event from Jira API
Jira + Pipedream
 
Try it
Get Component with Pipedream API on New Issue Deleted Event from Jira API
Jira + Pipedream
 
Try it
Get Component with Pipedream API on New Issue Updated Event from Jira API
Jira + Pipedream
 
Try it
Generate Component Code with Pipedream API on New Event from Jira API
Jira + Pipedream
 
Try it
Generate Component Code with Pipedream API on New Issue Created Event from Jira API
Jira + Pipedream
 
Try it
Generate Component Code with Pipedream API on New Issue Deleted Event from Jira API
Jira + Pipedream
 
Try it
Generate Component Code with Pipedream API on New Issue Updated Event from Jira API
Jira + Pipedream
 
Try it
JIRA - Create Issue with Jira API on New Scheduled Tasks (Alpha) from Pipedream API
Pipedream + Jira
 
Try it
JIRA - Get All Projects with Jira API on New Scheduled Tasks (Alpha) from Pipedream API
Pipedream + Jira
 
Try it
Add Comment To Issue with Jira API on New Scheduled Tasks (Alpha) from Pipedream API
Pipedream + Jira
 
Try it
Create Jira Version in project with Jira API on New Scheduled Tasks (Alpha) from Pipedream API
Pipedream + Jira
 
Try it
New Scheduled Tasks from the Pipedream API

Exposes an HTTP API for scheduling messages to be emitted at a future time

 
Try it
Card Due Date Reminder from the Pipedream API

Emit new event at a specified time before a card is due.

 
Try it
New Upcoming Calendar Event from the Pipedream API

Emit new event when a Calendar event is upcoming, this source is using reminderMinutesBeforeStart property of the event to determine the time it should emit.

 
Try it
New Event from the Jira API

Emit new event when an event with subscribed event source triggered, See the docs

 
Try it
New Issue Created Event (Instant) from the Jira API

Emit new event when an issue is created. Note that Jira supports only one webhook, if more sources are needed please use New Event source and select multiple events.

 
Try it
New Issue Deleted Event (Instant) from the Jira API

Emit new event when an issue is deleted. Note that Jira supports only one webhook, if more sources are needed please use New Event source and select multiple events.

 
Try it
New Issue Updated Event (Instant) from the Jira API

Emit new event when an issue is updated. Note that Jira supports only one webhook, if more sources are needed please use New Event source and select multiple events.

 
Try it
Create a Subscription with the Pipedream API

Create a Subscription. See Doc

 
Try it
Delete a Subscription with the Pipedream API

Delete a Subscription. See Doc

 
Try it
Generate Component Code with the Pipedream API

Generate component code using AI.

 
Try it
Get Component with the Pipedream API

Get info for a published component. See docs

 
Try it
Add Attachment To Issue with the Jira API

Adds an attachment to an issue, See the docs

 
Try it
Add Comment To Issue with the Jira API

Adds a new comment to an issue, See the docs

 
Try it
Add Multiple Attachments To Issue with the Jira API

Adds multiple attachments to an issue, See the docs

 
Try it
Add Watcher To Issue with the Jira API

Adds a user as a watcher of an issue by passing the account ID of the user, For example, 5b10ac8d82e05b22cc7d4ef5, If no user is specified the calling user is added. See the docs

 
Try it
Assign Issue with the Jira API

Assigns an issue to a user. See the docs

 
Try it
Create Custom Field Options (Context) with the Jira API

Create a context for custom field options. See the documentation here

 
Try it
Create Issue with the Jira API

Creates an issue or, where the option to create subtasks is enabled in Jira, a subtask, See the docs

 
Try it
Create Jira Version in project with the Jira API

Creates a project version., See the docs

 
Try it
Delete Project with the Jira API

Deletes a project, See the docs

 
Try it
Get All Projects with the Jira API

Gets metadata on all projects, See the docs

 
Try it
Get Issue with the Jira API

Gets the details for an issue. See the docs

 
Try it
Get Task with the Jira API

Gets the status of a long-running asynchronous task, See the docs

 
Try it
Get Transitions with the Jira API

Gets either all transitions or a transition that can be performed by the user on an issue, based on the issue's status, See the docs

 
Try it
Get User with the Jira API

Gets details of user, See the docs

 
Try it
Get Users with the Jira API

Gets details of a list of users. See docs here

 
Try it
List Issue Comments with the Jira API

Lists all comments for an issue, See the docs

 
Try it
Search Issues with JQL with the Jira API

Search for issues using JQL (Jira Query Language). See the documentation

 
Try it
Transition Issue with the Jira API

Performs an issue transition and, if the transition has a screen, updates the fields from the transition screen, See the docs

 
Try it
Update Comment with the Jira API

Updates a comment, See the docs

 
Try it
Update Issue with the Jira API

Updates an issue. A transition may be applied and issue properties updated as part of the edit, See the docs

 
Try it

Explore Other Apps

1
-
24
of
2,800+
apps by most popular

Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
Premium
AWS
AWS
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Premium
Twilio SendGrid
Twilio SendGrid
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Premium
Klaviyo
Klaviyo
Email Marketing and SMS Marketing Platform
Premium
Zendesk
Zendesk
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
Premium
ServiceNow
ServiceNow
The smarter way to workflow
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.
Slack
Slack
Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.