API Calls for Retrieving User Access to Dashboard Sheets
Hi ,
We would like to know the API calls required to retrieve the details of the sheets that a user has access to within the dashboard.
Current behavior: The user is able to view all dashboard sheets, regardless of whether they have access to them. Expected behavior: The user should only be able to view the sheets they have access to.
Sheet level security is not available in Sense, so you need to build it yourself and it is therefore not available in any API.
The way to implement sheet security is using the hide condition on the sheets you wish to secure. You then need an expression based on the OSUser() function that evaluates to true or false.
On a number of projects I have implemented an approach where a spreadsheet loads users with elevated permissions and gives them a user level between 1 and 5 (anyone not on the list is assumed zero). Each sheet then has a user level of 0-5 and then sheets are only shown if the user level is equal or above the sheet level.
You could implement something where individual sheets are allocated to each user, but that is more of an admin headache.
