Get Most Viewed Documents from SharePoint Document Library

Question

Hello Everyone,

I am using SharePoint online modern team site.

I have added 100+ documents in Shared Documents library.

I will need get most viewed documents from my SharePoint document library using PnPJS (Programmatically).

Is anyone can help me for the same?

Thanks in Advance.

Regards,
Meet Bhatt

Answer 1

Hi @Meet Bhatt ，

You could use pnp search to search in Shared Documents library. For most Viewed Documents we get all the results and sort them by “ViewsLifeTime”.

Below is my sample code for your reference:

import { sp , SortDirection,ISearchQuery, SearchResults, SearchQueryBuilder} from "@pnp/sp/presets/all";  
  
  
   let query=`Path:https://tenant.sharepoint.com/sites/test/Shared%20Documents AND ContentClass:STS_ListItem` ;	  
   const results2: SearchResults = await sp.search(<ISearchQuery>{  
    Querytext: query,  
    RowLimit: 10,  
    EnableInterleaving: true,  
      SortList:  
  [  
    {  
      Property: 'ViewsLifeTime',  
      Direction: SortDirection.Descending  
    }  
  ]  
	});  
  console.log(results2.ElapsedTime);  
  console.log(results2.RowCount);  
  console.log(results2.PrimarySearchResults);  
  console.log(results2.PrimarySearchResults[0]); //most viewed documents  

Reference: https://sshareasolutions.com/2017/11/17/how-to-get-most-visited-items-in-sharepoint-using-rest-and-jquery/

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.