Exporting groups in Atlassian Cloud

[Łukasz Gryz]

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

[Aron Gombas _Midori_]

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]

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.

[sanam malleswari]

Hi @Vicknesh Shanmugam

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