Export asana project in csv via API

Question

I want to regularly export a project from Asana in csv, programatically. An example of how to do this manually is here.

My objective is to have a frequently updated list of all tasks and where they are in the project (what "column") for reporting purposes. Getting the data is my current bottleneck, the rest can be done with basic Python.

Ideally I'd like to use the Asana python API, but can also be via the command line if easier.

Question: How can I programmatically export a project in csv format from Asana?

Answer 1

Is there a particular reason you need the project data in CSV format? I recommend you request the project you need via the Asana API:

GET https://app.asana.com/api/1.1/projects/<project-id>/tasks

This will return the tasks in a project in JSON format (you can later convert JSON to CSV if there is a particular reason you need that format). You can use options in your request if you want the response to contain certain data.

Depending on your use case, you could also use the events endpoint if you just want to see what has changed in a project. Depending on your technical ability, you could also look into implementing webhooks, though this is a more advanced option than using events.

Answer 2

If you still need a solution on automating the process, you can set it up with Import2 Wizard.

The first time you set up export Projects and Tasks from Asana into a CSV file configuring the mappings the way you need it.

Then you just set up how often you want to run it: weekly, daily etc.

Disclaimer: I am with the Import2 team