SSIS Components for Trello

Build 24.0.9062

Boards

Lists all boards that are available to the user.

Table Specific Information

Select

The 本製品 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 WHERE OrganizationId = '583558863c5859587053200c'

SELECT * FROM Boards WHERE BoardId = '583558863c5859587053200c'

SELECT * FROM Boards WHERE MemberId = '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'

Columns

Name Type ReadOnly Description
BoardID [KEY] String True

The Id of the Board

Name String True

The name of the Board.

Description String True

The description of the board.

Pinned Boolean True

Determines if Board is pinned or not.

Starred Boolean True

Determines if Board is starred or not.

Closed Boolean True

Determines if Board is archived or not.

Url String True

Board Url.

Subscribed Boolean True

Indicates if the user is subscribed to the board.

DateLastActivity Datetime True

Timestamp of the most recent activity on the board.

DateLastView Datetime True

Time when it board was last viewed.

CreationMethod String True

Indicates how the board was created.

MemberID String True

References the member of the board.

OrganizationID String True

References the organization of which the board is part of.

EnterpriseOwned Boolean True

Determines if the board is enterprise owned.

PermissionLevel String True

Permission level of the board (private, organization, public).

HideVotes Boolean True

Determines if votes can be shown or not.

Voting String True

Determines if voting is allowed.

Comments String True

Determines the user level which can comment.

Invitations String True

Determines the user level which can invite.

SelfJoin Boolean True

Determines if self join is enabled.

IsTemplate Boolean True

Determines if the board is a template.

CardCovers Boolean True

Determines if cards should have covers or not.

CardAging String True

Determines what style the cards will get if they stay for too long in a list.

CalendarFeedEnabled Boolean True

Determines if the calendar feed is enabled.

Background String True

Background color.

BackgroundImage String True

Background image.

BackgroundImageScaled String True

Background image.

BackgroundTile String True

Background tile.

BackgroundBrightness String True

Background brightness.

BackgroundColor String True

Background color.

BackgroundBottomColor String True

Bottom background color.

BackgroundTopColor String True

Top background color.

CanBePublic Boolean True

Determines if the board can be public.

CanBeEnterprise Boolean True

Determines if the board can be enterprise.

CanBeOrg Boolean True

Determines if the board can be an organization.

CanBePrivate Boolean True

Determines if the board can be private.

CanInvite Boolean True

Determines if invitations are enabled.

MyCustomFieldName String True

A JSON aggregates value containing the custom fields of the board. To retrieve these, IncludeCustomFields property must be enabled and a BoardId must be specified.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062