# Bulk edit users in Automation Hub using OpenAPI

> Process for bulk-editing Automation Hub user records via OpenAPI, including how to retrieve user lists and format updates for CSV or direct API input.

Applies to Automation Cloud only.

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](https://uipath-my.sharepoint.com/:u:/p/ionut_tiganuc/Ec_STw9AVtFItqGS0_HyxE0BOkCeMHIWpTLGTP6BCGamgg?e=IJrz1Q)**.
   * 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](https://automation-hub.uipath.com/api/v1/api-doc/#/Users/EditUser)
* [Inputs for the call](https://docs.uipath.com/automation-hub/automation-cloud/latest/api-guide/input-for-automation-idea-update-date)
* [Using the Postman Runner](https://learning.postman.com/docs/collections/running-collections/intro-to-collection-runs/)