Whether or not the REST API is used for retrieving data.

Syntax

Connect-ExcelServices -UseRESTAPI bool

Data Type

bool

Default Value

true

Remarks

Whether or not the REST API is used for retrieving data. SharePoint 2010 must use the REST API. In SharePoint versions after 2010, both the REST API and OData API are available.

Use the REST API to access spreadsheets and ranges as tables as well as table objects. The OData API enables access to only table objects.

See Data Model for more information on querying spreadsheets organized in different ways.