Contributors
Lists the users who have contributed to a specific page or space, providing insight into collaboration and content ownership.
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.
Note: Either ContentId, AccountId or ContentType must be specified in order to query the Contributors view.
- ContentId supports the '=,!=,IN,NOT IN' comparisons.
- AccountId supports the '=,IN' comparisons.
- ContentType supports the '=,!=,IN,NOT IN' comparisons.
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')
Additionally, ContentId column can be used in the ORDER BY clause, as following:
SELECT * FROM Contributors ORDER BY ContentId DESC
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. |