Trello

Setting up the Trello connector

No	Item	Required	Example	Notes
1	API key	Yes		Trello API key. See the docs for instructions on how to generate it.
2	API token	Yes		Trello API token. See the docs for instructions on how to generate it.
3	Start Date	Yes	2021-03-01T00:00:00Z	UTC date and time in the format 2017-01-25T00:00:00Z. Any data before this date will not be replicated.
4	Trello Board IDs	No		IDs of the boards to replicate data from. If left empty, data from all boards to which you have access will be replicated.

Tables in the Trello connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	checklists	49	id	Full Refresh		API Reference
2	cards	30	id	Full Refresh		API Reference
3	lists	7	id	Full Refresh		API Reference
4	organizations	25	id	Full Refresh		API Reference
5	boards	28	id	Full Refresh		API Reference
6	actions	8	id	Full Refresh, Incremental	date	API Reference
7	users	4	id	Full Refresh		API Reference

Table: checklists

No	Column Name	Type	Notes
1	date	VARCHAR
2	labelNames	VARCHAR
3	data	VARCHAR
4	idCard	VARCHAR
5	datePluginDisable	VARCHAR
6	idList	VARCHAR
7	type	VARCHAR
8	shortLink	VARCHAR
9	idBoardSource	VARCHAR
10	cover	VARCHAR
11	subscribed	BOOLEAN
12	starred	BOOLEAN
13	memberCreator	VARCHAR
14	dateLastView	VARCHAR
15	id	VARCHAR	Primary Key
16	enterpriseOwned	BOOLEAN
17	idAttachmentCover	VARCHAR
18	isTemplate	BOOLEAN
19	name	VARCHAR
20	idMemberCreator	VARCHAR
21	desc	VARCHAR
22	descData	VARCHAR
23	pinned	VARCHAR
24	shortUrl	VARCHAR
25	dueComplete	BOOLEAN
26	dateLastActivity	VARCHAR
27	memberships	VARCHAR
28	creationMethod	VARCHAR
29	dueReminder	VARCHAR
30	pos	DOUBLE
31	idOrganization	VARCHAR
32	idChecklists	VARCHAR
33	limits	VARCHAR
34	softLimit	VARCHAR
35	idBoard	VARCHAR
36	templateGallery	VARCHAR
37	fullName	VARCHAR
38	url	VARCHAR
39	checkItemStates	VARCHAR
40	prefs	VARCHAR
41	badges	VARCHAR
42	ixUpdate	VARCHAR
43	idShort	INTEGER
44	due	VARCHAR
45	idEnterprise	VARCHAR
46	closed	BOOLEAN
47	manualCoverAttachment	BOOLEAN
48	checkItems	VARCHAR
49	username	VARCHAR

Table: cards

No	Column Name	Type	Notes
1	descData	VARCHAR
2	idLabels	VARCHAR
3	shortUrl	VARCHAR
4	dueComplete	BOOLEAN
5	dateLastActivity	VARCHAR
6	idList	VARCHAR
7	idMembersVoted	VARCHAR
8	shortLink	VARCHAR
9	cover	VARCHAR
10	dueReminder	VARCHAR
11	subscribed	BOOLEAN
12	pos	DOUBLE
13	idChecklists	VARCHAR
14	id	VARCHAR	Primary Key
15	customFieldItems	VARCHAR
16	idBoard	VARCHAR
17	start	VARCHAR
18	checkItemStates	VARCHAR
19	url	VARCHAR
20	labels	VARCHAR
21	badges	VARCHAR
22	idMembers	VARCHAR
23	idShort	INTEGER
24	due	VARCHAR
25	idAttachmentCover	VARCHAR
26	isTemplate	BOOLEAN
27	name	VARCHAR
28	closed	BOOLEAN
29	manualCoverAttachment	BOOLEAN
30	desc	VARCHAR

Table: lists

No	Column Name	Type	Notes
1	subscribed	BOOLEAN
2	idBoard	VARCHAR
3	pos	DOUBLE
4	name	VARCHAR
5	closed	BOOLEAN
6	id	VARCHAR	Primary Key
7	softLimit	INTEGER

Table: organizations

No	Column Name	Type	Notes
1	descData	VARCHAR
2	activeBillableMemberCount	INTEGER
3	displayName	VARCHAR
4	memberships	VARCHAR
5	products	VARCHAR
6	credits	VARCHAR
7	invitations	VARCHAR
8	id	VARCHAR	Primary Key
9	limits	VARCHAR
10	powerUps	VARCHAR
11	membersCount	INTEGER
12	invited	BOOLEAN
13	billableCollaboratorCount	INTEGER
14	premiumFeatures	VARCHAR
15	enterpriseJoinRequest	VARCHAR
16	url	VARCHAR
17	prefs	VARCHAR
18	billableMemberCount	INTEGER
19	promotions	VARCHAR
20	ixUpdate	VARCHAR
21	domainName	VARCHAR
22	name	VARCHAR
23	idBoards	VARCHAR
24	idMemberCreator	VARCHAR
25	desc	VARCHAR

Table: boards

No	Column Name	Type	Notes
1	descData	VARCHAR
2	idTags	VARCHAR
3	pinned	BOOLEAN
4	labelNames	VARCHAR
5	shortUrl	VARCHAR
6	dateLastActivity	VARCHAR
7	datePluginDisable	VARCHAR
8	shortLink	VARCHAR
9	idBoardSource	VARCHAR
10	memberships	VARCHAR
11	creationMethod	VARCHAR
12	subscribed	BOOLEAN
13	starred	BOOLEAN
14	idOrganization	VARCHAR
15	dateLastView	VARCHAR
16	id	VARCHAR	Primary Key
17	limits	VARCHAR
18	powerUps	VARCHAR
19	templateGallery	VARCHAR
20	premiumFeatures	VARCHAR
21	url	VARCHAR
22	prefs	VARCHAR
23	enterpriseOwned	BOOLEAN
24	ixUpdate	VARCHAR
25	idEnterprise	VARCHAR
26	name	VARCHAR
27	closed	BOOLEAN
28	desc	VARCHAR

Table: actions

No	Column Name	Type	Notes
1	date	VARCHAR	Incremental sync key
2	data	VARCHAR
3	memberCreator	VARCHAR
4	member	VARCHAR
5	id	VARCHAR	Primary Key
6	type	VARCHAR
7	idMemberCreator	VARCHAR
8	limits	VARCHAR

Table: users

No	Column Name	Type	Notes
1	boardId	VARCHAR
2	fullName	VARCHAR
3	id	VARCHAR	Primary Key
4	username	VARCHAR

External Resources

• Authorizing A Client
• Trello Account
• Requests Limitation

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.