Blogposts
Retrieves detailed information about blog posts, including titles, authors, publication dates, and associated spaces.
Table Specific Information
Select
The connector will use the Confluence API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector. You can also search for Attachments using CQL (Confluence Query Language).
- Id supports the '=,!=,IN,NOT IN' comparisons.
- Type supports the '=,!=,IN,NOT IN' comparisons.
- Title supports the '=,!=,LIKE,NOT LIKE,IN,NOT IN' comparisons.
- SpaceKey supports the '=,!=,IN,NOT IN' comparisons.
- SpaceType supports the '=,!=,IN,NOT IN' comparisons.
- CreatedByUserName supports the '=,!=,IN,NOT IN' comparisons.
- CreatedDate supports the '=,!=,>,>=,<,<=' comparisons.
- LastUpdatedDatetime supports the '=,!=,>,>=,<,<=' comparisons.
For example, the following queries are processed server side:
SQL
SELECT * FROM Blogposts WHERE Id = '1234'
SELECT * FROM Blogposts WHERE Id IN ('1234', '2345')
SELECT * FROM Blogposts WHERE Id = '123458' AND Type = 'blogpost'
SELECT * FROM Blogposts WHERE CreatedDate <= '2019/03/29 15:00' AND Id IN ('1234', '2345')
Additionally Id, Type, Title, CreatedDate, CreatedByUserName, AND LastUpdatedDatetime columns can be used in the ORDER BY clause, as following:
SELECT * FROM Blogposts ORDER BY Id DESC SELECT * FROM Blogposts ORDER BY CreatedByUserName ASC
CQL
Note: Filtering with CQL has the highest priority and all the other filters except "Excerpt" will be ignored when CQL filter is present in the query.
SELECT * FROM Blogposts WHERE CQL = 'creator = currentUser() AND content = "1234" OR space.type = "global"'
Columns
| Name | Type | References | SupportedOperators | Description |
| Id [KEY] | String | =,!=,IN,NOT_IN | Unique identifier of the blog post within Confluence. Used to reference the post in related operations or queries. | |
| Type | String | =,!=,IN,NOT_IN | Specifies the content type, indicating that this record represents a blog post. | |
| Title | String | =,!=,IN,NOT_IN,LIKE | The title of the blog post as displayed in Confluence, used for identification and navigation. | |
| Status | String | Indicates the current publishing state of the blog post, such as current, draft, or archived. | ||
| SpaceKey | String |
Spaces.Key | =,!=,IN,NOT_IN | The unique key of the space in which the blog post is published. This links the content to its workspace. |
| SpaceType | String |
Spaces.Type | =,!=,IN,NOT_IN | Specifies the type of space that contains the blog post, such as global, team, or personal. |
| Position | String | Defines the placement or ordering of the blog post within the space or among other content items. | ||
| URL | String | The full URL that provides direct access to the blog post through the Confluence interface or API. | ||
| Excerpt | String | A short summary or preview of the blog post content, typically displayed in listings or search results. | ||
| IsLatest | Boolean | If the value is 'true', this record represents the latest published version of the blog post. If the value is 'false', it refers to a previous version. | ||
| CreatedByUserName | String | =,!=,IN,NOT_IN | The username of the user who originally created and published the blog post. | |
| CreatedByUserType | String | Specifies the type of user who created the blog post, such as internal user, external collaborator, or system account. | ||
| CreatedDate | Datetime | =,>,>=,<,<= | The date and time when the blog post was initially created and saved in Confluence. | |
| LastUpdatedDatetime | Datetime | =,>,>=,<,<= | The date and time when the blog post was last edited or updated. | |
| LastUpdatedMessage | String | The revision message or comment entered by the author when saving the most recent version. | ||
| LastUpdatedNumber | Integer | The version number associated with the latest update of the blog post. | ||
| LastUpdatedUserName | String | The username of the user who made the most recent update to the blog post. | ||
| LastUpdatedUserType | String | Indicates the type of user responsible for the latest update, such as internal, external, or system. | ||
| LastUpdatedIsMinorEdit | Boolean | If the value is 'true', the latest change was a minor edit that did not significantly alter the content. If the value is 'false', the edit was a major revision. | ||
| LastUpdatedIsHidden | Boolean | If the value is 'true', the latest version of the blog post is hidden from general visibility. If the value is 'false', it is publicly visible. | ||
| PreviousVersionUserName | String | The username of the user who created or modified the previous version of the blog post. | ||
| PreviousVersionUserType | String | Specifies the type of user who edited the previous version, such as internal user or automated process. | ||
| PreviousVersionDatetime | Datetime | The date and time when the previous version of the blog post was last modified. | ||
| PreviousVersionMessage | String | The revision message or note associated with the previous version of the blog post. | ||
| PreviousVersionNumber | String | The version number assigned to the previous revision of the blog post. | ||
| PreviousVersionIsMinorEdit | Boolean | If the value is 'true', the previous version was marked as a minor edit. If the value is 'false', it was a major revision. | ||
| PreviousVersionIsHidden | Boolean | If the value is 'true', the previous version of the blog post is hidden from visibility. If the value is 'false', it is viewable by users. | ||
| LinksEditui | String | The URL of the edit interface (EditUI) for the blog post, allowing direct modification from the Confluence editor. | ||
| LinksSelf | String | The self-referential API endpoint (Self link) for the blog post, used to retrieve its details programmatically. | ||
| LinksTinyui | String | The short link (TinyUI) version of the blog post URL, providing a concise format for sharing. | ||
| LinksWebui | String | The standard web interface URL (WebUI) of the blog post as viewed within the Confluence site. | ||
| ItemURL | String | The complete URL reference to the blog post as displayed in the user interface. | ||
| ContainerId | String | The identifier of the container, typically the space or content collection, that holds the blog post. | ||
| StorageBody | String | The full content of the blog post in Confluence Storage Format, which preserves rich text, macros, and formatting. |
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 | |
| CQL | String | Represents a Confluence Query Language (CQL) expression used to build structured queries for retrieving or filtering blog posts. |