AllPages
Presents a comprehensive collection of SharePoint site pages, providing details about content, layout, creation information, permissions, and associated metadata for effective page management.
Columns
| Name | Type | References | Description |
| SiteURL [KEY] | String |
Sites.SiteURL | The base URL of the SharePoint site that hosts the Wiki Page list. |
| PageListId [KEY] | String | The unique identifier of the Wiki Page list (library) that contains the Wiki pages. | |
| PageId [KEY] | Int | The unique identifier for the Wiki Page item. | |
| Name | String | The file name of the Wiki page item, as stored in SharePoint. | |
| Title | String | The display title of the Wiki page item. | |
| FileSize | String | The display string representing the file size of the Wiki page item. | |
| FileType | String | The file type or extension of the Wiki page item. | |
| ItemType | Int | Specifies the type of SharePoint item. Enumerated values: 0 = File, 1 = Folder. | |
| PageLayoutType | String | Specifies the layout type for the Wiki page, determining its design and structure. | |
| PrincipalCount | String | The number of principals (users or groups) associated with the page item's permissions. | |
| EncodedAbsoluteURL | String | The fully encoded URL used to access the Wiki page item. | |
| ServerRelativeURL | String | The server-relative URL path to the Wiki page item. | |
| Path | String | The server file path where the Wiki page item is stored within SharePoint. | |
| ContentTypeID | String | The unique identifier for the content type applied to the Wiki page item. | |
| PromotedState | Double | Specifies the promoted state of the Wiki page. Enumerated values: 0 = Regular page (not promoted), 2 = Promoted page (such as featured or news page). | |
| EffectivePermissionsMask | String | A permissions mask representing the effective rights of the current user for this Wiki page item. | |
| CreatedBy | String | Display name of the user who created the document associated with the Wiki page item. | |
| CreatedById | Int | Identifier of the user who created the Wiki page item. | |
| ModifiedBy | String | Display name of the user who last modified the document associated with the Wiki page item. | |
| ModifiedById | Int | Identifier of the user who last modified the Wiki page item. | |
| Created | Datetime | The date and time when the Wiki page item was created. | |
| Modified | Datetime | The date and time when the Wiki page item was last modified. | |
| Description | String | A brief description or summary of the Wiki page content. | |
| BannerImageDescription | String | Descriptive text associated with the banner image of the Wiki page item. | |
| BannerImageURL | String | The URL for the banner image associated with the Wiki page item. | |
| GUID | String | The globally unique identifier (GUID) for the Wiki page item. | |
| UniqueId | String | A read-only globally unique identifier distinct from the GUID for the Wiki page item. | |
| PageLayoutContent | String | The XML or HTML defining the layout and web parts of the Wiki page. | |
| AuthoringCanvasContent | String | The content and configuration of the authoring canvas, detailing web part arrangements for the Wiki page. | |
| WikiContent | String | The main textual content of the Wiki page, typically written in Wiki markup or HTML. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ItemCount | Int | The filter that is propagated to the AllLists view. |