Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Is there an API to export the User List from the Insights page on the admin console ?


Is there an API to export the user list csv as we can export manually from the Insights page under the Security tab of the Admin Console in Atlassian ?




1 answer

Hi @sam saas 

I don't think there's an API to export users but you can use a web scrapping framework such as selenium to automatically grab that information. Alternatively you can always query the search users endpoint, however that won't give you the same information as the insight does.

Hi @Prince Nyeche ,

Thanks for the response!

The search users endpoint seems to have a bug, where the accountType field does not get populated with values: app, atlassian. Hence, does not provide the capability to list real users only.

Hi @sam saas 

Hmm that's strange. I was curious about such problem, so I created a script that can actually extract the user list. however this is just minimal, you can expand on it if you need to. You can download the script from my github here. From my test the API works fine to get real Jira users and I can distinguish which user type i need.

Hi @Prince Nyeche ,

For Jira, the search user API seems to work fine as it populates the account type field with appropriate values. But for confluence cloud search users API, the value to the accountType field is an empty string for all users.

Related issue :

Response from Confluence Cloud REST Search Users API :

Screenshot 2020-12-16 at 11.32.47 AM.png

Hi @sam saas 

Yes I can see that behaviour as well, but the workaround, seem to be the same thing I thought. use the accountId to get the user by searching 1 by 1 or group the entire user list into a file and search all and get the info whether they are app user or atlassian user.

I believe if you have Jira and Confluence applications together, there's no need to even go through the Confluence API as that would exist on the User list on Jira even though the user only have Confluence application access. Also, you can query the group API to know which group is given to the user that has application access.

Just to give you my own opinion, on Cloud you will need to use multiple APIs to achieve a given solution. so do not rely too much on one if it doesn't give you the results you need, a combination of one or more APIs usually does the trick.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Atlassian Access

Atlassian Access Demo Q&A Recap

Hi Community! Thank you to all who joined our ongoing monthly Atlassian Access demo! We have an engaging group of attendees who asked many great questions. I’ll share a recap of frequently ask...

1,144 views 4 4
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you