Skip to main content

Trello

Trello is a visual collaboration and project management platform that uses boards, lists, and cards to help teams organize work, track tasks, and manage projects. This integration provides comprehensive access to Trello's organizational structure, enabling users to query and analyze boards, cards, lists, members, notifications, organizations, and user activities across their Trello workspace.

CategoryIT service management
DirectionQuery source
Sign-inAPI Key and Token
Query languagesSQLite
Tables13
Query templates77
Websitetrello.com

Before you start​

Huntbase signs in to Trello with API Key and Token. Create the credential in Trello first, then keep it to hand for the Connect step.

  1. Go to https://trello.com/apps/admin and open your Power-Up. An API key is tied to a Power-Up, so create one first if you don't have one.
  2. On the Trello Auth tab, select Generate a new API Key and copy the key.
  3. To generate a read-only token, open https://trello.com/1/authorize?expiration=never&scope=read&response_type=token&key=<your API key> and allow access.
  4. Copy the token from the page you're redirected to.

Permissions:

  • read scope
Watch out for
  • The token's expiration can be 1hour, 1day, 30days, or never. A short expiration breaks the connection when the token lapses.
  • The key and token act with the permissions of the Trello user who authorized them.

For the vendor's own instructions, see Trello API authorization guide.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect Trello​

  1. Go to Connections and click New connection, or click New connection on the Trello product page.
  2. On Product, pick Trello and choose the Owner.
  3. On Details, give the connection a Name and, optionally, a Description.
  4. On Connect, fill in the settings and credentials described below.
  5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Credentials​

The only Method is API Key and Token. Enter a Credential label (for example Production), then fill in:

FieldRequiredNotes
API KeyYesSecret — not shown again after you save it.
TokenYesSecret — not shown again after you save it.

Query it​

Once connected, Trello can serve these languages in a query tab, and Scout can use it when you ask in Auto:

LanguageUse it for
SQLiteSQL over the 13 tables listed below, alongside every other connected source.

Example: SQLite​

Trello member basic info — List all Trello members registered in the system, including their usernames, full names, email addresses, and initials.

select
  id,
  username,
  full_name,
  email,
  initials
from
  trello_member;

Trello ships with 77 query templates. Find them in Library › Queries — see Query templates.

Tables​

Trello adds 13 tables. Browse their columns from Schema in the query bar's ⋯ menu.

All 13 tables
TableContains
trello_boardGet details of all the boards in your organization.
trello_cardGet details of all cards in a list.
trello_listGet details of all the lists in a board.
trello_memberGet details of all members in an organization.
trello_my_boardGet details of the boards you have access to.
trello_my_memberGet details of your trello user.
trello_my_notificationGet details of your notifications.
trello_my_organizationGet details of my organizations you have access to.
trello_organizationGet details of the organization.
trello_search_boardFind boards you have access to that match search keywords.
trello_search_cardFind cards you have access to that match search keywords.
trello_tokenGet details of the tokens.
trello_webhookGet details of the webhooks.

Next steps​