Asana (v2) | Stitch Documentation

Asana is supported by the Singer community
This integration is powered by Singer's Asana tap. For support, visit the GitHub repo or join the Singer Slack.

Asana integration summary

Stitch’s Asana integration replicates data using the Asana API. Refer to the Schema section for a list of objects available for replication.

Asana feature snapshot

A high-level look at Stitch's Asana (v2) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on March 5, 2020	Supported by	Singer Community
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-asana
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Asana

Asana setup requirements

To set up Asana in Stitch, you need:

Access to all the data you want to replicate in Asana. This includes projects, tasks, tags, users, and workspaces. If the user authorizing the integration in Stitch doesn’t have access to something in Asana, Stitch will be unable to replicate it.

Step 1: Add Asana as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Asana icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Asana” would create a schema called stitch_asana in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Asana integration. This means that:

For tables using Key-based Incremental Replication, data equal to or newer than this date will be replicated to your destination.
For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your destination.

Change this setting if you want to replicate data beyond Asana’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Asana integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Asana

Next, you’ll be prompted to sign into your Asana account.
Enter your Asana credentials and sign into your account.
After the authorization process is successfully completed, you’ll be directed back to Stitch.
Click All Done.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Asana integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Asana, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Asana table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 2 of this integration.

This is the latest version of the Asana integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

portfolios

View table schema on GitHub

Replication Method :	Full Table	Primary Key :	gid
API endpoint :	Get multiple portfolios

The portfolios table contains info about the portfolios in your Asana account.

Custom fields

To replicate task custom fields, select the custom_fields attribute in Stitch. If your destination doesn’t natively support nested data structures, two subtables (tasks__custom_fields, tasks__custom_fields__enum_options) will be created.

portfolios table schema

archived
BOOLEAN

color
STRING

completed
BOOLEAN

completed_at
DATE-TIME

completed_by
OBJECT

Click to expand completed_by

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), completed_by (attribute)

created_at
DATE-TIME

created_by
OBJECT

Click to expand created_by

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), created_by (attribute)

created_from_template
OBJECT

Click to expand created_from_template

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), created_from_template (attribute)

current_status
STRING

current_status_update
OBJECT

Click to expand current_status_update

gid
STRING

resource_type
STRING

resource_subtype
STRING

title
STRING

portfolios (table), current_status_update (attribute)

custom_field_settings
ARRAY

Click to expand custom_field_settings

gid
STRING

resource_type
STRING

custom_field
OBJECT

Click to expand custom_field

gid
STRING

resource_type
STRING

created_by
OBJECT

Click to expand created_by

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), created_by (attribute)

currency_code
STRING

custom_label
STRING

custom_label_position
STRING

date_value
OBJECT

Click to expand date_value

date
STRING

date_time
DATE-TIME

portfolios (table), date_value (attribute)

description
STRING

display_value
STRING

enabled
BOOLEAN

enum_options
ARRAY

Click to expand enum_options

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_options (attribute)

enum_value
OBJECT

Click to expand enum_value

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_value (attribute)

format
STRING

has_notifications_enabled
BOOLEAN

is_global_to_workspace
BOOLEAN

multi_enum_values
ARRAY

Click to expand multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

portfolios (table), multi_enum_values (attribute)

name
STRING

number_value
NUMBER

people_value
ARRAY

Click to expand people_value

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), people_value (attribute)

precision
INTEGER

resource_subtype
STRING

text_value
STRING

type
STRING

portfolios (table), custom_field (attribute)

is_important
BOOLEAN

parent
OBJECT

Click to expand parent

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), parent (attribute)

project
OBJECT

Click to expand project

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), project (attribute)

portfolios (table), custom_field_settings (attribute)

custom_fields
ARRAY

Click to expand custom_fields

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

type
STRING

enum_options
ARRAY

Click to expand enum_options

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_options (attribute)

enum_value
OBJECT

Click to expand enum_value

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

portfolios (table), enum_value (attribute)

enabled
BOOLEAN

text_value
STRING

number_value
NUMBER

description
STRING

precision
INTEGER

is_global_to_workspace
BOOLEAN

has_notifications_enabled
BOOLEAN

date_value
OBJECT

Click to expand date_value

date
STRING

date_time
DATE-TIME

portfolios (table), date_value (attribute)

display_value
STRING

multi_enum_values
ARRAY

Click to expand multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

portfolios (table), multi_enum_values (attribute)

portfolios (table), custom_fields (attribute)

default_view
STRING

due_date
STRING

due_on
STRING

followers
ARRAY

Click to expand followers

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), followers (attribute)

gid
STRING

html_notes
STRING

icon
STRING

is_template
BOOLEAN

members
ARRAY

Click to expand members

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), members (attribute)

modified_at
DATE-TIME

name
STRING

notes
STRING

owner
OBJECT

Click to expand owner

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), owner (attribute)

permalink_url
STRING

portfolio_items
ARRAY

Click to expand portfolio_items

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), portfolio_items (attribute)

project_brief
OBJECT

Click to expand project_brief

gid
STRING

resource_type
STRING

portfolios (table), project_brief (attribute)

public
BOOLEAN

resource_type
STRING

start_on
STRING

team
OBJECT

Click to expand team

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), team (attribute)

workspace
OBJECT

Click to expand workspace

gid
STRING

resource_type
STRING

name
STRING

portfolios (table), workspace (attribute)

projects

View table schema on GitHub

Replication Method :	Key-based Incremental	Replication Key :	modified_at
Primary Key :	gid	Official docs :	Official Docs

The projects table contains info about the projects the user who authorized the Asana integration in Stitch has access to.

projects table schema

archived
BOOLEAN

color
STRING

completed
BOOLEAN

completed_at
DATE-TIME

completed_by
OBJECT

Click to expand completed_by

gid
STRING

resource_type
STRING

name
STRING

projects (table), completed_by (attribute)

created_at
DATE-TIME

created_from_template
OBJECT

Click to expand created_from_template

gid
STRING

resource_type
STRING

name
STRING

projects (table), created_from_template (attribute)

current_status
STRING

current_status_update
OBJECT

Click to expand current_status_update

gid
STRING

resource_type
STRING

resource_subtype
STRING

title
STRING

projects (table), current_status_update (attribute)

custom_field_settings
ARRAY

Click to expand custom_field_settings

gid
STRING

resource_type
STRING

custom_field
OBJECT

Click to expand custom_field

gid
STRING

resource_type
STRING

created_by
OBJECT

Click to expand created_by

gid
STRING

resource_type
STRING

name
STRING

projects (table), created_by (attribute)

currency_code
STRING

custom_label
STRING

custom_label_position
STRING

date_value
OBJECT

Click to expand date_value

date
STRING

date_time
DATE-TIME

projects (table), date_value (attribute)

description
STRING

display_value
STRING

enabled
BOOLEAN

enum_options
ARRAY

Click to expand enum_options

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_options (attribute)

enum_value
OBJECT

Click to expand enum_value

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_value (attribute)

format
STRING

has_notifications_enabled
BOOLEAN

is_global_to_workspace
BOOLEAN

multi_enum_values
ARRAY

Click to expand multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

projects (table), multi_enum_values (attribute)

name
STRING

number_value
NUMBER

people_value
ARRAY

Click to expand people_value

gid
STRING

resource_type
STRING

name
STRING

projects (table), people_value (attribute)

precision
INTEGER

resource_subtype
STRING

text_value
STRING

type
STRING

projects (table), custom_field (attribute)

is_important
BOOLEAN

parent
OBJECT

Click to expand parent

gid
STRING

resource_type
STRING

name
STRING

projects (table), parent (attribute)

project
OBJECT

Click to expand project

gid
STRING

resource_type
STRING

name
STRING

projects (table), project (attribute)

projects (table), custom_field_settings (attribute)

custom_fields
ARRAY

Click to expand custom_fields

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

type
STRING

enum_options
ARRAY

Click to expand enum_options

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_options (attribute)

enum_value
OBJECT

Click to expand enum_value

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

projects (table), enum_value (attribute)

enabled
BOOLEAN

text_value
STRING

number_value
NUMBER

description
STRING

precision
INTEGER

is_global_to_workspace
BOOLEAN

has_notifications_enabled
BOOLEAN

date_value
OBJECT

Click to expand date_value

date
STRING

date_time
DATE-TIME

projects (table), date_value (attribute)

display_value
STRING

multi_enum_values
ARRAY

Click to expand multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

projects (table), multi_enum_values (attribute)

projects (table), custom_fields (attribute)

default_view
STRING

due_date
STRING

due_on
STRING

followers
ARRAY

Click to expand followers

gid
STRING

resource_type
STRING

name
STRING

projects (table), followers (attribute)

gid
STRING

html_notes
STRING

icon
STRING

is_template
BOOLEAN

members
ARRAY

Click to expand members

gid
STRING

resource_type
STRING

name
STRING

projects (table), members (attribute)

modified_at
DATE-TIME

name
STRING

notes
STRING

owner
OBJECT

Click to expand owner

gid
STRING

resource_type
STRING

name
STRING

projects (table), owner (attribute)

permalink_url
STRING

project_brief
OBJECT

Click to expand project_brief

gid
STRING

resource_type
STRING

projects (table), project_brief (attribute)

public
BOOLEAN

resource_type
STRING

start_on
STRING

team
OBJECT

Click to expand team

gid
STRING

resource_type
STRING

name
STRING

projects (table), team (attribute)

workspace
OBJECT

Click to expand workspace

gid
STRING

resource_type
STRING

name
STRING

projects (table), workspace (attribute)

sections

View table schema on GitHub

Replication Method :	Full Table	Primary Key :	gid
API endpoint :	Get sections in a project

The sections table contains info about sections within specified projects in your Asana account.

sections table schema

created_at
DATE-TIME

gid
STRING

name
STRING

project
OBJECT

Click to expand project

gid
STRING

resource_type
STRING

name
STRING

sections (table), project (attribute)

projects
ARRAY

Click to expand projects

gid
STRING

resource_type
STRING

name
STRING

sections (table), projects (attribute)

resource_type
STRING

stories

View table schema on GitHub

Replication Method :	Key-based Incremental	Replication Key :	created_at
Primary Key :	gid	API endpoint :	Get stories from a task

The stories table contains info about all stories within specified tasks in your Asana account.

stories table schema

assignee
OBJECT

Click to expand assignee

gid
STRING

resource_type
STRING

name
STRING

stories (table), assignee (attribute)

created_at
DATE-TIME

created_by
OBJECT

Click to expand created_by

gid
STRING

resource_type
STRING

name
STRING

stories (table), created_by (attribute)

custom_field
OBJECT

Click to expand custom_field

gid
STRING

resource_type
STRING

date_value
OBJECT

Click to expand date_value

date
STRING

date_time
DATE-TIME

stories (table), date_value (attribute)

display_value
STRING

enabled
BOOLEAN

enum_options
ARRAY

Click to expand enum_options

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), enum_options (attribute)

enum_value
OBJECT

Click to expand enum_value

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), enum_value (attribute)

multi_enum_values
ARRAY

Click to expand multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), multi_enum_values (attribute)

name
STRING

number_value
NUMBER

resource_subtype
STRING

text_value
STRING

type
STRING

stories (table), custom_field (attribute)

dependency
OBJECT

Click to expand dependency

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), dependency (attribute)

duplicate_of
OBJECT

Click to expand duplicate_of

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), duplicate_of (attribute)

duplicated_from
OBJECT

Click to expand duplicated_from

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), duplicated_from (attribute)

follower
OBJECT

Click to expand follower

gid
STRING

resource_type
STRING

name
STRING

stories (table), follower (attribute)

gid
STRING

hearted
BOOLEAN

hearts
ARRAY

Click to expand hearts

gid
STRING

user
OBJECT

Click to expand user

gid
STRING

resource_type
STRING

name
STRING

stories (table), user (attribute)

stories (table), hearts (attribute)

hearts
NULL

html_text
STRING

is_editable
BOOLEAN

is_edited
BOOLEAN

is_pinned
BOOLEAN

liked
BOOLEAN

likes
ARRAY

Click to expand likes

gid
STRING

user
OBJECT

Click to expand user

gid
STRING

resource_type
STRING

name
STRING

stories (table), user (attribute)

stories (table), likes (attribute)

likes
NULL

new_approval_status
BOOLEAN

new_date_value
OBJECT

Click to expand new_date_value

start_on
STRING

due_at
DATE-TIME

due_on
STRING

stories (table), new_date_value (attribute)

new_dates
OBJECT

Click to expand new_dates

due_at
DATE-TIME

due_on
DATE-TIME

start_on
DATE-TIME

stories (table), new_dates (attribute)

new_enum_value
OBJECT

Click to expand new_enum_value

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), new_enum_value (attribute)

new_multi_enum_values
ARRAY

Click to expand new_multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), new_multi_enum_values (attribute)

new_name
STRING

new_number_value
NUMBER

new_people_value
ARRAY

Click to expand new_people_value

gid
STRING

resource_type
STRING

name
STRING

stories (table), new_people_value (attribute)

new_resource_subtype
STRING

new_section
OBJECT

Click to expand new_section

gid
STRING

resource_type
STRING

name
STRING

stories (table), new_section (attribute)

new_text_value
STRING

num_hearts
INTEGER

num_likes
INTEGER

old_approval_status
STRING

old_date_value
OBJECT

Click to expand old_date_value

start_on
STRING

due_at
DATE-TIME

due_on
STRING

stories (table), old_date_value (attribute)

old_dates
OBJECT

Click to expand old_dates

due_at
DATE-TIME

due_on
DATE-TIME

start_on
DATE-TIME

stories (table), old_dates (attribute)

old_enum_value
OBJECT

Click to expand old_enum_value

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), old_enum_value (attribute)

old_multi_enum_values
ARRAY

Click to expand old_multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

stories (table), old_multi_enum_values (attribute)

old_name
STRING

old_number_value
NUMBER

old_people_value
ARRAY

Click to expand old_people_value

gid
STRING

resource_type
STRING

name
STRING

stories (table), old_people_value (attribute)

old_resource_subtype
STRING

old_section
OBJECT

Click to expand old_section

gid
STRING

resource_type
STRING

name
STRING

stories (table), old_section (attribute)

old_text_value
STRING

previews
ARRAY

Click to expand previews

fallback
STRING

footer
STRING

header
STRING

header_link
STRING

html_text
STRING

text
STRING

title
STRING

title_link
STRING

stories (table), previews (attribute)

previews
NULL

project
OBJECT

Click to expand project

gid
STRING

resource_type
STRING

name
STRING

stories (table), project (attribute)

resource_subtype
STRING

resource_type
STRING

source
STRING

sticker_name
STRING

story
OBJECT

Click to expand story

gid
STRING

resource_type
STRING

created_at
DATE-TIME

created_by
OBJECT

Click to expand created_by

gid
STRING

resource_type
STRING

name
STRING

stories (table), created_by (attribute)

resource_subtype
STRING

name
STRING

text
STRING

stories (table), story (attribute)

tag
OBJECT

Click to expand tag

gid
STRING

resource_type
STRING

name
STRING

stories (table), tag (attribute)

target
OBJECT

Click to expand target

gid
STRING

name
STRING

resource_type
STRING

resource_subtype
STRING

stories (table), target (attribute)

task
OBJECT

Click to expand task

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

stories (table), task (attribute)

text
STRING

type
STRING

tasks

View table schema on GitHub

Replication Method :	Key-based Incremental	Replication Key :	modified_at
Primary Key :	gid	Official docs :	Official Docs

The tasks table contains info about the tasks in your Asana account.

Custom fields

tasks table schema

approval_status
STRING

assignee
OBJECT

Click to expand assignee

gid
STRING

resource_type
STRING

name
STRING

tasks (table), assignee (attribute)

assignee_section
OBJECT

Click to expand assignee_section

gid
STRING

resource_type
STRING

name
STRING

tasks (table), assignee_section (attribute)

assignee_status
STRING

completed
BOOLEAN

completed_at
DATE-TIME

completed_by
OBJECT

Click to expand completed_by

gid
STRING

resource_type
STRING

name
STRING

tasks (table), completed_by (attribute)

created_at
DATE-TIME

custom_fields
ARRAY

Click to expand custom_fields

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

type
STRING

enum_options
ARRAY

Click to expand enum_options

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

tasks (table), enum_options (attribute)

enum_value
OBJECT

Click to expand enum_value

gid
STRING

resource_type
STRING

name
STRING

enabled
BOOLEAN

color
STRING

tasks (table), enum_value (attribute)

enabled
BOOLEAN

text_value
STRING

number_value
NUMBER

description
STRING

precision
INTEGER

is_global_to_workspace
BOOLEAN

has_notifications_enabled
BOOLEAN

created_by
OBJECT

Click to expand created_by

gid
STRING

resource_type
STRING

name
STRING

tasks (table), created_by (attribute)

currency_code
STRING

custom_label
STRING

custom_label_position
STRING

date_value
OBJECT

Click to expand date_value

date
STRING

date_time
DATE-TIME

tasks (table), date_value (attribute)

display_value
STRING

format
STRING

multi_enum_values
ARRAY

Click to expand multi_enum_values

gid
STRING

resource_type
STRING

color
STRING

enabled
BOOLEAN

name
STRING

tasks (table), multi_enum_values (attribute)

people_value
ARRAY

Click to expand people_value

gid
STRING

resource_type
STRING

name
STRING

tasks (table), people_value (attribute)

tasks (table), custom_fields (attribute)

dependencies
ARRAY

Click to expand dependencies

gid
STRING

resource_type
STRING

name
STRING

tasks (table), dependencies (attribute)

dependents
ARRAY

Click to expand dependents

gid
STRING

resource_type
STRING

name
STRING

tasks (table), dependents (attribute)

due_at
DATE-TIME

due_on
DATE-TIME

external
OBJECT

Click to expand external

gid
STRING

data
STRING

tasks (table), external (attribute)

followers
ARRAY

Click to expand followers

gid
STRING

resource_type
STRING

name
STRING

tasks (table), followers (attribute)

gid
STRING

hearted
BOOLEAN

hearts
ARRAY

Click to expand hearts

gid
STRING

user
OBJECT

Click to expand user

gid
STRING

resource_type
STRING

name
STRING

tasks (table), user (attribute)

tasks (table), hearts (attribute)

hearts
NULL

html_notes
STRING

is_rendered_as_seperator
BOOLEAN

liked
BOOLEAN

likes
ARRAY

Click to expand likes

gid
STRING

user
OBJECT

Click to expand user

gid
STRING

resource_type
STRING

name
STRING

tasks (table), user (attribute)

tasks (table), likes (attribute)

likes
NULL

memberships
ARRAY

Click to expand memberships

project
OBJECT

Click to expand project

gid
STRING

resource_type
STRING

name
STRING

tasks (table), project (attribute)

section
OBJECT

Click to expand section

gid
STRING

resource_type
STRING

name
STRING

tasks (table), section (attribute)

tasks (table), memberships (attribute)

memberships
NULL

modified_at
DATE-TIME

name
STRING

notes
STRING

num_hearts
INTEGER

num_likes
INTEGER

num_subtasks
INTEGER

parent
OBJECT

Click to expand parent

gid
STRING

resource_type
STRING

name
STRING

resource_subtype
STRING

tasks (table), parent (attribute)

permalink_url
STRING

projects
ARRAY

Click to expand projects

gid
STRING

resource_type
STRING

name
STRING

tasks (table), projects (attribute)

resource_subtype
STRING

resource_type
STRING

start_at
DATE-TIME

start_on
STRING

tags
ARRAY

Click to expand tags

gid
STRING

resource_type
STRING

name
STRING

tasks (table), tags (attribute)

workspace
OBJECT

Click to expand workspace

gid
STRING

resource_type
STRING

name
STRING

tasks (table), workspace (attribute)

teams

View table schema on GitHub

Replication Method :	Full Table	Primary Key :	gid
API endpoint :	Get teams for a user

The teams table contains info about teams that belong to a specified user in your Asana account.

teams table schema

description
STRING

gid
STRING

html_description
STRING

name
STRING

organization
OBJECT

Click to expand organization

gid
STRING

resource_type
STRING

name
STRING

teams (table), organization (attribute)

permalink_url
STRING

resource_type
STRING

users
ARRAY

Click to expand users

gid
STRING

resource_type
STRING

name
STRING

teams (table), users (attribute)

visibility
STRING

users

View table schema on GitHub

Replication Method :	Full Table	Primary Key :	gid
Official docs :	Official Docs

The users table contains info about the users in your Asana account.

users table schema

email
STRING

gid
STRING

name
STRING

photo
OBJECT

Click to expand photo

image_21x21
STRING

image_27x27
STRING

image_36x36
STRING

image_60x60
STRING

image_128x128
STRING

image_1024x1024
STRING

users (table), photo (attribute)

resource_type
STRING

workspaces
ARRAY

Click to expand workspaces

gid
STRING

resource_type
STRING

name
STRING

users (table), workspaces (attribute)

workspaces

View table sch