Specifies whether the provider uses the SharePoint REST API instead of the OData API to retrieve data.

Data Type

bool

Default Value

true

Remarks

This property determines which SharePoint API the server uses to retrieve data.

If set to true, the server uses the REST API. If set to false, it uses the OData API.

SharePoint 2010 only supports the REST API. Later versions of SharePoint support both the REST and OData APIs.

Use the REST API to query spreadsheets and ranges as tables, as well as defined table objects. The OData API allows access only to named table objects.

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

Use this property when you need to retrieve data from cell ranges or non-tabular worksheet layouts that the OData API cannot expose.