ODBC Driver for Trello

Build 20.0.7587

Boards

Lists all boards that are available to the user.

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 Boards

SELECT * FROM Boards WHERE Starred='true'

SELECT * FROM Boards WHERE OrganizationId='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'
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
BoardID [KEY] String The Id of the Board
Name String The name of the Board
Pinned Boolean Determines if Board is pinned or not
Starred Boolean Determines if Board is starred or not
Closed Boolean Determines if Board is archived or not
Url String Board Url
DateLastView Datetime Time when it board was last viewed
MemberID String References the member of the board
OrganizationID String References the organization of which the board is part of
MyCustomFieldName String My custom field.

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