Hi,
I was wondering if there is a way to generate a list of all users that have access to a folder for every folder/subfolder on LabKey? Essentially we want to collect the /folderAccess.view page for every folder into something like a JSON.
We tried using the R API to pull a list of all the folders on LabKey and then querying the core.Users table for each folder, however we ran into an issue where if a user is a part of a project group, they will show up in the core.Users table for every subfolder regardless of whether they actually have access to that subfolder or not. Even if that project group is not added to any folders and has no ability to access anything in that project, the users in that group will still show up in the core.Users table for every subfolder.
In case it helps we are running on version 20.3.
Any suggestions or ideas would be appreciated.
Thanks,
Jon