cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Question: How can I export a list of Sisense users, for example users from a specific group?
 
Solution: Using the REST API you can pretty quickly get this info in JSON document format.
The GET /users API supports group ID: 
You could run GET /groups with the group name to get it's ID:
 
Then use that group ID in the GET /users call which will provide users who are members of that group.
You can even use the 'fields' parameter to include or exclude fields.
 
If you use the "v1" API instead, which is at /api/v1/users, you could simplify the results from this API by specifying which fields should be returned, via the "fields" parameter:
or as it would be in the URL:
Other solution is to connect to Sisense MongoDB through Mongo Connector https://documentation.sisense.com/latest/managing-data/connectors/mongodb_online.htm#gsc.tab=0 , before that you need to setup read user on your mongo for Sisense via this API:
After you setup this user and connect using it to Mongo on Sisense you will be able to select connecting to some databases and you should select this one:
The in Collections look for Users and Groups tables. Due to JSON structure mongo connector can generate multiple tables for Users and Groups depending on how many nested JSON structures are within it. That should be relatively easy to go through, and then you should have a full structure of Users per Group. What is more, this can be imported inside Sisense Elasticube so you will be able to create a dashboard based on this and export it into any format. 
 
Rate this article:
Comments
viktor_zhuk
Sisense Team Member
Sisense Team Member

Additionally, you can use the Usage Analytics dashboard to create a widget with a list of users and other required information and then export the table to CSV / Excel: https://docs.sisense.com/main/SisenseLinux/user-analytics.htm

Version history
Last update:
‎02-23-2024 09:25 AM
Updated by:
Contributors