page_type	products	languages	urlFragment	description	extensions
sample	office-sp office-365	csharp	crud-operations-sharepoint	Use the SharePoint REST/OData endpoints to perform operations on lists and list items from a SharePoint Add-in.	contentType technologies createdDate samples Add-ins 8/8/2015 11:33:40 AM

Basic CRUD operations in SharePoint Add-ins using the REST/OData APIs

SharePoint add-in model is considered as a legacy option for extending SharePoint user interface. Please see SharePoint Framework documentation and the SharePoint Framework samples for the future proven option to extend SharePoint Online. Possible backend services should be using Azure Active Directly based registration and related app models.

Summary

Use the SharePoint REST/OData endpoints to perform create, read, update, and delete operations on lists and list items from a SharePoint Add-in.

Applies to

• SharePoint Online and on-premise SharePoint 2013 and later

Prerequisites

This sample requires the following:

• A SharePoint 2013 (or later) development environment that is configured for add-in isolation and OAuth. (A SharePoint Online Developer Site is automatically configured. For an on premise development environment, see Set up an on-premises development environment for SharePoint Add-ins and Use an Office 365 SharePoint site to authorize provider-hosted add-ins on an on-premises SharePoint site.)

• Visual Studio and the Office Developer Tools for Visual Studio installed on your developer computer

• Basic familiarity with RESTful web services and OData

Description of the code

The code that uses the REST APIs is located in the Default.aspx.cs file of the SharePoint-Add-in-REST-OData-BasicDataOperationsWeb project. The Default.aspx page of the add-in appears after you install and launch the add-in and looks similar to the following.

The sample demonstrates the following:

• How to read and write data to and from a SharePoint host web. This data conforms with the OData protocol to the REST endpoints where the list and list item entities are exposed.

• How to parse Atom-formatted XML returned from these endpoints and how to construct JSON-formatted representations of the list and list item entities so that you can perform Create and Update operations on them.

• Best practices for retrieving form digest and eTag values that are required for Create and Update operations on lists and list items.

To use the sample

12. Open Visual Studio as an administrator.
13. Open the .sln file.
14. In Solution Explorer, highlight the SharePoint add-in project and replace the Site URL property with the URL of your SharePoint developer site.
15. Press F5.
16. After the add-in installs, the consent page opens. Click Trust It.
17. Enter a string in the text box beside the Add List button and click the button. In a moment, the page refreshes and the new list is in the table.
18. Click the ID of the list, and then click Retrieve List Items. There will initially be no items on the list. Some additional buttons will appear.
19. Add a string to the text box beside the Add Item button and press the button. The new item will appear in the table in the row for the list.
20. Add a string to the text box beside the Change List Title button and press the button. The title will change in the table.
21. Press the Delete the List button and the list is deleted.

Do not delete any of the built-in SharePoint lists. If you mistakenly do so, recover the list from the SharePoint Recycle Bin.

Troubleshooting

Problem	Solution
Visual Studio does not open the browser after you press the F5 key.	Set the SharePoint Add-in project as the startup project.
HTTP error 405 Method not allowed.	Locate the applicationhost.config file in %userprofile%\Documents\IISExpress\config. Locate the handler entry for StaticFile, and add the verbs GET, HEAD, POST, DEBUG, and TRACE.

Questions and comments

We'd love to get your feedback on this sample. You can send your questions and suggestions to us in the Issues section of this repository.

Additional resources

Get to know the SharePoint 2013 REST service.

Open Data Protocol

OData: JavaScript Object Notation (JSON) Format

OData: AtomPub Format.

Copyright

Copyright (c) Microsoft. All rights reserved.