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 | Unique GUID of the subsite (SP.Web.Id). | |
| Title | String | Display title of the subsite shown in navigation and the UI. | |
| Url | String | Absolute URL of the subsite (e.g., https://tenant.sharepoint.com/sites/parent/subsite). | |
| AccessRequestSiteDescription | String | Optional text shown on the access request page for this site. | |
| Acronym | String | Short name/acronym used for the site in certain experiences. | |
| AllowAutomaticASPXPageIndexing | Bool | Whether classic .aspx pages can be automatically added to search index. | |
| AllowCreateDeclarativeWorkflowForCurrentUser | Bool | Whether the current user can create declarative (no-code) workflows. | |
| AllowDesignerForCurrentUser | Bool | Whether the current user can open the site in SharePoint Designer. | |
| AllowMasterPageEditingForCurrentUser | Bool | Whether the current user can edit master pages for this site. | |
| AllowRevertFromTemplateForCurrentUser | Bool | Whether the current user can revert site changes applied from a template. | |
| AllowRssFeeds | Bool | Enables or disables RSS feeds at the site level. | |
| AllowSaveDeclarativeWorkflowAsTemplateForCurrentUser | Bool | Whether the current user can save a declarative workflow as a template. | |
| AllowSavePublishDeclarativeWorkflowForCurrentUser | Bool | Whether the current user can save and publish declarative workflows. | |
| AlternateCssUrl | String | Alternate CSS file URL for classic pages (if configured). | |
| AppInstanceId | String | App instance GUID associated with the site (if provisioned from an app). | |
| ClassicWelcomePage | String | Welcome page path used by classic experience. | |
| CommentsOnSitePagesDisabled | Bool | Turns modern page comments on or off for this site. | |
| Configuration | Int | Numeric template configuration (site definition configuration ID). | |
| ContainsConfidentialInfo | Bool | Indicates that the site may contain confidential information. | |
| Created | Datetime | Creation timestamp of the subsite. | |
| CurrentChangeToken_StringValue | String | Change token string identifying the latest change captured for this Web. | |
| CustomMasterUrl | String | Custom master page URL applied to the site (classic). | |
| CustomSiteActionsDisabled | Bool | Disables custom site actions in the UI when true. | |
| DefaultNewPageTemplateId | String | Default page template ID used when creating new modern pages. | |
| Description | String | Site description shown in some directory and UI contexts. | |
| DescriptionForExistingLanguage | String | Localized description for the current UI language. | |
| DesignerDownloadUrlForCurrentUser | String | Download URL for SharePoint Designer if available for the current user. | |
| DesignPackageId | String | Design package (WSP) identifier applied to this site (classic). | |
| DisableAppViews | Bool | Disables application-specific views within the site when true. | |
| DisableFlows | Bool | Disables Power Automate (Flow) integration for this site when true. | |
| DisableRecommendedItems | Bool | Turns off recommended content experiences for this site. | |
| DocumentLibraryCalloutOfficeWebAppPreviewersDisabled | Bool | Disables Office Web Apps document previewers in library callouts. | |
| EffectiveBasePermissions_High | Long | High 32 bits of the current user’s effective permission mask on the site. | |
| EffectiveBasePermissions_Low | Long | Low 32 bits of the current user’s effective permission mask on the site. | |
| EnableMinimalDownload | Bool | Enables the Minimal Download Strategy (MDS) for classic pages. | |
| ExcludeFromOfflineClient | Bool | Prevents site content from being made available to offline clients. | |
| FontOptionForSiteFooterNav_fontFace | String | Font face applied to the footer navigation (modern theming). | |
| FontOptionForSiteFooterNav_fontFamilyKey | String | Font family key used for footer navigation (modern). | |
| FontOptionForSiteFooterNav_fontVariantWeight | String | Variant/weight used for footer navigation font (modern). | |
| FontOptionForSiteFooterTitle_fontFace | String | Font face applied to footer titles (modern theming). | |
| FontOptionForSiteFooterTitle_fontFamilyKey | String | Font family key used for footer titles (modern). | |
| FontOptionForSiteFooterTitle_fontVariantWeight | String | Variant/weight used for footer title font (modern). | |
| FontOptionForSiteNav_fontFace | String | Font face applied to the site’s top navigation (modern). | |
| FontOptionForSiteNav_fontFamilyKey | String | Font family key used for site navigation (modern). | |
| FontOptionForSiteNav_fontVariantWeight | String | Variant/weight used for site navigation font (modern). | |
| FontOptionForSiteTitle_fontFace | String | Font face applied to the site title (modern header). | |
| FontOptionForSiteTitle_fontFamilyKey | String | Font family key used for the site title (modern). | |
| FontOptionForSiteTitle_fontVariantWeight | String | Variant/weight used for the site title font (modern). | |
| FooterAlignment | Int | Alignment setting for the modern site footer. | |
| FooterBlur | Int | Blur intensity for the modern footer background (if used). | |
| FooterColorIndexInDarkMode | Int | Theme color index applied to the footer in dark mode. | |
| FooterColorIndexInLightMode | Int | Theme color index applied to the footer in light mode. | |
| FooterEmphasis | Int | Emphasis level (weight) used by the modern footer. | |
| FooterEnabled | Bool | Enables the modern footer on the site. | |
| FooterLayout | Int | Layout option used by the modern footer. | |
| FooterOverlayColor | Int | Overlay color index applied to the footer background. | |
| FooterOverlayGradientDirection | Int | Gradient direction used by the footer overlay. | |
| FooterOverlayOpacity | Int | Opacity of the footer overlay layer. | |
| HasWebTemplateExtension | Bool | Indicates if a web template extension is present. | |
| HeaderColorIndexInDarkMode | Int | Theme color index applied to the header in dark mode. | |
| HeaderColorIndexInLightMode | Int | Theme color index applied to the header in light mode. | |
| HeaderEmphasis | Int | Emphasis level (weight) used by the modern header. | |
| HeaderLayout | Int | Layout option used by the modern header. | |
| HeaderOverlayColor | Int | Overlay color index applied to the header background. | |
| HeaderOverlayGradientDirection | Int | Gradient direction used by the header overlay. | |
| HeaderOverlayOpacity | Int | Opacity of the header overlay layer. | |
| HideTitleInHeader | Bool | Hides the site title in the modern header when true. | |
| HorizontalQuickLaunch | Bool | Uses horizontal quick launch navigation layout (classic). | |
| IsEduClass | Bool | Indicates the site is associated with an EDU Class experience. | |
| IsEduClassProvisionChecked | Bool | Marks whether EDU Class provisioning checks have completed. | |
| IsEduClassProvisionPending | Bool | Indicates EDU Class provisioning is pending. | |
| IsHomepageModernized | Bool | Indicates whether the site homepage has been modernized. | |
| IsMultilingual | Bool | Whether Multilingual UI (MUI) is enabled for the site. | |
| IsProvisioningComplete | Bool | Indicates the site provisioning process has completed. | |
| IsRevertHomepageLinkHidden | Bool | Hides the 'revert homepage' link for modernized sites. | |
| Language | Int | LCID for the site’s default UI language (e.g., 1033=en-US). | |
| LastItemModifiedDate | Datetime | Timestamp of the most recent item modification within the site. | |
| LastItemUserModifiedDate | Datetime | Timestamp of the most recent user-initiated item modification. | |
| LogoAlignment | Int | Alignment option for the site logo in the modern header. | |
| MasterUrl | String | Master page URL used by the site (classic master page). | |
| MegaMenuEnabled | Bool | Enables the modern mega menu-style navigation (where supported). | |
| MembersCanShare | Bool | Allows Members to share content with others when true. | |
| NavAudienceTargetingEnabled | Bool | Enables audience targeting for site navigation links. | |
| NextStepsFirstRunEnabled | Bool | Shows the 'Next steps' first-run experience to site owners. | |
| NoCrawl | Bool | If true, the site is excluded from search indexing and results. | |
| NotificationsInOneDriveForBusinessEnabled | Bool | Enables OneDrive for Business notifications related to this site. | |
| NotificationsInSharePointEnabled | Bool | Enables SharePoint notifications for site activities. | |
| ObjectCacheEnabled | Bool | Enables the object cache for classic publishing scenarios. | |
| OverwriteTranslationsOnChange | Bool | Overwrites alternate language translations when default text changes. | |
| PreviewFeaturesEnabled | Bool | Enables preview/early release features on this site (tenant-controlled). | |
| PrimaryColor | String | Primary brand color value applied by the current theme. | |
| QuickLaunchEnabled | Bool | Enables the left-hand (Quick Launch) navigation. | |
| RecycleBinEnabled | Bool | Whether the Recycle Bin feature is enabled for this site. | |
| RelatedHubSiteIds | String | List of hub site IDs related or associated with this site. | |
| ResourcePath_DecodedUrl | String | Decoded URL value of the resource path representing the site. | |
| SaveSiteAsTemplateEnabled | Bool | Allows saving the site as a template (classic feature) when true. | |
| SearchBoxInNavBar | Int | Placement/visibility option for the search box in the navbar. | |
| SearchBoxPlaceholderText | String | Custom placeholder text displayed in the navigation search box. | |
| SearchScope | Int | Default scope used when searching from this site’s UI. | |
| ServerRelativePath_DecodedUrl | String | Decoded server-relative path of the site (modern typed path). | |
| ServerRelativeUrl | String | Server-relative URL of the site (e.g., /sites/parent/subsite). | |
| ShowUrlStructureForCurrentUser | Bool | Lets the current user view URL/folder structure in the UI. | |
| SiteLogoDescription | String | Alt text/description for the site logo. | |
| SiteLogoUrl | String | URL of the site logo image. | |
| SupportedUILanguageIds | String | Collection of LCIDs for languages enabled for the site’s UI (MUI). | |
| SyndicationEnabled | Bool | Enables RSS syndication for the site when true. | |
| TenantAdminMembersCanShare | Int | Tenant policy value controlling whether Members can share. | |
| TenantTagPolicyEnabled | Bool | Indicates whether tenant tag policy is enforced for this site. | |
| ThemeApplicationActionHistory | String | History log of theme application actions on the site. | |
| ThemeData | String | Serialized theme data applied to the site. | |
| ThemedCssFolderUrl | String | Folder URL where themed CSS is stored for the site. | |
| ThirdPartyMdmEnabled | Bool | Enables 3rd-party mobile device management integration. | |
| TitleForExistingLanguage | String | Localized title for the current UI language. | |
| TreeViewEnabled | Bool | Shows the Tree View (classic) for navigation when true. | |
| UIVersion | Int | UI version number (classic UI versioning setting). | |
| UIVersionConfigurationEnabled | Bool | Allows configuration of the classic UI version when true. | |
| WebTemplate | String | Template name used to provision the site (e.g., STS). | |
| WebTemplateConfiguration | String | Template configuration value paired with WebTemplate (site definition config ID). | |
| WebTemplatesGalleryFirstRunEnabled | Bool | Shows the Web Templates gallery first-run experience when true. | |
| WelcomePage | String | Relative URL of the welcome/home page (classic experience). | |
| AccessRequestListUrl | String | URL of the list that stores access requests for this site. | |
| RequestAccessEmail | String | Email address used to receive access requests. | |
| UseAccessRequestDefault | Bool | Uses the default access request behavior when true. | |
| DescriptionTranslations | String | Localized resource entries for the site description. | |
| TitleTranslations | String | Localized resource entries for the site title. |