Tableau Connector for Microsoft SharePoint

Build 24.0.8963

Views

Creates, updates, deletes, and queries 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.

Select

To return results from Views, yout must specify either the ID or List in the SELECT statement. For example,


SELECT * FROM Views WHERE List = 'MyListName'

Insert

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

Columns

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963