ODBC Driver for Trello

Build 20.0.7587

Cards

Lists all the cards from every board

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: Closed column determines if the Card has been archived or not.

SELECT * FROM Cards

The query above will return all cards found regardless of whether they are archived or not.

SELECT * FROM Cards WHERE Closed='false'

The query above will return all the cards that are not archived.

SELECT * FROM Cards WHERE ListID='4e99eb7aa9797361bc22e6d5'

SELECT * FROM Cards WHERE BoardID='4e99eb7aa9797361bc22e6ct'

SELECT * FROM Cards WHERE Closed='true'
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.

Insert

To insert a new Card in table Cards you have to specify a Name and a ListId in the insert statement. Columns Name, Description, ListID, MemberIds, LabelIds and Due can be used for insert where ListId is. Columns MemberIds and LabelIds are comma separated list of member/label ids. Example of inserting a new Card:

INSERT INTO Cards(Name, Description, ListID, MemberIds, LabelIds, Due) VALUES('new Card', 'new card description', 'list_id', 'member_id_1, member_id_2', 'label_id_1,label_id_2', '2019-09-18')

Update

To execute an update to table Cards you have to specify the CardId you are trying to update. Columns Name, Description, ListID, MemberIds, LabelIds, Due and closed can be updated. Columns MemberIds and LabelIds are comma separated list of member/label ids. Example of updating all the fields:

UPDATE Cards SET Name='new name', Description='new description', ListID='listId', MemberIds='member_id_1,member_id_2', LabelIds='label_id_1,label_id_2', Due='2019-09-18' WHERE CardID='card_id'

To archive a card you can update its closed property to true for ex:

UPDATE Cards SET Closed='true' WHERE CardID='card_id'

Delete

To delete a card you must specify a CardID for ex:

DELETE FROM Cards WHERE CardID='card_id'

Columns

Name Type ReadOnly Description
CardID [KEY] String True

The Id of the card

Name String False

The name of the card

BoardID String True

The Id of the board which the card references

ListID String False

The Id of the list which the card references

MemberIds String False

The Ids of the members assigned to card

CheckListId String True

The Id of the checklist which the card references

LabelIds String False

The Ids of the labels assigned to card

CoverAttachmentId String True

The Id of the attachment on the cover of the card

Description String False

Description of the card

Closed Boolean False

Determines if the card is closed or not

Due Datetime False

This field returns the due time if it has been assigned to card

LastActivityDate Datetime True

AttachmentCount Int True

Number of total attachments in the card

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