Get Permission matrix report of SharePoint library and folders

Hi,

I have to prepare a report where I have to get folder path, users/groups and permissions on each of the folders and file in a document library. The library contains several nested folders and most of the folders have unique permissions. I am using SharePoint Rest API to get folders and permission.

If I loop through each of the folder and send request for permission so it is taking longer and page becomes irresponsive.

Please suggest a solutions.

Hi Rajesh,

When dealing with large document libraries with nested folders and unique permissions, it can be challenging to obtain the necessary data in an efficient manner. Here are my few suggestions to improve the performance of your code:

SharePoint Rest API supports batch requests, which allow you to group multiple requests together and send them as a single HTTP request. This can significantly reduce the number of round trips to the server and improve performance. You can use the $batch endpoint to execute batch requests.
SharePoint Search API can be used to query for folders and files along with their permissions. This can be a more efficient approach than iterating through each folder and file individually. You can use the Search REST API to query for the required data.
Rather than loading all the data at once, you can implement incremental loading. This means loading only a portion of the data at a time, as the user scrolls or interacts with the page. This can reduce the initial load time and make the page more responsive.
You can cache the results of your API calls to avoid repeatedly querying the server for the same data. This can improve performance and reduce the load on the server.
Make sure you are requesting only the necessary data and using the correct query parameters to filter and sort the data. This can significantly reduce the amount of data transferred between the server and the client, resulting in faster performance.

By implementing one or more of these suggestions, you can improve the performance of your code and make your report generation process more efficient.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul3y ago
Accepted answer
Hi Rajesh,

When dealing with large document libraries with nested folders and unique permissions, it can be challenging to obtain the necessary data in an efficient manner. Here are my few suggestions to improve the performance of your code:
1. SharePoint Rest API supports batch requests, which allow you to group multiple requests together and send them as a single HTTP request. This can significantly reduce the number of round trips to the server and improve performance. You can use the $batch endpoint to execute batch requests.
2. SharePoint Search API can be used to query for folders and files along with their permissions. This can be a more efficient approach than iterating through each folder and file individually. You can use the Search REST API to query for the required data.
3. Rather than loading all the data at once, you can implement incremental loading. This means loading only a portion of the data at a time, as the user scrolls or interacts with the page. This can reduce the initial load time and make the page more responsive.
4. You can cache the results of your API calls to avoid repeatedly querying the server for the same data. This can improve performance and reduce the load on the server.
5. Make sure you are requesting only the necessary data and using the correct query parameters to filter and sort the data. This can significantly reduce the amount of data transferred between the server and the client, resulting in faster performance.
By implementing one or more of these suggestions, you can improve the performance of your code and make your report generation process more efficient.
+2