Exporting group members
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!
Answers
-
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
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
@Amit Wadhwani Hello. I would like to know how to create this.
-
Hi @Ami Veltrie
- 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.
- While sending API request, use GET method and this URL to send request - https://api.smartsheet.com/2.0/groups
- 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.
- Once you send this request, you will see a list of all the groups in your account.
- 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.
- 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.
- 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.
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
@Amit Wadhwani - Thank you so much for these clear instructions! I was able to get what I needed in a matter of minutes.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives