API - How do I get the location of a sheet

hiker360

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.

Genevieve P.

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

hiker360

Thanks @Genevieve P. That's perfect. I didn't know about the loadAll.

Tim C

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

hiker360

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.

Genevieve P.

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

hiker360

Thanks @Genevieve P. That's perfect. I didn't know about the loadAll.