cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
In some cases, you would like to add many users in bulk.
The users are often managed in a CSV file.
With the following steps, you will be able to insert users from a CSV file by converting the CSV file to a JSON format and run it with an API through the Swagger.
Steps:
1. Prepare a CSV file with the following columns (case sensitive): 

email

userName

firstName

lastName

roleId

groups/0

[email protected]

Test10

FName10

Lname10

5d072c7b94278724f71ba2e5

5f477932c87fea1354e3e781

[email protected]

Test11

FName11

Lname11

5d072c7b94278724f71ba2e5

5f477932c87fea1354e3e781

[email protected]

Test12

FName12

Lname12

5d072c7b94278724f71ba2e5

5f477932c87fea1354e3e781

  • email - User's email
  • userName - User's user name
  • firstName - User First Name
  • lastName - User Last Name
  • roleId - The role you would like to assign the user. 
    • The roles are - admin, contributor, consumer and dataDesigner
    • You need to apply the roleId for each type of role. 
    • Note that each Sisense installation has a different roleId for similar role names. 
    • You can get the roleId for each role name by running the GET command in the Role group in Swagger 0.9.
  • groups/0 - The group id you want the user to be part of
    • Note: The groups have to exist. Use the Swagger 0.9 -> Groups -> Get -> Groups to get each group’s id.
2. Use a utility to transform the CSV file into a JSON format for example http://convertcsv.com/csv-to-json.htm)
[
 {
   "email": "[email protected]",
   "userName": "Test10",
   "firstName": "FName10",
   "lastName": "Lname10",
   "roleId": "5d072c7b94278724f71ba2e5",
   "groups": [
      "5f477932c87fea1354e3e781"
   ]
},
 {
   "email": "[email protected]",
   "userName": "Test11",
   "firstName": "FName11",
   "lastName": "Lname11",
   "roleId": "5d072c7b94278724f71ba2e5",
   "groups": [
      "5f477932c87fea1354e3e781"
   ]
},
 {
   "email": "[email protected]",
   "userName": "Test12",
   "firstName": "FName12",
   "lastName": "Lname12",
   "roleId": "5d072c7b94278724f71ba2e5",
   "groups": [
      "5f477932c87fea1354e3e781"
   ]
}
]
 Note:
  • After adding the new users, an activation email will be sent to each. The users then would need to set the initial password. 
  • If you wish to set an initial password and for the user only to get a Welcome message, then add a password column.
  • In the JSON you will see another line looking like this:   "password":"Sisense!1234"
3. Copy the JSON expression and paste it in Swagger 1.0 -> Users-> Post-> /users/bulk and execute.
  • If you get response code 201...you made it 🙂
4. Check the users and groups in Admin - > Users
Enjoy and share 🙂
Tamir
Rate this article:
Version history
Last update:
‎03-02-2023 09:03 AM
Updated by:
Contributors