API Call - List Sheet Shares
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
-
@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!
-
@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 :-(
-
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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives