Exporting group members

GregoryMuir

I'm wanting to do a review to make sure I have everyone placed in the right buckets. I can dump a user list but there's no group membership details included. I don't see any automated way of dumping group members to CSV for review. The best solution i found is stupid -- open each group and copy-paste the html into excel and then extract emails that way to cross-reference.

Is there a smarter way I'm not aware of? Thanks!

Amit Wadhwani

Hi @GregoryMuir

The only way I could think of is using Smartsheet API. This particular action is referenced at https://smartsheet.redoc.ly/#operation/get-group

You do not have to be a programmer to do this. You can use Postman to run the API and get the desired result. Let me know if you would to know how this works.

BR

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

Ami Veltrie

@Amit Wadhwani Hello. I would like to know how to create this.

Amit Wadhwani

Hi @Ami Veltrie

1. Sign up on https://www.postman.com/ and read this to know how to send API request https://learning.postman.com/docs/getting-started/first-steps/sending-the-first-request/. If you already know how to send API request using Postman, you can go to step 2 directly.
2. While sending API request, use GET method and this URL to send request - https://api.smartsheet.com/2.0/groups
3. You will have to click on Authorization under the input and change the type to bearer. In the token field that appears on the right, you need to put in the token that you can obtain from Smartsheet https://smartsheet.redoc.ly/#section/API-Basics/Raw-Token-Requests. Your token is confidential and should not be shared with anyone.
4. Once you send this request, you will see a list of all the groups in your account.
5. The response will be in JSON format, which you can convert into a table using this - https://jsongrid.com/json-grid. The first column of the table will show you IDs of all the groups.
6. You can then repeat the same process to get details of the group, by sending the request on this URL - https://api.smartsheet.com/2.0/groups/{groupId}, where {groupId} should be replaced by the ID of the group that you want to fetch.
7. If you have a programmer in house, this can be done faster with lesser number of steps.

I hope this helps. I am around if you have any other questions or you would like to jump on a screenshare to do this.

Chris Russell

@Amit Wadhwani - Thank you so much for these clear instructions! I was able to get what I needed in a matter of minutes.