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

データ型

bool

デフォルト値

true

解説

This property determines which SharePoint API the 本製品 uses to retrieve data.

If set to true, the 本製品 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.