Trello (v1) | Stitch Documentation

Trello extraction is supported by Stitch
This integration is powered by Singer's Trello tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Stitch support.

Trello integration summary

Stitch’s Trello integration replicates data using the Trello REST API. Refer to the Schema section for a list of objects available for replication.

Trello feature snapshot

A high-level look at Stitch's Trello (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on June 10, 2020	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-trello
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Trello

Trello setup requirements

To set up Trello in Stitch, you need:

To be a member of every Trello board you want to replicate. If a board is private and the user isn’t a member, Stitch will be unable to access it. Before beginning the setup process, verify that the user setting up the integration has access to all the boards you want to replicate.

Refer to the Replication section for why this is required.

Step 1: Add Trello as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Trello icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Trello” would create a schema called stitch_trello in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Trello integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Trello’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Trello integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Trello

Next, you’ll be redirected to Trello.
Log into your Trello account and complete the authorization process. When finished, you’ll be redirected back to Stitch.
Click All Done.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Trello integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Trello, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Trello replication

In this section:

Data replication via board membership
Custom field support

Data replication via board membership

Stitch’s Trello integration replicates data by first querying for the boards that the user authorizing the integration in Stitch is a member of. Specifically, Stitch uses the Get boards that member belongs to endpoint (/1/members/{id}/boards) to retrieve the boards the user is a member of.

This means that to replicate data successfully, including boards, the user who authorized the integration in Stitch must be a member of every board you want to replicate data from.

Let’s take a look at what Extraction might look like for boards and cards using some SQL queries.

Note: The queries in this section aren’t meant to be used to query replicated Trello data, and may not have parity with actual fields replicated by Stitch. They are for demonstration only.

Stitch queries for boards that the authorizing user is a member of. In this example, the authorizing user’s ID is 559be34bc1f1b3f3383671b7:

SELECT id as user_id,
       idBoard
  FROM members
 WHERE id = '559be34bc1f1b3f3383671b7'

Which returns the following:

| id                       | idBoard                  |
|--------------------------+--------------------------|
| 559be34bc1f1b3f3383671b7 | 574f5d5202564aa4447e14a5 |

Stitch queries for cards using the idBoard value returned in the first query:

SELECT id as card_id,
       idBoard,
       <other card fields>
  FROM cards
 WHERE idBoard = '574f5d5202564aa4447e14a5'

Which returns the following:

| card_id                  | boardId                  |
|--------------------------+--------------------------|
| 5c26a3ce766676349d2f82d2 | 574f5d5202564aa4447e14a5 |
| 5c2e83a628ffe90351d0208b | 574f5d5202564aa4447e14a5 |
| 5c950cf7e1ad9b845171680b | 574f5d5202564aa4447e14a5 |

This approach is used for every table set to replicate. If you’re missing data, verify that the authorizing user is a member of the board.

Custom field support

Custom fields are supported for the following tables:

Trello table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

This is the latest version of the Trello integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

actions

The actions table contains information about the actions within each board the authorizing user is a member of.

Replication Method	Key-based Incremental
Primary Key	id
Replication Key	date
Useful links	actions schema on GitHub Trello API method

actions table foreign keys

Join actions with	on
boards	actions.data.board.id = boards.id actions.data.organization.id = boards.idOrganization actions.idMemberCreator = boards.memberships.idMember actions.data.idMember = boards.memberships.idMember actions.data.idMemberAdded = boards.memberships.idMember actions.data.idMemberInviter = boards.memberships.idMember actions.data.card.idMembers = boards.memberships.idMember actions.data.member.id = boards.memberships.idMember actions.data.old.idMembers = boards.memberships.idMember actions.member.id = boards.memberships.idMember actions.memberCreator.id = boards.memberships.idMember
cards	actions.data.board.id = cards.idBoard actions.data.board.id = cards.labels.idBoard actions.data.card.id = cards.id actions.data.card.idList = cards.idList actions.data.list.id = cards.idList actions.data.listAfter.id = cards.idList actions.data.listBefore.id = cards.idList actions.data.old.idList = cards.idList actions.idMemberCreator = cards.idMembers actions.data.idMember = cards.idMembers actions.data.idMemberAdded = cards.idMembers actions.data.idMemberInviter = cards.idMembers actions.data.card.idMembers = cards.idMembers actions.data.member.id = cards.idMembers actions.data.old.idMembers = cards.idMembers actions.member.id = cards.idMembers actions.memberCreator.id = cards.idMembers actions.idMemberCreator = cards.idMembersVoted actions.data.idMember = cards.idMembersVoted actions.data.idMemberAdded = cards.idMembersVoted actions.data.idMemberInviter = cards.idMembersVoted actions.data.card.idMembers = cards.idMembersVoted actions.data.member.id = cards.idMembersVoted actions.data.old.idMembers = cards.idMembersVoted actions.member.id = cards.idMembersVoted actions.memberCreator.id = cards.idMembersVoted
checklists	actions.data.board.id = checklists.data.board.id actions.data.board.id = checklists.idBoard actions.data.card.id = checklists.idCard actions.data.card.id = checklists.data.card.id actions.data.card.idList = checklists.idList actions.data.list.id = checklists.idList actions.data.listAfter.id = checklists.idList actions.data.listBefore.id = checklists.idList actions.data.old.idList = checklists.idList actions.data.card.idList = checklists.data.list.id actions.data.list.id = checklists.data.list.id actions.data.listAfter.id = checklists.data.list.id actions.data.listBefore.id = checklists.data.list.id actions.data.old.idList = checklists.data.list.id actions.data.organization.id = checklists.idOrganization actions.data.organization.id = checklists.data.organization.id actions.idMemberCreator = checklists.checkItems.idMember actions.data.idMember = checklists.checkItems.idMember actions.data.idMemberAdded = checklists.checkItems.idMember actions.data.idMemberInviter = checklists.checkItems.idMember actions.data.card.idMembers = checklists.checkItems.idMember actions.data.member.id = checklists.checkItems.idMember actions.data.old.idMembers = checklists.checkItems.idMember actions.member.id = checklists.checkItems.idMember actions.memberCreator.id = checklists.checkItems.idMember actions.idMemberCreator = checklists.idMemberCreator actions.data.idMember = checklists.idMemberCreator actions.data.idMemberAdded = checklists.idMemberCreator actions.data.idMemberInviter = checklists.idMemberCreator actions.data.card.idMembers = checklists.idMemberCreator actions.data.member.id = checklists.idMemberCreator actions.data.old.idMembers = checklists.idMemberCreator actions.member.id = checklists.idMemberCreator actions.memberCreator.id = checklists.idMemberCreator actions.idMemberCreator = checklists.memberCreator.id actions.data.idMember = checklists.memberCreator.id actions.data.idMemberAdded = checklists.memberCreator.id actions.data.idMemberInviter = checklists.memberCreator.id actions.data.card.idMembers = checklists.memberCreator.id actions.data.member.id = checklists.memberCreator.id actions.data.old.idMembers = checklists.memberCreator.id actions.member.id = checklists.memberCreator.id actions.memberCreator.id = checklists.memberCreator.id actions.idMemberCreator = checklists.memberships.idMember actions.data.idMember = checklists.memberships.idMember actions.data.idMemberAdded = checklists.memberships.idMember actions.data.idMemberInviter = checklists.memberships.idMember actions.data.card.idMembers = checklists.memberships.idMember actions.data.member.id = checklists.memberships.idMember actions.data.old.idMembers = checklists.memberships.idMember actions.member.id = checklists.memberships.idMember actions.memberCreator.id = checklists.memberships.idMember
lists	actions.data.board.id = lists.idBoard actions.data.card.idList = lists.id actions.data.list.id = lists.id actions.data.listAfter.id = lists.id actions.data.listBefore.id = lists.id actions.data.old.idList = lists.id
users	actions.data.board.id = users.boardId actions.idMemberCreator = users.id actions.data.idMember = users.id actions.data.idMemberAdded = users.id actions.data.idMemberInviter = users.id actions.data.card.idMembers = users.id actions.data.member.id = users.id actions.data.old.idMembers = users.id actions.member.id = users.id actions.memberCreator.id = users.id

actions table schema

data

OBJECT

Click to expand data

board

OBJECT

Click to expand board

STRING

name

STRING

prefs

OBJECT

Click to expand prefs

background

STRING

shortLink

STRING

card

OBJECT

Click to expand card

closed

BOOLEAN

desc

STRING

idList

STRING

idMembers

ARRAY

idShort

INTEGER

name

STRING

pos

NUMBER

shortLink

STRING

cardSource

OBJECT

Click to expand cardSource

STRING

idShort

INTEGER

name

STRING

shortLink

STRING

deactivated

BOOLEAN

idMember

STRING

idMemberAdded

STRING

idMemberInviter

STRING

list

OBJECT

Click to expand list

closed

BOOLEAN

STRING

name

STRING

pos

NUMBER

listAfter

OBJECT

Click to expand listAfter

STRING

name

STRING

listBefore

OBJECT

Click to expand listBefore

STRING

name

STRING

member

OBJECT

Click to expand member

STRING

name

STRING

memberType

STRING

method

STRING

old

OBJECT

Click to expand old

closed

BOOLEAN

desc

STRING

idList

STRING

idMembers

ARRAY

name

STRING

pos

NUMBER

prefs

OBJECT

Click to expand prefs

background

STRING

organization

OBJECT

Click to expand organization

STRING

name

STRING

text

STRING

date

STRING

idMemberCreator

STRING

limits

OBJECT

Click to expand limits

reactions

OBJECT

Click to expand reactions

perAction

OBJECT

Click to expand perAction

disableAt

INTEGER

status

STRING

warnAt

INTEGER

uniquePerAction

OBJECT

Click to expand uniquePerAction

disableAt

INTEGER

status

STRING

warnAt

INTEGER

member

OBJECT

Click to expand member

activityBlocked

BOOLEAN

avatarHash

STRING

avatarUrl

STRING

fullName

STRING

idMemberReferrer

STRING

initials

STRING

nonPublicAvailable

BOOLEAN

username

STRING

memberCreator

OBJECT

Click to expand memberCreator

activityBlocked

BOOLEAN

avatarHash

STRING

avatarUrl

STRING

fullName

STRING

idMemberReferrer

STRING

initials

STRING

nonPublicAvailable

BOOLEAN

username

STRING

type

STRING

boards

The boards table contains info about the boards that the authorizing user is a member of.

Custom field support

Custom fields are supported for this table.

Replication Method

Full Table

Primary Key

Useful links

Trello documentation

boards schema on GitHub

Trello API method

boards table foreign keys

Join boards with	on
actions	boards.id = actions.data.board.id boards.idOrganization = actions.data.organization.id boards.memberships.idMember = actions.idMemberCreator boards.memberships.idMember = actions.data.idMember boards.memberships.idMember = actions.data.idMemberAdded boards.memberships.idMember = actions.data.idMemberInviter boards.memberships.idMember = actions.data.card.idMembers boards.memberships.idMember = actions.data.member.id boards.memberships.idMember = actions.data.old.idMembers boards.memberships.idMember = actions.member.id boards.memberships.idMember = actions.memberCreator.id
cards	boards.id = cards.idBoard boards.id = cards.labels.idBoard boards.memberships.idMember = cards.idMembers boards.memberships.idMember = cards.idMembersVoted
checklists	boards.id = checklists.data.board.id boards.id = checklists.idBoard boards.idOrganization = checklists.idOrganization boards.idOrganization = checklists.data.organization.id boards.memberships.idMember = checklists.checkItems.idMember boards.memberships.idMember = checklists.idMemberCreator boards.memberships.idMember = checklists.memberCreator.id boards.memberships.idMember = checklists.memberships.idMember
lists	boards.id = lists.idBoard
users	boards.id = users.boardId boards.memberships.idMember = users.id

boards table schema

closed

BOOLEAN

creationMethod

STRING

dateLastActivity

DATE-TIME

dateLastView

DATE-TIME

datePluginDisable

DATE-TIME

desc

STRING

descData

STRING

enterpriseOwned

BOOLEAN

STRING

idBoardSource

STRING

idEnterprise

STRING

idOrganization

STRING

idTags

ARRAY

ixUpdate

INTEGER

labelNames

OBJECT

Click to expand labelNames

black

STRING

blue

STRING

green

STRING

lime

STRING

orange

STRING

pink

STRING

purple

STRING

red

STRING

sky

STRING

yellow

STRING

limits

OBJECT

Click to expand limits

attachments

OBJECT

Click to expand attachments

perBoard

OBJECT

Click to expand perBoard

disableAt

INTEGER

status

STRING

warnAt

INTEGER

memberships

ARRAY

Click to expand memberships

deactivated

BOOLEAN

STRING

idMember

STRING

memberType

STRING

unconfirmed

BOOLEAN

name

STRING

pinned

BOOLEAN

powerUps

ARRAY

prefs

OBJECT

Click to expand prefs

background

STRING

backgroundBottomColor

STRING

backgroundBrightness

STRING

backgroundImage

STRING

backgroundImageScaled

ARRAY

Click to expand backgroundImageScaled

height

INTEGER

url

STRING

width

INTEGER

backgroundTile

BOOLEAN

backgroundTopColor

STRING

calendarFeedEnabled

BOOLEAN

canBeEnterprise

BOOLEAN

canBeOrg

BOOLEAN

canBePrivate

BOOLEAN

canBePublic

BOOLEAN

canInvite

BOOLEAN

cardAging

STRING

cardCovers

BOOLEAN

comments

STRING

hideVotes

BOOLEAN

invitations

STRING

isTemplate

BOOLEAN

permissionLevel

STRING

selfJoin

BOOLEAN

voting

STRING

premiumFeatures

ARRAY

shortLink

STRING

shortUrl

STRING

starred

BOOLEAN

subscribed

BOOLEAN

templateGallery

STRING

url

STRING

cards

The cards table contains info about all of the cards on boards that authorizing user is a member of.

Custom field support

Custom fields are supported for this table.

Replication Method

Full Table

Primary Key

Useful links

Trello documentation

cards schema on GitHub

Trello API method

cards table foreign keys

Join cards with	on
boards	cards.idBoard = boards.id cards.labels.idBoard = boards.id cards.idMembers = boards.memberships.idMember cards.idMembersVoted = boards.memberships.idMember
actions	cards.idBoard = actions.data.board.id cards.labels.idBoard = actions.data.board.id cards.id = actions.data.card.id cards.idList = actions.data.card.idList cards.idList = actions.data.list.id cards.idList = actions.data.listAfter.id cards.idList = actions.data.listBefore.id cards.idList = actions.data.old.idList cards.idMembers = actions.idMemberCreator cards.idMembersVoted = actions.idMemberCreator cards.idMembers = actions.data.idMember cards.idMembersVoted = actions.data.idMember cards.idMembers = actions.data.idMemberAdded cards.idMembersVoted = actions.data.idMemberAdded cards.idMembers = actions.data.idMemberInviter cards.idMembersVoted = actions.data.idMemberInviter cards.idMembers = actions.data.card.idMembers cards.idMembersVoted = actions.data.card.idMembers cards.idMembers = actions.data.member.id cards.idMembersVoted = actions.data.member.id cards.idMembers = actions.data.old.idMembers cards.idMembersVoted = actions.data.old.idMembers cards.idMembers = actions.member.id cards.idMembersVoted = actions.member.id cards.idMembers = actions.memberCreator.id cards.idMembersVoted = actions.memberCreator.id
checklists	cards.idBoard = checklists.data.board.id cards.labels.idBoard = checklists.data.board.id cards.idBoard = checklists.idBoard cards.labels.idBoard = checklists.idBoard cards.id = checklists.idCard cards.id = checklists.data.card.id cards.idChecklists = checklists.id cards.idChecklists = checklists.checkItems.idChecklist cards.idChecklists = checklists.data.checklist.id cards.idList = checklists.idList cards.idList = checklists.data.list.id cards.idMembers = checklists.checkItems.idMember cards.idMembersVoted = checklists.checkItems.idMember cards.idMembers = checklists.idMemberCreator cards.idMembersVoted = checklists.idMemberCreator cards.idMembers = checklists.memberCreator.id cards.idMembersVoted = checklists.memberCreator.id cards.idMembers = checklists.memberships.idMember cards.idMembersVoted = checklists.memberships.idMember
lists	cards.idBoard = lists.idBoard cards.labels.idBoard = lists.idBoard cards.idList = lists.id
users	cards.idBoard = users.boardId cards.labels.idBoard = users.boardId cards.idMembers = users.id cards.idMembersVoted = users.id

cards table schema

badges

OBJECT

Click to expand badges

attachments

INTEGER

attachmentsByType

OBJECT

Click to expand attachmentsByType

trello

OBJECT

Click to expand trello

board

INTEGER

card

INTEGER

checkItems

INTEGER

checkItemsChecked

INTEGER

checkItemsEarliestDue

DATE-TIME

comments

INTEGER

description

BOOLEAN

due

DATE-TIME

dueComplete

BOOLEAN

fogbugz

STRING

location

BOOLEAN

subscribed

BOOLEAN

viewingMemberVoted

BOOLEAN

votes

INTEGER

checkItemStates

ARRAY

closed

BOOLEAN

cover

OBJECT

customFieldItems

ARRAY

Click to expand customFieldItems

STRING

idCustomField

STRING

idModel

STRING

idValue

STRING

modelType

STRING

value

OBJECT

Click to expand value

checked

STRING

date

STRING

number

STRING

option

STRING

text

STRING

dateLastActivity

DATE-TIME

desc

STRING

descData

OBJECT

Click to expand descData

emoji

OBJECT

due

DATE-TIME

dueComplete

BOOLEAN

dueReminder

STRING

idAttachmentCover

STRING

idBoard

STRING

idChecklists

ARRAY

Click to expand idChecklists

STRING

idLabels

ARRAY

idList

STRING

idMembers

ARRAY

idMembersVoted

ARRAY

idShort

INTEGER

isTemplate

BOOLEAN

labels

ARRAY

Click to expand labels

color

STRING

idBoard

STRING

name

STRING

manualCoverAttachment

BOOLEAN

name

STRING

pos

NUMBER

shortLink

STRING

shortUrl

STRING

start

STRING

subscribed

BOOLEAN

url

STRING

checklists

The checklists table contains info about checklists on boards that the authorizing user is a member of.

Replication Method

Full Table

Primary Key

Useful links

checklists schema on GitHub

Trello API method

checklists table foreign keys

Join checklists with	on
boards	checklists.data.board.id = boards.id checklists.idBoard = boards.id checklists.idOrganization = boards.idOrganization checklists.data.organization.id = boards.idOrganization checklists.checkItems.idMember = boards.memberships.idMember checklists.idMemberCreator = boards.memberships.idMember checklists.memberCreator.id = boards.memberships.idMember checklists.memberships.idMember = boards.memberships.idMember
actions	checklists.data.board.id = actions.data.board.id checklists.idBoard = actions.data.board.id checklists.idCard = actions.data.card.id checklists.data.card.id = actions.data.card.id checklists.idList = actions.data.card.idList checklists.data.list.id = actions.data.card.idList checklists.idList = actions.data.list.id checklists.data.list.id = actions.data.list.id checklists.idList = actions.data.listAfter.id checklists.data.list.id = actions.data.listAfter.id checklists.idList = actions.data.listBefore.id checklists.data.list.id = actions.data.listBefore.id checklists.idList = actions.data.old.idList checklists.data.list.id = actions.data.old.idList checklists.idOrganization = actions.data.organization.id checklists.data.organization.id = actions.data.organization.id checklists.checkItems.idMember = actions.idMemberCreator checklists.idMemberCreator = actions.idMemberCreator checklists.memberCreator.id = actions.idMemberCreator checklists.memberships.idMember = actions.idMemberCreator checklists.checkItems.idMember = actions.data.idMember checklists.idMemberCreator = actions.data.idMember checklists.memberCreator.id = actions.data.idMember checklists.memberships.idMember = actions.data.idMember checklists.checkItems.idMember = actions.data.idMemberAdded checklists.idMemberCreator = actions.data.idMemberAdded checklists.memberCreator.id = actions.data.idMemberAdded checklists.memberships.idMember = actions.data.idMemberAdded checklists.checkItems.idMember = actions.data.idMemberInviter checklists.idMemberCreator = actions.data.idMemberInviter checklists.memberCreator.id = actions.data.idMemberInviter checklists.memberships.idMember = actions.data.idMemberInviter checklists.checkItems.idMember = actions.data.card.idMembers checklists.idMemberCreator = actions.data.card.idMembers checklists.memberCreator.id = actions.data.card.idMembers checklists.memberships.idMember = actions.data.card.idMembers checklists.checkItems.idMember = actions.data.member.id checklists.idMemberCreator = actions.data.member.id checklists.memberCreator.id = actions.data.member.id checklists.memberships.idMember = actions.data.member.id checklists.checkItems.idMember = actions.data.old.idMembers checklists.idMemberCreator = actions.data.old.idMembers checklists.memberCreator.id = actions.data.old.idMembers checklists.memberships.idMember = actions.data.old.idMembers checklists.checkItems.idMember = actions.member.id checklists.idMemberCreator = actions.member.id checklists.memberCreator.id = actions.member.id checklists.memberships.idMember = actions.member.id checklists.checkItems.idMember = actions.memberCreator.id checklists.idMemberCreator = actions.memberCreator.id checklists.memberCreator.id = actions.memberCreator.id checklists.memberships.idMember = actions.memberCreator.id
cards	checklists.data.board.id = cards.idBoard checklists.idBoard = cards.idBoard checklists.data.board.id = cards.labels.idBoard checklists.idBoard = cards.labels.idBoard checklists.idCard = cards.id checklists.data.card.id = cards.id checklists.id = cards.idChecklists checklists.checkItems.idChecklist = cards.idChecklists checklists.data.checklist.id = cards.idChecklists checklists.idList = cards.idList checklists.data.list.id = cards.idList checklists.checkItems.idMember = cards.idMembers checklists.idMemberCreator = cards.idMembers checklists.memberCreator.id = cards.idMembers checklists.memberships.idMember = cards.idMembers checklists.checkItems.idMember = cards.idMembersVoted checklists.idMemberCreator = cards.idMembersVoted checklists.memberCreator.id = cards.idMembersVoted checklists.memberships.idMember = cards.idMembersVoted
lists	checklists.data.board.id = lists.idBoard checklists.idBoard = lists.idBoard checklists.idList = lists.id checklists.data.list.id = lists.id
users	checklists.data.board.id = users.boardId checklists.idBoard = users.boardId checklists.checkItems.idMember = users.id checklists.idMemberCreator = users.id checklists.memberCreator.id = users.id checklists.memberships.idMember = users.id

checklists table schema

badges

OBJECT

Click to expand badges

attachments

INTEGER

attachmentsByType

OBJECT

Click to expand attachmentsByType

trello

OBJECT

Click to expand trello

board

INTEGER

card

INTEGER

checkItems

INTEGER

checkItemsChecked

INTEGER

checkItemsEarliestDue

STRING

comments

INTEGER

description

BOOLEAN

due

STRING

dueComplete

BOOLEAN

fogbugz

STRING

location

BOOLEAN

subscribed

BOOLEAN

viewingMemberVoted

BOOLEAN

votes

INTEGER

checkItemStates

STRING

checkItems

ARRAY

Click to expand checkItems

creationMethod

STRING

due

STRING

idChecklist

STRING

idMember

STRING

name

STRING

nameData

STRING

pos

NUMBER

state

STRING

type

STRING

closed

BOOLEAN

cover

OBJECT

creationMethod

STRING

data

OBJECT

Click to expand data

board

OBJECT

Click to expand board

STRING

name

STRING

prefs

OBJECT

Click to expand prefs

permissionLevel

STRING

selfJoin

BOOLEAN

shortLink

STRING

card

OBJECT

Click to expand card

closed

BOOLEAN

due

STRING

dueComplete

BOOLEAN

STRING

idShort

INTEGER

name

STRING

shortLink

STRING

checklist

OBJECT

Click to expand checklist

STRING

name

STRING

creationMethod

STRING

list

OBJECT

Click to expand list

STRING

name

STRING

old

OBJECT

Click to expand old

closed

BOOLEAN

due

STRING

dueComplete

BOOLEAN

name

STRING

prefs

OBJECT

Click to expand prefs

permissionLevel

STRING

selfJoin

BOOLEAN

organization

OBJECT

Click to expand organization

STRING

name

STRING

date

STRING

dateLastActivity

STRING

dateLastView

STRING

datePluginDisable

STRING

desc

STRING

descData

STRING

due

STRING

dueComplete

BOOLEAN

dueReminder

STRING

enterpriseOwned

BOOLEAN

fullName

STRING

idAttachmentCover

STRING

idBoard

STRING

idBoardSource

STRING

idCard

STRING

idChecklists

ARRAY

idEnterprise

STRING

idList

STRING

idMemberCreator

STRING

idOrganization

STRING

idShort

INTEGER

isTemplate

BOOLEAN

ixUpdate

STRING

labelNames

OBJECT

Click to expand labelNames

black

STRING

blue

STRING

green

STRING

lime

STRING

orange

STRING

pink

STRING

purple

STRING

red

STRING

sky

STRING

yellow

STRING

limits

OBJECT

Click to expand limits

checkItems

OBJECT

Click to expand checkItems

perChecklist

OBJECT

Click to expand perChecklist

disableAt

INTEGER

status

STRING

warnAt

INTEGER

manualCoverAttachment

BOOLEAN

memberCreator

OBJECT

Click to expand memberCreator

activityBlocked

BOOLEAN

avatarHash

STRING

avatarUrl

STRING

fullName

STRING

idMemberReferrer

STRING

initials

STRING

nonPublicAvailable

BOOLEAN

username

STRING

memberships

ARRAY

Click to expand memberships

deactivated

BOOLEAN

STRING

idMember

STRING

memberType

STRING

unconfirmed

BOOLEAN

name

STRING

pinned

STRING

pos

NUMBER

prefs

OBJECT

Click to expand prefs

background

STRING

backgroundBottomColor

STRING

backgroundBrightness

STRING

backgroundColor

STRING

backgroundImage

STRING

backgroundImageScaled

ARRAY

Click to expand backgroundImageScaled

height

INTEGER

url

STRING

width

INTEGER

backgroundTile

BOOLEAN

backgroundTopColor

STRING

calendarFeedEnabled

BOOLEAN

canBeEnterprise

BOOLEAN

canBeOrg

BOOLEAN

canBePrivate

BOOLEAN

canBePublic

BOOLEAN

canInvite

BOOLEAN

cardAging

STRING

cardCovers

BOOLEAN

comments

STRING

hideVotes

BOOLEAN

invitations

STRING

isTemplate

BOOLEAN

permissionLevel

STRING

selfJoin

BOOLEAN

voting

STRING

shortLink

STRING

shortUrl

STRING

softLimit

STRING

starred

BOOLEAN

subscribed

BOOLEAN

templateGallery

STRING

type

STRING

url

STRING

username

STRING

lists

The lists table contains info about lists on boards that the authorizing user is a member of.

Note: To replicate this table, the boards table must be set to replicate.

Replication Method

Full Table

Primary Key

Useful links

lists schema on GitHub

Trello API method

lists table foreign keys

Join lists with	on
boards	lists.idBoard = boards.id
actions	lists.idBoard = actions.data.board.id lists.id = actions.data.card.idList lists.id = actions.data.list.id lists.id = actions.data.listAfter.id lists.id = actions.data.listBefore.id lists.id = actions.data.old.idList
cards	lists.idBoard = cards.idBoard lists.idBoard = cards.labels.idBoard lists.id = cards.idList
checklists	lists.idBoard = checklists.data.board.id lists.idBoard = checklists.idBoard lists.id = checklists.idList lists.id = checklists.data.list.id
users	lists.idBoard = users.boardId

lists table schema

closed

BOOLEAN

STRING

idBoard

STRING

name

STRING

pos

NUMBER

softLimit

INTEGER

subscribed

BOOLEAN

users

The users table contains information about users who are members of boards that the authorizing user is also a member of.

Replication Method

Full Table

Primary Keys

boardId

Useful links

users schema on GitHub

Trello API method

users table foreign keys

Join users with	on
boards	users.boardId = boards.id users.id = boards.memberships.idMember
actions	users.boardId = actions.data.board.id users.id = actions.idMemberCreator users.id = actions.data.idMember users.id = actions.data.idMemberAdded users.id = actions.data.idMemberInviter users.id = actions.data.card.idMembers users.id = actions.data.member.id users.id = actions.data.old.idMembers users.id = actions.member.id users.id = actions.memberCreator.id
cards	users.boardId = cards.idBoard users.boardId = cards.labels.idBoard users.id = cards.idMembers users.id = cards.idMembersVoted
checklists	users.boardId = checklists.data.board.id users.boardId = checklists.idBoard users.id = checklists.checkItems.idMember users.id = checklists.idMemberCreator users.id = checklists.memberCreator.id users.id = checklists.memberships.idMember
lists	users.boardId = lists.idBoard

users table schema

boardId

STRING

fullName

STRING

username

STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues