July 2021link
Now we use the Asana Batch API during the initial sync. According to our benchmarks, the initial sync time was reduced, on average, by 40 %. We are gradually rolling out this feature.
We added custom fields for the PROJECT table.
We added the following tables:
PORTFOLIOPORTFOLIO_MEMBERPORTFOLIO_ITEM
See our Asana ERD for details.
IMPORTANT: The current API user should be the owner of the portfolios to sync them.
Portfolios are available to Asana Business and Asana Enterprise customers. If you are not on any these plans, we cannot sync project-level custom fields and portfolio-related tables.
June 2021link
We have removed the hearted and assignee_status fields in the TASK table. See our March 2021 release note for details.
We have added a new field, num_likes, to replace the num_hearts field in the TASK table. Asana has deprecated the num_hearts field. We will deprecate the num_hearts field from the TASK table after July 31, 2021. Be sure to update your queries.
May 2021link
We have added a new field, current_status_color, to the PROJECT table to represent the overall state of the project (green - On Track, yellow - At Risk, red - Off Track, blue - On Hold).
March 2021link
We have added a new field, liked, to replace the hearted field in the TASK table. Asana has deprecated the hearted field. We will deprecate the hearted field from the TASK table after May 31, 2021. Be sure to update your queries.
We will deprecate the assignee_status field to support Asana’s breaking changes after May 31, 2021. Be sure to update your queries.
August 2020link
We have released a pre-built dbt package for Asana. Find the package in Fivetran’s dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.
June 2020link
You can now control which projects will be synced. Project IDs are now listed in the Specific Projects section of the Fivetran setup form.
May 2020link
You can now configure your Asana connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
February 2020link
We have added the completed_by_id column to the TASK table. Asana recently added this field to the Asana API Task endpoint. It lets you know who completed the task.
March 2019link
Added new field start_on to TASK table.
August 2018link
- We have added a new table,
TASK_SECTION, which is a join table of theTASKandSECTIONtables. - We have deprecated the
section_idcolumn from theTASKtable.
July 2018link
We have removed the STORY_EVENT table.