PageContents
Get content from the page.
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 Id of the page content. | ||
| ExpandableAncestors | String | The ExpandableAncestors of the page content. | ||
| ExpandableChildren | String | The ExpandableChildren of the page content. | ||
| ExpandableChildTypes | String | The ExpandableChildTypes of the page content. | ||
| ExpandableContainer | String | The ExpandableContainer of the page content. | ||
| ExpandableDescendants | String | The ExpandableDescendants of the page content. | ||
| ExpandableHistory | String | The ExpandableHistory of the page content. | ||
| ExpandableMetadata | String | The ExpandableMetadata of the page content. | ||
| ExpandableOperations | String | The ExpandableOperations of the page content. | ||
| ExpandableRestrictions | String | The ExpandableRestrictions of the page content. | ||
| ExpandableSchedulePublishDate | Datetime | The ExpandableSchedulePublishDate of the page content. | ||
| ExpandableSpace | String | The ExpandableSpace of the page content. | ||
| ExpandableVersion | String | The ExpandableVersion of the page content. | ||
| LinksBase | String | The LinksBase of the page content. | ||
| LinksCollection | String | The LinksCollection of the page content. | ||
| LinksContext | String | The LinksContext of the page content. | ||
| LinksEditui | String | The LinksEditui of the page content. | ||
| LinksSelf | String | The LinksSelf of the page content. | ||
| LinksTinyui | String | The LinksTinyui of the page content. | ||
| LinksWebui | String | The LinksWebui of the page content. | ||
| BodyExpandableAnonymousExportView | String | The BodyExpandableAnonymousExportView of the page content. | ||
| BodyExpandableAtlasDocFormat | String | The BodyExpandableAtlasDocFormat of the page content. | ||
| BodyExpandableDynamic | String | The BodyExpandableDynamic of the page content. | ||
| BodyExpandableEditor | String | The BodyExpandableEditor of the page content. | ||
| BodyExpandableEditor2 | String | The BodyExpandableEditor2 of the page content. | ||
| BodyExpandableExportView | String | The BodyExpandableExportView of the page content. | ||
| BodyExpandableStyledView | String | The BodyExpandableStyledView of the page content. | ||
| BodyExpandableView | String | The BodyExpandableView of the page content. | ||
| BodyStorageExpandableContent | String | The BodyStorageExpandableContent of the page content. | ||
| BodyStorageEmbeddedContent | String | The BodyStorageEmbeddedContent of the page content. | ||
| BodyStorageRepresentation | String | The BodyStorageRepresentation of the page content. | ||
| BodyStorageValue | String | The BodyStorageValue of the page content. | ||
| ExtensionsPosition | String | The ExtensionsPosition of the page content. | ||
| Status | String | The Status of the page content. | ||
| Title | String | The Title of the page content. | ||
| Type | String | The Type of the page content. | ||
| PageId | String |
Pages.Id | =,!=,IN,NOT IN | The Id of the page. |