Get Trello Board tasks date to Power BI

[Diego Ferreira]

Hi, could please assist me here?

We need to get Trello data information for one specific board, we are able to do it by the API, although he isn't bringing us information like, "Task" and "Task Data"

How can we configure to bringing us these informations?

[Lam]

Hi @Diego Ferreira - Thanks for reaching out! When you say 'Task' are you referring to Trello's checklist items? If so then you can get the data through the 'checklists' endpoint shown here: https://developer.atlassian.com/cloud/trello/rest/api-group-checklists/#api-group-checklists - If you're using any third-party Power-Ups to store your task data then I would suggest reaching out to the Power-Up creators directly to see if they offer an API to programatically fetch your data. 

[Diego Ferreira]

I can bringing almost all information's from Trello do Power Bi by the API, the only that I can't bringing is the information about "Task Dates" we need these information to know if one task is expired or not.

[Lam]

Hi @Diego Ferreira - Are you using Trello's 'Advanced Checklists' or a Power-Up to store the tasks? 

If using Advanced Checklists then the tasks should be returned under the checkItems field: https://developer.atlassian.com/cloud/trello/rest/api-group-checklists/#api-checklists-id-get-request-Query%20parameters