Trello

Creating the data source

Once logged into Trello with the account you want to integrate, visit https://trello.com/power-ups/admin/
Click the "New" button to create a new power-up
Fill in the information with the name of the power-up, choose the workspace from which you wish to replicate the data and fill in the fields "Email", "Support Contact" and "Author", then click “Create”
Click the "Create new API Key" button and then again the "Create API Key" button
Store the key generated on the "API Key" field and then choose the option to manually create an API token (it will be located on the right side of the API Key field)
You will be redirected to the token generation page, similar to the image below:
Scroll down the screen a little more, until you find the “Allow” button. Click that button
Your token will be generated similar to the image below. Copy it
With the API Key and Token in hand, log into Kondado > click the CREATE+ button > Data Source > Trello
Fill in the data source information as follows:
1. Name: An internal identification of your data source, for example “Trello Operations Account”
2. API Key: API Key generated in step (5)
3. API Token: Token generated in step (8)
Once the values are filled in, just click on SAVE and your data source is ready to use!

Click to expand

Main object

Campo	Tipo
id	text	[en] Unique identifier of the Board.
idorganization	text	[en] Unique identifier of the Organization. Organizations > > id
name	text	[en] Board name.
board_desc	text
closed	boolean
url	text
datelastactivity	timestamp
datelastview	timestamp
shorturl	text

trello_lists

Main object

Campo	Tipo
id	text	[en] Unique identifier of the card.
board_id	text	[en] Identifier of the board to which the card belongs. Boards and Lists > > id
list_id	text	[en] Identifier of the list where the card is located.
closed	boolean	[en] Indicates if the card is archived (true) or active (false).
duecomplete	boolean	[en] Indicates if the card's due date has been marked as complete.
datelastactivity	timestamp	[en] Timestamp of the last activity recorded on the card.
card_desc	text	[en] Detailed description of the card's content or purpose.
due	timestamp	[en] Scheduled date and time for the task associated with the card.
name	text	[en] Title or name of the card.
position	float	[en] Position of the card within the list, used for ordering.
shortlink	text	[en] Unique short link referencing the card.
shorturl	text	[en] Short URL directing to the card in Trello.
url	text	[en] Full URL directing to the card in Trello.

trello_cards__actions

Campo	Tipo
card_id	text
action_id	text	[en] Unique identifier of the action.
action_type	text	[en] Type of action performed (e.g., commentCard, updateCard).
action_date	timestamp	[en] Timestamp when the action was performed.
action_idmembercreator	text	[en] Identifier of the member who performed the action.
action_data_list_id	text
action_data_old_desc	text

trello_cards__labels

Campo	Tipo
card_id	text	[en] Unique identifier of the label.
labels__id	text	[en] Identifier of the board to which the label belongs.
labels__idboard	text	[en] Identifier of the board to which the label belongs.
labels__name	text	[en] Name of the label.
labels__color	text	[en] Color assigned to the label.

This pipeline includes custom fields data but it takes more time to run. If you do not need custom field data, use its non-detail version

Main object

Campo	Tipo
id	text	[en] Unique identifier of the card.
board_id	text	[en] Identifier of the board to which the card belongs. Boards and Lists > > id
list_id	text	[en] Identifier of the list where the card is located.
closed	boolean	[en] Indicates if the card is archived (true) or active (false).
duecomplete	boolean	[en] Indicates if the card's due date has been marked as complete.
datelastactivity	timestamp	[en] Timestamp of the last activity recorded on the card.
card_desc	text	[en] Detailed description of the card's content or purpose.
due	timestamp	[en] Scheduled date and time for the task associated with the card.
name	text	[en] Title or name of the card.
position	float	[en] Position of the card within the list, used for ordering.
shortlink	text	[en] Unique short link referencing the card.
shorturl	text	[en] Short URL directing to the card in Trello.
url	text	[en] Full URL directing to the card in Trello.
custom_field_board1_x	text	[en] A custom text field named X on board 1
custom_field_board1_y	date	[en] A custom text field named Y on board 2
custom_field_board2_z	float	[en] A custom text field named Z on board 2

trello_cards__actions

Campo	Tipo
card_id	text
action_id	text	[en] Unique identifier of the action.
action_type	text	[en] Type of action performed (e.g., commentCard, updateCard).
action_date	timestamp	[en] Timestamp when the action was performed.
action_idmembercreator	text	[en] Identifier of the member who performed the action.
action_data_list_id	text
action_data_old_desc	text

trello_cards__labels

Campo	Tipo
card_id	text	[en] Unique identifier of the label.
labels__id	text	[en] Identifier of the board to which the label belongs.
labels__idboard	text	[en] Identifier of the board to which the label belongs.
labels__name	text	[en] Name of the label.
labels__color	text	[en] Color assigned to the label.

Main object

trello_checklists__checkItems

Main object

trello_organizations__boards

Campo	Tipo
org_id	text	[en] Unique identifier of the Organization.
board_id	text	[en] Unique identifier of the Board. Boards and Lists > > id

Campo

Tipo

org_id

text

[en] Unique identifier of the Organization.

board_id

text

[en] Unique identifier of the Board.