How to Interface Trello with Power BI using API

[Peter Cranston]

Hi I need a little guidance on using Trello API key to allow me to connect a Trello board to Power BI.

I was successfully using DOIT power up software however they have stopped supporting for new boards

The new board I wish to connect is IM 2024 AOP IM 2024 AOP | Trello

I can access Trello Power Ups administration and have created a power UP IM 2024 AOP however need clarification on the following to allow input into the following

Create a Web Data Source in Power BI: In Power BI Desktop, click Get Data -> Web. In the URL field, enter the following URL, replacing {BOARD_ID}, {YOUR_API_KEY}, and {YOUR_API_TOKEN} with your actual Board ID, API Key, and Token1:

https://api.trello.com/1/boards/{BOARD_ID}?key={YOUR_API_KEY}&token={YOUR_API_TOKEN}

Board ID: can you please confirm board id is the characters after b/ on the board URL i.e. rAfEDI4b and that this should be entered with the {} around it and no spaces

API Key: Please confirm that this is as per attached screenshot 01 and should be entered with the {}

API Token: Please confirm that this is the item marked secret on attached screenshot 01 and should be entered with the {}.

Allowed origins: Can you please also clarify what I should enter in the Allowed origins section of screenshot 01 or can I leave it blank.

IFrame connector for URL: Grateful if you can please advise what I should enter here on attached screenshot 02

Finally, as my clients reporting and connection sophistication grow, I would like to become more competent in API interfacing and would be grateful if you can advise which languages and protocols are associated with using Trello APIs so that I can find a suitable course online.

[Cody C_ · Accepted solution]

Hi Peter! You're on the right track, glad to help get you some answers.

Board ID: This is a 25 digit unique identifer for your board. The easiest way to get it is to load your board in your browser, then add .json to the end of the URL. It will be the first value in the "id" attribute.

API Key: Correct! It's that value in the API Key field there from your screenshot. It's entered without the braces {} when you make your API request

API Token: This value isn't your Secret, instead it's what you'll get when you click the "Token" link to the right of the API Key field from your 1st screenshot.

Allowed origins: Not needed, unless you're creating a Power-Up that you want other people to be able to use.

Iframe connector URL: Not needed, unless you're creating a Power-Up that you want other people to be able to use.

Something I should mention -- generally, we suggest keeping all of these values private, particularly your Secret and your Token. Never share these, especially the Token, as it can be used to access your account and take actions as yourself.

I've deleted the screenshots, but since they were public for a period of time I'd recommend resetting those values before you get started with your API requests, just to be sure everything remains secure.

As far as languages go, I'd recommend familiarizing yourself with CURL requests first, as they can be done from the command line without needing anything extra. There are also programs like Postman you can download that will help you send API requests, and save ones that you use regularly.

[Peter Cranston]

Many thanks for the reply. Also thanks for the security considerations. I have now changed the token. Now looking at CURL and Postman as suggested.

Regards,

Peter C.