Returns SharePoint lists.

Table-Specific Information

Lists can be used to list the tables in SharePoint. This only returns actual lists in SharePoint, and not any special tables associated with the add-in.

The following columns in a WHERE clause are handled server-side:

• Title
• BaseTemplate

The rest are handled client-side.

Columns

Name	Type	References	Description
Id [KEY]	String		The GUID that identifies the list in the database.
EntityTypeName	String		The entity type name for the list.
Title	String		The displayed title for the list.
AdditionalUXProperties	String		Additional user experience properties associated with the list.
AllowContentTypes	Bool		Specifies whether the list supports content types.
AllowDeletion	Bool		Specifies whether the list allows deletion.
BaseTemplate	Int		The list definition type on which the list is based. Represents a ListTemplateType value.
BaseType	Int		The base type for the list. Represents an SP.BaseType value: Generic List = 0; Document Library = 1; Discussion Board = 3; Survey = 4; Issue = 5.
BrowserFileHandling	Int		The override of the web application's BrowserFileHandling property at the list level: Permissive = 0; Strict = 1.
Color	String		The color value associated with the list.
ContentTypesEnabled	Bool		Specifies whether content types are enabled for the list.
CrawlNonDefaultViews	Bool		Specifies whether non-default views of the list are included in search crawls.
Created	Datetime		Date and time when the list was created.
DefaultContentApprovalWorkflowId	String		The default workflow identifier for content approval on the list. Returns an empty GUID if there is no default content approval workflow.
DefaultDisplayFormURL	String		The location of the default display form for the list. Clients specify a server-relative URL, and the server returns a site-relative URL
DefaultEditFormURL	String		The URL of the edit form to use for list items in the list. Clients specify a server-relative URL, and the server returns a site-relative URL.
DefaultItemOpenInBrowser	Bool		Specifies whether list items are opened in the browser by default.
DefaultItemOpenUseListSetting	Bool		Specifies whether the list setting determines how items are opened by default.
DefaultNewFormURL	String		Gets or sets a value that specifies the location of the default new form for the list. Clients specify a server-relative URL, and the server returns a site-relative URL.
DefaultViewPath_DecodedURL	String		The decoded URL of the default view path for the list.
DefaultViewURL	String		The URL of the default view for the list.
Description	String		The description of the list.
Direction	String		The reading order of the list. Returns NONE, LTR, or RTL.
DisableCommenting	Bool		Specifies whether commenting is disabled for items in the list.
DisableGridEditing	Bool		Specifies whether grid editing is disabled for the list.
DocumentTemplateURL	String		The server-relative URL of the document template for the list. Returns a server-relative URL if the base type is DocumentLibrary, otherwise returns null.
DraftVersionVisibility	Int		The minimum permission required to view minor versions and drafts within the list: Reader = 0; Author = 1; Approver = 2.
EffectiveBasePermissions_High	Long		The effective permissions on the list that are assigned to the current user.
EffectiveBasePermissions_Low	Long		The effective permissions on the list that are assigned to the current user.
EffectiveBasePermissionsForUI_High	Long		The high-order part of the effective base permissions for the list as displayed in the user interface.
EffectiveBasePermissionsForUI_Low	Long		The low-order part of the effective base permissions for the list as displayed in the user interface.
EnableAssignToEmail	Bool		Specifies whether the 'Assign To' email notification feature is enabled for the list.
EnableAttachments	Bool		Specifies whether list item attachments are enabled for the list.
EnableFolderCreation	Bool		Specifies whether new list folders can be added to the list.
EnableMinorVersions	Bool		Specifies whether minor versions are enabled for the list.
EnableModeration	Bool		Specifies whether content approval is enabled for the list.
EnableRequestSignOff	Bool		Specifies whether the 'Request Sign Off' feature is enabled for the list.
EnableVersioning	Bool		Specifies whether historical versions of list items and documents can be created in the list.
ExcludeFromOfflineClient	Bool		Specifies whether the list is excluded from offline clients.
ExcludeFromOfflineMode	Bool		Specifies whether the list is excluded from offline mode.
ExemptFromBlockDownloadOfNonViewableFiles	Bool		Specifies whether the list is exempt from the block download policy for non-viewable files.
FileSavePostProcessingEnabled	Bool		Specifies whether post-processing is enabled when saving files to the list.
ForceCheckout	Bool		Specifies whether forced checkout is enabled for the document library.
HasContentAssemblyTemplates	Bool		Specifies whether the list has content assembly templates.
HasExternalDataSource	Bool		Specifies whether the list is an external list.
HasFolderColoringFields	Bool		Specifies whether the list has folder coloring fields.
HasListBoundContentAssemblyTemplates	Bool		Specifies whether the list has list-bound content assembly templates.
HasUniqueRoleAssignments	Bool		Specifies whether the role assignments are uniquely defined for this securable object or inherited from a parent securable object.
Hidden	Bool		Specifies whether the list is hidden. If true, the server sets the OnQuickLaunch property to false.
HighPriorityMediaProcessing	Bool		Specifies whether high priority media processing is enabled for the list.
Icon	String		The icon associated with the list.
ImagePath_DecodedURL	String		The decoded URL of the image path for the list.
ImageURL	String		The URL for the icon of the list.
IrmEnabled	Bool		Specifies whether IRM is enabled for the list.
IrmExpire	Bool		Specifies whether IRM expiration is enabled for the list.
IrmReject	Bool		Specifies whether IRM rejection is enabled for the list.
IsApplicationList	Bool		Specifies a flag that a client application can use to determine whether to display the list.
IsCatalog	Bool		Specifies whether the list is a gallery.
IsContributorOwnerEnabled	Bool		Specifies whether contributor owner is enabled for the list.
IsDefaultDocumentLibrary	Bool		Specifies whether the list is the default document library.
IsPredictionModelApplied	Bool		Specifies whether a prediction model is applied to the list.
IsPrivate	Bool		Specifies whether the list is private.
IsSystemList	Bool		Specifies whether the list is a system list.
ItemCount	Int		The number of items in the list.
LastItemDeletedDate	Datetime		The last date and time a list item was deleted from the list.
LastItemModifiedDate	Datetime		The last date and time a list item, field, or property of the list was modified.
LastItemUserModifiedDate	Datetime		The last date and time a list item, field, or property of the list was last modified by a user.
ListExperienceOptions	Int		The experience options for the list.
ListFormCustomized	Bool		Specifies whether the list form is customized.
ListItemEntityTypeFullName	String		The full entity type name for the list items.
ListSchemaVersion	Int		The schema version of the list.
MajorVersionLimit	Int		The limit of major versions allowed for items in the list.
MajorWithMinorVersionsLimit	Int		The limit of major versions with minor versions allowed for items in the list.
MultipleDataList	Bool		Specifies whether the list in a Meeting Workspace site contains data for multiple meeting instances within the site.
NoCrawl	Bool		Specifies that the crawler must not crawl the list.
OnQuickLaunch	Bool		Specifies whether the list appears on the Quick Launch of the site. If true, the server sets the Hidden property to false.
PageRenderType	Int		The page render type for the list.
ParentWebPath_DecodedURL	String		The decoded URL of the parent web path for the list.
ParentWebURL	String		Specifies the server-relative URL of the site that contains the list.
ParserDisabled	Bool		Specifies whether the parser is disabled for the list.
ReadSecurity	Int		The read security setting for the list.
SchemaXML	String		The list schema represented as an XML.
ServerRelativeURL	String		The Server Relative URL.
ServerTemplateCanCreateFolders	Bool		Specifies whether folders can be created within the list.
ShowHiddenFieldsInModernForm	Bool		Specifies whether hidden fields are shown in the modern form for the list.
TemplateFeatureId	String		The identifier of the feature that contains the list schema for the list. Returns an empty GUID if the list schema is not contained within a feature.
TemplateTypeId	String		The template type identifier for the list.
ValidationFormula	String		The data validation criteria for a list item.
ValidationMessage	String		The error message returned when data validation fails for a list item.
WriteSecurity	Int		The write security setting for the list.
TableName	String		The driver-assigned name used to query this list as a table. The driver derives this name from the list's Title or EntityTypeName, depending on the UseEntityTypeName connection property, and appends a numeric suffix to resolve any naming conflicts.