Subsites
Lists all subsites under a specified SharePoint site, including hierarchy and metadata. Helps in structuring and organizing content within a SharePoint environment.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A unique identifier for the subsite. Useful for tracking and managing SharePoint subsites. | |
| AllowRssFeeds | Boolean | Indicates whether RSS feeds are enabled for the subsite. Helps users stay updated on site changes. | |
| AlternateCssUrl | String | The URL of an alternate CSS file applied to the subsite. Useful for customizing the site's appearance. | |
| AppInstanceId | String | A unique identifier for the app instance associated with the subsite. Helps manage app-based integrations. | |
| ClassicWelcomePage | String | The URL of the classic welcome page for the subsite. Useful for setting a landing page in classic SharePoint mode. | |
| Configuration | Int | The configuration ID of the subsite, defining its structure and settings. Helps with site provisioning. | |
| Created | Datetime | The date and time when the subsite was created. Useful for tracking site lifespan and history. | |
| CurrentChangeToken_StringValue | String | Represents the latest change token for the subsite. Helps track modifications and ensure data consistency. | |
| CustomMasterUrl | String | The URL of a custom master page applied to the subsite. Useful for customizing the site's branding and layout. | |
| Description | String | A brief summary of the subsite’s purpose. Helps users understand the site's function at a glance. | |
| DesignPackageId | String | The identifier for the design package applied to the subsite. Helps manage SharePoint themes and templates. | |
| DocumentLibraryCalloutOfficeWebAppPreviewersDisabled | Boolean | Indicates whether Office Web App previewers are disabled for document libraries in the subsite. Helps control document preview behavior. | |
| EnableMinimalDownload | Boolean | Indicates whether minimal download strategy (MDS) is enabled for the subsite. Helps improve page load performance. | |
| FooterEmphasis | Int | Defines the emphasis style for the subsite's footer. Helps customize branding and layout. | |
| FooterEnabled | Boolean | Indicates whether the footer is enabled on the subsite. Useful for adding navigation and site information. | |
| FooterLayout | Int | Specifies the layout style of the subsite’s footer. Helps manage visual consistency across sites. | |
| HeaderEmphasis | Int | Defines the emphasis style for the subsite's header. Helps maintain branding and aesthetic consistency. | |
| HeaderLayout | Int | Specifies the layout style of the subsite’s header. Useful for customizing the top navigation experience. | |
| HideTitleInHeader | Boolean | Indicates whether the site title is hidden in the header. Helps achieve a cleaner UI design. | |
| HorizontalQuickLaunch | Boolean | Indicates whether horizontal quick launch navigation is enabled. Helps improve site accessibility. | |
| IsHomepageModernized | Boolean | Indicates whether the homepage has been modernized. Useful for tracking the site's transition to the modern SharePoint experience. | |
| IsMultilingual | Boolean | Indicates whether the subsite supports multiple languages. Helps enable localization and internationalization. | |
| IsRevertHomepageLinkHidden | Boolean | Indicates whether the 'Revert to Classic Homepage' link is hidden. Useful for enforcing modern UI. | |
| Language | Int | The language code used by the subsite. Helps define language settings and content localization. | |
| LastItemModifiedDate | Datetime | The date and time when the last item in the subsite was modified. Helps monitor recent activity. | |
| LastItemUserModifiedDate | Datetime | The date and time when the last modification was made by a user. Helps differentiate between system and user edits. | |
| LogoAlignment | Int | Specifies how the site logo is aligned. Helps customize branding appearance. | |
| MasterUrl | String | The URL of the master page applied to the subsite. Helps in controlling the site's overall design and layout. | |
| MegaMenuEnabled | Boolean | Indicates whether the mega menu feature is enabled for the subsite. Helps enhance navigation in large site structures. | |
| NavAudienceTargetingEnabled | Boolean | Indicates whether audience targeting is enabled for navigation links. Useful for personalizing site content visibility. | |
| NoCrawl | Boolean | Indicates whether the subsite is excluded from search indexing. Helps manage content visibility in search results. | |
| ObjectCacheEnabled | Boolean | Indicates whether object caching is enabled for the subsite. Helps improve site performance by reducing server load. | |
| OverwriteTranslationsOnChange | Boolean | Indicates whether translations should be overwritten when site content changes. Helps maintain language consistency. | |
| ResourcePath_DecodedUrl | String | The decoded URL of the subsite’s resource path. Useful for referencing site assets. | |
| QuickLaunchEnabled | Boolean | Indicates whether Quick Launch navigation is enabled for the subsite. Helps improve accessibility. | |
| RecycleBinEnabled | Boolean | Indicates whether the Recycle Bin is enabled for the subsite. Helps in restoring deleted items. | |
| SearchScope | Int | Specifies the search scope applied to the subsite. Helps control search indexing and filtering. | |
| ServerRelativeUrl | String | The URL of the subsite relative to the SharePoint server root. Useful for constructing internal references. | |
| SiteLogoUrl | String | The URL of the site logo used in the subsite. Helps maintain brand identity. | |
| SyndicationEnabled | Boolean | Indicates whether syndication is enabled for the subsite. Helps manage content sharing across multiple locations. | |
| TenantAdminMembersCanShare | Int | Defines the sharing permissions for tenant admin members. Helps control external and internal sharing policies. | |
| Title | String | The display name of the subsite. Useful for identification and navigation. | |
| TreeViewEnabled | Boolean | Indicates whether the tree view navigation is enabled. Helps users browse site hierarchies more easily. | |
| UIVersion | Int | Specifies the UI version of the subsite. Useful for determining whether the site is using a modern or classic experience. | |
| UIVersionConfigurationEnabled | Boolean | Indicates whether UI version configuration is enabled. Helps manage UI compatibility settings. | |
| Url | String | The full URL of the subsite. Useful for navigation and direct access. | |
| WebTemplate | String | The template used to create the subsite. Helps identify the site’s structure and functionality. | |
| WelcomePage | String | The URL of the default welcome page for the subsite. Helps control user landing pages. | |
| AccessRequestListUrl | String | The URL of the list where access requests are stored. Helps manage site access permissions. | |
| AccessRequestSiteDescription | String | The description provided when a user submits an access request. Helps inform site administrators about access needs. | |
| Acronym | String | The acronym associated with the subsite. Useful for quick identification in large organizations. | |
| AllowAutomaticASPXPageIndexing | Boolean | Indicates whether ASPX pages are automatically indexed. Helps control search visibility. | |
| AllowCreateDeclarativeWorkflowForCurrentUser | Boolean | Indicates whether the current user can create declarative workflows. Helps manage workflow automation permissions. | |
| AllowDesignerForCurrentUser | Boolean | Indicates whether the current user can use SharePoint Designer. Helps control site customization access. | |
| AllowMasterPageEditingForCurrentUser | Boolean | Indicates whether the current user can edit the master page. Useful for enforcing design consistency. | |
| AllowRevertFromTemplateForCurrentUser | Boolean | Indicates whether the user can revert the site to its original template. Helps manage template customizations. | |
| AllowSaveDeclarativeWorkflowAsTemplateForCurrentUser | Boolean | Indicates whether the current user can save workflows as templates. Useful for workflow standardization. | |
| AllowSavePublishDeclarativeWorkflowForCurrentUser | Boolean | Indicates whether the current user can save and publish declarative workflows. Helps control workflow deployment. | |
| CommentsOnSitePagesDisabled | Boolean | Indicates whether commenting is disabled on site pages. Useful for managing discussions and content moderation. | |
| ContainsConfidentialInfo | Boolean | Indicates whether the subsite contains confidential information. Helps enforce security policies. | |
| CustomSiteActionsDisabled | Boolean | Indicates whether custom site actions are disabled. Helps restrict site modifications. | |
| DefaultNewPageTemplateId | String | The identifier of the default template used when creating new pages. Helps standardize page creation. | |
| DescriptionForExistingLanguage | String | The description of the subsite in the current language. Useful for multilingual site management. | |
| DescriptionTranslations | String | A collection of translations for the site description. Helps support multilingual environments. | |
| DesignerDownloadUrlForCurrentUser | String | The URL where the current user can download SharePoint Designer. Useful for site customization access. | |
| DisableAppViews | Boolean | Indicates whether app views are disabled for the subsite. Helps restrict third-party app interactions. | |
| DisableFlows | Boolean | Indicates whether Power Automate flows are disabled for the subsite. Helps control automation and data integration. | |
| DisableRecommendedItems | Boolean | Indicates whether recommended items are disabled. Helps customize the user experience. | |
| EffectiveBasePermissions_High | Long | Defines the high-level base permissions assigned to the subsite. Helps enforce security policies. | |
| EffectiveBasePermissions_Low | Long | Defines the low-level base permissions assigned to the subsite. Useful for detailed permission management. | |
| ExcludeFromOfflineClient | Boolean | Indicates whether the subsite is excluded from offline synchronization. Helps control data access policies. | |
| HasWebTemplateExtension | Boolean | Indicates whether the subsite has an associated web template extension. Helps with template customization. | |
| IsEduClass | Boolean | Indicates whether the subsite is classified as an educational class site. Helps in school and academic environments. | |
| IsEduClassProvisionChecked | Boolean | Indicates whether provisioning for an education class has been checked. Helps track setup completion. | |
| IsEduClassProvisionPending | Boolean | Indicates whether provisioning for an education class is pending. Helps manage site activation. | |
| IsProvisioningComplete | Boolean | Indicates whether the site provisioning process is complete. Useful for tracking setup progress. | |
| LastItemModifiedDate | Datetime | The LastItemModifiedDate of the subsite. | |
| LastItemUserModifiedDate | Datetime | The LastItemUserModifiedDate of the subsite. | |
| LogoAlignment | Int | Specifies how the site logo is aligned. Helps customize branding appearance. | |
| NotificationsInOneDriveForBusinessEnabled | Boolean | Indicates whether notifications are enabled for OneDrive for Business in the subsite. Helps manage alerts for file changes. | |
| NotificationsInSharePointEnabled | Boolean | Indicates whether notifications are enabled in SharePoint. Helps keep users informed of updates. | |
| PrimaryColor | String | The primary color used in the subsite’s theme. Helps maintain branding consistency. | |
| RelatedHubSiteIds | String | A list of hub sites associated with the subsite. Useful for site navigation and content organization. | |
| RequestAccessEmail | String | The email address where access requests for the subsite are sent. Helps manage permission requests. | |
| SaveSiteAsTemplateEnabled | Boolean | Indicates whether the subsite can be saved as a template. Useful for site replication and standardization. | |
| SearchBoxInNavBar | Int | Defines the placement of the search box in the navigation bar. Helps improve search accessibility. | |
| SearchBoxPlaceholderText | String | The placeholder text displayed in the search box. Useful for guiding user searches. | |
| ServerRelativePath_DecodedUrl | String | The decoded server-relative URL of the subsite. Helps reference site locations. | |
| ShowUrlStructureForCurrentUser | Boolean | Indicates whether the site’s URL structure is visible to the current user. Helps with site navigation and debugging. | |
| SiteLogoDescription | String | A description of the site logo. Useful for accessibility and branding. | |
| SupportedUILanguageIds | String | A list of supported UI languages for the subsite. Helps enable multilingual support. | |
| TenantTagPolicyEnabled | Bit | Indicates whether tenant-wide tag policies are enforced on the subsite. Helps manage metadata governance. | |
| ThemeData | String | Stores theme-related data for the subsite. Useful for UI customization and branding. | |
| ThemedCssFolderUrl | String | The URL of the folder containing themed CSS files. Helps manage site styling. | |
| ThirdPartyMdmEnabled | Boolean | Indicates whether third-party mobile device management (MDM) is enabled. Helps enforce security policies. | |
| TitleForExistingLanguage | String | The title of the subsite in the currently selected language. Useful for multilingual environments. | |
| TitleTranslations | String | A collection of translated titles for the subsite. Helps support multilingual user experiences. | |
| WebTemplateConfiguration | String | Stores configuration settings for the subsite’s web template. Helps define site structure and behavior. | |
| WebTemplatesGalleryFirstRunEnabled | Boolean | Indicates whether the Web Templates Gallery is enabled on the first run. Helps manage template availability. | |
| WebTemplatesGalleryFirstRunComplete | Boolean | Indicates whether the Web Templates Gallery setup has been completed. Helps track template initialization. |