TDV Adapter for Confluence

Build 22.0.8462

Contributors

Get information about the users who have contributed to the content.

Table Specific Information

Select

The adapter 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 adapter.

Note: ContentId is required in order to query the Contributors view.

  • ContentId supports the '=,!=,IN,NOT IN' comparisons.
  • AccountId 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! = '12345678'

SELECT * FROM Contributors WHERE AccountId IN ('12345678','23456789')

SELECT * FROM Contributors WHERE AccountId NOT IN ('12345678','23456789')

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 This is the Id of the content that support labels. This can be referenced from Attachments.Id, Pages.Id, Comments.Id or Blogposts.Id.
UserType String Type of the contributor.
AccountId String =,!=,IN,NOT IN Unique account Id of the contributor. NOTE: This column is exclusive to Confluence Cloud.
UserName String =,!=,IN,NOT IN Unique user key of the contributor. NOTE: This column is exclusive to Confluence Server.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462