Asana
Asana is a project management tool that helps teams track their tasks and projects.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | CUSTOM_FIELD, PROJECT, TASK, TAG, TEAM, USER, and WORKSPACE tables. |
| History mode | ||
| Custom data | check | TASK table |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Asana setup guide to connect Asana with your destination using Fivetran connectors.
Schema information
This schema applies to all Asana connections.
Limitations
Fivetran may not sync the data from your USER table because the Asana API may not return the corresponding data. We collect the USER data from various sources: USERS endpoint, PORTFOLIO, TAG, TASK, and PROJECT tables. If we don't receive this data after the sync, we consider it deleted.
Sync strategy
We perform incremental updates to project data by processing events received from the Events endpoint.
The sync token is used to receive new events only. However, if the sync token gets too old, the Asana API returns a 412 Precondition Failed error and includes a fresh sync token in the response. If this happens, we are forced to re-sync the whole project, which may increase MAR usage.