Dears,
I have JSM datacenter edition and I have script runner is this possible to write directly from jira form to external DB ? using script runner or any other tool or automation
@Mohamed Saad Taha -
Please provide more information on your ask -
1) What is the process for?
2) What is the external DB system?
It seems it is a custom development using custom scripting and Atlassian REST APIs to pull the data in JSM and send out JSON payload for downstream processing against your external DB.
https://docs.atlassian.com/jira-servicedesk/REST/4.15.0/
Otherwise, you will need to search in Atlassian Marketplace for possible third party add-ons for external integration.
Hope this helps. Sorry.
Best, Joseph Chung Yin
Dear @Joseph Chung Yin
thansk a lot for your reply and interest
1- creating recorded in database tables after certain workflow steps
2- Database is oracle database
@Mohamed Saad Taha Did you obtain a solution for this? I have a similar task to do and would be very interested in what you were able to discover?Alternatively:@Joseph Chung Yin Do you have any additional information that we may find helpful?After a certain workflow step, we need to make an external callout.One approach would be to call into an Oracle Database and execute a small block of code to pass data from the workflow page.Alternately, we could call out to a Python script.What are the options to make a call out from a page based on a particular step in the workflow to be able to send data from the workflow to an external interface?
@Timothy Madsen -
Welcome to the Community. You can setup automation rules for your project based on transition issue event as a trigger. In your rule, then you can do a WEB REQUEST action to your targeted receiving application. The action will send out the JSON Payload of the issue.
Hope this makes sense.
It looks like you're new here. Sign in or register to get started.
