Automating export of JIRA issues to SharePoint

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

 

1 answer

Seems pointless, as JIRA keeps all the logs already, and no-one reads sharepoint stuff, and most exports of JIRA data tend not to include everything.

But, no, you're slightly stuck on Cloud.  The best option is a third service - a simple script can read JIRA over REST for all the issue data (including history), and I imagine it can poke it into Sharepoint.

I'd probably think about something that runs maybe nightly and does  something like

curl -D- \
  -u fred:fred \
  -X GET \
  -H "Content-Type: application/json" \
  http://kelpie9:8081/rest/api/2/search?jql=updated>-1d

(which was wholeheartedly stolen from https://developer.atlassian.com/jiradev/jira-apis/jira-rest-apis/jira-rest-api-tutorials/jira-rest-api-example-query-issues )

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!

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!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,711 views 17 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you