Posts

Showing posts from January, 2017

SharePoint List Operations on SharePoint 2013 using REST API Services In - Part IV (GET All Items)

function GetItems() {       $.ajax     ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items?$select=Column1,Column2",         type: type,         data: data,         headers:         {             "Accept": "application/json;odata=verbose",             "Content-Type": "application/json;odata=verbose",             "X-RequestDigest": $("#__REQUESTDIGEST").val(),             "IF-MATCH": "*",             "X-HTTP-Method": null         },         cache: false,         success: function(data)           {     //success - bind values here             $("#sampleDIV").empty();             for (var i = 0; i < data.d.results.length; i++)               {                 var item = data.d.results[i];                 $("#sampleDIV").append(item.Column1);             }         },        
Post a Comment
Read more

SharePoint List Operations on SharePoint 2013 using REST API Services In - Part III (DELETE)

function deleteItemByID(id) {     $.ajax     ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items("+id+")",         type: "POST",         headers:         {             "X-RequestDigest": $("#__REQUESTDIGEST").val(),             "IF-MATCH": "*",             "X-HTTP-Method": "DELETE"         },         success: function(data, status, xhr)         {             //alert("Success");         },         error: function(xhr, status, error)         {            //Failure         }     }); }  
Post a Comment
Read more

SharePoint List Operations on SharePoint 2013 using REST API Services In - Part II (UPDATE)

function updateListItem(id) {     var titleVal = $("#txtTitle").val();     $.ajax     ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items("+id+")", // list item ID         type: "POST",         data: JSON.stringify         ({             __metadata:             {                 type: "SP.Data.TestListItem"             },             Title: titleVal         }),         headers:         {             "Accept": "application/json;odata=verbose",             "Content-Type": "application/json;odata=verbose",             "X-RequestDigest": $("#__REQUESTDIGEST").val(),             "IF-MATCH": "*",             "X-HTTP-Method": "MERGE"         },         success: function(data, status, xhr)         {             //alert("Success");         },  
Post a Comment
Read more

SharePoint List Operations on SharePoint 2013 using REST API Services In - Part I (ADD)

Add List Item function AddItem() {     var titleVal = $("#txtTitle").val();      var metadataVal = {                 "__metadata": { "type": getListItemType("SharePoint List Name") },                 "Title": titleVal             };     $.ajax         ({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('SharePoint List Name')/items",         type: "POST",         data: JSON.stringify(metadataVal),         headers:         {             "Accept": "application/json;odata=verbose",             "Content-Type": "application/json;odata=verbose",             "X-RequestDigest": $("#__REQUESTDIGEST").val(),             "X-HTTP-Method": "POST"         },         success: function(data, status, xhr)         {             //alert("Success");         },         error: function(x
Post a Comment
Read more

Opening SharePoint Links List in New Window

< script type ="text/javascript" language ="javascript" src ="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></ script > < script type ="text/javascript" language ="javascript">     $(document).ready( function () {         $( ".ms-vb a" ).attr( 'target' , '_blank' );     }); </ script >
Post a Comment
Read more

SHAREPOINT / .NET C# EXPORT DATATABLE TO EXCEL USING OPENXML DLL

Convert DataTable to Stream private static MemoryStream WriteExcelFile (string sheetName , DataTable table ) {  MemoryStream stream = new MemoryStream();  using (SpreadsheetDocument document = SpreadsheetDocument.Create( stream , SpreadsheetDocumentType.Workbook,true))  {   WorkbookPart workbookPart = document.AddWorkbookPart();   workbookPart.Workbook = new Workbook();   WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();   var sheetData = new SheetData();   worksheetPart.Worksheet = new Worksheet(sheetData);   Sheets sheets = workbookPart.Workbook.AppendChild(new Sheets());   Sheet sheet = new Sheet() { Id = workbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = sheetName };   sheets.Append(sheet);   Row headerRow = new Row();   List<String> columns = new List<string>();   foreach (System.Data.DataColumn column in table .Columns)   {    columns.Add(column.ColumnName);    Cel
Post a Comment
Read more

Get List Item Count in SPServices

completefunc: function (xData, Status) {            var ItemCount = $(xData.responseXML).SPFilterNode("rs:data").attr("ItemCount"); }
Post a Comment
Read more

How to Create an Export to Excel Link on Any List or Library for 2010 and 2013

Generate the below URL for any list / library SiteURL/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={ List ID }&View={ View ID }&CacheControl=1 Ex: http://SharepointSiteCollection:80/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={XXXXXXXX-XXXX-XXXX-XXXXXXXXX&View={XXXXXXXX-XXXX-XXXX-XXXXXXXXX}&CacheControl=1 Note : For List ID and View ID, you could get it from List Setting page and View page respectively
Post a Comment
Read more