cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Question: 

How can I export a list of Sisense users, for example users from a specific group?

Answer:

Using the REST API you can pretty quickly get this info in JSON document format.

The GET /users API supports group ID: 

Community_Admin_0-1634176924097.png

You could run GET /groups with the group name to get it's ID:

Community_Admin_1-1634176924076.png

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:

Community_Admin_2-1634176924024.png

or as it would be in the URL:

http://10.50.12.161:30845/api/v1/users?fields=userName%2Cemail

Community_Admin_3-1634176924029.png

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:

Community_Admin_4-1634176924101.png

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:

Community_Admin_5-1634176924103.png

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. 

 

Version history
Last update:
‎10-13-2021 07:08 PM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request