Post
Ask Question

Retrieve List Views From SharePoint List Using PnP JavaScript

Introduction

In this article, you will learn to perform the basic list view read operations on SharePoint sites, using PnP JavaScript Core Library.

Note: The operations, given below, get information from the respective site where the code is executed. The logic can be executed by adding the script references on the content editor Web part or any normal custom Web part from the site collections or sites or sub sites. The results will be retrieved only from the respective site where the code is executed.

The PnP JavaScript Core Library is supported by SharePoint 2013, SharePoint 2016 On Premises, and Office 365 versions. The following operations are tested on SharePoint 2013 and Office 365 environments:

Prerequisite

The required JavaScript Core Library references for executing any operations using PnP, are: 

  • es6-promise.js
  • fetch.js
  • pnp.js or pnp.min.js

The script references should be called from the Web parts, only in the order given above.

Note: You can download the references from my initial article about PnP JavaScript Core Library.

I have explained about the necessity of using the promise and retrieve JS references, in the article mentioned above. You can download these references from Github site, as well.

We can set up the header before executing any operation. This is required when you want the response type to be predetermined. Let us see how we can get the JSON data as a response. This has to be done once, before initiating all the requests on the page. This step is not mandatory for O365 environments.

The code snippet, given below, shows setting up the header:

  1. $pnp.setup({  
  2.     headers: {  
  3.         "Accept": "application/json; odata=verbose",  
  4.     },  
  5. });  

Retrieve List Views

In this section, you will learn how to retrieve all list views available for a list.

First, we need to retrieve the list by using the list name; and then, we need to access the views collection. Get method is used to get all the views information.

The following code snippet helpsin  retrieving all the list views and properties.

  1. $pnp.sp.web.lists.getByTitle("PnPList").views.get().then(function(data){  
  2.     for(var i=0;i<data.length;i++){  
  3.         console.log("View Title : " + data[i].Title);  
  4.         console.log("View URL   : " + data[i].ServerRelativeUrl);  
  5.     }  
  6.       
  7. }).catch(function(data){  
  8. console.log(data);  
  9. });  

The following snapshot shows the views available on the list.

 

Retrieve List Views with Selected Properties

Here, we will see how we can list down all the views for a list with only selected view properties. Select method filters the required properties.

The following code snippet shows all the views for a list with only view title property filtered, using select method.

  1. // Get Views with few properties  
  2. $pnp.sp.web.lists.getByTitle("PnPList").views.select("Title").get().then(function(data){  
  3.     for(var i=0;i<data.length;i++){  
  4.         console.log("View Title : " + data[i].Title);  
  5.     }  
  6.       
  7. }).catch(function(data){  
  8. console.log(data);  
  9. });  

The following snapshot shows the result for the above operation on debugger console.

 
Retrieve Required List View

Here, we will see how we can get the view that is required, using view title.

The following code snippet retrieves a list view with properties by passing the view name filter.

  1. // Get View by Title  
  2. $pnp.sp.web.lists.getByTitle("PnPList").views.getByTitle("PnPView").get().then(function(data){  
  3.     console.log("View Title : " + data.Title);  
  4.     console.log("View URL   : " + data.ServerRelativeUrl);    
  5. }).catch(function(data){  
  6. console.log(data);  
  7. });  

Retrieve Required List View with Select Properties

Here, we will see how we can get a particular view information, using view title, and get only required properties using select method.

The following code snippet retrieves a view from a list by using view name and gets only URL of view in the response.

  1. // Get View by Title with selected properties  
  2. $pnp.sp.web.lists.getByTitle("PnPList").views.getByTitle("PnPView").select("Title").get().then(function(data){  
  3.     console.log("View Title : " + data.Title);    
  4. }).catch(function(data){  
  5. console.log(data);  
  6. });  

Note: The results can be viewed on the Browser's debugger console, for the operations given above.

Summary

Thus, you learned how to retrieve the views and their properties from a SharePoint site, using PnP JavaScript Core Library. PnP JavaScript Library is supported by SharePoint 2013, SharePoint 2016 On Premises, and Office 365 versions. The operations, mentioned above, are tested in SharePoint 2013 and Office 365 environments.


Similar Articles