Excel Add-In for Microsoft SharePoint

Build 24.0.8963

Subsites

This lists the available subsites.

Table Specific Information

Select


SELECT * FROM Subsites

Columns

Name Type References Description
Id [KEY] String The Id of the subsite.
AllowRssFeeds Boolean The AllowRssFeeds of the subsite.
AlternateCssUrl String The AlternateCssUrl of the subsite.
AppInstanceId String The AppInstanceId of the subsite.
ClassicWelcomePage String The ClassicWelcomePage of the subsite.
Configuration Int The Configuration of the subsite.
Created Datetime The Created of the subsite.
CurrentChangeToken_StringValue String The CurrentChangeToken_StringValue of the subsite.
CustomMasterUrl String The CustomMasterUrl of the subsite.
Description String The Description of the subsite.
DesignPackageId String The DesignPackageId of the subsite.
DocumentLibraryCalloutOfficeWebAppPreviewersDisabled Boolean The DocumentLibraryCalloutOfficeWebAppPreviewersDisabled of the subsite.
EnableMinimalDownload Boolean The EnableMinimalDownload of the subsite.
FooterEmphasis Int The FooterEmphasis of the subsite.
FooterEnabled Boolean The FooterEnabled of the subsite.
FooterLayout Int The FooterLayout of the subsite.
HeaderEmphasis Int The HeaderEmphasis of the subsite.
HeaderLayout Int The HeaderLayout of the subsite.
HideTitleInHeader Boolean The HideTitleInHeader of the subsite.
HorizontalQuickLaunch Boolean The HorizontalQuickLaunch of the subsite.
IsHomepageModernized Boolean The IsHomepageModernized of the subsite.
IsMultilingual Boolean The IsMultilingual of the subsite.
IsRevertHomepageLinkHidden Boolean The IsRevertHomepageLinkHidden of the subsite.
Language Int The Language of the subsite.
LastItemModifiedDate Datetime The LastItemModifiedDate of the subsite.
LastItemUserModifiedDate Datetime The LastItemUserModifiedDate of the subsite.
LogoAlignment Int The LogoAlignment of the subsite.
MasterUrl String The MasterUrl of the subsite.
MegaMenuEnabled Boolean The MegaMenuEnabled of the subsite.
NavAudienceTargetingEnabled Boolean The NavAudienceTargetingEnabled of the subsite.
NoCrawl Boolean The NoCrawl of the subsite.
ObjectCacheEnabled Boolean The ObjectCacheEnabled of the subsite.
OverwriteTranslationsOnChange Boolean The OverwriteTranslationsOnChange of the subsite.
ResourcePath_DecodedUrl String The ResourcePath_DecodedUrl of the subsite.
QuickLaunchEnabled Boolean The QuickLaunchEnabled of the subsite.
RecycleBinEnabled Boolean The RecycleBinEnabled of the subsite.
SearchScope Int The SearchScope of the subsite.
ServerRelativeUrl String The ServerRelativeUrl of the subsite.
SiteLogoUrl String The SiteLogoUrl of the subsite.
SyndicationEnabled Boolean The SyndicationEnabled of the subsite.
TenantAdminMembersCanShare Int The TenantAdminMembersCanShare of the subsite.
Title String The Title of the subsite.
TreeViewEnabled Boolean The TreeViewEnabled of the subsite.
UIVersion Int The UIVersion of the subsite.
UIVersionConfigurationEnabled Boolean The UIVersionConfigurationEnabled of the subsite.
Url String The Url of the subsite.
WebTemplate String The WebTemplate of the subsite.
WelcomePage String The WelcomePage of the subsite.
AccessRequestListUrl String The AccessRequestListUrl of the subsite.
AccessRequestSiteDescription String The AccessRequestSiteDescription of the subsite.
Acronym String The Acronym of the subsite.
AllowAutomaticASPXPageIndexing Boolean The AllowAutomaticASPXPageIndexing of the subsite.
AllowCreateDeclarativeWorkflowForCurrentUser Boolean The AllowCreateDeclarativeWorkflowForCurrentUser of the subsite.
AllowDesignerForCurrentUser Boolean The AllowDesignerForCurrentUser of the subsite.
AllowMasterPageEditingForCurrentUser Boolean The AllowMasterPageEditingForCurrentUser of the subsite.
AllowRevertFromTemplateForCurrentUser Boolean The AllowRevertFromTemplateForCurrentUser of the subsite.
AllowSaveDeclarativeWorkflowAsTemplateForCurrentUser Boolean The AllowSaveDeclarativeWorkflowAsTemplateForCurrentUser of the subsite.
AllowSavePublishDeclarativeWorkflowForCurrentUser Boolean The AllowSavePublishDeclarativeWorkflowForCurrentUser of the subsite.
CommentsOnSitePagesDisabled Boolean The CommentsOnSitePagesDisabled of the subsite.
ContainsConfidentialInfo Boolean The ContainsConfidentialInfo of the subsite.
CustomSiteActionsDisabled Boolean The CustomSiteActionsDisabled of the subsite.
DefaultNewPageTemplateId String The DefaultNewPageTemplateId of the subsite.
DescriptionForExistingLanguage String The DescriptionForExistingLanguage of the subsite.
DescriptionTranslations String The DescriptionTranslations of the subsite.
DesignerDownloadUrlForCurrentUser String The DesignerDownloadUrlForCurrentUser of the subsite.
DisableAppViews Boolean The DisableAppViews of the subsite.
DisableFlows Boolean The DisableFlows of the subsite.
DisableRecommendedItems Boolean The DisableRecommendedItems of the subsite.
EffectiveBasePermissions_High Long The EffectiveBasePermissions_High of the subsite.
EffectiveBasePermissions_Low Long The EffectiveBasePermissions_Low of the subsite.
ExcludeFromOfflineClient Boolean The ExcludeFromOfflineClient of the subsite.
HasWebTemplateExtension Boolean The HasWebTemplateExtension of the subsite.
IsEduClass Boolean The IsEduClass of the subsite.
IsEduClassProvisionChecked Boolean The IsEduClassProvisionChecked of the subsite.
IsEduClassProvisionPending Boolean The IsEduClassProvisionPending of the subsite.
IsProvisioningComplete Boolean The IsProvisioningComplete of the subsite.
LastItemModifiedDate Datetime The LastItemModifiedDate of the subsite.
LastItemUserModifiedDate Datetime The LastItemUserModifiedDate of the subsite.
LogoAlignment Int The LogoAlignment of the subsite.
NotificationsInOneDriveForBusinessEnabled Boolean The NotificationsInOneDriveForBusinessEnabled of the subsite.
NotificationsInSharePointEnabled Boolean The NotificationsInSharePointEnabled of the subsite.
PrimaryColor String The PrimaryColor of the subsite.
RelatedHubSiteIds String The RelatedHubSiteIds of the subsite.
RequestAccessEmail String The RequestAccessEmail of the subsite.
SaveSiteAsTemplateEnabled Boolean The SaveSiteAsTemplateEnabled of the subsite.
SearchBoxInNavBar Int The SearchBoxInNavBar of the subsite.
SearchBoxPlaceholderText String The SearchBoxPlaceholderText of the subsite.
ServerRelativePath_DecodedUrl String The ServerRelativePath_DecodedUrl of the subsite.
ShowUrlStructureForCurrentUser Boolean The ShowUrlStructureForCurrentUser of the subsite.
SiteLogoDescription String The SiteLogoDescription of the subsite.
SupportedUILanguageIds String The SupportedUILanguageIds of the subsite.
TenantTagPolicyEnabled Bit The TenantTagPolicyEnabled of the subsite.
ThemeData String The ThemeData of the subsite.
ThemedCssFolderUrl String The ThemedCssFolderUrl of the subsite.
ThirdPartyMdmEnabled Boolean The ThirdPartyMdmEnabled of the subsite.
TitleForExistingLanguage String The TitleForExistingLanguage of the subsite.
TitleTranslations String The TitleTranslations of the subsite.
WebTemplateConfiguration String The WebTemplateConfiguration of the subsite.
WebTemplatesGalleryFirstRunEnabled Boolean The WebTemplatesGalleryFirstRunEnabled of the subsite.
WebTemplatesGalleryFirstRunComplete Boolean The WebTemplatesGalleryFirstRunComplete of the subsite.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963