Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Is it possible to automate exporting data to a JSON/EXCEL?

Is it possible to automate exporting data to a JSON/EXCEL?

In other words, is there a way of telling it to:

Create export file from the "Ad Hoc Board" each day at 6am and save it as:

"S:\EVERYONES_FOLDER\TRELLO_FILE.CSV"

thanks.

1 answer

0 votes
Mike Atlassian Team Mar 30, 2018

Hi Matt,

 

With Trello Business Class, you can export all of the boards for your organization via your organization's page in Trello. You can automate this process by using an undocumented API feature. If you're unfamiliar with the API, you can read more at https://developers.trello.com/. For a Python example of exporting your organization's data via the API, see https://github.com/bmccormack/trello-python-demo/blob/master/demo_bc_org_backup.py

You need to get a developer key and a user token like for any other API use.  The relevant routes are:

/1/organizations/:idOrganization/exports

This is used to begin an export.  It takes two arguments:

"attachments" should be either "true" or "false" (default: false); describes whether you want attachments in the export.

"attachment_age" should be a number between 0 and 3650 (default: 0); which attachments should be in the export.  If 0, gets all of them; if anything else, gets only attachments uploaded the past `attachment_age` days.

It returns a JSON object with the key "token".  You'll need to hold onto the token for the other routes.

/1/organizations/:idOrganization/exports/:token/status

Used to check the status of an export.  Returns a JSON object.  If it contains the key "complete", then the export has finished.  If it contains the key "error", then something went wrong and you should either try again or contact us.  You should not poll this URL more often than once per second; polling this URL at about once per minute is about right.

/1/organizations/:idOrganization/exports/:token/download

That should help get you started!

This response does not answer the original poster's question. The REST API endpoint described above does not produce a CSV export of the contents of a single board (IE all the board's cards and their fields). That REST API endpoint is used to trigger the creation of reports about boards, and those reports are the same three reports that can be generated from the Workspace Reports page, as described on this Automating Exports page.

There are numerous mistakes on that Automating Exports page, as it describes a URL:

https://trello.com/{workspaceName}/export

Which does not exist. The correct URL is:

https://trello.com/{workspaceName}/reports

It also describes how to access the reports via the REST API via a query to:

https://trello.com/1/organizations/{organizationNameOrId}/exports

But omits the required 'api.' at the start of the URL.

Suggest an answer

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

📹 Favorite Trello templates

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...

1,298 views 12 31
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