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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Trello icon.

  4. 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

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:

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

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

Step 5: Set objects to replicate

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. 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.

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.


Trello replication

In this section:

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.

  1. 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 |
    
  2. 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

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

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

data

OBJECT

board

OBJECT

id

STRING

name

STRING

prefs

OBJECT

background

STRING

shortLink

STRING

card

OBJECT

closed

BOOLEAN

desc

STRING

id

STRING

idList

STRING

idMembers

ARRAY

idShort

INTEGER

name

STRING

pos

NUMBER

shortLink

STRING

cardSource

OBJECT

id

STRING

idShort

INTEGER

name

STRING

shortLink

STRING

deactivated

BOOLEAN

idMember

STRING

idMemberAdded

STRING

idMemberInviter

STRING

list

OBJECT

closed

BOOLEAN

id

STRING

name

STRING

pos

NUMBER

listAfter

OBJECT

id

STRING

name

STRING

listBefore

OBJECT

id

STRING

name

STRING

member

OBJECT

id

STRING

name

STRING

memberType

STRING

method

STRING

old

OBJECT

closed

BOOLEAN

desc

STRING

idList

STRING

idMembers

ARRAY

name

STRING

pos

NUMBER

prefs

OBJECT

background

STRING

organization

OBJECT

id

STRING

name

STRING

text

STRING

date

STRING

id

STRING

idMemberCreator

STRING

limits

OBJECT

reactions

OBJECT

perAction

OBJECT

disableAt

INTEGER

status

STRING

warnAt

INTEGER

uniquePerAction

OBJECT

disableAt

INTEGER

status

STRING

warnAt

INTEGER

member

OBJECT

activityBlocked

BOOLEAN

avatarHash

STRING

avatarUrl

STRING

fullName

STRING

id

STRING

idMemberReferrer

STRING

initials

STRING

nonPublicAvailable

BOOLEAN

username

STRING

memberCreator

OBJECT

activityBlocked

BOOLEAN

avatarHash

STRING

avatarUrl

STRING

fullName

STRING

id

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

id

Useful links

Trello documentation

boards schema on GitHub

Trello API method

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

closed

BOOLEAN

creationMethod

STRING

dateLastActivity

DATE-TIME

dateLastView

DATE-TIME

datePluginDisable

DATE-TIME

desc

STRING

descData

STRING

enterpriseOwned

BOOLEAN

id

STRING

idBoardSource

STRING

idEnterprise

STRING

idOrganization

STRING

idTags

ARRAY

ixUpdate

INTEGER

labelNames

OBJECT

black

STRING

blue

STRING

green

STRING

lime

STRING

orange

STRING

pink

STRING

purple

STRING

red

STRING

sky

STRING

yellow

STRING

limits

OBJECT

attachments

OBJECT

perBoard

OBJECT

disableAt

INTEGER

status

STRING

warnAt

INTEGER

memberships

ARRAY

deactivated

BOOLEAN

id

STRING

idMember

STRING

memberType

STRING

unconfirmed

BOOLEAN

name

STRING

pinned

BOOLEAN

powerUps

ARRAY

prefs

OBJECT

background

STRING

backgroundBottomColor

STRING

backgroundBrightness

STRING

backgroundImage

STRING

backgroundImageScaled

ARRAY

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

id

Useful links

Trello documentation

cards schema on GitHub

Trello API method

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

badges

OBJECT

attachments

INTEGER

attachmentsByType

OBJECT

trello

OBJECT

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

id

STRING

idCustomField

STRING

idModel

STRING

idValue

STRING

modelType

STRING

value

OBJECT

checked

STRING

date

STRING

number

STRING

option

STRING

text

STRING

dateLastActivity

DATE-TIME

desc

STRING

descData

OBJECT

due

DATE-TIME

dueComplete

BOOLEAN

dueReminder

STRING

id

STRING

idAttachmentCover

STRING

idBoard

STRING

idChecklists

ARRAY

idLabels

ARRAY

idList

STRING

idMembers

ARRAY

idMembersVoted

ARRAY

idShort

INTEGER

isTemplate

BOOLEAN

labels

ARRAY

color

STRING

id

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

id

Useful links

checklists schema on GitHub

Trello API method

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

badges

OBJECT

attachments

INTEGER

attachmentsByType

OBJECT

trello

OBJECT

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

creationMethod

STRING

due

STRING

id

STRING

idChecklist

STRING

idMember

STRING

name

STRING

nameData

STRING

pos

NUMBER

state

STRING

type

STRING

closed

BOOLEAN

cover

OBJECT

creationMethod

STRING

data

OBJECT

board

OBJECT

id

STRING

name

STRING

prefs

OBJECT

permissionLevel

STRING

selfJoin

BOOLEAN

shortLink

STRING

card

OBJECT

closed

BOOLEAN

due

STRING

dueComplete

BOOLEAN

id

STRING

idShort

INTEGER

name

STRING

shortLink

STRING

checklist

OBJECT

id

STRING

name

STRING

creationMethod

STRING

list

OBJECT

id

STRING

name

STRING

old

OBJECT

closed

BOOLEAN

due

STRING

dueComplete

BOOLEAN

name

STRING

prefs

OBJECT

permissionLevel

STRING

selfJoin

BOOLEAN

organization

OBJECT

id

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

id

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

black

STRING

blue

STRING

green

STRING

lime

STRING

orange

STRING

pink

STRING

purple

STRING

red

STRING

sky

STRING

yellow

STRING

limits

OBJECT

checkItems

OBJECT

perChecklist

OBJECT

disableAt

INTEGER

status

STRING

warnAt

INTEGER

manualCoverAttachment

BOOLEAN

memberCreator

OBJECT

activityBlocked

BOOLEAN

avatarHash

STRING

avatarUrl

STRING

fullName

STRING

id

STRING

idMemberReferrer

STRING

initials

STRING

nonPublicAvailable

BOOLEAN

username

STRING

memberships

ARRAY

deactivated

BOOLEAN

id

STRING

idMember

STRING

memberType

STRING

unconfirmed

BOOLEAN

name

STRING

pinned

STRING

pos

NUMBER

prefs

OBJECT

background

STRING

backgroundBottomColor

STRING

backgroundBrightness

STRING

backgroundColor

STRING

backgroundImage

STRING

backgroundImageScaled

ARRAY

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

id

Useful links

lists schema on GitHub

Trello API method

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

closed

BOOLEAN

id

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

id

boardId

Useful links

users schema on GitHub

Trello API method

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

boardId

STRING

fullName

STRING

id

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.