CRUD Operation with SharePoint REST Service using ADO.NET DATA Services

By -

Today I am going to implement the SharePoint 2010 REST Services using ADO.NET Data Services. In this example i will show you how to applying the CRUD Operation to the SharePoint List. In this example I will create the Window Application and consuming the ListData.svc service and perform the basic list Operations. I will provide you a video link so you can easily understand and do it your self. 

Overview 
  • Prerequisite
  • General error while using SharePoint Rest Services.
  • Fix Errors
  • Implementation
  • CRUD Operation with SharePoint REST Service using ADO.NET DATA Services
  • Video
  • Source Code
Prerequisite
  • Visual Studio 2010 
  • ADO.NET Data Services v1.5 CTP2 Installed on your machine
  • Full Access to the SharePoint 2010 Rest Service URL. Ex http://<<servername:port>>/_vti_bin/Listdata.svc 


General error while using SharePoint Rest Services.
“System.Data.Services.Providers.IDataServiceUpdateProvider’ from assembly ‘System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089”
Fix Errors

You need to installed the following 
  1. Make sure your SharePoint 2010 Rest Service Accessible to you.
  2. To check the URL enter the service name in your browser. Example (http://home/_vti_bin/Listdata.svc)
  3. Open visual Studio and Add SharePoint data source and consume this services.

Please email me your email id so I can share with you this video.

Video



Source Code

  1. Rest Example

  1. PPT Presentation 

Comments

Post a Comment

Popular posts from this blog

SharePoint RPC Protocols Examples Using OWSSVR.DLL

By -
Image
What is SharePoint RPC Protocols? Part 1 This reference includes information about the methods and usage of SharePoint Foundation Remote Procedure Call (RPC) protocol. This protocol can be used in Win32-based applications or in ASPX applications to make HTTP POST requests to the server. Methods in this protocol that do not modify the contents of the database can also be used in URL protocol to make HTTP GET requests. Definition taken from http://msdn.microsoft.com/en-us/library/ms448359.aspx You will find the OWSSVR.DLL in SharePoint 2010 Server Physical Path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI and MOSS C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI OWSSVR.DLL List of commands DialogView  Display ExportList GetProjSchema GetUsageBlob HitCounter RenderView To read more about the OWSSVR.DLL command Please read the URL Protocol from Microsoft Blog having a URL http://msdn.microsoft.com/en-us/
Read more

Send Email using SharePoint Rest API

By -
We have a requirement to send email vai SharePoint Rest API. We dig and find the below solution to send email using SharePoint API. Point Must be remember End point " /_api/SP.Utilities.Utility.SendEmail " end point to send email.  In JSON __metadata we used the type " SP.Utilities.EmailProperties ". The User / Group must have a read permission for particular site. where we placed this site code. JS Dependency  JQuery Code URL:  https://gist.github.com/BasantPandey/05189832546f2c6cc0bd008fcfec3264#file-sharepointsendemail-js Code  var Email = function (){ // Email Either email groupname or email address var from = ' abc.yahoo.com ' , to = ' abc.yahoo.com ' , cc = ' abc.yahoo.com ' , subject = ' My Email Subject ' ; this . options = this . options || {}; this . options [ ' fromEmail ' ] = this . options [ ' fromEmail ' ] || {}; this . options [ ' toEmail &
Read more

Query suggestions in SP 2013 Using Rest API (/_api/search/suggest)

By -
Image
SharePoint Query suggestions: In this post I am going to share with you code snippets to implement the query suggestion in custom text box. Below are the dependency files  1. Jquery UI : http://code.jquery.com/ui/1.10.0/jquery-ui.js 2. Jquery AutoComplete CSS: http://code.jquery.com/ui/1.10.0/themes/base/jquery-ui.css http://code.jquery.com/ui/1.10.0/themes/base/jquery.ui.autocomplete.css 3. JQuery: http://code.jquery.com/jquery-1.8.3.js Query Suggestion Parameter: Here is the post http://blogs.msdn.com/b/nadeemis/archive/2012/08/24/sharepoint-2013-search-rest-api.aspx that specified the detail query suggestions parameter list. Implementation: I have two vertical examples. 1. People Vertical 2. Everything Vertical I wanted to display the query suggestions on TeamSite pages although my search is configured in one of our serach center, so when user search for a particular term and it contains in the search query completion list t
Read more