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
StartDate	Datetime	True	The start date of a card!