Documentation

Documentation

  • Getting Started
  • Core Concepts
  • Using Fivetran
  • Usage-Based Pricing
  • Connectors
  • Applications
    • Application Reports
    • Lite Connectors
    • 15Five
    • 360Learning
    • 6sense
    • ActiveCampaign
    • Acumatica
    • Ada
    • Adjust
    • Adobe Analytics
    • Adobe Analytics Data Feed
    • Adobe Commerce
    • ADP Workforce Now
    • AdRoll
    • Affinity
    • Afterpay
    • Aha
    • Aircall
    • Airtable
    • Alchemer
    • Algolia
    • Amazon Ads
    • Amazon Attribution
    • Amazon Cloudfront
    • Amazon Selling Partner
    • Amplitude
    • Anaplan
    • Appcues
    • Appfigures
    • Apple App Store
    • Apple Search Ads
    • AppsFlyer
    • Asana
      • Setup Guide
      • Release Notes
    • Assembled
    • Attentive
    • Attio
    • Aumni
    • Auth0
    • Autodesk BIM 360
    • AvantLink
    • Awin
    • AWS CloudTrail
    • AWS Cost Explorer
    • AWS Inventory
    • Azure Boards
    • Azure Devops
    • BallotReady
    • BambooHR
    • BigCommerce
    • BillingPlatform
    • Birdeye
    • Bitly
    • Blackboard
    • Braintree
    • Branch
    • Braze
    • Brevo
    • Brex
    • Buildkite
    • Buzzsprout
    • Calabrio
    • Calendly
    • Campaign Monitor
    • Canny
    • Canvas
    • Care Quality Commission
    • Castor EDC
    • Ceridian Dayforce
    • Chameleon
    • ChannelAdvisor
    • Chargebee
    • ChargeDesk
    • ChartMogul
    • Checkout.com
    • Chorus
    • Churnkey
    • ChurnZero
    • Cimis
    • Cin7
    • CircleCI
    • Clari
    • ClickUp
    • Close
    • Coassemble
    • Codefresh
    • Collibra
    • Column
    • commercetools
    • Confluence
    • Contrast Security
    • Copper
    • Coupa
    • Criteo
    • Crossbeam
    • crowd.dev
    • Customer.io
    • Cvent
    • D2L Brightspace
    • dbt Cloud
    • DCL Logistics
    • DEAR
    • Delighted
    • Deputy
    • Destini
    • Dixa
    • Docebo
    • Drata
    • Drift
    • Drip
    • Dropbox Sign
    • Duoplane
    • e-conomic
    • EasyPost
    • Ellucian Banner
    • Eloqua
    • Employment Hero
    • Epicor Prophet 21
    • Eventbrite
    • Everhour
    • Expensify
    • EZOfficeInventory
    • Facebook Ads
    • Facebook Pages
    • FinancialForce
    • Flexport
    • Float
    • Fone Dynamics
    • Forj Community
    • Fountain
    • Freightview
    • FreshBooks
    • Freshchat
    • Freshdesk
    • Freshdesk Contact Center
    • Freshservice
    • Freshsuccess
    • Freshteam
    • Friendbuy
    • Front
    • FullStory
    • Gainsight Customer Success
    • Gem
    • GetFeedback
    • GitHub
    • Gladly
    • GlobalMeet
    • GoCardless
    • Gong
    • Google Ad Manager
    • Google Ads
    • Google Analytics
    • Google Analytics (MCF)
    • Google Analytics 360
    • Google Analytics 4
    • Google Analytics 4 Export
    • Google Calendar
    • Google Campaign Manager 360
    • Google Display & Video 360
    • Google Play
    • Google Search Ads 360
    • Google Search Console
    • Google Tasks
    • Gorgias
    • Greenhouse
    • GreenPowerMonitor
    • Grepsr
    • GRIN
    • Guru
    • HappyFox
    • Harvest
    • Heap
    • Height
    • Help Scout
    • Helpshift
    • HiBob
    • Hopin
    • HubSpot
    • iLevel
    • Impact
    • incident.io
    • Infobip
    • Insightly
    • Instagram Business
    • Integral Ad Science
    • Integrate
    • Intercom
    • Ironclad
    • ironSource
    • Iterable
    • Ivanti
    • Jira
    • Jira Align
    • Jotform
    • JustCall
    • Kandji
    • Katana
    • KeyPay
    • Khoros Care
    • Kissmetrics
    • Klarna
    • Klaviyo
    • Konnect Insights
    • Kustomer
    • Lattice
    • LaunchDarkly
    • LearnUpon
    • Lessonly
    • Lever
    • Liftoff
    • Lightspeed Retail
    • Linear
    • LinkedIn Ad Analytics
    • LinkedIn Company Pages
    • LinkSquares
    • LiveChat
    • Loaded Commerce
    • Lob
    • Looker
    • Loop
    • Loopio
    • Luma
    • Magento
    • Mailchimp
    • Mailgun
    • Mandrill
    • Marin Software
    • Marketo
    • Mavenlink
    • Maxio Chargify
    • Medallia
    • Megaphone
    • Meltwater
    • Mention
    • Microsoft Advertising
    • Microsoft Dynamics
    • Microsoft Lists
    • Microsoft Teams
    • Mixmax
    • Mixpanel
    • MNTN
    • Mode
    • Moloco
    • Monday.com
    • Mux
    • Namely
    • Navan
    • nCino
    • NetSuite SuiteAnalytics
    • Notion
    • Nylas
    • Okta
    • Ometria
    • Open Data DC
    • Open Exchange Rates
    • Opsgenie
    • Optimizely
    • Oracle Business Intelligence Publisher
    • Oracle E-Business Suite
    • Oracle Fusion Cloud Applications
    • Oracle Moat Analytics
    • Oracle PeopleSoft
    • Oracle Siebel CRM
    • Orbit
    • Ordway
    • Ortto
    • OsCommerce
    • Outbrain
    • Outreach
    • PagerDuty
    • Papershift
    • Pardot
    • PartnerStack Vendor
    • Paychex
    • PayPal
    • Pendo
    • Persona
    • Personio
    • Pingdom
    • Pinpoint
    • Pinterest Ads
    • Pipe17
    • Pipedrive
    • Pivotal Tracker
    • Piwik PRO
    • Playvox
    • PostHog
    • PowerReviews Enterprise
    • PowerSchool
    • PrestaShop
    • Prive
    • Productboard
    • Qualaroo
    • Qualtrics
    • QuickBooks
    • Ramp
    • Rarible
    • Recharge
    • Recurly
    • Reddit Ads
    • Reltio
    • Reply
    • RetailNext
    • Retently
    • Revel Systems
    • RevOps
    • RevX
    • RingCentral
    • Rippling
    • Rollbar
    • Rootly
    • RTB House
    • Sage HR
    • Sage Intacct
    • Sailthru
    • Salesforce
    • Salesforce Commerce Cloud
    • Salesforce Marketing Cloud
    • Salesloft
    • Salsify
    • Samsara
    • SAP Business ByDesign
    • SAP Business One
    • SAP Concur
    • SCORM
    • Security Journey
    • SendGrid
    • Sensor Tower
    • ServiceNow
    • ServiceTitan
    • Sharetribe
    • ShipHero
    • ShipStation
    • Shopify
    • Shopware
    • Short.io
    • Shortcut
    • Simplecast
    • Simplesat
    • Skilljar
    • SkuVault
    • Slab
    • Slack
    • Smadex
    • Smartwaiver
    • Snapchat Ads
    • SonarQube
    • Split
    • Splunk
    • Spotify Ads
    • Spree Commerce
    • Square
    • Squarespace
    • StackAdapt
    • Standard Metrics
    • Statsig
    • Statuspage
    • Stripe
    • Stylight
    • Subscript
    • SurveyMonkey
    • Survicate
    • Swoogo
    • Tableau
    • Taboola
    • Talkdesk
    • Talkwalker
    • Teamwork
    • Tempo
    • The Trade Desk
    • Thinkific
    • TikTok Ads
    • Toggl Track
    • Transcend
    • Trello
    • Trisolute
    • Twilio
    • Twitter Ads
    • Twitter Organic
    • Typeform
    • Unicommerce
    • Upland Software
    • UpPromote
    • UserVoice
    • Veeva
    • Verizon Media
    • Vitally
    • Vonage
    • VWO
    • Web Scraper
    • When I Work
    • Wherefour
    • WooCommerce
    • WordPress
    • Workable
    • Workday Financial Management
    • Workday HCM
    • Workday RaaS
    • Workday Strategic Sourcing
    • WorkflowMax
    • WorkRamp
    • Wrike
    • Xero
    • Xray
    • Yahoo DSP
    • Yahoo Search Ads on Yahoo Japan
    • Yotpo
    • YouTube Analytics
    • Zen Cart
    • Zendesk Chat
    • Zendesk Sell
    • Zendesk Sunshine
    • Zendesk Support
    • Zenefits
    • Zingtree
    • Zoho Books
    • Zoho Campaigns
    • Zoho CRM
    • Zoho Desk
    • Zoom
    • Zuora
  • Databases
  • Files
  • Events
  • Functions
  • Destinations
  • Partner-Built
  • Transformations
  • Logs
  • Security
  • REST API
  • Local Data Processing (HVR 6)
  • Release Notes
RSS
Release notes RSS
HVR 5 Documentation
HVR 5 Documentation
  • Support
  • Sign In

Release Noteslink


April 2023link

We have added a new optional toggle, Show Advanced Options, to the connector setup form. The toggle allows you to filter the project list by team ID when you select the Synchronize specific projects sync mode. For more information, see our setup instructions.


December 2022link

We have added a new table, GOAL_RELATIONSHIP, which stores information about the relationship between a goal and another goal, a project, or a portfolio.

We will deprecate the GOAL_SUPPORTING_WORK table on February 1, 2023. Be sure to update your queries.


September 2022link

We now check the following columns of the following user-related tables during the sync to ensure data completeness in the USER table:

TABLECOLUMNS
PORTFOLIOowner_id and created_by_id
PORTFOLIO_MEMBERuser_id
STORYcreated_by_id
STORY_HEARTuser_id
TASKassignee_id and completed_by_id
TASK_FOLLOWERuser_id
TAG_FOLLOWERuser_id

Previously, some user records synced to the USER table might have been missed during syncs.


July 2022link

We have added the Date and Person custom fields to the TASK and PORTFOLIO tables.


April 2022link

We have added the following new tables that store data about goals in Asana:

  • GOAL
  • GOAL_FOLLOWER
  • GOAL_STATUS
  • GOAL_SUPPORTING_WORK

March 2022link

We now sync a new column, created_by_id, to the TASK table.


January 2022link

We now sync a new column, portfolio_id, and portfolio custom fields to the CUSTOM_FIELD table.


December 2021link

We have added a new table, PROJECT_STATUS, that stores historical information about project status changes.

We now sync the following custom field properties to the CUSTOM_FIELD table:

  • id
  • name
  • description
  • type
  • workspace_id
  • project_id

November 2021link

We have added a new column, resource_subtype, to the TASK table.

If you want to sync historical data for this column, contact Fivetran Support to re-sync the TASK table.


October 2021link

We now sync the Multi-select enums custom field.


September 2021link

Our Asana connector now uses multithreading when syncing projects. To avoid exceeding API rate limits, we use 3 parallel threads for Asana Basic accounts and 10 parallel threads for Asana Premium, Business, and Enterprise accounts.


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 have added custom fields for the PROJECT table.

We have added the following tables:

  • PORTFOLIO
  • PORTFOLIO_MEMBER
  • PORTFOLIO_ITEM

IMPORTANT: The current API user should be the owner of the portfolios to sync the tables. 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 from the TASK table.

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 expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the Asana connector by adding the auth section to payloads.

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 pre-built, dbt Core-compatible data models for Asana. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.


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 the TASK and SECTION tables.
  • We have deprecated the section_id column from the TASK table.

July 2018link

We have removed the STORY_EVENT table.


Questions?

We're always happy to help with any other questions you might have! Send us an email.

    Thanks for your feedback!
    Was this page helpful?