Asana
On This Page
Asana is a project management tool that helps you to organize, track, and manage your work.
You can replicate the data from your Asana account to a Destination database or Data Warehouse using Hevo Pipelines.
Prerequisites
-
An active Asana account from which data has to be ingested.
-
The configured user has Admin or Owner privileges, to access all the projects.
Configuring Asana as a Source
Perform the following steps to configure Asana as the Source in your Pipeline:
-
Click PIPELINES in the Asset Palette.
-
Click + CREATE in the Pipelines List View.
-
In the Select Source Type page, select Asana.
-
In the Configure your Asana account page, click + Add Asana Account.
-
Sign in using your Asana account.
-
In the Configure your Asana Source page, specify the following:
-
Pipeline Name: A unique name for your Pipeline, not exceeding 255 characters.
-
Select Projects: Select at least one project whose data you would like to ingest.
-
Historical Sync Duration: The duration for which the historical data must be ingested. Default value: 6 Months.
-
-
Click TEST & CONTINUE.
-
Proceed to configuring the data ingestion and setting up the Destination.
Data Replication
-
Historical Data: In the first run of the Pipeline, Hevo ingests the data from the beginning of time for all the objects in your Asana account.
-
Incremental Data: Once the historical load is completed, every subsequent run of the Pipeline fetches the entire data for the objects you select. However, in case of the
Tasks
object, only the new and modified data is ingested.
Schema and Primary Keys
Hevo uses the following schema to upload the records in the Destination database:
Data Model
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
Object | Description |
---|---|
Portfolios | Contains an overview of the state of multiple projects, including a progress report and the most recent project status update. |
Portfolio Items | Contains the list of the projects in a portfolio. |
Projects | Contains the prioritized list of tasks in Asana or a board with columns of tasks represented as cards. A project is specific to an organization or workspace. |
Project Custom Fields | Contains the list of project-specific custom fields. For example, a priority value or a number representing the time required to complete a task. |
Project Followers | Contains a list of users following a project. Followers are the users who have opted in to receive tasks added notifications for a project. |
Project Members | Contains the list of users who are members of the project. |
Project Statuses | Contains the history of project status changes. |
Sections | Contains a group of tasks within a project. It can either be a header above a list of tasks in a list view or a column in a board view of a project. |
Tags | Contains the list of labels that can be attached to task in Asana. A tag is specific to an organization or workspace. |
Tags Followers | Contains the list of users following a tag. |
Tasks | Contains the list of different operations performed in Asana. |
Tasks Custom Fields | Contains the list of custom field values applied to the task. |
Tasks Dependencies | Contains the list of resources referencing tasks that a particular task depends on. The objects contain only the Global Identifier (GID) of the dependency. |
Tasks Dependents | Contains the IDs of the resources that depend on the task. |
Tasks Followers | Contains the list of users following the task. |
Tasks Memberships | Contains the list of projects that a task is associated with and the section it belongs to. At task creation time, this list can be used to add the task to specific sections. |
Tasks Tags | Contains the list of tags associated with the task. |
Teams | Contains the groups of related projects and people within an organization. |
Users | Contains the list of accounts in Asana that can be given access to various workspaces, projects, and tasks. |
Workspaces | Contains the list of projects and tasks that are associated with the workspace. |
Limitations
-
Portfolios are only available for Premium and Business plans in Asana.
-
The
Stories
object is not included in the schema due to API limitations. -
Hevo does not track any deletes for the Asana objects. Please reach out to Hevo Support if required.
See Also
Revision History
Refer to the following table for the list of key updates made to this page:
Date | Release | Description of Change |
---|---|---|
Jan-03-2022 | 1.79 | New document. |