Trello

Trello is a project management tool used to track team projects and ongoing tasks, show who they are assigned to, and get detailed progress towards completion. Trello is easy to integrate with the other software .

Trello authenticates API requests from Hevo to access your account data with HTTP Basic authentication.


Prerequisites

  • An active Trello account from which data is to be ingested.

  • The API key is available to authenticate Hevo on your Trello account.

  • You are logged in as an Admin user, to obtain the API Key and Server Token. Else, you can obtain these from your account administrator. Read User Types to know about the different types of user accounts in Trello.


Obtaining the API Key and Server Token

Hevo uses an API token to authenticate itself on your Trello account.

Perform the following steps to create the access token:

  1. Log in to your Trello account.

  2. Visit Developers API Keys to obtain API Key and Server Token.

  3. In the Developers API Keys section, copy the Personal Key and save it securely like any other password.

    API-Key

  4. To retrieve the Server Token, in the Developers API Keys section, click Token.

    Hyperlink-token

  5. In the Server Token page, scroll down to the bottom, and click Allow.

    Click-allow

  6. Copy the token and save it securely like any other password.

    Server-token

You have successfully obtained your API Key and Server Token. Use these for creating Hevo Pipelines.


Configuring Trello as a Source

Perform the following steps to configure Trello as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Trello.

  4. In the Configure your Trello Source page, specify the following:

    Source-config

    • Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.

    • API Key: The API Key that you obtained and copied from your Trello account.

    • Server Token: The Server Token that you obtained and copied from your Trello account to authenticate Hevo to read your Source data.

  5. Click TEST & CONTINUE.

  6. Proceed to configuring the data ingestion and setting up the Destination.


Data Replication

Default Pipeline Frequency Minimum Pipeline Frequency Maximum Pipeline Frequency Custom Frequency Range (Hrs)
1 Hr 1 Hr 24 Hrs 1-24

Note: You must set the custom frequency in hours as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

  • Historical Data: In the first run of the Pipeline, Hevo ingests all historical data for all the objects except Cards and Actions objects and loads it to the Destination.

  • Incremental Data: Once the historical load is complete, all new and updated records for the Cards object is synchronized with your Destination as per the Pipeline frequency.


Source Considerations

  • Pagination: An API response for each Trello object fetches one page with up to 1000 records.

  • Rate Limit: Trello imposes a limit of a maximum of 30 API calls per second for each API Key and 10 API calls per second for each Server token, except for the Boards object, which has a limit of 6 calls per minute, to ensure that their system remains stable for usage by all users.


Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination database:


Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object Mode Description
Actions Incremental Contains the details of all the actions associated with Trello entities. For example, Trello action addAttachmentToCard means that attachment was added to a card.
Boards Full Contains the details of all the projects, teams, or workflows in an organized order.
Boards allows you to organize your tasks which helps you to collaborate with your colleagues.
Cards Incremental Contains the details of all the tasks and ideas within a board.
Checklists Full Contains the list of all the subtasks within a card.
Labels Full Contains the details of the color tags used to organize cards within your Trello account.
It is used to track which types of activities your team is spending time on.
Lists Full Contains the details of all the cards, to keep track of their progress.
A card is a collection of ideas, things to remember, or different stages of a workflow.
Members Full Contains the details of all the users who are given access to workspaces, projects, and tasks in your Trello account.

Limitations

  1. Hevo does not capture information for records deleted in the Source objects.

  2. Hevo does not provide you with the option to select the historical sync duration for loading historical data. All the historical data in your Harvest account is loaded.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-08-2022 2.01 New document.
Last updated on 08 Nov 2022

Tell us what went wrong