GroupMembers
Retrieves all users belonging to a specified group, including their display names and account details.
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.
- Name supports the '=' comparisons.
For example, the following queries are processed server side:
SELECT * FROM GroupMembers WHERE Name = 'test1'
Columns
| Name | Type | References | SupportedOperators | Description |
| AccountId | String | The unique account identifier of the user who is a member of the group. | ||
| AccountType | String | Specifies the type of user account, such as internal, external, or system. | ||
| DisplayName | String | The display name of the user as it appears in Confluence: in mentions, comments, or activity feeds. | ||
| String | The email address associated with the user's Confluence account. | |||
| PublicName | String | The public name or nickname of the user, shown in areas where privacy settings restrict full display names. | ||
| ProfilePicturePath | String | The file path or URL that points to the user's profile picture within Confluence. | ||
| ProfilePictureWidth | Int | The width, in pixels, of the user's profile picture. | ||
| ProfilePictureHeight | Int | The height, in pixels, of the user's profile picture. | ||
| ProfilePictureIsDefault | Boolean | If the value is 'true', the profile picture is the default system image and has not been changed by the user. If the value is 'false', the user has uploaded a custom profile picture. | ||
| Operations | String | Describes available operations and the target entities they apply to, indicating possible actions for the user within the group context. | ||
| Type | String | Defines the type of user, such as standard user, administrator, or external collaborator. | ||
| GroupId | String | = | The unique identifier of the Confluence group that the user belongs to. | |
| Name | String | = | The name of the group to which these members are assigned. |