API - How can I get all existing workspaces of my organization ?

Vincent Durannot

Hello,

We tryed to get list of workspace created in our organization account

We use API with Bearer Authentification :'https://api.smartsheet.com/2.0/workspaces

I created API acces with my account (Administrator system) , API get result only Workspace where i have an acces on my SmartSheet Account/

How can I get all existing workspaces of my organization ?

Thanks in advance,

Genevieve P.

Hi Vincent,

As you've found, the List Workspace request can only list those Workspaces that you have sharing permissions on, and can access to within your account (see our API documentation, here).

Since you are a System Admin, you can generate a list of all sheets within your Organization (see here), but this does not include the Workspaces the sheets are located in.

Instead of using the API, you may want to generate a Sheet Access Report from the User Management section of Smartsheet. This will provide you with a CSV file of all the sheets in your organization, and this includes the name of the workspace (see here).

Cheers,

Genevieve

Vincent Durannot

Hello Genevieve,

Thanks you for this response,

If i understwwod well, if i wish to extract automaticaly list of all worksapces with API, i have to ask at all users to share with me worksapces.

Other point,it's possible to extract automatically Sheet Access Report ?

Thanks in advance,

BR,

Genevieve P.

Hi Vincent,

Yes, you are correct!

If you want to pull a list of all Workspaces in your organization through the API, then your account needs to be shared to each of those workspaces.

The Sheet Access Report can be downloaded at any time through the Admin Center in your account as a CSV file.

Martin.W

Hey, it's been a few years since this post, and I wanted to check if there have been any updates from the Smartsheet side on getting access to Workspace details across all users on our account. Is that something that we might eventually see? I can't imagine we are the only ones who want to ensure that all Workspaces are visible to Admins.

Genevieve P.

Hi @Martin.W

The Sheet Access Report lists out all sheets in your organization and the Workspace these items are located in, or you can use the Alternate Version for the Workspace ID. Here's more information: https://help.smartsheet.com/articles/2483064-sheet-access-published-items-report#toc-generate-a-sheet-access-report

And the recent announcement post on an update, here: Enhancements to the Alternate Sheet Access Report and Published Items Report now generally available

Cheers,
Genevieve

Martin.W

@Genevieve P. Thanks for your reply! I do have a follow-up question. It appears that the Sheet Access report only lists workspaces that contain items. Blank Workspaces are not visible on any report to an Admin. Is that correct?

Genevieve P.

Hi @Martin.W

That's correct - if there are no items in the workspace, it won't appear in the Access Report, as there is no item to access.