It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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.

 

1 answer

0 votes
Iain Dooley Community Leader Oct 05, 2019

@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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,550 views 13 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you