Tableau Connector for Microsoft SharePoint

Build 25.0.9434

AllLists

Lists all available SharePoint lists within the domain, including system fields and metadata. Essential for identifying and managing lists across the SharePoint environment.

Columns

Name Type References Description
SiteURL [KEY] String

Sites.SiteURL

The full URL of the SharePoint site where the list is located. Useful for identifying the site context of the list.
Id [KEY] String A unique identifier for the list. Helps in distinguishing lists when working with APIs or automation scripts.
Title String The display name of the list. Useful for user-friendly identification of lists.
BaseTemplate Int The template type used to create the list, such as a document library, task list, or calendar. Helps determine the list’s functionality.
BaseType Int Indicates the base type of the list, such as a generic list or a library. Useful for categorizing lists.
Description String A brief description of the list, providing context about its purpose and usage.
Hidden Bool Indicates whether the list is hidden from standard SharePoint views. Helps determine if a list is meant for background processes.
AllowDeletion Bool Indicates whether the list can be deleted. Useful for protecting critical lists from accidental deletion.
ItemCount Int The total number of items stored in the list. Helps in monitoring list usage and performance.
Created Datetime The date and time when the list was originally created. Useful for tracking its lifespan.
LastItemDeletedDate Datetime The date and time when the most recent item was deleted from the list. Useful for tracking recent deletions.
LastItemModifiedDate Datetime The date and time when the last modification was made to any item in the list. Helps identify recent activity.
LastItemUserModifiedDate Datetime The date and time when the last modification was made by a user. Useful for differentiating between system and user changes.
HasUniqueRoleAssignments Bool Indicates whether the list has custom permission settings instead of inheriting them from the parent site. Important for security management.
DefaultDisplayFormUrl String The URL of the default display form for viewing list items. Useful for navigation and form customization.
DefaultEditFormUrl String The URL of the default edit form for modifying list items. Helps in linking to the correct edit page.
DefaultNewFormUrl String The URL of the default form for creating new list items. Useful for directing users to item creation pages.
DefaultViewPath_DecodedUrl String The decoded URL of the default view path for the list. Helps in accessing the list’s standard view.
DefaultViewUrl String The URL of the default view of the list. Useful for quick access to the main list view.
DisableCommenting Bool Indicates whether commenting is disabled for the list. Helps manage collaboration settings.
DocumentTemplateUrl String The URL of the default document template used when creating new files in the list. Important for document libraries.
EnableAttachments Bool Indicates whether attachments are allowed for list items. Useful for managing file uploads within lists.
EnableFolderCreation Bool Indicates whether users can create folders within the list. Important for structuring content hierarchies.
EntityTypeName String The entity type name associated with the list. Helps in API interactions and automation.
ImagePath_DecodedUrl String The decoded URL of the list’s associated image. Useful for branding and visual identification.
ImageUrl String The URL of the image representing the list. Helps in user-friendly display of lists.
IsApplicationList Bool Indicates whether the list is used as part of an application. Helps differentiate standard lists from system-generated ones.
IsCatalog Bool Indicates whether the list functions as a catalog. Useful for managing product or resource directories.
IsDefaultDocumentLibrary Bool Indicates whether the list is the primary document library of the site. Useful for identifying the main storage location.
IsPrivate Bool Indicates whether the list is private and not accessible to all users. Helps enforce security and data protection.
IsSystemList Bool Indicates whether the list is a system-generated list used by SharePoint internally. Useful for avoiding unintended modifications.
ListFormCustomized Bool Indicates whether the list’s forms have been customized. Important for tracking UI customizations.
ListItemEntityTypeFullName String The full entity type name associated with list items. Useful for integrations and API usage.
ParentWebPath_DecodedUrl String The decoded URL of the parent site containing the list. Helps identify hierarchical site relationships.
ParentWebUrl String The URL of the parent site containing the list. Useful for navigation and organization.
ReadSecurity Int Specifies the level of read security applied to the list. Controls who can view items within the list.
ServerTemplateCanCreateFolders Bool Indicates whether the server template allows folder creation in the list. Helps manage content structuring.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434