Contents

Our clients often want to use tools like Jira to manage their business processes faster and more efficiently. But can you integrate Jira with Oracle APEX applications? Of course – here’s what you need to do.

What is Jira Cloud?

Jira is a popular project management solution created by Atlassian. You can use it to manage workflows and tasks within your team easily – thanks to a user-friendly drag&drop interface. It supports various project management methodologies and offers many useful features, including interactive timelines, reports and analytics, and repository integration.

Jira is available in server (local) and cloud (SaaS) versions. However, on February 15, 2024, Atlassian plans to end the support for the server line of its various products (including Jira), which means that half a year from now, many companies will be forced to switch to the cloud variant (or look for other alternatives).

Thankfully, the cloud version of Jira is a good product, and you can easily integrate it with various tools and technologies. And the best thing? It only takes a few minutes – all thanks to the powerful REST API the solution offers (for more information on it, check out the solution’s detailed documentation).

Jira Cloud + Oracle APEX apps – step-by-step guide

First, you’ll need a Jira Cloud account. You can create a free (temporary) account, and this is what we will use here for the purposes of this article. 

My test account is jiracloudtest01.atlassian.net, but use your own account details whenever I mention it throughout the article.

You’ll also need a project. I created a sample project using the Scrum template. There are several Tasks and Bugs in my sprint in different statuses. It looks like this:

A screen showing the project in Jira.

Now, you need to download the list of tasks and bugs from your project to your APEX application. To do this, you will use REST Data Sources that allow developers to access REST services and then use them as a data source in APEX components. Simply put, you will call JIRA REST API and display the response using an interactive report. 

Here’s how to do this:

1. Go to Shared ComponentsData SourcesREST Data Sources and click Create.

2. Select Create REST Data Source – Method and choose From scratch.

A screen showing APEX settings.

3. Now, create the REST Data Source using the following details on the first tab:

REST Data Source Type: Simple HTTP

Name: get issues

URL Endpoint: https://jiracloudtest01.atlassian.net (use your Jira Cloud account here)

A screen showing APEX settings.

4. Setup the Create REST Data Source – Remote Server tab using the following information:

Base URL: https://jiracloudtest01.atlassian.net (again, use your account here)

Service URL Path: /rest/api/3/search

A screen showing APEX settings.

5. Go through the Create REST Data Source – Settings tab and choose No Pagination as the Pagination Type

A screen showing APEX settings.

6. In the Authentication tab, specify that authentication is required by using the switch

Choose the option you want from the list. You can define your credentials in App BuilderWorkspace Utilities All Workspace UtilitiesWeb Credentials

When you’re done, click the Discover button. 

A screen showing APEX settings.

7. The REST Data Source Discovery window displays the response of the REST service. It should look like this:

A screen showing APEX settings.

8. Next, you will need to create an interactive report in your application 

Go to the Location section, and select REST Source in the report settings. Choose get issues from the REST Source drop-down list.

A screen showing APEX settings.

The report will display a list of data from Jira. You can adapt the report to your needs by selecting the appropriate columns. In my case, the end result looks like this:

A screen showing the report.

Conclusion

As you can see, thanks to Jira REST API and REST Data Sources in Oracle APEX, integrating these two solutions is very simple. Jira Cloud provides a powerful REST API that gives us many possibilities, such as downloading a list of projects, a list of issues, and details of custom fields or users. 

Want to learn more about REST Data Sources and create integrations with other applications? Check the Oracle documentation.

If you have any questions regarding this integration, please contact me at lcieslik@pretius.com. Also, be sure to read my other articles on the Pretius blog:

  1. Maps in Oracle APEX – introduction for beginners
  2. Drawing objects on maps in Oracle APEX – MapLibre vs OpenLayers
Share