Automating export of JIRA issues to SharePoint

Question

Hi all!

We have a business requirement as part of our ISO 27001 certification to keep logs of all service desk incidents (and also change management tickets, which are in a standard JIRA project).

Essentially what I need is the ability to automate an export of all issues that match a filter, to a SharePoint document library.

I've seen various plugins that can do exports but not all are available for JIRA Cloud, so I thought i'd ask on here for some advice. Perhaps there is a way to do this with the JIRA API? I'd rather not have to manually run the report (or pick it up and upload it) myself.

Any advise or guidance would be greatly appreciated.

Thanks,
Harley

Boris Zinchenko · Answer

With Enterprise Bridge you can transform entire JIRA into SharePoint site collection. It will transfer issues, navigation, comments, documents and metadata.

Nic Brough -Adaptavist- · Answer

Yes the "Logs" I mean are the issue histories, which are not editable without database access or broken scripts.  I usually disallow delete which would destroy them.  You would have to trust your administrators to not allow those things to be done.  But, having said that, it's the same with Sharepoint - your admins can still edit or destroy the records or allow them to be altered or removed.

The view thing is the one that makes an export make sense.  Although the data is still in JIRA after export, so it's still an odd requirement, as someone can still look in there.

The REST call should get all that you need though.  And I completely forgot (hence the reply) I think you may need to say &expand=changelog on the end of the query to get the history records out!

harleythorne · Answer

Hey Nic,

Thanks very much for the reply. In terms of our requirement, I totally know what you're saying. The problem is, for ISO, we need to have these logs in a secure location that CAN NOT be edited by anyone, and can only be viewed by a very select group of people. If they remain in JIRA there are several power users that would have the access and we cannot prove changes have not been made.

Unless you're speaking of different logs, rather than just the fact that the issues are obviously sat there? Someone could delete a ticket, for example.

The rest API looks a good call. I'll take a look into this further. Thanks for the suggestion!