TDV Adapter for Microsoft SharePoint

Build 22.0.8462


Create, update, delete, and query the available lists in SharePoint.

Table Specific Information

Views is a special table. It may be used to get, update, insert, and delete views from a specified List.


In order to return results from Views, either the Id or List must be specified in the SELECT statement. For example:

SELECT * FROM Views WHERE List='MyListName'


The List, Name, Type, and Fields columns are required to insert to this table.


Name Type ReadOnly Description
ID [KEY] String True

The Id of the view.

List String True

The list the view is associated with. A list must be specified when performing SELECT statements if the Id is not specified.

ViewID String True

The Id of the view. May only be unique for the specific list.

Name String False

The name of the view.

Type String False

The type of view. This must have a value on inserts and updates.

The allowed values are CALENDAR, GRID, HTML.

The default value is HTML.

Fields String False

A comma separated list of the fields associated with the view. This is space-sensitive.

IsDefault Boolean False

A boolean indicating if the view is the default view for the list.

Query String False

A query for the view.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462