Excel Services REST API Overview

SharePoint 2010

Last modified: April 07, 2010

Applies to: SharePoint Server 2010

The REST API in Excel Services is new in Microsoft SharePoint Server 2010. By using the REST API, you can access workbook parts or elements directly through a URL.

REST services are based on two requirements:

  • An addressing scheme used to locate networked resources

  • A methodology for returning representations of these resources

REST services are resource-centric. With REST, data is divided into resources, each resource is given a URL, and standard operations are implemented on the resources, which enable operations like creation, retrieval, update, and deletion.

Note Note

For more information about the difference between REST services and custom Web services, see Custom Service or RESTful Service.

A REST API for Excel Services enables operations against Excel workbooks by using operations specified in the HTTP standard. This allows for a flexible, secure, and simpler mechanism to access and manipulate Excel Services content.

The discovery mechanisms built into the Excel Services REST API also enable developers and users to explore the content of the workbook manually or programmatically by supplying an Atom feed that contains information about the elements that reside in a specific workbook. Some examples of the resources that you can access through the REST API are charts, PivotTables, and tables.

Using the Atom feed provided by the REST API is an easier way of getting to the data that you care about. The feed contains traversable elements that enable any piece of code to discover what elements exist in a workbook.

For information about accessing the REST service and obtaining sample URIs for the REST service in Excel Services, see Basic URI Structure and Path and Sample URI For Excel Services REST API.