Accessing Access Data using Rest APIs

Access Services provides data storage and reporting functionality SharePoint 2010. Developers can use Rest APIs to access and modify Access Services data. This lab will demonstrate how Access Service data can be queried using the Rest APIs.

Overview

Access Services provides data storage and reporting functionality SharePoint 2010. Developers can use Rest APIs to access and modify Access Services data. This lab will demonstrate how Access Service data can be queried using the Rest APIs.

Objectives

• Create a Web Database.
• Retrieve data using the Rest API and display list data.

System Requirements

You must have the following items to complete this lab:

• 2010 Information Worker Demonstration and Evaluation Virtual Machine
• Microsoft Visual Studio 2010
• Visual Studio 2010 SharePoint Power Tools
• Silverlight 4 Toolkit
• Silverlight WebPart

Setup

You must perform the following steps to prepare your computer for this lab...

1. Download the 2010 Information Worker Demonstration and Evaluation Virtual Machine from https://tinyurl.com/2avoc4b and create the Hyper-V image.
2. Install the Visual Studio 2010 Silverlight Web Part. The Silverlight Web Part is an add-on to Visual Studio 2010 and can be downloaded from https://code.msdn.microsoft.com/vsixforsp.
3. Install the Silverlight 4 Toolkit located at https://silverlight.codeplex.com/
4. Install the Visual Studio 2010 SharePoint Power Tools located at https://visualstudiogallery.msdn.microsoft.com/en-us/8e602a8c-6714-4549-9e95-f3700344b0d9

Exercises

This Hands-On Lab comprises the following exercises:

1. Create a Contacts Web Database
2. Retrieve Contacts from the Contacts Web Database using the Rest API Display the Query Results

Estimated time to complete this lab: 40 minutes.

Starting Materials

This Hands-On Lab includes the following starting materials.

• Visual Studio solutions. The lab provides the following Visual Studio solutions that you can use as starting point for the exercises.
  • <Install location>\Labs\AccessingAccessDataRestAPIs\Source\Begin\SilverlightAccessListDataService.sln: This solution is a a Silverlight Web Part with the starter code commented out.
  Note:

  Inside each exercise folder, you will find an end folder containing a solution with the completed lab exercise.