JDBC Driver for Trello

Build 22.0.8462

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

CData JDBC Driver for Trello Views

Name Description
Actions Lists different actions made on Organization/Board/Card determined by type.
BoardPlugins Lists all plugins enabled for each board.
BoardPreferences Lists preferences of the boards.
Boards Lists all boards that are available to the user.
BoardStars Lists all the Boards that the user has starred.
CardAttachments Lists all the attachments of each card.
CardChecklists Lists all checklists that have been created.
CardLabels Lists all labels assigned to each card.
CardMembers Lists all members assigned to each card.
CardStickers Lists all stickers for each card.
CheckListItems Lists all items found on checklists.
Checklists Lists all checklists found on boards.
Enterprises Gets information about an enterprise.
Exports Lists all exports of the organizations.
Labels Lists all labels of the boards.
Lists Lists all the lists that have been created on boards.
Memberships Lists all members associated with the boards.
Notifications Lists all notifications of the user logged.
OrganizationPreferences Lists preferences of the boards.
Organizations Lists all organizations where the user is associated.
PluginData Get data from plugins that have been enabled on board.
Reactions Lists all Reactions made on the logged users Actions.
TokenPermissions Gets information about read and write permissions.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462