Exporting groups in Atlassian Cloud

Łukasz Gryz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 25, 2024

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


2 answers

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 25, 2024

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.

0 votes
Vicknesh Shanmugam April 25, 2024

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events