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?
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
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.
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events