SharePoint 2013 Hosting – HostForLIFE.eu :: Fetching SharePoint List Items Using A Simple HTTP REST Command

Nov 15th

Posted by Peter in European SharePoint 2013 Hosting

In this article, I will introduce you to an online service I created that allows you to code against certain services without using an SDK, simply by sending HTTPS REST commands. In this article, I will demonstrate how this works against SharePoint Online; however other services are also available.

Please note that I built this service with the community in mind, and as a result, it is free for simple use. The service stores your configuration settings securely so that the actual service secrets (such as your SharePoint password) are not stored on the client code.

Developing without an SDK makes it much easier to code IoT, web and Mobile projects, and works regardless of the operating system or programming language. That’s because you can make simple REST commands instead of using an SDK; the call returns a JSON payload with the data.

Let’s see how we can fetch SharePoint List Items using a simple HTTP REST command. The REST method to call is called GetListItemEx. Let’s first look at a raw HTTP command that you can send using Postman for example. There are a few variables to change, which we will review.

GET ENZO_URI/bsc/sharepoint/getlistitemsex HTTP/1.1
authToken: YOUR_AUTH_TOKEN
_config: myconfigname
viewname: mylist
where: State=’FL’

The following variables should be replaced in the above code:

ENZO_URI: this is the URI of your Enzo service endpoint that is assigned to you on the portal
YOUT_AUTH_TOKEN: this is your assigned authToken, also available on the portal
myconfigname: this is a configuration name that you created in the portal that points to SharePoint
viewname: the name of the SharePoint list
where: an optional WHERE clause that looks like a SQL where clause

For example, the following Postman screenshot shows you the REST command I sent to my server, which in turn connected to SharePoint Online to fetch items from the US States list. The name of the configuration is called sharepointroggero (we will see this shortly).

As you can see, there are no SharePoint-specific secrets here; all the details are stored on the portal under the configuration setting called sharepointroggero. Let’s go to the portal and review the configuration settings; once you log in to the portal, click on the SharePoint service on the left, and click on Create. You will see a screen similar to this where you can store your configuration settings.

Now let’s create a small C# Console project to make the same REST call. To try the following source code, you will need to sign up on the Enzo Online portal here, create a configuration setting for SharePoint Online and access your Enzo URI and AuthToken by selecting Enzo Accounts from the menu. The code does essentially the same thing as above: it retrieves the content of a list called MyList using a configuration setting called myconfigname. As discussed previously, this code does not use the SharePoint SDK; it relies entirely on HTTPS REST calls.

using System;  
using System.Collections.Generic;  
using System.Linq;  
using System.Net;  
using System.Text;  
using System.Threading.Tasks;  
  
namespace Sample  
{  
class Program  
{  
static void Main(string[] args)  
{  
    string url = "https://ENZO_URI/bsc/sharepoint/getlistitemsex";  
    string authId = "YOUR_AUTH_ID";  
    WebRequest wr = WebRequest.CreateHttp(url);  
    try  
    {  
        // Add the required HTTP headers for the call  
        wr.Headers.Add("authToken", authId);  
        wr.Headers.Add("viewname", "mylist");  
        wr.Headers.Add("_config", "myconfigname");  
        wr.Method = "GET";  
        var resp = wr.GetResponse();    // Execute the command  
        using (var stream = resp.GetResponseStream())  
        {  
        }  
        Console.WriteLine("HTTP Response: " + ((System.Net.HttpWebResponse)(resp)).StatusCode);  
  
    }  
    catch (Exception ex)  
    {  
        Console.WriteLine("ERROR: Response from " + baseUrl + command + ":" + ex.Message);  
    }  
    Console.ReadKey();  
}  
}  
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Text;

using System.Threading.Tasks;

namespace Sample

{

class Program

{

static void Main(string[] args)

{

string url = "https://ENZO_URI/bsc/sharepoint/getlistitemsex";

string authId = "YOUR_AUTH_ID";

WebRequest wr = WebRequest.CreateHttp(url);

try

{

// Add the required HTTP headers for the call

wr.Headers.Add("authToken", authId);

wr.Headers.Add("viewname", "mylist");

wr.Headers.Add("_config", "myconfigname");

wr.Method = "GET";

var resp = wr.GetResponse(); // Execute the command

using (var stream = resp.GetResponseStream())

{

}

Console.WriteLine("HTTP Response: " + ((System.Net.HttpWebResponse)(resp)).StatusCode);

}

catch (Exception ex)

{

Console.WriteLine("ERROR: Response from " + baseUrl + command + ":" + ex.Message);

}

Console.ReadKey();

}

Similarly, here is a Python sample code that does essentially the same thing.

import sys  
import urllib  
import urllib2  
import requests  
  
enzourl_receiveMsg="https://ENZO_URI:ENZO_PORT/bsc/sharepoint/getlistitemsex"  
enzo_guid="YOUR_AUTH_ID"  

#create the headers this call expects  
headers={  
    'authToken': enzoguid,  
    'viewname': 'mylist',  
    '_config': 'myconfigname'    
}  
response=requests.get(enzourl_receiveMsg,headers=headers)

import sys

import urllib

import urllib2

import requests

enzourl_receiveMsg="https://ENZO_URI:ENZO_PORT/bsc/sharepoint/getlistitemsex"

enzo_guid="YOUR_AUTH_ID"

#create the headers this call expects

headers={

'authToken': enzoguid,

'viewname': 'mylist',

'_config': 'myconfigname'

}

response=requests.get(enzourl_receiveMsg,headers=headers)

The purpose of this article was to introduce you to a new development approach that simplifies development, and removes complex SDKs from client code using SharePoint as an example. Additional documentation and sample code is available online.

SharePoint 2013 Hosting Recommendation

HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint 2016 Mobile View Not Working On Mobile Devices

Nov 8th

Posted by Peter in European SharePoint 2013 Hosting

No comments

The last couple of days, I got stuck in an issue in which whenever the users browsed the sites on their mobile devices, the Mobile View was not working and it showed a blank page with site collection name written on the top left along with a mobilesuite navbar in the bottom of one of the SharePoint 2016 on-premise farms. When they clicked on the ellipsis and switched to the PC View, nothing happened. It showed just a blank page.

While troubleshooting, if they clicked on the “GoTo” button, it threw the following error message.

“Sorry, it seems like your connection is too slow. Try connecting to Wi-Fi or going somewhere with better reception.”

I have multiple SharePoint farms with different configurations, so I tested the same scenario on two farms. One farm was where I have a User Profile service along with MySite host and the second farm is where the User Profile service is without MySite Host. I tested the below scenario on both, iOS as well as Android, devices and also tried Safari, Chrome, and Samsung browsers.

Farm with UPA and MySite host

When I perform the testing in this farm, I am able to browse the SharePoint sites on mobile devices as well as in the browser. Perfect!

Farm with UPA but no MySite host

When I performed the testing on this farm, I was unable to browse the sites on the mobile devices. That’s pain.

As per the documentation, there is no such requirement of UPA along with MySite host for browsing the sites on the mobile devices. Now, I moved to the next step to deep dive into it and checked what the root cause was.

ULS logs

There is nothing in ULS logs for me even with Verbose logging. I tried different categories but got no clue over here. I used the F12 Developer tool (I configured my browser so it acts as a mobile browser).

In the working farm

If I browse the sites on mobile, I noticed it loaded the following JS files.

mblappbar.js
mblsuitenav.js
touchappstrings.js
touchapp.js
mylinks.js

It rendered the page properly without any error in the developer tool.

In the non-working farm

I opened the sites in a mobile browser and noticed that all the JavaScript files were loading properly except mylinks.js which was not loading at all. After further checking the mylinks.js file, I came to know that this is the file which looks for the information from person.aspx page and that puts the dependency on MySite host. Because we don’t have the MySite host configured in this farm, so there was no person.aspx page, which is where the Mobile View got broken on the mobile devices.

Now, it is a blank page with nothing on it. In developer tools, it showed the error on loading the touchapp.js file. This is the main file which makes calls to all the other JavaScript files.

So now, the question arises why this dependency. To get the answer, I contacted MSFT. As per MSFT, it is a bug and they will fix it in future updates.

Resolution

I created a MySite host site collection and configured it inside of the User Profile Service’s MySite settings. I removed the permission for everyone because we don’t want anyone to create the MySite host on this farm. As soon as the stuff was configured, everything started working as expected.

If you don’t have the MySite host configured in your farm then you will get into this problem. You have to create a MySite host in order to make the mobile view work properly.

Note
If you don’t allow MySite for your users, then you have to remove the permissions from the MySite Host page so that no one can create a MySite page.

Hope this will help you for now. I will update once they release the fix for this one. By the way, this problem exists in SharePoint 2019 preview as well.

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Access Denied Error

Nov 1st

Posted by Peter in European SharePoint 2013 Hosting

No comments

We have a SharePoint 2013 farm and were retracting a solution; we were using Chrome browser. In the browser our site was open in two tabs and in one tab was central admin. When we were trying to retract a solution through central admin we were getting an “Access Denied” error. We are logged in with user having Administrator rights so it seems not to be a user permission issue.

It was a very small fix but I thought to share, as maybe it can save you time.

Error and Stack Trace
Access denied. Only machine administrators are allowed to create administration service job definitions of type

Microsoft.SharePoint.Administration.SPSolutionDeploymentJobDefinition, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c.Application error when access /_admin/RetractSolution.aspx, Error=Access denied. Only machine administrators are allowed to create administration service job definitions of type: Microsoft.SharePoint.Administration.SPSolutionDeploymentJobDefinition, Microsoft.SharePoint, Version=15.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c. at Microsoft.SharePoint.Administration.SPAdministrationServiceJobDefinition..ctor(String name, SPService service, SPServer server, SPJobLockType lockType) at Microsoft.SharePoint.Administration.SPSolutionDeploymentJobDefinition..ctor(String solutionName, Guid solutionId, UInt32 lcid, SPTimerService service, SPCompatibilityRange compatibilityRange) at Microsoft.SharePoint.Administration.SPSolutionLanguagePack.CreateSolutionDeployTimerJob(DateTime... e4a5099e-e182-6064-8575-d8b087e7d93cGeneral 8nca Medium ... dt, Collection`1 webApplications, SPSolutionDeploymentJobType jobType, Boolean globalInstallDlls, Boolean force, Boolean isRestore, SPCompatibilityRange compatibilityRange) at Microsoft.SharePoint.ApplicationPages.SolutionPageBase.CreateDeploymentJob(Boolean deploy, String strSelectedWeb, Boolean globalInstall, DateTime dt, Boolean localDeployment) at Microsoft.SharePoint.ApplicationPages.RetractSolutionPage.BtnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsy... e4a5099e-e182-6064-8575-d8b087e7d93c

Microsoft.SharePoint.Administration.SPSolutionDeploymentJobDefinition, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c.Application error when access /_admin/RetractSolution.aspx, Error=Access denied. Only machine administrators are allowed to create administration service job definitions of type: Microsoft.SharePoint.Administration.SPSolutionDeploymentJobDefinition, Microsoft.SharePoint, Version=15.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c. at Microsoft.SharePoint.Administration.SPAdministrationServiceJobDefinition..ctor(String name, SPService service, SPServer server, SPJobLockType lockType) at Microsoft.SharePoint.Administration.SPSolutionDeploymentJobDefinition..ctor(String solutionName, Guid solutionId, UInt32 lcid, SPTimerService service, SPCompatibilityRange compatibilityRange) at Microsoft.SharePoint.Administration.SPSolutionLanguagePack.CreateSolutionDeployTimerJob(DateTime... e4a5099e-e182-6064-8575-d8b087e7d93cGeneral 8nca Medium ... dt, Collection`1 webApplications, SPSolutionDeploymentJobType jobType, Boolean globalInstallDlls, Boolean force, Boolean isRestore, SPCompatibilityRange compatibilityRange) at Microsoft.SharePoint.ApplicationPages.SolutionPageBase.CreateDeploymentJob(Boolean deploy, String strSelectedWeb, Boolean globalInstall, DateTime dt, Boolean localDeployment) at Microsoft.SharePoint.ApplicationPages.RetractSolutionPage.BtnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsy... e4a5099e-e182-6064-8575-d8b087e7d93c

It seems to be a weird error. No user permission issue.

We Googled a lot and then got the below article related to the same issue but not the exact one.

https://social.technet.microsoft.com/wiki/contents/articles/30757.sharepoint-troubleshooting-access-denied-only-machine-administrators-are-allowed-to-create-administration-service-job.aspx

In the above article the exact issue isn’t mentioned but at least we got an idea. We have closed the browser, opened the central admin again with the run as administrator option, tried again and it worked like a charm.

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create And Use Task List In SharePoint 2013?

Oct 11th

Posted by Peter in European SharePoint 2013 Hosting

No comments

This post will explain you about create task list in SharePoint 2013. Using task list can in SharePoint to track your daily activities, assign task to team members, track due date for daily activities, etc.

First, open SharePoint site. Now, select the Site settings and Add an app.

Click on Task app to create.

Provide the name for the task list. Click Create.
So the new task list has been created successfully. So here’s the task list with timeline. In SharePoint 2013 we have a timeline feature in the task list to track your daily task activities.

Now I am going to assign a task to my team member. Click on new task.
Provide the name for the task.
Provide the task start date and due date.
Assigned to ‘Assign the task to any of your team member’.
Percentage completed and the default will be ‘0’ as in the following screenshot:

Set priority to Low, High, Normal.

Update the status of the task.
Click Save.
Fill the description if u needed and add predecessors.
So the new task has been assigned successfully.

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Scripting Capabilities, Why SharePoint Framework

Oct 3rd

Posted by Peter in European SharePoint Server 2013 Hosting

No comments

Custom scripting is a vital element of custom development in SharePoint Online. Scripting allows running custom scripts on SharePoint Online sites to achieve the desired result. It may be used to fetch the data from SharePoint or manipulate the DOM structure.

A few features of it are turned off by default. Scripting capability is also one of those features.

Custom Scripting Scenarios

The custom script by default is disabled on the below sites.

SharePoint Online root site collection
Classic SharePoint site collection
SharePoint MySites
Personal OneDrive sites
SharePoint site collection created based on self-service site creation

Mentioned below are a few scenarios which are impacted due to a disabled custom script.

Uploading sandbox solutions
Upload custom master pages and page layouts

If custom scripting is turned off, it does not allow you to upload the below file types.

.master
.aspx
.ascx
.asmx
.htc
.jar
.swf
.xap
.xsf

The following site features are unavailable if the custom scripting is turned off.

Save Site as Template
Save document library as template
Solution Gallery
Theme Gallery
Help Settings
HTML Field Security
Sandbox solutions
SharePoint Designer
Uploading files that potentially include script

Turn on custom scripting

Follow the below procedure to turn custom scripting on.

Open SharePoint Online Admin Center (https://[tenant]-admin.sharepoint.com).
From the left menu, click settings.
Check “Allow users to run custom scripts on personal sites and self-service created sites”.

Enable Custom Script with PowerShell

If it is not feasible to wait for 24 hours until the timer job runs to turn on the custom scripting, we can turn it on using PowerShell.

Download and Install SharePoint Online Management Shell from https://www.microsoft.com/en-us/download/details.aspx?id=35588
Open SharePoint Online Management Shell.
Connect to your SharePoint online tenant.Connect-SPOService -Url “https://[tenant]-admin.sharepoint.com”
Run the below command to enable custom scripting.Set-SPOSite -Identity https://[tenant].sharepoint.com -DenyAddAndCustomizePages 0
To disable scripting capabilities, run this command -Set-SPOSite -Identity https://[tenant].sharepoint.com -DenyAddAndCustomizePages 1

Security Implications

Enabling the custom scripts on SharePoint tenant helps the developers in inserting the script to address different business scenarios. However, we can no longer enforce the governance around what custom script can do and where the scripts can be added to SharePoint.

Anyone who has “Add and Customize Pages” permission can insert the custom code. There are no boundaries for executing the script. This makes it very difficult to identify –

Who has added the custom script?
What code has been added as part of a custom script?
Where the custom script has been added on SharePoint site?

What can custom script do?

The custom script runs in the context of the current logged in user. That means, the script can access everything that a user has access to. Script can also access the content across Office 365 services.

Alternative to Custom Script (SharePoint Framework – SPFx)

To bring the governance, the recommended approach is to use SharePoint Framework (SPFx). Below are features of SPFx:

SPFx runs in the context of the current user
It does not use iFrame
Controls are responsive
SPFx has access to Document Object Model (DOM)
Developer can access the lifecycle
It can be developed using any JavaScript framework (React, Knockout, Angular, etc)
The toolchain is open source (npm, TypeScript, Yeoman, Gulp)
Office 365 admins have governance tool to disable the SPFx solution
SPFx can work with classic and modern SharePoint

Summary

Enabling custom script allows the developers to address business scenarios easily by inserting the scripts. However, it makes it very difficult to bring the governance. SharePoint Framework (SPFx) is a recommended way to implement the solutions that can work for both, classic and modern, SharePoint sites.

SharePoint 2013 Hosting – HostForLIFE.eu :: Custom Like And Comment Functionality For SharePoint Online Custom Pages

Sep 27th

Posted by Peter in European SharePoint 2013 Hosting

No comments

Today we will see how to add custom like and comment functionality in SharePoint custom pages. For that I have developed one common web part/txt file using JQuery and REST api. Currently SharePoint is providing likes and rating functionality for the list items. I tried to use this but this was not required so I tried to develop this custom functionality for SharePoint online pages.

You need to just add one content editor web part and add the below code into that web part. Below are the overall steps.Step 1
Create custom list in SharePoint having name “LikesList” to store all the likes given by the user. Add the below columns into it,

column name : LikeBy type : Person or Group
column name : CommentID type : Number
column name : PageURL type : Single line of text

Step 2
Create custom list in SharePoint having the name “CommentsList” to store all the comments added by user. Add the below columns into it,

column name : ParentCommentID type : Number
column name : CommentText type : Multiple lines of text
column name : PageURL type : Single line of text
column name : CommentBy type : Person or Group

Step 3
Now create one text file and add the below code into it and save that file.

<div style="width: 70%;background-color: white;color: black; border-radius: 5px; padding:10px;">  
    <table style="width:100%">  
        <tbody>  
            <tr>  
                <td style="text-align: right;">  
                    <span id="lblPageComments">0 Comments | </span>  
                    <span id="spLikes" title="" class="LikeClass">  
                        <img id="imgLike" src="../_layouts/15/images/LikeFull.11x11x32.png?rev=23">  
                        <span id="lblPageLikes">0</span>  
                    </span>  
                    <a id="lnkBtnPageLike" class="links">Like</a>  
                    <span id="LikeID" style="display:none;"></span>     </td>  
            </tr>  
            <tr>  
                <td style="padding-left: 5px;">  
                    <h3>Comment : </h3>  
                </td>  
            </tr>  
            <tr>  
                <td style="padding: 25px;">  
                    <textarea name="txtComments" rows="3" cols="20" id="txtComments" placeholder="Comment..." style="width:95%;"></textarea><br><br>  
                    <input type="button" name="btnPost" value="Post" id="btnPost">  
                    <input type="button" name="btnReset" value="Reset" id="btnReset">  
                </td>  
            </tr>  
        </tbody>  
    </table>  
    <br> Comments... <table id="tblComments" style="width:100%">  
    </table>  
</div>  
<style type="text/css">  
    a {  
        cursor: pointer;  
    }  
</style>  
<script src="/JS/jquery.min.js"></script>  
<script src="/JS/jquery-ui.js"></script>  
<link rel="stylesheet" href="/CSS/jquery-ui.css">  
<script src="JS/jquery-dateFormat.min.js"></script>  
<script type="text/javascript">  
    var PageURL = window.location.href;  
    var UserID = _spPageContextInfo.userId;  
    $(document).ready(function() {  
        getSetPageDet();  
        getAllComments();  
        $("#btnPost").click(function() {  
            AddComment();  
        });  
        $("#btnReset").click(function() {  
            $("#txtComments").val("");  
        });  
        $("#lnkBtnPageLike").click(function() {  
            if ($("#lnkBtnPageLike")[0].innerText == "Like") {  
                LikePage();  
            } else {  
                UnLikePage();  
            }  
        });  
    });  
    // This function will reset the value of comment box  
    function reset(textbox) {  
        $("#txtReply_" + textbox).val("");  
    }  
    // This function is used to get all the comments from comments list for that particular page having type as comment.  
    function getAllComments() {  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items?$expand=CommentBy&$select=*,CommentBy/Title&$filter=PageURL eq '" + PageURL + "' and Title eq 'Comment'&$orderby=ID desc",  
            type: "GET",  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "content-Type": "application/json;odata=verbose"  
            },  
            success: function(data) {  
                var commentsHTML = "";  
                if (data.d.results.length > 0) {  
                    $.each(data.d.results, function(index, value) {  
                        var CreatedDate = jQuery.format.date(value.Created, "ddd, MMM d, yyyy h:mm a");  
                        commentsHTML += "<tr><td><span id='CommentsID_" + value.Id + "' style='display:none;'>" + value.Id + "</span><br><span>" + value.CommentText + "</span><br><a class='linksAuthor' href='/../../_layouts/15/userdisp.aspx?ID=" + value.CommentById + "' target='_blank'>" + value.CommentBy.Title + "</a><br><span>" + CreatedDate + "</spam>      <span id='lblCommentReplies_" + value.Id + "'>0 Replies | </span><span id='spLikes_" + value.Id + "' title='' class='LikeClass'>  <img src='../_layouts/15/images/LikeFull.11x11x32.png?rev=23'>  <span id='lblLikes_" + value.Id + "' class='LikeClass'>0</span></span>  <a id='lnkBtnLike_" + value.Id + "' class='links' onClick='LikeComment(" + value.Id + ")'>Like</a><span id='LikeID_" + value.Id + "' style='display:none;'></span>";  
                        if (UserID == value.CommentById) {  
                            commentsHTML += "   <a id='lnkBtnDelete_" + value.Id + "' class='links' onClick='DeleteComment(" + value.Id + ")'>Delete</a><br><br>Replies...<br><div style='margin-left: 10%;'><table style='width: 90%'><tbody><tr><td colspan='2'><textarea name='txtReply_" + value.Id + "' rows='1' cols='20' id='txtReply_" + value.Id + "' placeholder='Reply...' style='width:100%;'></textarea><br><br><input type='button' name='btnPostReply_" + value.Id + "' value='Post' id='btnPostReply_" + value.Id + "' onClick='AddReply(" + value.Id + ")'><input type='button' name='btnResetReply_" + value.Id + "' value='Reset' id='btnResetReply_" + value.Id + "' onClick='reset(" + value.Id + ")'></td></tr></tbody></table><div><table cellspacing='0' id='tblReply_" + value.Id + "' style='border-collapse:collapse;'></table></div></div><br><hr></td></tr>";  
                        } else {  
                            commentsHTML += "<br><br>Replies...<br><div style='margin-left: 10%;'><table style='width: 90%'><tbody><tr><td colspan='2'><textarea name='txtReply_" + value.Id + "' rows='1' cols='20' id='txtReply_" + value.Id + "' placeholder='Reply...' style='width:100%;'></textarea><br><br><input type='button' name='btnPostReply_" + value.Id + "' value='Post' id='btnPostReply_" + value.Id + "' onClick='AddReply(" + value.Id + ")'><input type='button' name='btnResetReply_" + value.Id + "' value='Reset' id='btnResetReply_" + value.Id + "' onClick='reset(" + value.Id + ")'></td></tr></tbody></table><div><table cellspacing='0' id='tblReply_" + value.Id + "' style='border-collapse:collapse;'></table></div></div><br><hr></td></tr>";  
                        }  
                    });  
                    $("#tblComments")[0].innerHTML = commentsHTML;  
                    getSetCommentDet();  
                }  
            },  
            error: function(error) {  
                alert(JSON.stringify(error));  
            }  
        });  
    }  
    // This function is used to get all the likes from like list for that particular page.  
    function LikeReply(CommentID) {  
        var title = "Reply";  
        if ($("#lnkBtnReplyLike_" + CommentID)[0].innerText == "Like") {  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items",  
                type: "POST",  
                data: JSON.stringify({  
                    '__metadata': {  
                        'type': 'SP.Data.LikesListListItem'  
                    },  
                    'LikeById': UserID,  
                    'Title': title,  
                    'CommentID': CommentID  
                }),  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                    "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                    "content-Type": "application/json;odata=verbose"  
                },  
                success: function(data) {  
                    $("#lnkBtnReplyLike_" + CommentID)[0].innerText = "Unlike";  
                },  
                error: function(error) {  
                    console.log(JSON.stringify(error));  
                }  
            });  
        } else {  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items(" + $("#ReplyLikeID_" + CommentID)[0].innerText + ")",  
                type: "POST",  
                async: false,  
                headers: {  
                    "Accept": "application/json;odata=verbose",  
                    "X-Http-Method": "DELETE",  
                    "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                    "If-Match": "*"  
                },  
                success: function(data) {  
                    $("#lnkBtnReplyLike_" + CommentID)[0].innerText = "Like";  
                    getSetPageDet();  
                    getAllComments();  
                },  
                error: function(data) {  
                    console.log(JSON.stringify(error));  
                }  
            });  
        }  
    }  
  
    function LikeComment(CommentID) {  
        var title = "Comment";  
        if ($("#lnkBtnLike_" + CommentID)[0].innerText == "Like") {  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items",  
                type: "POST",  
                data: JSON.stringify({  
                    '__metadata': {  
                        'type': 'SP.Data.LikesListListItem'  
                    },  
                    'LikeById': UserID,  
                    'Title': title,  
                    'CommentID': CommentID  
                }),  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                    "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                    "content-Type": "application/json;odata=verbose"  
                },  
                success: function(data) {  
                    $("#lnkBtnLike_" + CommentID)[0].innerText = "Unlike";  
                },  
                error: function(error) {  
                    console.log(JSON.stringify(error));  
                }  
            });  
        } else {  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items(" + $("#LikeID_" + CommentID)[0].innerText + ")",  
                type: "POST",  
                async: false,  
                headers: {  
                    "Accept": "application/json;odata=verbose",  
                    "X-Http-Method": "DELETE",  
                    "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                    "If-Match": "*"  
                },  
                success: function(data) {  
                    $("#lnkBtnLike_" + CommentID)[0].innerText = "Like";  
                    getSetPageDet();  
                    getAllComments();  
                },  
                error: function(data) {  
                    console.log(JSON.stringify(error));  
                }  
            });  
        }  
    }  
  
    function getSetCommentDet() {  
        var commentIDColl = $('span[id^="CommentsID_"]');  
        $.each(commentIDColl, function(index, e) {  
            var commentID = e.innerText;  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$filter=LikeById eq " + UserID + " and CommentID eq '" + commentID + "'",  
                type: "GET",  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                    "content-Type": "application/json;odata=verbose"  
                },  
                success: function(data) {  
                    if (data.d.results.length > 0) {  
                        $("#lnkBtnLike_" + commentID)[0].innerText = "Unlike";  
                        $("#LikeID_" + commentID)[0].innerText = data.d.results[0].Id;  
                    } else {  
                        $("#lnkBtnLike_" + commentID)[0].innerText = "Like";  
                    }  
                },  
                error: function(error) {  
                    alert(JSON.stringify(error));  
                }  
            });  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$expand=LikeBy&$select=*,LikeBy/Title&$filter=CommentID eq '" + commentID + "' and Title eq 'Comment'&$orderby=ID desc",  
                type: "GET",  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                    "content-Type": "application/json;odata=verbose"  
                },  
                success: function(data) {  
                    if (data.d.results.length > 0) {  
                        var likeToolTip = "";  
                        var me = false;  
                        $("#lblLikes_" + commentID)[0].innerText = data.d.results.length;  
                        $.each(data.d.results, function(index, value) {  
                            if (value.LikeById == UserID) {  
                                me = true;  
                            } else {  
                                likeToolTip += value.LikeBy.Title + "; ";  
                            }  
                        });  
                        if (me == true) {  
                            likeToolTip = "You; " + likeToolTip;  
                        }  
                        $("span#spLikes_" + commentID).attr("title", likeToolTip);  
                    } else {  
                        $("#lblLikes_" + commentID)[0].innerText = "0";  
                    }  
                },  
                error: function(error) {  
                    alert(JSON.stringify(error));  
                }  
            });  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items?$expand=CommentBy&$select=*,CommentBy/Title&$filter=ParentCommentID eq '" + commentID + "' and Title eq 'Reply'&$orderby=ID desc",  
                type: "GET",  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                    "content-Type": "application/json;odata=verbose"  
                },  
                success: function(data) {  
                    if (data.d.results.length > 0) {  
                        $("#lblCommentReplies_" + commentID)[0].innerText = data.d.results.length + " Replies |";  
                        var replyHTML = "";  
                        if (data.d.results.length > 0) {  
                            $.each(data.d.results, function(index, value) {  
                                var CreatedDate = jQuery.format.date(value.Created, "ddd, MMM d, yyyy h:mm a");  
                                replyHTML += "<tr><td><br><span id='ReplyID_" + value.Id + "' style='display:none;'>" + value.Id + "</span><br><span id='lblReply_" + value.Id + "' class='comments'>" + value.CommentText + "</span><br><a id='hrfReplyAuthor_" + value.Id + "' class='linksAuthor' href='/../../_layouts/15/userdisp.aspx?ID=" + value.CommentById + "' target='_blank'>" + value.CommentBy.Title + "</a><br><span id='lblReplydate_" + value.Id + "'>" + CreatedDate + "</span>      <span id='spReplyLikes_" + value.Id + "' title='' class='LikeClass'>  <img id='imgLike_" + value.Id + "' src='../_layouts/15/images/LikeFull.11x11x32.png?rev=23'>  <span id='lblReplyLikes_" + value.Id + "' title='' class='LikeClass' ></span></span>  <a id='lnkBtnReplyLike_" + value.Id + "' class='links' onClick='LikeReply(" + value.Id + ")'>Like</a><span id='ReplyLikeID_" + value.Id + "' style='display:none;'></span>";  
                                if (UserID == value.CommentById) {  
                                    replyHTML += "   <a id='lnkBtnDelete_" + value.Id + "' class='links' onClick='DeleteReply(" + value.Id + ")'>Delete</a></td></tr>";  
                                } else {  
                                    replyHTML += "</td></tr>";  
                                }  
                            });  
                            $("#tblReply_" + commentID)[0].innerHTML = replyHTML;  
                            getSetReplyDet();  
                        }  
                    } else {  
                        $("#lblCommentReplies_" + commentID)[0].innerText = "0 Replies |";  
                    }  
                },  
                error: function(error) {  
                    alert(JSON.stringify(error));  
                }  
            });  
        })  
    }  
  
    function getSetPageDet() {  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$filter=LikeById eq " + UserID + " and PageURL eq '" + PageURL + "'",  
            type: "GET",  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "content-Type": "application/json;odata=verbose"  
            },  
            success: function(data) {  
                if (data.d.results.length > 0) {  
                    $("#lnkBtnPageLike")[0].innerText = "Unlike";  
                    $("#LikeID")[0].innerText = data.d.results[0].Id;  
                } else {  
                    $("#lnkBtnPageLike")[0].innerText = "Like";  
                }  
            },  
            error: function(error) {  
                alert(JSON.stringify(error));  
            }  
        });  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$expand=LikeBy&$select=*,LikeBy/Title&$filter=PageURL eq '" + PageURL + "' and Title eq 'Page'",  
            type: "GET",  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "content-Type": "application/json;odata=verbose"  
            },  
            success: function(data) {  
                if (data.d.results.length > 0) {  
                    var likeToolTip = "";  
                    var me = false;  
                    $("#lblPageLikes")[0].innerText = data.d.results.length;  
                    $.each(data.d.results, function(index, value) {  
                        if (value.LikeById == UserID) {  
                            me = true;  
                        } else {  
                            likeToolTip += value.LikeBy.Title + "; ";  
                        }  
                    });  
                    if (me == true) {  
                        likeToolTip = "You; " + likeToolTip;  
                    }  
                    $("span#spLikes").attr("title", likeToolTip);  
                } else {  
                    $("#lblPageLikes")[0].innerText = "0";  
                }  
            },  
            error: function(error) {  
                alert(JSON.stringify(error));  
            }  
        });  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items?$filter=PageURL eq '" + PageURL + "' and Title eq 'Comment'",  
            type: "GET",  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "content-Type": "application/json;odata=verbose"  
            },  
            success: function(data) {  
                if (data.d.results.length > 0) {  
                    $("#lblPageComments")[0].innerText = data.d.results.length + " Comments |";  
                } else {  
                    $("#lblPageComments")[0].innerText = "0 Comments |";  
                }  
            },  
            error: function(error) {  
                alert(JSON.stringify(error));  
            }  
        });  
    }  
  
    function AddComment() {  
        var title = "Comment";  
        var ParentCommentID = 0;  
        var CommentText = $("#txtComments").val();  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items",  
            type: "POST",  
            data: JSON.stringify({  
                '__metadata': {  
                    'type': 'SP.Data.CommentsListListItem'  
                },  
                'PageURL': PageURL,  
                'CommentById': UserID,  
                'Title': title,  
                'ParentCommentID': ParentCommentID,  
                'CommentText': CommentText  
            }),  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                "content-Type": "application/json;odata=verbose"  
            },  
            success: function(data) {  
                $("#txtComments").val("");  
                getSetPageDet();  
                getAllComments();  
            },  
            error: function(error) {  
                console.log(JSON.stringify(error));  
            }  
        });  
    }  
  
    function AddReply(CommentID) {  
        var title = "Reply";  
        var CommentText = $("#txtReply_" + CommentID).val();  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items",  
            type: "POST",  
            data: JSON.stringify({  
                '__metadata': {  
                    'type': 'SP.Data.CommentsListListItem'  
                },  
                'CommentById': UserID,  
                'Title': title,  
                'ParentCommentID': CommentID,  
                'CommentText': CommentText  
            }),  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                "content-Type": "application/json;odata=verbose"  
            },  
            success: function(data) {  
                getSetPageDet();  
                getAllComments();  
            },  
            error: function(error) {  
                console.log(JSON.stringify(error));  
            }  
        });  
    }  
  
    function LikePage() {  
        var title = "Page";  
        var CommentID = 0;  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items",  
            type: "POST",  
            data: JSON.stringify({  
                '__metadata': {  
                    'type': 'SP.Data.LikesListListItem'  
                },  
                'PageURL': PageURL,  
                'LikeById': UserID,  
                'Title': title,  
                'CommentID': CommentID  
            }),  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                "content-Type": "application/json;odata=verbose"  
            },  
            success: function(data) {  
                $("#lnkBtnPageLike")[0].innerText = "Unlike";  
                getSetPageDet();  
                getAllComments();  
            },  
            error: function(error) {  
                console.log(JSON.stringify(error));  
            }  
        });  
    }  
  
    function UnLikePage() {  
        var title = "Page";  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items(" + $("#LikeID")[0].innerText + ")",  
            type: "POST",  
            async: false,  
            headers: {  
                "Accept": "application/json;odata=verbose",  
                "X-Http-Method": "DELETE",  
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                "If-Match": "*"  
            },  
            success: function(data) {  
                $("#lnkBtnPageLike")[0].innerText = "Like";  
            },  
            error: function(data) {  
                console.log(JSON.stringify(error));  
                getSetPageDet();  
                getAllComments();  
            }  
        });  
    }  
  
    function DeleteReply(CommentID) {  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items(" + CommentID + ")",  
            type: "POST",  
            async: false,  
            headers: {  
                "Accept": "application/json;odata=verbose",  
                "X-Http-Method": "DELETE",  
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                "If-Match": "*"  
            },  
            success: function(data) {  
                DeleteChildItems(CommentID);  
                console.log("Comment deleted successfully!");  
                getSetPageDet();  
                getAllComments();  
            },  
            error: function(data) {  
                console.log(JSON.stringify(error));  
            }  
        });  
    }  
  
    function DeleteComment(CommentID) {  
        $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items(" + CommentID + ")",  
            type: "POST",  
            async: false,  
            headers: {  
                "Accept": "application/json;odata=verbose",  
                "X-Http-Method": "DELETE",  
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                "If-Match": "*"  
            },  
            success: function(data) {  
                DeleteChildItems(CommentID);  
                console.log("Comment deleted successfully!");  
                getSetPageDet();  
                getAllComments();  
            },  
            error: function(data) {  
                console.log(JSON.stringify(error));  
            }  
        });  
    }  
  
    function DeleteChildItems(parentId) {  
        getItemsfromURL("/_api/web/lists/GetByTitle('LikesList')/items?$filter=CommentID eq " + parentId).done(function(data) {  
            data.d.results.forEach(function(item) {  
                var childId = item.ID;  
                deleteItem("/_api/web/lists/GetByTitle('LikesList')/getItemById(" + childId + ")", item).done(function(d_data) {  
                    //deleted child item.  
                });  
            });  
        });  
        getItemsfromURL("/_api/web/lists/GetByTitle('CommentsList')/items?$filter=ParentCommentID eq " + parentId).done(function(data) {  
            data.d.results.forEach(function(item) {  
                var childReplyId = item.ID;  
                deleteItem("/_api/web/lists/GetByTitle('CommentsList')/getItemById(" + childReplyId + ")", item).done(function(d_data) {  
                    //deleted child item.  
                });  
                getItemsfromURL("/_api/web/lists/GetByTitle('LikesList')/items?$filter=CommentID eq " + childReplyId).done(function(data) {  
                    data.d.results.forEach(function(item) {  
                        var childLikeId = item.ID;  
                        deleteItem("/_api/web/lists/GetByTitle('LikesList')/getItemById(" + childLikeId + ")", item).done(function(d_data) {  
                            //deleted child item.  
                        });  
                    });  
                });  
            });  
        });  
    }  
    //Get items   
    function getItemsfromURL(url) {  
        return $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + url,  
            type: "GET",  
            headers: {  
                "accept": "application/json;odata=verbose",  
            }  
        });  
    }  
    //Delete Item  
    function deleteItem(url, oldItem) {  
        return $.ajax({  
            url: _spPageContextInfo.webAbsoluteUrl + url,  
            type: "DELETE",  
            headers: {  
                "accept": "application/json;odata=verbose",  
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),  
                "If-Match": oldItem.__metadata.etag  
            }  
        });  
    }  
  
    function getSetReplyDet() {  
        var commentIDColl = $('span[id^="ReplyID_"]');  
        $.each(commentIDColl, function(index, e) {  
            var commentID = e.innerText;  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$filter=LikeById eq " + UserID + " and CommentID eq '" + commentID + "'",  
                type: "GET",  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                    "content-Type": "application/json;odata=verbose"  
                },  
                success: function(data) {  
                    if (data.d.results.length > 0) {  
                        $("#lnkBtnReplyLike_" + commentID)[0].innerText = "Unlike";  
                        $("#ReplyLikeID_" + commentID)[0].innerText = data.d.results[0].Id;  
                    } else {  
                        $("#lnkBtnReplyLike_" + commentID)[0].innerText = "Like";  
                    }  
                },  
                error: function(error) {  
                    alert(JSON.stringify(error));  
                }  
            });  
            $.ajax({  
                url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$expand=LikeBy&$select=*,LikeBy/Title&$filter=CommentID eq '" + commentID + "' and Title eq 'Reply'",  
                type: "GET",  
                headers: {  
                    "accept": "application/json;odata=verbose",  
                    "content-Type": "application/json;odata=verbose"  
                },  
                success: function(data) {  
                    if (data.d.results.length > 0) {  
                        var likeToolTip = "";  
                        var me = false;  
                        $("#lblReplyLikes_" + commentID)[0].innerText = data.d.results.length;  
                        $.each(data.d.results, function(index, value) {  
                            if (value.LikeById == UserID) {  
                                me = true;  
                            } else {  
                                likeToolTip += value.LikeBy.Title + "; ";  
                            }  
                        });  
                        if (me == true) {  
                            likeToolTip = "You; " + likeToolTip;  
                        }  
                        $("span#spReplyLikes_" + commentID).attr("title", likeToolTip);  
                    } else {  
                        $("#lblReplyLikes_" + commentID)[0].innerText = "0";  
                    }  
                },  
                error: function(error) {  
                    alert(JSON.stringify(error));  
                }  
            });  
        })  
    }  
</script>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

552

553

554

555

556

557

558

559

560

561

562

563

564

565

566

567

568

569

570

571

572

573

574

575

576

577

578

579

580

581

582

583

584

585

586

587

588

589

590

591

592

593

594

595

596

597

598

599

600

601

602

603

604

605

606

607

608

609

610

611

612

613

614

615

616

617

618

619

620

621

<tbody>

<tr>

<span id="lblPageComments">0 Comments | </span>

</span>

</tr>

<tr>

<h3>Comment : </h3>

</td>

</tr>

<tr>

</td>

</tr>

</tbody>

</table>

<br> Comments... <table id="tblComments" style="width:100%">

</table>

</div>

a {

cursor: pointer;

}

</style>

var PageURL = window.location.href;

var UserID = _spPageContextInfo.userId;

$(document).ready(function() {

getSetPageDet();

getAllComments();

$("#btnPost").click(function() {

AddComment();

});

$("#btnReset").click(function() {

$("#txtComments").val("");

});

$("#lnkBtnPageLike").click(function() {

if ($("#lnkBtnPageLike")[0].innerText == "Like") {

LikePage();

} else {

UnLikePage();

}

});

// This function will reset the value of comment box

function reset(textbox) {

$("#txtReply_" + textbox).val("");

}

// This function is used to get all the comments from comments list for that particular page having type as comment.

function getAllComments() {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items?$expand=CommentBy&$select=*,CommentBy/Title&$filter=PageURL eq '" + PageURL + "' and Title eq 'Comment'&$orderby=ID desc",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

var commentsHTML = "";

if (data.d.results.length > 0) {

$.each(data.d.results, function(index, value) {

var CreatedDate = jQuery.format.date(value.Created, "ddd, MMM d, yyyy h:mm a");

commentsHTML += "<tr><td><span id='CommentsID_" + value.Id + "' style='display:none;'>" + value.Id + "</span><br><span>" + value.CommentText + "</span><br><a class='linksAuthor' href='/../../_layouts/15/userdisp.aspx?ID=" + value.CommentById + "' target='_blank'>" + value.CommentBy.Title + "</a><br><span>" + CreatedDate + "</spam> <span id='lblCommentReplies_" + value.Id + "'>0 Replies | </span><span id='spLikes_" + value.Id + "' title='' class='LikeClass'> <img src='../_layouts/15/images/LikeFull.11x11x32.png?rev=23'> <span id='lblLikes_" + value.Id + "' class='LikeClass'>0</span></span> <a id='lnkBtnLike_" + value.Id + "' class='links' onClick='LikeComment(" + value.Id + ")'>Like</a><span id='LikeID_" + value.Id + "' style='display:none;'></span>";

if (UserID == value.CommentById) {

commentsHTML += " <a id='lnkBtnDelete_" + value.Id + "' class='links' onClick='DeleteComment(" + value.Id + ")'>Delete</a><br><br>Replies...<br><div style='margin-left: 10%;'><table style='width: 90%'><tbody><tr><td colspan='2'><textarea name='txtReply_" + value.Id + "' rows='1' cols='20' id='txtReply_" + value.Id + "' placeholder='Reply...' style='width:100%;'></textarea><br><br><input type='button' name='btnPostReply_" + value.Id + "' value='Post' id='btnPostReply_" + value.Id + "' onClick='AddReply(" + value.Id + ")'><input type='button' name='btnResetReply_" + value.Id + "' value='Reset' id='btnResetReply_" + value.Id + "' onClick='reset(" + value.Id + ")'></td></tr></tbody></table><div><table cellspacing='0' id='tblReply_" + value.Id + "' style='border-collapse:collapse;'></table></div></div><br><hr></td></tr>";

} else {

commentsHTML += "<br><br>Replies...<br><div style='margin-left: 10%;'><table style='width: 90%'><tbody><tr><td colspan='2'><textarea name='txtReply_" + value.Id + "' rows='1' cols='20' id='txtReply_" + value.Id + "' placeholder='Reply...' style='width:100%;'></textarea><br><br><input type='button' name='btnPostReply_" + value.Id + "' value='Post' id='btnPostReply_" + value.Id + "' onClick='AddReply(" + value.Id + ")'><input type='button' name='btnResetReply_" + value.Id + "' value='Reset' id='btnResetReply_" + value.Id + "' onClick='reset(" + value.Id + ")'></td></tr></tbody></table><div><table cellspacing='0' id='tblReply_" + value.Id + "' style='border-collapse:collapse;'></table></div></div><br><hr></td></tr>";

}

});

$("#tblComments")[0].innerHTML = commentsHTML;

getSetCommentDet();

}

error: function(error) {

alert(JSON.stringify(error));

}

});

}

// This function is used to get all the likes from like list for that particular page.

function LikeReply(CommentID) {

var title = "Reply";

if ($("#lnkBtnReplyLike_" + CommentID)[0].innerText == "Like") {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items",

type: "POST",

data: JSON.stringify({

'__metadata': {

'type': 'SP.Data.LikesListListItem'

'LikeById': UserID,

'Title': title,

'CommentID': CommentID

}),

headers: {

"accept": "application/json;odata=verbose",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"content-Type": "application/json;odata=verbose"

success: function(data) {

$("#lnkBtnReplyLike_" + CommentID)[0].innerText = "Unlike";

error: function(error) {

console.log(JSON.stringify(error));

}

});

} else {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items(" + $("#ReplyLikeID_" + CommentID)[0].innerText + ")",

type: "POST",

async: false,

headers: {

"Accept": "application/json;odata=verbose",

"X-Http-Method": "DELETE",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"If-Match": "*"

success: function(data) {

$("#lnkBtnReplyLike_" + CommentID)[0].innerText = "Like";

getSetPageDet();

getAllComments();

error: function(data) {

console.log(JSON.stringify(error));

}

});

}

function LikeComment(CommentID) {

var title = "Comment";

if ($("#lnkBtnLike_" + CommentID)[0].innerText == "Like") {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items",

type: "POST",

data: JSON.stringify({

'__metadata': {

'type': 'SP.Data.LikesListListItem'

'LikeById': UserID,

'Title': title,

'CommentID': CommentID

}),

headers: {

"accept": "application/json;odata=verbose",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"content-Type": "application/json;odata=verbose"

success: function(data) {

$("#lnkBtnLike_" + CommentID)[0].innerText = "Unlike";

error: function(error) {

console.log(JSON.stringify(error));

}

});

} else {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items(" + $("#LikeID_" + CommentID)[0].innerText + ")",

type: "POST",

async: false,

headers: {

"Accept": "application/json;odata=verbose",

"X-Http-Method": "DELETE",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"If-Match": "*"

success: function(data) {

$("#lnkBtnLike_" + CommentID)[0].innerText = "Like";

getSetPageDet();

getAllComments();

error: function(data) {

console.log(JSON.stringify(error));

}

});

}

function getSetCommentDet() {

var commentIDColl = $('span[id^="CommentsID_"]');

$.each(commentIDColl, function(index, e) {

var commentID = e.innerText;

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$filter=LikeById eq " + UserID + " and CommentID eq '" + commentID + "'",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

$("#lnkBtnLike_" + commentID)[0].innerText = "Unlike";

$("#LikeID_" + commentID)[0].innerText = data.d.results[0].Id;

} else {

$("#lnkBtnLike_" + commentID)[0].innerText = "Like";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$expand=LikeBy&$select=*,LikeBy/Title&$filter=CommentID eq '" + commentID + "' and Title eq 'Comment'&$orderby=ID desc",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

var likeToolTip = "";

var me = false;

$("#lblLikes_" + commentID)[0].innerText = data.d.results.length;

$.each(data.d.results, function(index, value) {

if (value.LikeById == UserID) {

me = true;

} else {

likeToolTip += value.LikeBy.Title + "; ";

}

});

if (me == true) {

likeToolTip = "You; " + likeToolTip;

}

$("span#spLikes_" + commentID).attr("title", likeToolTip);

} else {

$("#lblLikes_" + commentID)[0].innerText = "0";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items?$expand=CommentBy&$select=*,CommentBy/Title&$filter=ParentCommentID eq '" + commentID + "' and Title eq 'Reply'&$orderby=ID desc",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

$("#lblCommentReplies_" + commentID)[0].innerText = data.d.results.length + " Replies |";

var replyHTML = "";

if (data.d.results.length > 0) {

$.each(data.d.results, function(index, value) {

var CreatedDate = jQuery.format.date(value.Created, "ddd, MMM d, yyyy h:mm a");

replyHTML += "<tr><td><br><span id='ReplyID_" + value.Id + "' style='display:none;'>" + value.Id + "</span><br><span id='lblReply_" + value.Id + "' class='comments'>" + value.CommentText + "</span><br><a id='hrfReplyAuthor_" + value.Id + "' class='linksAuthor' href='/../../_layouts/15/userdisp.aspx?ID=" + value.CommentById + "' target='_blank'>" + value.CommentBy.Title + "</a><br><span id='lblReplydate_" + value.Id + "'>" + CreatedDate + "</span> <span id='spReplyLikes_" + value.Id + "' title='' class='LikeClass'> <img id='imgLike_" + value.Id + "' src='../_layouts/15/images/LikeFull.11x11x32.png?rev=23'> <span id='lblReplyLikes_" + value.Id + "' title='' class='LikeClass' ></span></span> <a id='lnkBtnReplyLike_" + value.Id + "' class='links' onClick='LikeReply(" + value.Id + ")'>Like</a><span id='ReplyLikeID_" + value.Id + "' style='display:none;'></span>";

if (UserID == value.CommentById) {

replyHTML += " <a id='lnkBtnDelete_" + value.Id + "' class='links' onClick='DeleteReply(" + value.Id + ")'>Delete</a></td></tr>";

} else {

replyHTML += "</td></tr>";

}

});

$("#tblReply_" + commentID)[0].innerHTML = replyHTML;

getSetReplyDet();

}

} else {

$("#lblCommentReplies_" + commentID)[0].innerText = "0 Replies |";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

})

}

function getSetPageDet() {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$filter=LikeById eq " + UserID + " and PageURL eq '" + PageURL + "'",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

$("#lnkBtnPageLike")[0].innerText = "Unlike";

$("#LikeID")[0].innerText = data.d.results[0].Id;

} else {

$("#lnkBtnPageLike")[0].innerText = "Like";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$expand=LikeBy&$select=*,LikeBy/Title&$filter=PageURL eq '" + PageURL + "' and Title eq 'Page'",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

var likeToolTip = "";

var me = false;

$("#lblPageLikes")[0].innerText = data.d.results.length;

$.each(data.d.results, function(index, value) {

if (value.LikeById == UserID) {

me = true;

} else {

likeToolTip += value.LikeBy.Title + "; ";

}

});

if (me == true) {

likeToolTip = "You; " + likeToolTip;

}

$("span#spLikes").attr("title", likeToolTip);

} else {

$("#lblPageLikes")[0].innerText = "0";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items?$filter=PageURL eq '" + PageURL + "' and Title eq 'Comment'",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

$("#lblPageComments")[0].innerText = data.d.results.length + " Comments |";

} else {

$("#lblPageComments")[0].innerText = "0 Comments |";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

}

function AddComment() {

var title = "Comment";

var ParentCommentID = 0;

var CommentText = $("#txtComments").val();

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items",

type: "POST",

data: JSON.stringify({

'__metadata': {

'type': 'SP.Data.CommentsListListItem'

'PageURL': PageURL,

'CommentById': UserID,

'Title': title,

'ParentCommentID': ParentCommentID,

'CommentText': CommentText

}),

headers: {

"accept": "application/json;odata=verbose",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"content-Type": "application/json;odata=verbose"

success: function(data) {

$("#txtComments").val("");

getSetPageDet();

getAllComments();

error: function(error) {

console.log(JSON.stringify(error));

}

});

}

function AddReply(CommentID) {

var title = "Reply";

var CommentText = $("#txtReply_" + CommentID).val();

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items",

type: "POST",

data: JSON.stringify({

'__metadata': {

'type': 'SP.Data.CommentsListListItem'

'CommentById': UserID,

'Title': title,

'ParentCommentID': CommentID,

'CommentText': CommentText

}),

headers: {

"accept": "application/json;odata=verbose",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"content-Type": "application/json;odata=verbose"

success: function(data) {

getSetPageDet();

getAllComments();

error: function(error) {

console.log(JSON.stringify(error));

}

});

}

function LikePage() {

var title = "Page";

var CommentID = 0;

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items",

type: "POST",

data: JSON.stringify({

'__metadata': {

'type': 'SP.Data.LikesListListItem'

'PageURL': PageURL,

'LikeById': UserID,

'Title': title,

'CommentID': CommentID

}),

headers: {

"accept": "application/json;odata=verbose",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"content-Type": "application/json;odata=verbose"

success: function(data) {

$("#lnkBtnPageLike")[0].innerText = "Unlike";

getSetPageDet();

getAllComments();

error: function(error) {

console.log(JSON.stringify(error));

}

});

}

function UnLikePage() {

var title = "Page";

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items(" + $("#LikeID")[0].innerText + ")",

type: "POST",

async: false,

headers: {

"Accept": "application/json;odata=verbose",

"X-Http-Method": "DELETE",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"If-Match": "*"

success: function(data) {

$("#lnkBtnPageLike")[0].innerText = "Like";

error: function(data) {

console.log(JSON.stringify(error));

getSetPageDet();

getAllComments();

}

});

}

function DeleteReply(CommentID) {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items(" + CommentID + ")",

type: "POST",

async: false,

headers: {

"Accept": "application/json;odata=verbose",

"X-Http-Method": "DELETE",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"If-Match": "*"

success: function(data) {

DeleteChildItems(CommentID);

console.log("Comment deleted successfully!");

getSetPageDet();

getAllComments();

error: function(data) {

console.log(JSON.stringify(error));

}

});

}

function DeleteComment(CommentID) {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('CommentsList')/items(" + CommentID + ")",

type: "POST",

async: false,

headers: {

"Accept": "application/json;odata=verbose",

"X-Http-Method": "DELETE",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"If-Match": "*"

success: function(data) {

DeleteChildItems(CommentID);

console.log("Comment deleted successfully!");

getSetPageDet();

getAllComments();

error: function(data) {

console.log(JSON.stringify(error));

}

});

}

function DeleteChildItems(parentId) {

getItemsfromURL("/_api/web/lists/GetByTitle('LikesList')/items?$filter=CommentID eq " + parentId).done(function(data) {

data.d.results.forEach(function(item) {

var childId = item.ID;

deleteItem("/_api/web/lists/GetByTitle('LikesList')/getItemById(" + childId + ")", item).done(function(d_data) {

//deleted child item.

});

getItemsfromURL("/_api/web/lists/GetByTitle('CommentsList')/items?$filter=ParentCommentID eq " + parentId).done(function(data) {

data.d.results.forEach(function(item) {

var childReplyId = item.ID;

deleteItem("/_api/web/lists/GetByTitle('CommentsList')/getItemById(" + childReplyId + ")", item).done(function(d_data) {

//deleted child item.

});

getItemsfromURL("/_api/web/lists/GetByTitle('LikesList')/items?$filter=CommentID eq " + childReplyId).done(function(data) {

data.d.results.forEach(function(item) {

var childLikeId = item.ID;

deleteItem("/_api/web/lists/GetByTitle('LikesList')/getItemById(" + childLikeId + ")", item).done(function(d_data) {

//deleted child item.

});

}

//Get items

function getItemsfromURL(url) {

return $.ajax({

url: _spPageContextInfo.webAbsoluteUrl + url,

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

}

});

}

//Delete Item

function deleteItem(url, oldItem) {

return $.ajax({

url: _spPageContextInfo.webAbsoluteUrl + url,

type: "DELETE",

headers: {

"accept": "application/json;odata=verbose",

"X-RequestDigest": $("#__REQUESTDIGEST").val(),

"If-Match": oldItem.__metadata.etag

}

});

}

function getSetReplyDet() {

var commentIDColl = $('span[id^="ReplyID_"]');

$.each(commentIDColl, function(index, e) {

var commentID = e.innerText;

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$filter=LikeById eq " + UserID + " and CommentID eq '" + commentID + "'",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

$("#lnkBtnReplyLike_" + commentID)[0].innerText = "Unlike";

$("#ReplyLikeID_" + commentID)[0].innerText = data.d.results[0].Id;

} else {

$("#lnkBtnReplyLike_" + commentID)[0].innerText = "Like";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('LikesList')/items?$expand=LikeBy&$select=*,LikeBy/Title&$filter=CommentID eq '" + commentID + "' and Title eq 'Reply'",

type: "GET",

headers: {

"accept": "application/json;odata=verbose",

"content-Type": "application/json;odata=verbose"

success: function(data) {

if (data.d.results.length > 0) {

var likeToolTip = "";

var me = false;

$("#lblReplyLikes_" + commentID)[0].innerText = data.d.results.length;

$.each(data.d.results, function(index, value) {

if (value.LikeById == UserID) {

me = true;

} else {

likeToolTip += value.LikeBy.Title + "; ";

}

});

if (me == true) {

likeToolTip = "You; " + likeToolTip;

}

$("span#spReplyLikes_" + commentID).attr("title", likeToolTip);

} else {

$("#lblReplyLikes_" + commentID)[0].innerText = "0";

}

error: function(error) {

alert(JSON.stringify(error));

}

});

})

}

</script>

Step 4
Create one web part page add your contents in to it. Add one more content editor web part -> edit web part -> give path of the txt file-> click on apply -> click on ok-> save the page -> publish it.

Step 5
After publishing the page you will see a comment box to add the comments and a like button to like the particular page.

Step 6
You can add the above code into any web part page using content editor and you will see the above functionality is working.

European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: Fetching SharePoint List Items Using A Simple HTTP REST Command

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint 2016 Mobile View Not Working On Mobile Devices

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Access Denied Error

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create And Use Task List In SharePoint 2013?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Scripting Capabilities, Why SharePoint Framework

SharePoint 2013 Hosting – HostForLIFE.eu :: Custom Like And Comment Functionality For SharePoint Online Custom Pages

BLOGROLL

Featured On

European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: Fetching SharePoint List Items Using A Simple HTTP REST Command

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: SharePoint 2016 Mobile View Not Working On Mobile Devices

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Access Denied Error

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Create And Use Task List In SharePoint 2013?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: Scripting Capabilities, Why SharePoint Framework

SharePoint 2013 Hosting – HostForLIFE.eu :: Custom Like And Comment Functionality For SharePoint Online Custom Pages

BLOGROLL

Featured On

Tags