How can I download my board data on trello automatically via API ?

[Marcel Olmo]

Hi guys,

I've recently joined the Trello community, and I've started to use the boards, lists, cards, etc.. with my colleagues.

I'd like to analyze our trello data into an external platform, and I've seen an article about how to export all your board related data here manually :

https://help.trello.com/article/747-exporting-data-from-trello-1

But I'd like to do it automatically via API. I've done my registration with my token and my key and I can do calls to the API like this :

https://api.trello.com/1/boards/[board_id]/lists?cards=open&card_fields=name&fields=name&key=[MyKey]&token=[MyToken]

But I get in return a Table named "RestConnectorMasterTable" with a mixture of fields that they are not the same as the field of the manual export.

Anybody knows how to do that?

Kind regards, Marcel.

[Iain Dooley]

@Marcel Olmo you can use Google Sheets for that:

http://www.littlebluemonkey.com/blog/automated-trello-reporting-using-google-spreadsheets

In fact, it was that guy's work upon which I based much of the early work I did with Trellinator:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

For example you could easily create a sheet on a daily basis with some card data in it.