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:
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:
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.
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.
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:
Which does not exist. The correct URL is:
It also describes how to access the reports via the REST API via a query to:
But omits the required 'api.' at the start of the URL.
Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristjan Geir Mathiesen - Origo for sharing the picture of Taco having fun with his new friend...
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