PageContents
Provides access to the textual and metadata content of a Confluence page, including version and author information.
Table Specific Information
Select
The add-in will use the Confluence API to process WHERE clause conditions built with the following column and operator.
Note: PageId is required in order to query the PageContents view.
- PageId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PageContents WHERE PageId = '163902'
SELECT * FROM PageContents WHERE PageId IN ('163902', '33106')
Columns
| Name | Type | References | SupportedOperators | Description |
| Id [KEY] | String | The unique identifier of the page content within Confluence. | ||
| ExpandableAncestors | String | Provides a link to the expandable list of ancestor pages, allowing retrieval of hierarchical context above the current page. | ||
| ExpandableChildren | String | Links to child content items associated with the page, such as subpages or embedded components. | ||
| ExpandableChildTypes | String | Specifies the types of child content that can exist under this page, for example page, comment, or attachment. | ||
| ExpandableContainer | String | Provides a link to the container element that holds this page, typically a space or parent page. | ||
| ExpandableDescendants | String | Links to all descendant content items that can be expanded from this page, showing the complete hierarchy below it. | ||
| ExpandableHistory | String | Links to the historical versions of the page, allowing retrieval of revision data, authors, and timestamps. | ||
| ExpandableMetadata | String | Links to the expandable metadata section, which includes labels, properties, and other contextual information. | ||
| ExpandableOperations | String | Lists available operations that can be performed on the page, such as view, edit, or delete. | ||
| ExpandableRestrictions | String | Links to the access restrictions applied to the page, defining user and group permissions. | ||
| ExpandableSchedulePublishDate | Datetime | Specifies the date and time when the page is scheduled for publication, if applicable. | ||
| ExpandableSpace | String | Provides a link to the space containing the page, allowing retrieval of related space-level details. | ||
| ExpandableVersion | String | Links to version information for the page, including version numbers, authors, and modification data. | ||
| LinksBase | String | The base API URL used as a reference point for the page's linked resources. | ||
| LinksCollection | String | Provides a link to the collection of related content items, such as pages within the same space. | ||
| LinksContext | String | Defines the contextual relationship of the page within Confluence, including references to its environment or parent container. | ||
| LinksEditui | String | The URL of the edit interface (EditUI) for the page, allowing direct access to the page editor. | ||
| LinksSelf | String | The self-referential API endpoint (Self link) for the page, used for direct retrieval via the Confluence API. | ||
| LinksTinyui | String | The short link (TinyUI) version of the page's URL, providing a compact, shareable format. | ||
| LinksWebui | String | The standard web interface URL (WebUI) of the page as accessed through the Confluence site. | ||
| BodyExpandableAnonymousExportView | String | Provides access to the anonymous export view of the page body, allowing public export without authentication. | ||
| BodyExpandableAtlasDocFormat | String | Links to the Atlas Document Format (ADF) representation of the page body, used for rich text and structured data rendering. | ||
| BodyExpandableDynamic | String | Provides a link to dynamically rendered sections of the page body, allowing runtime expansion of embedded content. | ||
| BodyExpandableEditor | String | Links to the editable representation of the page body as used in the Confluence editor. | ||
| BodyExpandableEditor2 | String | Provides a link to an alternate editor format of the page body, typically used for newer Confluence editor versions. | ||
| BodyExpandableExportView | String | Links to the export view of the page body, suitable for use in external formats or exports. | ||
| BodyExpandableStyledView | String | Provides access to the styled view of the page body, displaying formatted content as seen in the Confluence UI. | ||
| BodyExpandableView | String | Links to the view representation of the page body used for display in standard Confluence views. | ||
| BodyStorageExpandableContent | String | Provides access to the underlying storage content of the page body, including macros and embedded objects. | ||
| BodyStorageEmbeddedContent | String | Links to any embedded resources or files within the page's storage format. | ||
| BodyStorageRepresentation | String | Specifies the format used to represent the page body in storage, such as storage or view. | ||
| BodyStorageValue | String | Contains the actual content of the page body in Confluence Storage Format, including rich text and markup. | ||
| ExtensionsPosition | String | Indicates the position of the page within its parent hierarchy, defining its order among sibling content. | ||
| Status | String | Indicates the current status of the page, such as current, draft, or archived. | ||
| Title | String | The title of the page as displayed in Confluence. | ||
| Type | String | Specifies the content type, indicating that this record represents a page. | ||
| PageId | String |
Pages.Id | =,!=,IN,NOT_IN | The unique identifier of the page whose content is being retrieved. |