PageContents
Provides access to the textual and metadata content of a Confluence page, including version and author information.
Table Specific Information
Select
The connector 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. |