API - How do I get the location of a sheet
Using the smartsheet API, how can I get the location of a sheet using the sheet ID? This seems like it should be simple but I'm not able to find anything. The getsheet API doesn't seem to have this information. What I want to do is get the other sheets in the same folder.
Best Answers
-
Thanks for the tag, @Tim C!
@hiker360 the Get Sheet call will bring back information about a sheet, including the Workspace that it's found in.
You can then use Get Workspace with
loadAll
=true
to see the folders/levels within the workspace, and identify the folder that this specific sheet is in.Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks @Genevieve P. That's perfect. I didn't know about the loadAll.
Answers
-
You may have already seen this but here might be a good starting point https://smartsheet.redoc.ly/tag/sheetsObjects#section/Sheet-Object.
Could take a look at @Genevieve P. ' post from a few months ago https://community.smartsheet.com/discussion/103472/get-sheet-id-by-name-using-smartsheet-api
-
Thanks. I was able to do something similar using the Search Everything API. It comes back with a context folder path that I then have to parse and navigate the workspaces/folders to get the actual folder ID. It just seemed there must be an easier way. The problem with this method is that it doesn't support searching object sheet ID.
-
Thanks for the tag, @Tim C!
@hiker360 the Get Sheet call will bring back information about a sheet, including the Workspace that it's found in.
You can then use Get Workspace with
loadAll
=true
to see the folders/levels within the workspace, and identify the folder that this specific sheet is in.Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks @Genevieve P. That's perfect. I didn't know about the loadAll.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 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