API Call - List Sheet Shares

Options

We are trying the "List Sheet Shares" (https://smartsheet.redoc.ly/tag/sheets#operation/list-sheet-shares) using PostMan as well as Microsoft Power Apps. We would like to get all the sharings of the sheets, no matter if they set on the sheet itself or inherited from the workspace. i have tried " https://api.smartsheet.com/2.0/sheets/1461969329907588/shares?sharingInclude=workspace", but I can only see the sharing from the sheet, but not from the workspace. Can you help, please?

Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Options

    @Gabi As far as I can tell that sharingInclude query parameter doesn't do anything at all. You have to use the List Workspace Shares in order to get the workspace shares.

    I think that's what's happening when you view the shares of a sheet or other object inside a workspace - it's running both and combining the results. If you notice, when you view shares of sheet inside a workspace, a user with both explicit rights via the sheet and inherited rights from the workspace is listed twice, once for each.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

  • Gabi
    Gabi ✭✭✭
    Options

    @Jeff Reisman , thank you for your answer. I agree, it looks like the parameter "sharingInclude" does not make any difference.

    But my experience is the other way around, I only get the users directly shared on the sheet, I never the users shared via workspace :-(

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Options

    I should have been more clear - when you are in Smartsheet looking at a sheet, and view the shares - that's when you'll see two entries for a user who has both direct share permissions and workspace inherited permissions:

    This is what makes me think this process is making both calls - List Sheet Shares and List Workspace Shares - and combining the results.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!