API Calls for Retrieving User Access to Dashboard Sheets

Vyshakh — Fri, 02 Jan 2026 14:45:42 GMT

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.

Regards
Vyshakh R

Re: API Calls for Retrieving User Access to Dashboard Sheets

stevedark — Fri, 09 May 2025 09:36:30 GMT

Hi @Vyshakh

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.

Hope that helps.

Steve

topic API Calls for Retrieving User Access to Dashboard Sheets in Talend Studio

API Calls for Retrieving User Access to Dashboard Sheets

Re: API Calls for Retrieving User Access to Dashboard Sheets