Help Needed: Gathering Organization-wide Board and Card Counts

[Bruna Gonzaga]

Hello Community,

I'm reaching out to seek assistance regarding obtaining some general data from my organization. Despite my efforts, I've encountered difficulty in retrieving this information via APIs.

Specifically, I'm in need of acquiring the total number of boards existing within all the workspaces of my organization, along with the count of cards created within these boards. To clarify, I only require the total count of boards and cards; detailed information about the distribution of boards within each workspace is unnecessary for my current purpose.

I'm wondering if anyone has any insights or suggestions on how I might be able to gather this data efficiently?

Your assistance would be greatly appreciated.

[Lam]

Hi @Bruna Gonzaga - Thanks for reaching out the Community! We have a developer focussed Community here who may be better equiped to assist: https://community.developer.atlassian.com/c/trello/42

I can see that you've spoken to one of our Support folks recently about a similar question. It sounds like you're on the right track to grabbing that information through the API. As there isn't an endpoint that gives you the count of both your boards and the cards, you'll have to iterate over a few different endpoints to extrapolate that information:

- First you'll need to get a list of your organisations, you can make a GET request to this endpoint: https://developer.atlassian.com/cloud/trello/rest/api-group-enterprises/#api-enterprises-id-organizations-put

- Then iterate through the organizations/id/boards/ endpoint for all your organisations that you gathered above: https://developer.atlassian.com/cloud/trello/rest/api-group-organizations/#api-organizations-id-boards-get (At this point you'll get a number of Boards in your organisation

- Lastly, you can use the boards/id/cards endpoint for all the boards listed above to finally get all the cards within each board: https://developer.atlassian.com/cloud/trello/rest/api-group-boards/#api-boards-id-cards-get

If you'd rather get this information without the API then you can try generating a Workspace export instead: https://support.atlassian.com/trello/docs/exporting-data-from-trello/#Export-all-boards-within-a-Workspace - You will need to visit each Workspace and generate them one Workspace at a time

Please feel free to reply in the most recent ticket you had with our team if you require further assistance from us, we're happy to assist!  

[Rasmus Wulff Jensen]

If still relevant, then this tool can do it: https://trellotools.azurewebsites.net/Overview (it will take a bit of time collecting all the data live (below screenshot took ~35 sec to generate))