Exporting groups in Atlassian Cloud

Question

Hi,

We want to make general review and cleanup of security groups in our Atlassian site.
As there is no native way to export all the data into csv/excel for review i wanted to ask if you know of any way to do so? API or maybe some addon?

Our goal: To review all groups efficiently and be able to easy consult that with non site-admin users
Our Software: Atlassian Cloud, Jira+Confluence

Sanam Malleswari · Answer

Hi @Vicknesh Shanmugam

Could you please suggest, is there anyway to get groups list with details as well?

Aron Gombas _Midori_ · Answer

If this is something that you have to do only once, then use the REST API endpoints suggested by @Vicknesh Shanmugam and manually convert the JSONs to CSV, then import to Excel.

If this is something that you have to do repeatedly, then develop a custom Excel export template for the Better Excel Exporter. The template should connect to the same REST API endpoints, get the same data, but do the conversion programmatically, finally download the resulted Excel spreadsheet to you.

Vicknesh Shanmugam_7qjfr8 · Answer

Hi Lukasz.

You may use the REST API endpoints below to get the list of groups in your Atlassian Cloud:

1. https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-groups/#api-rest-api-3-group-bulk-get

2. https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-groups/#api-rest-api-3-group-get

You can convert the JSON response to Excel and use the information to the audit purpose.