Lists
Returns SharePoint lists.
Table Specific Information
Lists can be used to list the tables in SharePoint. This will only return actual lists in SharePoint and not any special tables associated with the component.
The following columns can be used in the WHERE clause: Title and BaseTemplate.
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. |