Integration with Asana

[tsw-attila]

Tell us about the new integration you’d like to have

Which source and which destination? Which frequency?

Describe the context around this new integration

Which team in your company wants this integration, what for? This helps us understand the use case.

Describe the alternative you are considering or using

What are you considering doing if you don’t have this integration through Airbyte?

Would be great to add Asana to your sources.

┆Issue is synchronized with this Asana task by Unito

[sherifnada]

@tsw-attila thanks for your request. Could you give us some context on the connector by answering the questions in the issue description? Specifically:

• Which sources/destinations you'd like to use in conjunction with Asana
• What is your usecase for replicating asana data?
• Would you be open to contributing the connector?

[hoanghapham]

Not sure about the OP's use case, but I am also interested in this.
I am looking for a way to pull Asana task statistics into our BigQuery data warehouse to have visibility of our operations. Questions that we have are:

• How long does it take for a task to be completed? Break down to team members.
• What are the task types that take the longest to complete? (by using tags as a dimension)

So far I see Stitch has an integration. However I am considering using Airbyte for other ETL tasks within the company, so if Asana is supported, we do not need to add another tool to the stack.

[sherifnada]

@hoanghapham thanks for the context! We'll scope this work soon. Could you let us know: which of the Asana API endpoints do you need support for?

[tsw-attila]

@tsw-attila thanks for your request. Could you give us some context on the connector by answering the questions in the issue description? Specifically:

• Which sources/destinations you'd like to use in conjunction with Asana
• What is your usecase for replicating asana data?
• Would you be open to contributing the connector?

Hi @sherifnada thank you for getting in touch. First thing, I'm a novice so bear with me if my responses do not properly address the questions you asked.

• I would probably use BigQuery or PostgreSQL as the destination
• [Use case is quite confusing] I am looking to analyse the asana data for performance on the various tasks, projects, and teams
• Not sure how I can do that as a non-programmer. I only have basic working knowledge of SQL. I use BI tools extensively for analysis, and that's where it ends for me.

[sherifnada]

@tsw-attila no problem! thanks for the information. Which API endpoints would you like to sync using the connector? API docs: https://developers.asana.com/docs

[hoanghapham]

@sherifnada the ones that I think our team will need are:

• Task
• Projects
• Users
• Teams, Team Memberships
• Events
• Stories
• Custom fields
• Tags

[sherifnada]

Deprioritized by one sprint, Will revisit next sprint (starting beginning of May)

[sherifnada]

Integration Vetting

Webhook-based? (no/partially/yes)
it is webhook-capable but most endpoints are standard REST

Available authentication modes (API key/Oauth/other)
API Key + OAuth

Creating an account
Created a free account. Also applied for a developer sandbox account.

How to populate the account with data?
Can it be done entirely through the API? yes

Available streams for sync
listed here: https://developers.asana.com/docs/

Integration supports incremental sync?
Some endpoints do. See the API reference for the various endpoints.

Requirements

We'd like to sync the following endpoints, incrementally wherever possible:
Custom fields
Events
Projects
Sections
Stories
Tags
Tasks
Teams, Team Memberships
Users
Workspaces

[sherifnada]

for subscription use the sandbox accounts available in lastpass.

[Zirochkaa]

@tsw-attila and @hoanghapham

We just merged this connector into master and released a new version of the connector.

The connector will be available in the next release of Airbyte (we usually release every Tuesday). If you can't wait and want to get started now trying it out in a running Airbyte instance, add the connector like described in https://docs.airbyte.io/integrations/custom-connectors#adding-your-connectors-in-the-ui . The information for the connector is:

Display Name: Asana
Docker repository name: airbyte/source-asana
Docker image tag: 0.1.0
Documentation URL: hub.docker.com/r/airbyte/source-asana

Please let us know if you have any further questions.

Enjoy!

[hoanghapham]

Awesome, thanks a lot @Zirochkaa !