Boards
Lists all boards that are available to the user.
Table Specific Information
Select
The add-in 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 Boards WHERE OrganizationId = '583558863c5859587053200c' SELECT * FROM Boards WHERE BoardId = '583558863c5859587053200c' SELECT * FROM Boards WHERE MemberId = '583558863c5859587053200c'
We can retrieve public Trello Boards by providing their Id directly to the query. You can try the query below, which tries to retrieve data from the following board https://trello.com/board/trello-development/4d5ea62fd76aa1136000000c
To get the Id of a public board, append ".json" to the board URL ( https://trello.com/b/rq2mYJNn/public-trello-boards.json for example ) and you will see something like "{"id":"4e99eb7aa9797361bc22e6ce", ...". Take that id and use it in a query.
SELECT * FROM Boards WHERE BoardId = '4d5ea62fd76aa1136000000c'
Columns
| Name | Type | ReadOnly | Description |
| BoardID [KEY] | String | False |
The Id of the Board |
| Name | String | False |
The name of the Board. |
| Description | String | False |
The description of the board. |
| Pinned | Boolean | False |
Determines if Board is pinned or not. |
| Starred | Boolean | False |
Determines if Board is starred or not. |
| Closed | Boolean | False |
Determines if Board is archived or not. |
| Url | String | False |
Board Url. |
| Subscribed | Boolean | False |
Indicates if the user is subscribed to the board. |
| DateLastActivity | Datetime | False |
Timestamp of the most recent activity on the board. |
| DateLastView | Datetime | False |
Time when it board was last viewed. |
| CreationMethod | String | False |
Indicates how the board was created. |
| MemberID | String | False |
References the member of the board. |
| OrganizationID | String | False |
References the organization of which the board is part of. |
| EnterpriseOwned | Boolean | False |
Determines if the board is enterprise owned. |
| PermissionLevel | String | False |
Permission level of the board (private, organization, public). |
| HideVotes | Boolean | False |
Determines if votes can be shown or not. |
| Voting | String | False |
Determines if voting is allowed. |
| Comments | String | False |
Determines the user level which can comment. |
| Invitations | String | False |
Determines the user level which can invite. |
| SelfJoin | Boolean | False |
Determines if self join is enabled. |
| IsTemplate | Boolean | False |
Determines if the board is a template. |
| CardCovers | Boolean | False |
Determines if cards should have covers or not. |
| CardAging | String | False |
Determines what style the cards will get if they stay for too long in a list. |
| CalendarFeedEnabled | Boolean | False |
Determines if the calendar feed is enabled. |
| Background | String | False |
Background color. |
| BackgroundImage | String | False |
Background image. |
| BackgroundImageScaled | String | False |
Background image. |
| BackgroundTile | String | False |
Background tile. |
| BackgroundBrightness | String | False |
Background brightness. |
| BackgroundColor | String | False |
Background color. |
| BackgroundBottomColor | String | False |
Bottom background color. |
| BackgroundTopColor | String | False |
Top background color. |
| CanBePublic | Boolean | False |
Determines if the board can be public. |
| CanBeEnterprise | Boolean | False |
Determines if the board can be enterprise. |
| CanBeOrg | Boolean | False |
Determines if the board can be an organization. |
| CanBePrivate | Boolean | False |
Determines if the board can be private. |
| CanInvite | Boolean | False |
Determines if invitations are enabled. |
| MyCustomFieldName | String | False |
A JSON aggregates value containing the custom fields of the board. To retrieve these, IncludeCustomFields property must be enabled and a BoardId must be specified. |