Sparks Model

using System.Collections.Generic;

namespace SpoWebApi.Models
{
    public class SparksModel
    {
    }
    public class Datum
    {
        public string sourceapp { get; set; }
        public string size { get; set; }
        public string destinationapp { get; set; }
        public string resdata { get; set; }
        public string id { get; set; }
        public string resname { get; set; }
        public string timestamp { get; set; }
    }

    public class SparksResponse
    {
        public string msg { get; set; }
        public int count { get; set; }
        public List<Datum> data { get; set; }
        public bool status { get; set; }
    }
    public class Result
    {
        public SparksResponse sparksResponse { get; set; }
    }
    public class RootObject
    {
        public Result result { get; set; }
    }
    public class Resdata
    {
        public string pendingWith { get; set; }
        public string VisitorRequestID { get; set; }
        public string requestId { get; set; }
        public string processType { get; set; }
        public string id { get; set; }
        public string message { get; set; }
        public string taskId { get; set; }
        public string requestStatus { get; set; }
        public string status { get; set; }
    }
    public class ErrorLog
    {
        public string message { get; set; }
        public bool status { get; set; }
    }
}

Javascript code - Copy selected Items from One SP list webpart to another SP LIst

var sourceListName="CustomerDetails";
var targetListName="WelcomeList";
var sourceListURL="https://.sharepoint.com/sites/m/vms/Lists/CustomerDetails/AllItems.aspx";
var targetListURL="https://your site/sites/SecurityTeam/Lists/WelcomeList/AllItems.aspx";
var siteUrl ="https://Target site URL/";
var sourceSiteUrl="yoursite/VisitorManagement/";
//var userName,Company;

function clickMethod() {             
                var ctx = SP.ClientContext.get_current();
                var items = SP.ListOperation.Selection.getSelectedItems(ctx);
                var mySeletedItems = '';
                var i=0;
             
                    for (i in items) {
                        mySeletedItems += '|' + items[i].id;
                        var itemID = items[i].id;
                        //createListItem();
                         GetRequestItem(itemID);
                    }
                //alert(mySeletedItems);
                return false;
        }

     function GetRequestItem(rItemID) {
           // alert("GetRequestItem called");
            // Getting our list items
            var ItemId = rItemID;
            var currentSiteUrl = "https://your site name/";
            var requestUri = currentSiteUrl + "/_api/web/lists/getbytitle('CustomerDetails')/items(" + ItemId + ")";

            $.ajax({
                url: requestUri,
                method: "GET",
                headers: { "Accept": "application/json; odata=verbose" },
                success: function (data) {
                 
                    // Returning the results
                    //console.log(requestUri);
                    var userName = data.d.Title;
                    var userCompany = data.d.Visitor_x0020_Company;
                    var uDesignation = data.d.UserDesignation;
                    var salutation= data.d.Salutation;             
                    createListItem(userName,userCompany,uDesignation,salutation);

                },
                error: function (data) {
                    console.log(data.message);
                }
            });
        }

//ShowOnDisplayBoard
function createListItem(uName,uCompany,uDesig,salutation) {
//alert("createListItem starts now :"+siteUrl);
var userArray = uName.split('.');
    var clientContext = new SP.ClientContext(siteUrl);
    var oList = clientContext.get_web().get_lists().getByTitle(targetListName);
    var itemCreateInfo = new SP.ListItemCreationInformation();
    this.oListItem = oList.addItem(itemCreateInfo);
    oListItem.set_item('Title', uName);
    oListItem.set_item('Gender', salutation);
    oListItem.set_item('PersonName', uName);
    oListItem.set_item('UserCompanyName', uCompany);
    oListItem.set_item('UserDesignation', "DemoDesignation");
     oListItem.set_item('OrderBy', "1");
     oListItem.set_item('UserImage', "https://(yoursite)/sites/ST/SiteAssets/WelcomePage/DemoImage.png");
    oListItem.update();
    clientContext.load(oListItem);
    clientContext.executeQueryAsync(
        Function.createDelegate(this, this.onQuerySucceeded),
        Function.createDelegate(this, this.onQueryFailed)
    );
    window.location.href = window.location.href;
}

function onQuerySucceeded() {
    alert('Selected Item is copied to welcome list: ' + oListItem.get_id());
}

function onQueryFailed(sender, args) {
    alert('Request failed. ' + args.get_message() +
        '\n' + args.get_stackTrace());
}

SharePoint 2013 Installation

https://collab365.community/step-by-step-installation-of-sharepoint-2013-on-windows-server-2/

Get Folders under Subfolder

 public string sMenuString = "";
        [HttpGet]
        [Route("api/GetFolderTreeView")]
        public string GetFolderTreeView()
        {
            string sharePointUrl = ConfigurationManager.AppSettings["SharePointURL"];
            string _spUserName = ConfigurationManager.AppSettings["userName"];
            string _spPwd = ConfigurationManager.AppSettings["Password"];
            try
            {
                using (ClientContext clientContext = new ClientContext(sharePointUrl))
                {
                    var passWord = new SecureString();
                    foreach (char c in _spPwd.ToCharArray()) passWord.AppendChar(c);
                    clientContext.Credentials = new SharePointOnlineCredentials(_spUserName, passWord);
                    Web web = clientContext.Web;
                    // We want to retrieve the web's properties.
                    clientContext.Load(web);
                    clientContext.Load(web.Lists);
                    clientContext.Load(web, wb => wb.ServerRelativeUrl);
                    clientContext.ExecuteQuery();

                    List list = web.Lists.GetByTitle("SampleDocuments");
                    clientContext.Load(list);
                    clientContext.ExecuteQuery();

                    Microsoft.SharePoint.Client.Folder folder = web.GetFolderByServerRelativeUrl(web.ServerRelativeUrl + "/SampleDocuments/0019E00000hQCs4QAG");
                    clientContext.Load(folder);
                    clientContext.ExecuteQuery();

                    CamlQuery camlQuery = new CamlQuery();
                    camlQuery.ViewXml = @"<View Scope='RecursiveAll'>
                                     <Query>
                                     </Query>
                                 </View>";
                    camlQuery.FolderServerRelativeUrl = folder.ServerRelativeUrl;
                    ListItemCollection listItems = list.GetItems(camlQuery);
                    clientContext.Load(listItems);
                    clientContext.ExecuteQuery();

                    clientContext.Load(list.RootFolder);
                    clientContext.Load(list.RootFolder.Folders);
                    clientContext.ExecuteQuery();

                    foreach (var item in listItems)
                    {
                        if (item.FileSystemObjectType == FileSystemObjectType.Folder)
                        {
                            // This is a  Folder
                            clientContext.Load(item.Folder);
                            clientContext.ExecuteQuery();
                            sMenuString += "Folder" + item.Folder.Name;

                        }
                        else if (item.FileSystemObjectType == FileSystemObjectType.File)
                        {
                            // This is a File
                            clientContext.Load(item.File);
                            clientContext.ExecuteQuery();
                            //sMenuString += "File : "+item.File.Name;
                        }

                    }
                }
            }
            catch (Exception ex)
            {
                var errmsg = ex.Message;
            }

            return sMenuString;
        }
           

http://mstechtalk.com/using-jslink-alternative-calculated-columns/

http://mstechtalk.com/using-jslink-alternative-calculated-columns/

Using JSLink as an alternative for Calculated columns to Display Images Depending on Checkbox values

alert("Hello");

(function () {
    alert('starting')
    var fieldCtx = {};

    fieldCtx.Templates = {};
    fieldCtx.Templates.Fields = {
        "ShowOnDisplayBoard": //This is field name, make sure to enter the internal column name
        {
            "View": UpdateApprovalTempalte //Enter the function name
        }
    };

    SPClientTemplates.TemplateManager.RegisterTemplateOverrides(fieldCtx);
})();

var imgTrue = "<img src='/siteassets/checked.png' width='16px'/>"
var imgFalse = "<img src='/siteassets/uncheck.png' width='16px'/>"
 

function UpdateApprovalTempalte(ctx) {
    var columnValue = ctx.CurrentItem.ShowOnDisplayBoard;  // get the value of the ApprovalColumn field of the current item
    var returnValue = "";
    if (columnValue == 'Yes')
        returnValue = imgTrue;
    else if (columnValue == 'No')
        returnValue = imgFalse;
    else if (columnValue == '')
        returnValue = imgFalse;
    else
        returnValue = columnValue;

    return returnValue;
}

Backup and restore SharePoint online site

To back up and restore data in SharePoint Online, we can create an Office 365 support ticket to achieve it.

Contact Office 365 for business support - Admin Help

More information:

The 4 Options You Need to Know About SharePoint Online Backup and Restore

Thanks

Best Regards

I hope the above suggestion clarifies your concern, In SharePoint Online, we cannot backup and restore contents as what we do in SharePoint Server 2013. Instead, the backup and restoring features are reflected by the following features: version, template, recycle bin and some third party solutions.

Please follow this links to get more information about backup process in SharePoint Online

https://itsolutionsblog.net/the-backup-options-in-sharepoint-online/

How to back-up a Office 365 SharePoint Online site and data

Restore options in SharePoint Online

Hope this helps!

Migration solution to migrate to-and-from SharePoint and Office 365 along with File Servers, Exchange/Office 365 Public Folders, Google Drive and OneDrive Business to SharePoint Online/On-premise migration.

WebApi - Enable to CORS - cross domain - get Json format

WebApiConfig.cs under App_Start

using System.Net.Http.Headers;
using System.Web.Http;
using System.Web.Http.Cors; 


// Web API configuration and services
            var cors = new EnableCorsAttribute("*", "*", "*");
            config.EnableCors(cors);


config.MapHttpAttributeRoutes();

            config.Routes.MapHttpRoute(
                name: "DefaultApi",
                routeTemplate: "api/{controller}/{id}",
                defaults: new { id = RouteParameter.Optional }
            );

//This will get JSOn format
            config.Formatters.JsonFormatter.SupportedMediaTypes.Add(new MediaTypeHeaderValue("text/html"));

List View Filter - Show only Today's Or Less than 7days items

If you want to filter only items that are less than 7 days old then you just use

Filter

• Created
• is greater than or equal to
• [Today]-7

Note - the screenshot is incorrect.

Azure SharePoint online - webAPI

Recently I worked on Azure webAPI

Basically it will get data from outside environment and update data into SharePoint Online and It will delete entries from sparks server.

Followed below link

https://blogs.msmvps.com/windsor/2017/03/12/walkthrough-building-a-custom-web-api-for-use-with-sharepoint-online/

https://www.nuget.org/packages/Microsoft.IdentityModel.Protocols.WsFederation/

https://wpoffice365.com/access-sharepoint-online-using-postman/

https://sharepoint.stackexchange.com/questions/113929/make-a-restful-api-call-to-sharepoint-online-from-console-program