nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get Confluence User Status via Rest API

Jonathan Klapel

I would like to be able to find out if a particular user is activated or disabled in Confluence via the REST API (or some other similar method). I can find how to get the details of users via the REST API (e.g. GET of http://example.com/rest/api/user?username=jblogs), but those details do not seem to return the status. Is there something I can use in the "expand" property perhaps?

Accepted answers

AnnWorley

If you have access to the database you can run a SQL query like:

select user_name, active from cwd_user where lower_user_name = 'admin';

The lower_user_name is the login username. The results should be something like this: Screen Shot 2017-06-14 at 3.31.30 PM.png

The T means the user is active.

All comments

AnnWorley

If you have access to the database you can run a SQL query like:

select user_name, active from cwd_user where lower_user_name = 'admin';

The lower_user_name is the login username. The results should be something like this: Screen Shot 2017-06-14 at 3.31.30 PM.png

The T means the user is active.

Jonathan Klapel

Thanks for the response. This is what I ended up having to do, along with an HTTP to SQL connector in order to access it from another internal website.

Peter Bunde Hansen

How to get access to the database for confluence? I need to do it from EXCEL VBA - is that possible if the admin grants me the rights? Do I need to install something?

SEI Information Technology

What if we don't have access to the database to run queries? How can we find this user status information via API?