Contributors
Lists the users who have contributed to a specific page or space, providing insight into collaboration and content ownership.
View-Specific Information
Select
The connector uses the Confluence API to process WHERE clause conditions that are built with the following columns and operators:
- ContentId supports the =, !=, IN, NOT IN operators.
- AccountId supports the =, IN operators.
- ContentType supports the =, !=, IN, NOT IN operators.
For example, the following queries are processed server-side:
SELECT * FROM Contributors WHERE ContentId = '1234'
SELECT * FROM Contributors WHERE ContentId != '1234'
SELECT * FROM Contributors WHERE ContentId IN ('1234', '2345')
SELECT * FROM Contributors WHERE ContentId NOT IN ('1234', '2345')
SELECT * FROM Contributors WHERE AccountId = '12345678'
SELECT * FROM Contributors WHERE AccountId IN ('12345678', '23456789')
SELECT * FROM Contributors WHERE ContentType = 'page'
SELECT * FROM Contributors WHERE ContentType != 'page'
SELECT * FROM Contributors WHERE ContentType IN ('page', 'attachment')
SELECT * FROM Contributors WHERE ContentType NOT IN ('page', 'attachment')
The ContentId column can also be used in the ORDER BY clause. For example:
SELECT * FROM Contributors ORDER BY ContentId DESC
The connector processes other filters client-side.
Note: To query the Contributors view, you must specify either ContentId, AccountId, or ContentType.
Columns
| Name | Type | References | SupportedOperators | Description |
| ContentId [KEY] | String | =,!=,IN,NOT_IN | The unique identifier of the content item that supports contributions, such as a page, blog post, comment, or attachment. This value corresponds to the 'Id' field in related tables like Attachments, Pages, Comments, or Blogposts. | |
| ContentType | String | =,!=,IN,NOT_IN | Specifies the type of content to which the contributor has added input, for example page, comment, or blog post. | |
| UserType | String | Indicates the type of user who contributed, such as internal user, external collaborator, or system account. | ||
| AccountId [KEY] | String | =,IN | The unique account identifier of the contributor, used to link the user to their contributions across Confluence content. |