Authorization List

Hello Team,

Is there way I can generate the list of users, who I have granted access or as an administrator can I generate a report of a particular Sheet, Workspace or Work App. I am looking for all these 3 categories.

We are grating access for multiple users from 2 differnet domain with differnet access level. I would like to generate the list of who has access and what type of access granted.

Likely a Security Report.

Answers

  • SSFeatures
    SSFeatures ✭✭✭

    Hi,

    I don't think that this functionality is built anywhere into the SmartSheet app. For example, there is no button such as "Generate Access Grant" report, and there is no way to reference this data within a SmartSheet.

    However, you can get this data using the SmartSheet API.

    Specifically, the "List Sheet Shares" API request.

    The API would give you authorization data for a sheet, and it would look something like this:

    {
      "pageNumber": 1,
      "pageSize": 100,
      "totalPages": 1,
      "totalCount": 3,
      "data": [
        {
          "id": "1213100864381156",
          "type": "USER",
          "email": "john.doe@example.com",
          "name": "John Doe",
          "accessLevel": "EDITOR"
        },
        {
          "id": "7783277262589316",
          "type": "USER",
          "email": "jane.doe@example.com",
          "name": "Jane Doe",
          "accessLevel": "ADMIN"
        },
        {
          "id": "4519104836281156",
          "type": "GROUP",
          "name": "Project Managers",
          "accessLevel": "EDITOR"
        }
      ]
    }
    

    You might also be able to use SmartSheet Bridge to perform the API call and bring the data back into SmartSheet.

    I didn't find an equivalent API for Workspace Level data, or Work App data.

    Hope this helps!

    SSFeatures

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Automatic sorting, sorting with filters, saving sort settings
    • Spell checking
    • Report PDF generator that supports grouped and summarized reports