How to create a JIRA issue using PLSQL code. Whre JIRA is remote server?

[Rudrama Devi]

We have a requirement to create an issue through PLSQL when a concurrent Job completed in oracle apps. 

I am new to using REST APIS of JIRA. So some one could provide me the details oe existing code to use how to creata a JIRA issue through PLSQL code using BAsic authentication?

[Lenin Raj · Accepted solution]

Hi @Rudrama Devi 

I found some references online about how to call REST APIs via PL/SQL: https://technology.amis.nl/2015/05/11/invoke-a-rest-service-from-plsql-make-an-http-post-request-using-utl_http-in-oracle-database-11g-xe/

This is the documentation for creating a new issue: https://developer.atlassian.com/cloud/jira/platform/rest/v3/?utm_source=%2Fcloud%2Fjira%2Fplatform%2Frest%2F&utm_medium=302#api-rest-api-3-issue-post

[Ozan_KURT]

Hi @Rudrama Devi,

I need to create an issue through PLSQL too. I tried UTL_HTTP but cannot get result. Did you get some progress? If so, could you help me? h.ozankurt@gmail.com

[Rudrama Devi]

Hi Ozan,

Based on our analysis we found 2 solutions to integrate Oracle EBS with JIRA

Option 1: Intrgrate Oracle EBS with JIRA through e-mail handler. This is simple. We have to create shared outlook email box and attch it to JIRA project.This is working fine.

Oprion 2: Through PLSQL code .. Our progress on this is 

        We tried sample code and it was failing due to wrong certitificate. So currently we are trying to get correct .pks certificate with ,immediate server details,private key etc. Hoping this will work beacuse we are only getting getting invalid certificate error.Will update you once we tested with new certificate.

[Rudrama Devi]

Thanks Raj for the documents. Really they helpful to understand basic concepts, but need clarifications on below.

1)  Actually when we try to connect to Webservice through REST API using utl_http package we require a certificate to be attached with it.. So is this certificate required for JIRA services also?

2) I could see sample code to create an issue in n Curl,node.js,Java,Python and PHO languages..Can we use any of this code directly in PLSQL?

3) Is there any sample Java code which can create an issue in JIRA that will be called through PLSQL:

Any how thanks much for the documents.

[Ozan_KURT]

@Rudrama Devi Hi, did you get any progress? I am trying to same thing. Could you help me?

[ChandlerBing]

@Ozan_KURT  have you find any solution , I am trying to do same thing