SSIS Components for Trello

Build 24.0.9062

Actions

Lists different actions made on Organization/Board/Card determined by type.

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 queries are processed server-side: Actions differ from each other from their type.

SELECT * FROM Actions WHERE Type = 'commentCard' AND CardId = '56eae4d5eb3eb531f1ab43af'
We are retrieving all comment actions made on Card with CardId = '56eae4d5eb3eb531f1ab43af'.
SELECT * FROM Actions WHERE Type = 'addMemberToBoard' AND BoardId = '5835595ee004411c6abdbfbd'
We are retrieving all add member actions made on Board with BoardId = '56eae4d5eb3eb531f1ab43af'.

For a full list of actions types, visit: https://developers.trello.com/reference#action-types

If BoardId and OrganizationId are not present in the connection properties or in query ( in the case of

SELECT * FROM Actions
, for example) all logged actions of the user will be returned,

otherwise if BoardId is specified,

SELECT * FROM Actions
will return all Actions of the board. Because a board can have many actions, the query may take a while to execute.

If OrganizationId is specified

SELECT * FROM Actions
will return all actions actions on the organization.

If both properties are present

SELECT * FROM Actions
will return all Actions of the board.

Columns

Name Type Description
ActionId [KEY] String The Id of the action.
Type String The action type (possible values https://developers.trello.com/reference#action-types)
Date Datetime Date created.
BoardID String The Id of the board which the action references.
ListName String The name of the list which the action references.
ListID String The Id of the list which the action references.
CardID String The Id of the card which the action references.
CardName String The name of the card which the action references.
CardShortLink String The link of the card which the action references.
MemberId String The Id of the member associated with the action.
MemberName String The name of the member associated with the action.
OldPosition String The old position of the card when you move it up or down inside a list.
ListAfterId String The old position of the card when you move it up or down inside a list.
ListBeforeId String The old position of the card when you move it up or down inside a list.
OrganizationID String The Id of the organization which the action references.
Comment String The comment body if the action is of type commentCard.
CreatedDate Datetime The time the action was created.

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