Jira Scriptrunner for Cloud allows external DB connection?

[Venkat Krishnamoorthy]

Hello,

Scriptrunner for Jira Server has the "Resources" section that allows establishing connection to an external database to pull data and populate fields on a Jira screen. I did not see such an option in Scriptrunner for Jira Cloud. 

Does Scriptrunner for Jira cloud have an alternate way to accomplish this?

Thanks,

Venkat

[Kristian Walker _Adaptavist_ · Accepted solution]

Hi K,

Thank you for your question.

I can confirm that we do not provide the Resources functionality or any functionality to connect to databases with ScriptRunner for Jira Cloud and the reason for this is due to the fact that Atlassian only provides a Rest API in Jira Cloud and does not provide a Java API in the cloud-like they do in Jira Server.

Unfortunately, the rest API's do not provide the API's that would be needed to provide the same database picker fields or resources feature that the server version has, as Atlassian restrict access to the database inside of Jira cloud and due to this, it means it is not possible to have a field which returns values from the database.

You can see more detailed information on the differences between the cloud and server versions inside of our documentation page located here.

I hope this information helps.

Regards,

Kristian

[Venkat Krishnamoorthy]

Thanks a lot Kristian for the prompt response!

[Venkat Krishnamoorthy]

Hey Kristian,

Does Scriptrunner for Jira cloud have a way to read from an Excel spreadsheet and convert each row into Jira Issues? Ideally set that up a nightly scheduled job.

May be if I explain to you what I am trying to accomplish, you can provide me the best possible solution. We have a third-party software that writes new Customer info/record to a database on a daily basis. For each "new" Customer record that got added the previous day we are trying to create a respective Jira Issue. Since we cannot connect to a External database from Jira cloud, I was hoping, if the data got exported to Excel/CSV, can Jira read from that and create Issues.

Thanks

Venkat

[Kristian Walker _Adaptavist_]

Hi Venkat,

In future, Could I request that you raise all new questions as a new question so all users can see these.

Unfortunately it is not possible to read in an Excel file as Atlassian does not provide any API's to read in data from files or provide any access to the file system.

The reason for this is due to the fact that Atlassian only provides a Rest API in Jira Cloud and does not provide a Java API in the cloud-like they do in Jira Server.

You would only be able to read in data from an external system is if the external system provided a Rest API that could be called to get the data from it.

However, Atlassian does provide an import from CSV function inside of Jira as described here which you could run manually to import in issues from a  CSV file you created.

I hope this information helps.
Regards,