Memberships
Lists all members associated with the boards.
Table Specific Information
Select
The connector will use the Trello API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. For example, the following query is processed server-side:
SELECT * FROM Memberships WHERE BoardId = '4e99eb7aa9797361bc22e6ct'
If BoardId is not present in the connection properties or in query, for example:
SELECT * FROM Membershipsall members from all boards will be returned,
otherwise if BoardId is specified:
SELECT * FROM Membershipswill return all members of the board.
Columns
Name | Type | ReadOnly | Description |
MemberId [KEY] | String | True |
The Id of the member. |
FullName | String | True |
The full name of the member. |
UserName | String | True |
The username of the member. |
OrganizationID | String | True |
The Id of the organization where the member is part of. |
BoardID [KEY] | String | True |
The Id of the board that the member is part of. |