Export SharePoint User Alerts using C#

Hello friends, in this blog article we will see how we can export all the user alerts from SharePoint Online Site. It will export the list of user alerts from defined site collection in CSV format. The exported data will contain all the details about user and his alerts like on which lists he subscribed for the alerts, frequency of the same.

We know that we can see a list of user alerts from site settings > User alerts. But it has some limitations like a number of users. It won’t provide the list of all users once it crossed the specified limit. So to export all user alerts, we need to write either PowerShell or some console application.

Here are steps to get all alerts from SharePoint online site. You can tweak the code according to your need.

1) Open Visual Studio 2013
2) Create Window console project
3) Open Tools → NuGet Package Manager → Package Manager Console
4) Run following command in the console

Install-Package Microsoft.SharePointOnline.CSOM -Version 16.1.7317.1200

5) Add following code in the main class

using Microsoft.SharePoint.Client;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Security;
using System.Text;
using System.Threading.Tasks;

namespace Alerts {
    class Program {
        static void Main(string[] args) {

            string targetSiteURL = @ "https://myclassbook.sharepoint.com/sites/test123";
            var login = "[email protected]";
            var password = "XXX";
            var securePassword = new SecureString();

            foreach(char c in password) {
                securePassword.AppendChar(c);
            }

            SharePointOnlineCredentials onlineCredentials = new SharePointOnlineCredentials(login, securePassword);
            ClientContext ctx = new ClientContext(targetSiteURL);
            ctx.Credentials = onlineCredentials;
            var users = ctx.Web.SiteUsers;
            ctx.Load(users);
            ctx.ExecuteQuery();
            var csv = new StringBuilder();

            foreach(var user in users) {
                var alerts = user.Alerts;
                ctx.Load(alerts);
                ctx.ExecuteQuery();
                if (alerts.Count > 0) {
                    csv.AppendLine(string.Format("Display alerts for {0}({1})", user.Title, user.LoginName));
                    foreach(var alert in alerts) {
                        csv.AppendLine(string.Format("Frequency:{0}, Delivery Method(s):{1}, AlertName:{2}", alert.AlertFrequency, alert.DeliveryChannels, alert.Title));
                    }
                }
            }
            System.IO.File.WriteAllText("C:\\Alerts\\alerts.csv", csv.ToString());
        }
    }
}

6) Change Url and login details. Resolve references
7) Add “Alerts” folder in C: drive
8) Run code

See also: Manage, view, or delete SharePoint alerts

I hope you liked this article. Please share it with your friends and like our facebook page. If you have any queries, feel free to ask in the comment section below.

Add Geolocation column in SharePoint using PowerShell

Hello Friends, in this article we will learn how we can enable a Geo-location column on custom list in SharePoint online. We will use a PowerShell script to add Geo-location column in our list. Same script can be used for SharePoint 2010/2013.

Add Geolocation column in SharePoint using PowerShell

  1. Open Windows PowerShell ISE

    Windows PowerShell ISE
    Windows PowerShell ISE
  2. Write below PowerShell code and run the same. Make the necessary changes in the below code like: $WebUrl, $EmailAddress, $List.
    #Load SharePoint CSOM Assemblies
    Add-Type -Path "C:\Users\Desktop\Data\Old\Microsoft.SharePoint.Client.Runtime.dll"
    Add-Type -Path "C:\Users\Desktop\Data\Old\Microsoft.SharePoint.Client.dll"
    
    #Define SharePoint URL, login details
    $WebUrl = 'https://myclassbook.sharepoint.com/teams/TestSite/'
    $EmailAddress = "[email protected]"
    $Context = New-Object Microsoft.SharePoint.Client.ClientContext($WebUrl)
    $Credentials = Get-Credential -UserName $EmailAddress -Message "Please enter your Office 365 Password"
    $Context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($EmailAddress,$Credentials.Password)
    
    #Define list name where we need to add Geolocation column
    $List = $Context.Web.Lists.GetByTitle("Project Portals")
    $FieldXml = "<Field Type='Geolocation' DisplayName='Location'/>"
    $Option=[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView
    $List.Fields.AddFieldAsXml($fieldxml,$true,$option)
    $Context.Load($list)
    $Context.ExecuteQuery()
    $Context.Dispose()

    Screenshot of above code:

    Add geolocation column in sharepoint using powershell
    Add Geo-location column in SharePoint using PowerShell
  3. Once the script is successfully executed, you can see that the Geolocation columns with Display Name “Location” will be added in your list.

    Add Geolocation column in SharePoint using PowerShell
    Add Geolocation column in SharePoint using PowerShell

Downloads:
1) Microsoft.SharePoint.Client.Runtime.dll
2) Microsoft.SharePoint.Client.dll
3) PowerShell Script

I hope you liked this article. Please let us know in case you are having any questions in the comment section below. Like our facebook page and subscribe to our newsletter for future updates. have a great time 🙂

Export all users from SharePoint group in Excel

Hello friends, in this article we will see how we can export a list of all users present in a SharePoint group.

Export all users from SharePoint group in Excel

  1. Open Microsoft Excel and Click on From OData Data Feed as shown below:

    Click on
    Click on “From OData Data Feed”
  2. In ‘Data Connection Wizard’ Enter the REST URL as below:

    https://myclassbook.sharepoint.com/teams/TestSite/_api/Web/SiteGroups/getbyid(142)/UsersMake sure that you have entered the correct site URL and group ID. You can find the group ID by opening specific group URL: 

  3. Click on Next and you will ask to choose the required Data. In this case we will only get the option for Users. Check it and click on Next.
  4. You can then see that the data will be loading in your Excel:
  5. Once it retrieves all the users from SharePoint group, you can save the file 🙂

I hope you liked this article. Please let us know in case you are having any questions in the comment section below. Like our facebook page and subscribe to our newsletter for future updates. have a great time 🙂

SharePoint Content Types – Best Explained

Hello folks, in this article I will try to explain SharePoint Content types in details. Most of the SharePoint beginners find it difficult to understand what exactly the content type is? and how we can use it in SharePoint? We will try to learn SharePoint content types by comparing it with one day-to-day example. We will cover the advantages and use of SharePoint content types during this course as well.

Day-to-day example (to understand SharePoint content types)

The example that we are going to discuss is the Banking system. When we need to make some transactions like cash withdrawal, cash deposit, cheque encashment, etc. we use different formats of slips. Making use of different format slips for different purposes makes it easy for bank officers to differentiate the type of transaction.

Consider that the bank has one big box in which they keep all kind of slips together. By the end of the day, it will be easier for them to differentiate the different formats of slips and make the calculations. If they would have used the same slip format for all kind of transactions (deposit, withdrawal, etc) it would have become difficult for them to deal with them. It may cause the huge loss for the bank as well.

SharePoint Content Types

In this example, you can consider

  • Big box (in which the slips are collected) as your list or library
  • Different formats of slips as SharePoint Content Type
  • Unique fields (like Name, Account number, Signature) in all formats of slips as Site columns

Thus, a content type is a reusable group of site columns which represents a set of information.

You can find another awesome example given by Greg here: Content Types Example

SharePoint Content Types

You will hear the word Content type every day while working with SharePoint. It is very important to understand and utilize the same. According to Microsoft, A content type is a reusable collection of metadata (columns), workflow, behavior, and other settings for a category of items or documents in a SharePoint list or document library. Content types enable you to manage the settings for a category of information in a centralized, reusable way.

SharePoint content type provides one more advantage to you, whenever you make any changes in content type, it provides an option whether to apply the new changes to all the lists (which are using that particular content type) or not.

If you have worked on a Task list or Announcement list then you have already used a content type. SharePoint has many default content types. If you create a new Task list, you can see that there are some columns already available like Task name, start date, due date, etc. These columns are default site columns and the Task list is using default content type as Task as shown below.

SharePoint Content Types

How to create a SharePoint content type?

Before creating a Content type you should make note of below important points

  1. It’s a best practice to create a Content type under the root site (top site) so that it can be used under all subsites as well. This is again based on the requirements of the organization because users don’t want to have too many content types under the root sites, which are not useful.
  2. If you create a Content type in a subsite, you cant use that Content type in your root site.
  3. When you update the Content type, it’s your wish whether to apply the updates on existing lists or not.
  4. If you want to delete the content type from the site collection, you need to remove that content type from all the associated list/libraries.

A) Create a content type for List

  1. Create a list named BankingSystem
  2. We will create 2 content types named Cash Deposit and Cash Withdrawal 
  3. Create 3 site columns named Customer Name, Account Number, Signature (You can read this article on creating site columns: SharePoint Site Columns)
  4. Go to Site Contents > Web Designer Galleries > Site content types
    SharePoint Content Types
  5. Click on create
  6. Enter the information as shown below. It will ask you to choose a Parent Content type, you can choose anyone. In this case, I have chosen Item content type. Item content type by default has Title site column only. Finally, click on OK
    SharePoint Content Types
  7. Now our content type is ready but before using it we have to first add site columns to it.
  8. To add site columns to this content type, go to Site SettingsWeb Designer Galleries > Site content types > Click on newly created a content type (Cash Deposit)
  9. Click on Add from existing site columns
    SharePoint Content Types
    10. Add the site columns to this content type. Here is an important point need to be noted. Add all the required site columns for this content type. In the below screenshot I have added only 3 but you can add as many as you want to make it different from other content types.
    SharePoint Content Types
  10. Similarly, add another content type and name it Cash Withdrawal with some different site columns.
  11. Now both the content types are ready for use. Let’s add these content types to a List named BankingSystem
  12. Go to List Settings > Advanced settings > make sure the Allow management of content type is selected as shown below:
    SharePoint Content Types
  13. Click on Add from existing site content types
  14. Add both the custom content types as shown below
  15. You can see both these content types are available under the New Item option

B) Create a SharePoint Content Type for Document Library

  1. Create a Document Library named BankingSystem
  2. We will create 2 content types named Cash Deposit and Cash Withdrawal 
  3. Create 3 site columns named Customer Name, Account Number, Signature (You can read this article on creating site columns: SharePoint Site Columns)
  4. Go to Site Contents > Web Designer Galleries > Site content types
  5. Then click on create.
  6. Enter the information as shown below. It will ask you to choose a Parent Content type, you can choose anything. In this case, I have chosen Document content type. Finally, click on OK
    SharePoint Content Types
  7. Now our content type is ready but before using it we can add site columns to it or can change the document template from advanced settings as shown below
  8. To add site columns to this content type, go to Site SettingsWeb Designer Galleries > Site content types > Click on newly created a content type (Cash Deposit)
  9. Click on Add from existing site columns
  10. Add the site columns to this content type. Here is an important point need to be noted. Add all the required site columns for this content type. In the below screenshot I have added only 3 but you can add as many as you want to make it different from other content types.
  11. Similarly, add another content type and name it Cash Withdrawal with some different site columns.
  12. Now both the content types are ready for use. Let’s add these content types to a Library named BankingSystem
  13. Go to Library Settings > Advanced settings > make sure the Allow management of content type is selected as shown below:
  14. Click on Add from existing site content types

  15. Add both the custom content types as shown below
  16. You can see both these content types are available under the New Document option

I hope you liked reading this article on SharePoint Content Types. If you have any questions feel free to as in the comment section below.

SharePoint Site Columns – Best Explained

Hello friends, in my 3 years of journey with SharePoint, I have never used SharePoint site columns. SharePoint provides the lightning fast way for creating list columns, which makes us lazy to learn about site columns. In this article, I will try to explain about SharePoint site columns in details. This applies to all versions of SharePoint like SharePoint 2010, 2013 and SharePoint Online (Office 365).

It takes a few seconds to create list columns
It takes a few seconds to create list columns

SharePoint Site Columns

According to Microsoft, “A site column is a reusable column definition, or template, that you can assign to multiple lists across multiple SharePoint sites. Site columns are useful if your organization wants to establish some consistent settings across lists and libraries.”

Why should we use SharePoint Site Columns?

Scenario:

Assume that your organization has a SharePoint portal which has 20 different lists. Each list contains a choice column named a country with 3 options as India, America, and England. later point of time, if you want to add one more country as China in the option for all the lists, what will you do? The only way available for you is to add that new option in each list manually from list settings.

In such scenarios, Site columns play an important role. Site columns allow you to share the changes/settings across multiple lists so that you don’t have to configure the settings each time. Site columns provide one more advantage to you, whenever you make any changes in site columns, it provides an option whether to apply the new changes to all the lists (which are using that particular site column) or not.

When you update the site column, it will ask whether to apply the changes on all lists which are using the particular site column
When you update the site column, it will ask whether to apply the changes on all lists which are using the particular site column.

How to Create a Site Column in SharePoint?

Before creating a Site Column you should make note of below important points

  1. It’s a best practice to create a Site Column under the root site (top site) so that it can be used under all subsites as well. This is again based on the requirements of the organization because users don’t want to have too many site columns under the root sites, which are not useful.
  2. If you create a Site Column in a subsite, you cant use that site column in your root site.
  3. When you update the site column, it’s your wish whether to apply the updates on existing lists or not (this point is already explained above).
  4. If you delete the site column, it won’t be deleted automatically from all the lists. You have to delete the site columns specifically from all the lists.

let’s see how to create a SharePoint site column:

  1. Go to Site Settings
  2. Click on Site columns under Web Designer Galleries
  3. Click on Create

  4. In the Name and Type section, type the name that you want in the Column name box. In this case we are creating a site column named Country.
  5. Choose the appropriate the column type like Singe line of text, Lookup, etc. In this case, Choice (India, America, and England)
  6. In the Group section, add this new Site column under existing groups or create a new one. Categorizing columns into groups will make it easier for users to find them in the future. In this case, we are adding this site column to a group named Custom Columns.
  7. Click on OK.

This way we are ready with the new site column, which can be used in all lists under the specified sites or subsites.

How to add site columns to existing SharePoint List or Library

Let’s add the newly created site column to the existing list. We have a list named EmployeeDetails where we are going to add a Site Column named Country which was added in Custom Columns group.

  1. Go to list settings
  2. Click on add from existing site columns

  3. Choose group so that it will be easy to find the custom site column. Then choose the site column name and click on Add
  4. Click on OK and we are ready to use this site column in our list.

How to update/delete site columns in SharePoint?

  1. Go to Site Settings
  2. Click on Site columns under Web Designer Galleries
  3. Click on Site Column name
  4. Update the site column and click OK or if you want to delete the column, click on Delete button.

I hope you liked this article. If you have any queries, please use below comments section for the same. Please like our facebook page and subscribe to our newsletter for future updates. Have a nice day! ta da…

CRUD Operations using REST API in SharePoint Online/2013/2010

  1. Hello folks, in this tutorial we are going to perform CRUD (Create, Read, Update and Delete) operations using REST API in SharePoint.

Learn how to perform CRUD (Create, Read, Update and Delete) operations using REST API in SharePoint List. You can use it for SharePoint Online, 2010, 2013 and 2016.
.

Create SharePoint list Item using REST API Read SharePoint list Item using REST API Update SharePoint list Item using REST API Delete SharePoint list Item using REST API

Setup required

We are using a SharePoint custom list named “EmployeeDetails” with below columns:

Column Name Type
EmloyeeName (internal name is Title) Single line of text
Address Multiple lines of text
Country Choice (India, US, UK)
Age Number
Salary Currency
DateOfBirth Date and Time
IsEmployeeMarried Checkbox
ManagerName Person or group
ProfileUrl Hyperlink

Download: You can download the template of this SharePoint list here.

Create Item:

//Create a SharePoint List Item using REST Api

function createItem() {
    $.ajax({
        url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('EmployeeDetails')/Items",
        type: 'POST',
        headers: {
            "Accept": "application/json;odata=verbose",
            "Content-Type": "application/json;odata=verbose",
            "X-RequestDigest": $("#__REQUESTDIGEST").val(),
            "X-HTTP-Method": "POST"
        },
        data: JSON.stringify({
            __metadata: {
                type: "SP.Data.EmployeeDetailsListItem"
            },
            Title: "Mayuresh Dinkar Joshi",
            Address: "ABC Center, Near Sdftji Dfrtg 123123 Test",
            Country: 'India',
            Age: 25,
            Salary: 1000,
            DateOfBirth: "1993-09-21T07:00:00Z",
            IsEmployeeMarried: true,
            ManagerNameId: 16, //internalName is 'ManagerName' but we have to use 'ManagerNameId' to pass id of a person
            ProfileUrl: {
                __metadata: {
                    "type": "SP.FieldUrlValue"
                },
                Url: "http://test.com",
                Description: "Url Description"
            },
        }),
        success: function(data) {
            alert('Item created successfully!');
        },
        error: function(error) {
            alert(JSON.stringify(error));
        }
    });
}

Read Item:

//Read a SharePoint List Item using REST Api

function readItem() {
    $.ajax({
        url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('EmployeeDetails')/Items(1)",
        type: 'GET',
        headers: {
            "accept": "application/json;odata=verbose",
        },
        success: function(data) {
            console.log(data.d);
            alert(" First name: " + data.d.Title +
                "\n Address: " + data.d.Address +
                "\n Country: " + data.d.Country +
                "\n Age: " + data.d.Age +
                "\n Salary: " + data.d.Salary +
                "\n DateOfBirth: " + data.d.DateOfBirth +
                "\n IsEmployeeMarried: " + data.d.IsEmployeeMarried +
                "\n ManagerName: " + data.d.ManagerNameId +
                "\n ProfileUrl: " + data.d.ProfileUrl.Url);
        },
        error: function(error) {
            alert(JSON.stringify(error));
        }
    });
}

Update Item

//Update a SharePoint List Item using REST Api

function updateItem() {
    $.ajax({
        url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('EmployeeDetails')/Items(1)",
        type: "PATCH",
        headers: {
            "Accept": "application/json;odata=verbose",
            "Content-Type": "application/json;odata=verbose",
            "X-RequestDigest": $("#__REQUESTDIGEST").val(),
            "IF-MATCH": "*",
            "X-HTTP-Method": "MERGE"
        },
        data: JSON.stringify({
            __metadata: {
                type: "SP.Data.EmployeeDetailsListItem"
            },
            Title: "updated Mayuresh Dinkar Joshi",
            Address: "updated ABC Center, Near Sdftji Dfrtg 123123 Test",
            Country: 'US',
            Age: 26,
            Salary: 2000,
            DateOfBirth: "1993-09-22T07:00:00Z",
            IsEmployeeMarried: false,
            ManagerNameId: 16, //internalName is 'ManagerName' but we have to use 'ManagerNameId' to pass id of a person
            ProfileUrl: {
                __metadata: {
                    "type": "SP.FieldUrlValue"
                },
                Url: "http://test1.com",
                Description: "updated Url Description"
            },
        }),
        success: function(data) {
            alert('Item updated successfully!');
        },
        error: function(error) {
            alert(JSON.stringify(error));
        }
    })
}

Delete Item

//Delete a SharePoint List Item using REST Api

function deleteItem() {
    $.ajax({
        url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('EmployeeDetails')/Items(1)",
        type: 'DELETE',
        headers: {
            "X-RequestDigest": $("#__REQUESTDIGEST").val(),
            "IF-MATCH": "*",
            "X-HTTP-Method": "DELETE"
        },
        success: function(data) {
            alert('Item deleted');
        },
        error: function(error) {
            alert(JSON.stringify(error));
        }
    })
}

 

 

Sharepoint online practice test for beginners

Sharepoint online practice test – 1

 

The objective of this SharePoint online test is to evaluate the basic knowledge of SharePoint for beginners. In this quiz, there are 10 Simple questions for SharePoint online. There is no time limitation for this quiz with unlimited attempts.

[wp_quiz id=”1681″]

Tags: online test, practice test, online practice, online practice test, SharePoint online, online test online, test online, SharePoint online test, SharePoint practice exams

Meta keywords: Sharepoint online test, online test, Sharepoint, test, quiz, Sharepoint MCQs, Sharepoint Multiple Choice Questions, beginners.

Convert Excel to JSON using JavaScript code

Hello friends, in this javascript tutorial we are going to learn about how to Convert Excel to JSON using JavaScript code. We can read an excel file which is hosted on any server, SharePoint folder, etc with the help of javascript code. Here you can get readymade javascript code for Excel to JSON conversion.

Excel to JSON
Excel to JSON

Convert Excel to JSON using JavaScript Code

In this tutorial, we are going to use a js-xlsx library to convert Excel to JSON. It has xlsx.full.min.js file which we are going to refer in our HTML file. js-xlsx is a parser and writer for various spreadsheet formats. So without wasting time lets jump to coding part. We can also use .csv files as well.

Below is a code for reading Excel as a JSON object:

<!doctype html>
<html>

<head>
    <title>Excel to JSON Demo</title>
    <script src="xlsx.full.min.js"></script>
</head>

<body>

    <script>
        /* set up XMLHttpRequest */
        var url = "https://myclassbook.org/wp-content/uploads/2017/12/Test.xlsx";
        var oReq = new XMLHttpRequest();
        oReq.open("GET", url, true);
        oReq.responseType = "arraybuffer";

        oReq.onload = function(e) {
            var arraybuffer = oReq.response;

            /* convert data to binary string */
            var data = new Uint8Array(arraybuffer);
            var arr = new Array();
            for (var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);
            var bstr = arr.join("");

            /* Call XLSX */
            var workbook = XLSX.read(bstr, {
                type: "binary"
            });

            /* DO SOMETHING WITH workbook HERE */
            var first_sheet_name = workbook.SheetNames[0];
            /* Get worksheet */
            var worksheet = workbook.Sheets[first_sheet_name];
            console.log(XLSX.utils.sheet_to_json(worksheet, {
                raw: true
            }));
        }

        oReq.send();
    </script>
</body>

</html>

In the above code, if you could observe, you will find that we have used xlsx.full.min.js file and a Test.xlsx file. We are going to read Test.xlsx Excel file to generate a JSON Object.

Note: While using above code make sure that you have uploaded your Excel file on any server and give the correct full path of that file. You can use the same code to convert CSV to JSON.

Here is our Test.xlsx file which looks like below

Output

When you host your index.html file on the server, on the page load we are running our script to show the objects in the browser console. Below is the output in JSON object

JSON Object output
JSON Object output

Download Excel to JSON javascript

You can use any one of the links to download the source code

  1. MyClassBook: Download
  2. Google Drive: Download
  3. MediaFire: Download

I hope you liked this article. Please let us know if you face any issues in the comment sections below. Like our facebook page and subscribe to our newsletter for future updates. Have a great time! 🙂

Convert SharePoint Date to Readable date format using jquery

Hi friends, today we are going to see how can we convert SharePoint date into human radable date format using jquery.

When you use REST api or JSOM to retrieve the date from sharepoint date field you will get the output like /Date(1508371200000)/

We can easily convert above date format into human readable format using below script. Here

var rawDate = "/Date(1508371200000)/"; 
var rawDate = parseInt(rawDate.substring(6, 19)); 
var d = new Date(rawDate); 
var result = d.format("dd MMM yyyy");

In the above code variable result will give you the output as 19 Oct 2017

Convert SharePoint date to Readable date
Convert SharePoint date to Readable date

I hope you liked this article. Please feel free to ask your queries in comment section below. Like our facebook page ans subscribe to our newslette for future updates. Have a nice day!

How to Display SharePoint List in jQuery Datatables

Hello friends, in this article we are going to retrieve data from SharePoint List using REST API and will display that data into jQuery Datatable. So let’s begin…

Show SharePoint List in Datatable format

Step 1:

We have a SharePoint list named EmployeeDetails as shown below with some dummy data. This list has 4 columns (Title, Name, Salary, Address).

EmployeeDetails List
EmployeeDetails List

Step 2 : Create a site page where we are going to show above data in datatable. For creating a page go to Site contents > Site pages > Click on new page icon. In this case I have created a page with name Employee Details.

Step 3 : Insert a Content Editor Webpart into a page.

Employee Details Page
Employee Details Page

Step 4 : Edit the Content Editor Webpart and paste the below code into it.

 

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js"></script>
<link href="https://cdn.datatables.net/1.10.9/css/jquery.dataTables.min.css" rel="Stylesheet" type="text/css" />
<script type="text/javascript" src="../SiteAssets/EmployeeJqueryDatatable.js"></script>
<div id="DatatablePanel">
    <table style="width: 100%;">
        <tr>
            <td>
                <div id="DatatableGrid" style="width: 100%"></div>
            </td>
        </tr>
    </table>
</div>

download above html file here. (or you can use MediaFire link)

Step 5 : If you can observe the above code, we have referenced a .js file named EmployeeJqueryDatatable.js So we have to first create this js file and upload it into Site assets. Please copy the below code into this js file and named it as EmployeeJqueryDatatable.js

$(document).ready(function() {
    var RestUrl = "../_vti_bin/listdata.svc/EmployeeDetails";
    $.ajax({
        url: RestUrl,
        method: "GET",
        headers: {
            "accept": "application/json;odata=verbose",
        },
        success: function(data) {
            if (data.d.results.length > 0) {
                //construct HTML Table from the JSON Data
                $('#DatatableGrid').append(GenerateTableFromJson(data.d.results));
                //Bind the HTML data with Jquery DataTable
                var oTable = $('#EmployeeTable').dataTable({
                    "iDisplayLength": 5,
                    "aLengthMenu": [
                        [5, 10, 30, 50],
                        [5, 10, 30, 50]
                    ],
                    "sPaginationType": "full_numbers"
                });
            } else {
                $('#DatatableGrid').append("<span>No Employee Details Found.</span>");
            }
        },
        error: function(data) {
            $('#DatatableGrid').append("<span>Error Retreiving Employee Details. Error : " + JSON.stringify(data) + "</span>");
        }
    });

    function GenerateTableFromJson(objArray) {
        var tableContent = '<table id="EmployeeTable" style="width:100%"><thead><tr><td>Title</td>' + '<td>Name</td>' + '<td>Salary</td>' + '<td>Address</td>' + '</tr></thead><tbody>';
        for (var i = 0; i < objArray.length; i++) {
            tableContent += '<tr>';
            tableContent += '<td>' + objArray[i].Title + '</td>';
            tableContent += '<td>' + objArray[i].Name + '</td>';
            tableContent += '<td>' + objArray[i].Salary + '</td>';
            tableContent += '<td>' + objArray[i].Address + '</td>';
            tableContent += '</tr>';
        }
        return tableContent;
    }
});

download above .js file here (for security reasons I have used .txt file here, so after downloading rename it to .js) or you can use MediaFire link to download the direct js file here

Step 6 : Once you upload the above js file into your site assets, go to our EmployeeDetails page that we ceated in step no. 2. Here we go!!! below is the output for our EmployeeDetails list

Video tutorial:

I have also created a step by step video tutorial for SharePoint Datatables. Please watch it for clear understanding:

https://www.youtube.com/watch?v=gXoeBrXSb3A

I would like to reply to your queries. Please let me know whether you liked this simple step by step article on SharePoint Datatable integration. I am waiting for your comments! Please like our facebook page and subscibe to our newsletter for future updates. Have a nice day!