SSIS Components for Trello

Build 21.0.8137

Checklists

Lists all checklists found on boards.

Table Specific Information

Select

The {i 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 CheckLists

SELECT * FROM CheckLists WHERE CardId='58e34da8446e578ac1bbb03b'

SELECT * FROM CheckLists WHERE BoardID='58e2018031e2b8e881b89b4g'
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
ChecklistId [KEY] String The Id of the checklist.
Name String The name of the checklist.
CardID String The Id of the card with the checklist.
BoardID String The Id of the board referencing the card with the checklist

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137