Lists
Retrieves metadata for available lists within a SharePoint site, including list types and settings. Important for understanding the structure of SharePoint lists and their usage.
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 server.
The following columns can be used in the WHERE clause: Title and BaseTemplate.
Columns
| Name | Type | References | Description |
| HasUniqueRoleAssignments [KEY] | Bool | Indicates whether the list has custom permissions instead of inheriting from its parent. Useful for managing security settings. | |
| LinkedFirstUniqueAncestorSecurableObject | String | References the first ancestor object with unique permissions. Helps track permission inheritance. | |
| LinkedRoleAssignments | String | Stores role assignments associated with the list. Useful for managing user access. | |
| ServerRelativeUrl | String | The URL of the list relative to the SharePoint server root. Useful for constructing API requests. | |
| Id [KEY] | String | A unique identifier for the list. Essential for referencing lists in scripts and automation. | |
| AllowContentTypes | Bool | Indicates whether content types can be assigned to the list. Helps enable structured data management. | |
| AllowDeletion | Bool | Indicates whether the list can be deleted. Useful for protecting critical lists from accidental removal. | |
| BaseTemplate | Int | The template type used to create the list, such as a document library or task list. Helps in identifying list functionality. | |
| BaseType | Int | Specifies the base type of the list, such as a standard list or a library. Helps categorize lists. | |
| BrowserFileHandling | Int | Determines how browser requests for files are handled. Useful for security and file access management. | |
| ContentTypesEnabled | Bool | Indicates whether content types are enabled for the list. Helps enforce metadata structure. | |
| CrawlNonDefaultViews | Bool | Indicates whether search indexing includes non-default list views. Useful for improving search results. | |
| Created | Datetime | The date and time when the list was created. Helps track list lifecycle. | |
| CurrentChangeToken_StringValue | String | Represents the current change token for the list. Useful for tracking modifications. | |
| CustomActionElements_Items | String | Stores custom action elements related to the list. Useful for managing list-level customizations. | |
| DataSource_Properties | String | Holds properties related to external data sources linked to the list. Helps with integration management. | |
| DefaultContentApprovalWorkflowId | String | The ID of the default content approval workflow assigned to the list. Useful for process automation. | |
| DefaultDisplayFormUrl | String | The URL of the default display form for viewing list items. Helps in navigation. | |
| DefaultEditFormUrl | String | The URL of the default edit form for modifying list items. Useful for quick access to edit pages. | |
| DefaultItemOpenUseListSetting | Bool | Determines whether list settings control how items are opened. Helps enforce standard behavior. | |
| DefaultNewFormUrl | String | The URL of the default form used to create new list items. Useful for directing users to item creation pages. | |
| DefaultViewPath_DecodedUrl | String | The decoded URL of the list’s default view. Helps in accessing the main list view. | |
| DefaultViewUrl | String | The URL of the default view for the list. Useful for quick navigation. | |
| Description | String | A short description of the list’s purpose. Helps users understand the function of the list. | |
| Direction | String | Specifies the reading order (left-to-right or right-to-left). Useful for localization settings. | |
| DisableGridEditing | Bool | Indicates whether inline editing (grid editing) is disabled for the list. Helps control data entry methods. | |
| DocumentTemplateUrl | String | The URL of the default document template associated with the list. Useful for document libraries. | |
| DraftVersionVisibility | Int | Determines the visibility of draft versions. Helps manage versioning access control. | |
| EffectiveBasePermissions_High | Long | Represents high-level base permissions applied to the list. Useful for security auditing. | |
| EffectiveBasePermissions_Low | Long | Represents low-level base permissions applied to the list. Helps enforce access control. | |
| EffectiveBasePermissionsForUI_High | Long | Defines high-level UI permissions for the list. Helps determine user actions. | |
| EffectiveBasePermissionsForUI_Low | Long | Defines low-level UI permissions for the list. Useful for security filtering. | |
| EnableAssignToEmail | Bool | Indicates whether 'Assigned To' email notifications are enabled for list items. Useful for task management. | |
| EnableAttachments | Bool | Indicates whether attachments can be added to list items. Helps manage file storage within lists. | |
| EnableFolderCreation | Bool | Indicates whether folders can be created in the list. Helps structure content hierarchically. | |
| EnableMinorVersions | Bool | Indicates whether minor (draft) versions are enabled for the list. Useful for version control. | |
| EnableModeration | Bool | Indicates whether content approval is required before items are published. Helps enforce approval workflows. | |
| EnableRequestSignOff | Bool | Determines if the request sign-off feature is enabled for the list. Useful for approval tracking. | |
| EnableVersioning | Bool | Indicates whether versioning is enabled for the list. Helps track changes over time. | |
| EntityTypeName | String | The entity type name associated with the list. Useful for API calls and automation. | |
| ExcludeFromOfflineClient | Bool | Indicates whether the list is excluded from offline synchronization. Helps control data availability. | |
| ExemptFromBlockDownloadOfNonViewableFiles | Bool | Indicates whether non-viewable files can be downloaded. Useful for managing security policies. | |
| FileSavePostProcessingEnabled | Bool | Indicates whether post-processing occurs when files are saved. Useful for custom workflows. | |
| ForceCheckout | Bool | Indicates whether files must be checked out before editing. Helps enforce document control. | |
| HasExternalDataSource | Bool | Indicates whether the list is connected to an external data source. Useful for integration monitoring. | |
| Hidden | Bool | Indicates whether the list is hidden from users. Helps manage background system lists. | |
| ImagePath_DecodedUrl | String | The decoded URL of the image associated with the list. Useful for branding and UI enhancements. | |
| ImageUrl | String | The URL of the image representing the list. Helps visually distinguish lists. | |
| IrmEnabled | Bool | Indicates whether Information Rights Management (IRM) is enabled. Useful for securing sensitive data. | |
| IrmExpire | Bool | Indicates whether IRM expiration is enforced on list items. Helps manage document retention policies. | |
| IrmReject | Bool | Indicates whether IRM-restricted files are rejected. Helps enforce document security settings. | |
| IsApplicationList | Bool | Indicates whether the list is used by an application. Helps differentiate between user-created and system lists. | |
| IsCatalog | Bool | Indicates whether the list is a catalog. Useful for managing product or content directories. | |
| IsEnterpriseGalleryLibrary | Bool | Indicates whether the list is part of an enterprise gallery. Helps manage corporate-wide resources. | |
| IsPrivate | Bool | Indicates whether the list is private. Helps enforce access restrictions. | |
| IsSiteAssetsLibrary | Bool | Indicates whether the list is the default site assets library. Useful for managing branding and site assets. | |
| IsSystemList | Bool | Indicates whether the list is a system-generated list. Helps prevent unintended modifications. | |
| ItemCount | Int | The total number of items in the list. Useful for monitoring list size and performance. | |
| LastItemDeletedDate | Datetime | The date and time when the last item was deleted. Helps track recent deletions. | |
| LastItemModifiedDate | Datetime | The date and time when the last item was modified. Useful for tracking recent updates. | |
| LastItemUserModifiedDate | Datetime | The date and time when the last modification was made by a user. Helps distinguish system updates from user actions. | |
| ListExperienceOptions | Int | Determines the user experience mode for the list. Helps manage classic vs. modern UI settings. | |
| ListItemEntityTypeFullName | String | The full entity type name for list items. Useful for API interactions. | |
| MajorVersionLimit | Int | The maximum number of major versions retained. Helps control versioning. | |
| MajorWithMinorVersionsLimit | Int | The maximum number of minor versions retained. Helps manage version history. | |
| MultipleDataList | Bool | Indicates whether the list supports multiple data sources. Useful for complex integrations. | |
| NoCrawl | Bool | Indicates whether the list is excluded from search indexing. Helps manage search visibility. | |
| OnQuickLaunch | Bool | Indicates whether the list appears in the Quick Launch menu. Useful for navigation. | |
| PageRenderType | Int | Determines how list pages are rendered. Helps optimize performance. | |
| ParentWebPath_DecodedUrl | String | The decoded URL of the parent site. Helps in site navigation. | |
| ParentWebUrl | String | The URL of the parent web containing the list. Useful for organizing hierarchical sites. | |
| ParserDisabled | Bool | Indicates whether the parser is disabled for the list. Useful for security and performance. | |
| ReadSecurity | Int | Specifies the read security level for the list. Helps control visibility. | |
| SchemaXml | String | Stores the XML schema definition of the list. Useful for customization. | |
| ServerTemplateCanCreateFolders | Bool | Indicates whether folders can be created using the list template. Helps manage structured content. | |
| TemplateFeatureId | String | The feature ID associated with the list template. Useful for template tracking. | |
| Title | String | The display name of the list. Helps in identifying lists in the UI. | |
| ValidationFormula | String | Stores the formula for list validation. Helps enforce data entry rules. | |
| ValidationMessage | String | The message displayed when validation fails. Useful for guiding users. | |
| WriteSecurity | Int | Determines write permissions for the list. Helps enforce access control. | |
| LinkedContentTypes | String | Lists the content types associated with the SharePoint list. Helps manage metadata and define structured data types. | |
| LinkedCreatablesInfo | String | Contains information about items that can be created in the list. Useful for determining available item types. | |
| LinkedDefaultView | String | The default view linked to the SharePoint list. Helps in displaying data with predefined filters and formatting. | |
| LinkedDescriptionResource | String | The resource containing the localized description of the list. Useful for multi-language support and UI customization. | |
| LinkedEventReceivers | String | Lists event receivers associated with the list. Helps track automated actions triggered by list events. | |
| LinkedFields | String | Stores the schema of fields (columns) linked to the list. Useful for defining data structures and managing list properties. | |
| LinkedForms | String | Contains references to the forms (New, Edit, and Display) associated with the list. Helps in customizing the user interface. | |
| LinkedInformationRightsManagementSettings | String | Stores IRM settings for the list. Helps enforce document security and compliance policies. | |
| LinkedItems | String | Lists all items linked to the SharePoint list. Useful for retrieving related data or performing batch operations. | |
| LinkedParentWeb | String | The parent website associated with the list. Helps in understanding site hierarchy and navigation. | |
| LinkedRootFolder | String | The root folder associated with the list. Useful for managing document library structures and file storage. | |
| LinkedSubscriptions | String | Lists active subscriptions related to the list. Helps in managing notifications and automated workflows. | |
| LinkedTitleResource | String | Contains the localized title of the list. Useful for supporting multiple languages in SharePoint UI. | |
| LinkedUserCustomActions | String | Lists custom user actions linked to the list. Helps in managing personalized commands and automation. | |
| LinkedViews | String | Stores references to views associated with the list. Useful for managing different ways to present list data. | |
| LinkedWorkflowAssociations | String | Lists workflows linked to the list. Helps in tracking automated processes and approvals. |