![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/trello-logo.png\"){kind=logo}
<\/a>Trello is a popular project management platform used by teams worldwide to organize tasks, track progress, and collaborate on projects. Many applications and tools need to integrate with Trello data for reporting, analytics, and business intelligence. Using Zappysys ODBC Driver for Trello, you can easily query card data, lists, and board information from Trello using standard SQL queries without writing custom code.<\/p>\nThis tutorial demonstrates how to connect to Trello via ODBC and extract card and board data for use in your applications, databases, and reporting tools.<\/p>\n
<\/h3>\nPrerequisites<\/h2>\n\n- A Windows or Linux system with an ODBC driver manager installed.<\/li>\n
- An ODBC-compatible application (Excel, Power BI, Tableau, database tool, etc.).<\/li>\n
- A Trello account with at least one board and list created.<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\nGenerate Trello API Key and Token<\/h3>\n\n- Go to the Trello Power-up page<\/a> and log in to your account.<\/li>\n
- Create a new App and fill in the form.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Trello-Create-a-new-App.png\")
<\/a>Trello – Create a new App<\/p><\/p><\/div><\/li>\n
- Inside your new App, click the API key<\/strong>, then generate a new API Key.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/trello-API-key-page.png\")
<\/a>Trello – API key page<\/p><\/p><\/div><\/li>\n
- In the API Key section, click the Token<\/strong> link to generate an access token.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Trello-API-key-and-Token-link.png\")
<\/a>Trello – API key and Token link<\/p><\/div><\/li>\n
- Choose the token’s expiration time (Recommended: 30 days for security).<\/li>\n
- Review the permissions and click Create Token<\/strong>.<\/li>\n
- Copy the generated token and store it securely.<\/li>\n
- You now have both your API Key and Token. Keep these credentials confidential.<\/li>\n<\/ol>\n
Creating a new ODBC DSN using ZappySys JSON Driver<\/h3>\n\n- Search for ODBC<\/strong> in the Windows Start menu and open the ODBC Data Source Administrator<\/strong>.
\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\")
<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- In the ODBC Data Source Setup<\/strong> window, select the ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png\")
<\/a><\/li>\n<\/ol>\n\u00a0Configure the Connection and API Settings<\/h3>\n\n- In the Base URL<\/strong> field, enter the URL:\n
https:\/\/api.trello.com\/1\/members\/me\/boards?key={{TrelloApiKey}}&token={{TrelloToken}}<\/pre>\nFor more examples:
\nGET \/boards\/{boardId}\/cards \u2014 Retrieve all cards from a specific board<\/code>
\nGET \/boards\/{boardId}\/lists \u2014 Retrieve all lists from a specific board<\/code>
\nGET \/cards\/{cardId} \u2014 Retrieve details of a specific card
\n<\/code><\/li>\n- In the Request Method,<\/strong> use GET<\/strong><\/li>\n
- You can use the Array filter<\/strong> to get the object you need.<\/li>\n
- Test the connection to check everything is working fine\n<\/div>\n
- \n
- A Windows or Linux system with an ODBC driver manager installed.<\/li>\n
- An ODBC-compatible application (Excel, Power BI, Tableau, database tool, etc.).<\/li>\n
- A Trello account with at least one board and list created.<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\n
Generate Trello API Key and Token<\/h3>\n
- \n
- Go to the Trello Power-up page<\/a> and log in to your account.<\/li>\n
- Create a new App and fill in the form.\n
<\/a>Trello – Create a new App<\/p><\/p><\/div><\/li>\n
- Inside your new App, click the API key<\/strong>, then generate a new API Key.\n
<\/a>Trello – API key page<\/p><\/p><\/div><\/li>\n
- In the API Key section, click the Token<\/strong> link to generate an access token.\n
<\/a>Trello – API key and Token link<\/p><\/div><\/li>\n
- Choose the token’s expiration time (Recommended: 30 days for security).<\/li>\n
- Review the permissions and click Create Token<\/strong>.<\/li>\n
- Copy the generated token and store it securely.<\/li>\n
- You now have both your API Key and Token. Keep these credentials confidential.<\/li>\n<\/ol>\n
Creating a new ODBC DSN using ZappySys JSON Driver<\/h3>\n
- \n
- Search for ODBC<\/strong> in the Windows Start menu and open the ODBC Data Source Administrator<\/strong>.
\n<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- In the ODBC Data Source Setup<\/strong> window, select the ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
\n<\/a><\/li>\n<\/ol>\n\u00a0Configure the Connection and API Settings<\/h3>\n
- \n
- In the Base URL<\/strong> field, enter the URL:\n
https:\/\/api.trello.com\/1\/members\/me\/boards?key={{TrelloApiKey}}&token={{TrelloToken}}<\/pre>\nFor more examples:
\nGET \/boards\/{boardId}\/cards \u2014 Retrieve all cards from a specific board<\/code>
\nGET \/boards\/{boardId}\/lists \u2014 Retrieve all lists from a specific board<\/code>
\nGET \/cards\/{cardId} \u2014 Retrieve details of a specific card
\n<\/code><\/li>\n- In the Request Method,<\/strong> use GET<\/strong><\/li>\n
- You can use the Array filter<\/strong> to get the object you need.<\/li>\n
- Test the connection to check everything is working fine\n
<\/div>\n - In the Request Method,<\/strong> use GET<\/strong><\/li>\n
- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- Create a new App and fill in the form.\n
- Go to the Trello Power-up page<\/a> and log in to your account.<\/li>\n