ODBC Driver for Trello

Build 20.0.7587

Memberships

Lists all members associated with the boards.

Table Specific Information

Select

The driver 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

SELECT * FROM Memberships WHERE BoardId='4e99eb7aa9797361bc22e6ct'

If BoardId and OrganizationId are not present in the connection properties or in query ( for example,

SELECT * FROM Memberships
) all members from all boards will be returned,

otherwise if BoardId is specified,

SELECT * FROM Memberships
will return all members of the board.

If OrganizationId is specified,

SELECT * FROM Memberships
will return all members of the organization.

If both properties are present,

SELECT * FROM Memberships
will return all members of the organization.

You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type Description
MemberId [KEY] String The Id of the member.
FullName String The full name of the member.
UserName String The username of the member.
OrganizationID [KEY] String The Id of the organization where the member is part of.
BoardID [KEY] String The Id of the board that the member is part of.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587