Bulk edit users in Automation Hub using OpenAPI

1. Get the users you want to edit
   • The list of the users to edit can be fetched by using the GET Users API.
   • An easy way to get it closer to a CSV is to export the response from the API and import it into Excel or connect an excel directly to the API.
   • If you have users with multiple roles, they need to be parsed manually, as this generates different entries in the excel file.
   • Once you get the API data, make sure for the headers to mapped to the variable names you have in the API requests (for example role_id needs to be renamed to role_id1)
   • Perform the changes in the file as needed and then save it with the name editusers.csv.
2. Edit users to Automation Hub
   • Download the Postman Collection.
   • Open the Postman collection in to your workspace. This example contains only one role, but you can add as many roles as you want to the array.
   • Once you have the file ready, go to Postman and open the Postman Runner.
   • In the Run Order page, select the Edit User (Variables) call only.
   • In the right, click Select file and upload the editusers.csv file.
   • Check the number of iterations on the right to be the same as the number of rows in your file (headers excluded).
   • Click Run. Postman runs the requests one by one and show a correspondent status for each one.
   • Successful runs have the 201 - Resource Updated message.
   • Now you can check your edits in Automation Hub.

For more information, check the following documentation references:

• Users can be edited in Automation Hub using the Add User API
• Inputs for the call
• Using the Postman Runner