Please suggest a recommended way to fetching data at the organization level with admin user
We need a way to fetch the entire data at the organization level using admin user (Data of all the Non admin and admin users). From the APi documentation and from the below discussion it appears that admin user's oauth2 token is not sufficient to fetch the entire organization's data. Pleas help us with this query. Also please tell us how to achieve this using admin's oauth2 token as well as admin's personal API token
Please find reference here:
https://community.smartsheet.com/discussion/114230/improve-the-api-documentation-for-assumeuser
https://community.smartsheet.com/discussion/comment/409154/#Comment_409154
Answers
-
Hi @smartsheet team,
Can you please answer my above query. -
Hi @Reshma R
The Smartsheet API gives you access to the same data you have access to when you log into the UI. This means if you are not shared to the sheet as a user, you won't be able to fetch that sheet's data with the API.
If your account is a System Admin, you can get Organization-level data with List Org Sheets: https://smartsheet.redoc.ly/tag/sheets#operation/list-org-sheets
This will not bring back cell contents, but it will list all the sheets created by users in that organizaton (like a Sheet Access Report that a System Admin can download from the Admin Center). Does that make sense?
It sounds like you may want to look into Event Reporting, too, if you're on an Enterprise plan.
Cheers,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives