Asana NA TEJ STRONIE
Asana is a team communication manager.
Asana integration replicates data using the Asana API .
See the
Schema section for a list of objects available for replication.
Migawka cech Ogólne informacje o tym łączniku, w tym przydatne linki i obsługiwane cechy.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Informacja Upewnij się, że używane konto ma uprawnienia do odczytu interesujących Cię tabel.
To retrieve your client ID and secret:
Log into your Asana account. In the My apps section, click Create new app . Complete the required information, then click Create app . Select the OAuth tab. Make sure Redirect URLs is set to https://connector.qlik.com/auth/oauth/v3.htm . In the Permission scopes section, select Full permissions . Select the Manage distribution tab. Click Add workspace . From the dropdown menu, select the workspace you want to replicate data from, then click Add . In the OAuth section, copy and paste your client secret and client ID into a secured file. Creating the connection Więcej informacji zawiera temat Łączenie się z aplikacjami SaaS
Po wprowadzaniu wymaganych ustawień połączenia kliknij przycisk Uwierzytelnij .
Możesz zostać poproszony o zalogowanie się w aplikacji źródłowej.
Zostanie wyświetlone okno z kodem uwierzytelniającym.
Skopiuj ten kod do schowka i wróć do okna dialogowego połączeń.
Wklej kod w polu Ukończ uwierzytelnianie przy użyciu kodu podanego przez źródło i kliknij przycisk Weryfikuj .
Wskazówka Być może trzeba będzie przewinąć w dół, aby zobaczyć to pole.
Status Zweryfikowano oznacza, że uwierzytelnianie zostało zweryfikowane.
Podaj nazwę połączenia w polu Nazwa połączenia .
Wybierz opcję Otwórz metadane połączenia , aby zdefiniować metadane połączenia po jegu utworzeniu.
Connection settings Setting Description Data gateway
Wybierz bramę Brama danych ruchu danych , jeżeli jest wymagana do danego zastosowania.
Informacja To pole jest niedostępne w subskrypcji Qlik Talend Cloud Starter , ponieważ brama Brama danych ruchu danych jest w niej nieobsługiwana. Jeśli masz inny poziom subskrypcji i nie chcesz korzystać z bramy Brama danych ruchu danych , wybierz opcję Brak .
Informacje o zaletach bramy Brama danych ruchu danych i o okolicznościach, w których jest wymagana, zawiera temat Brama danych Qlik — ruch danych
Start Date Wprowadź datę, w formacie MM/DD/YYYY, od której dane muszą być replikowane ze źródła do celu.
Client ID Client ID. Client Secret Client secret.
Informacja Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
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 foreign keys Join portfolios with on projects portfolios.created_by.gid = projects.followers.gid portfolios.members.gid = projects.followers.gid portfolios.owner.gid = projects.followers.gid portfolios.created_by.gid = projects.members.gid portfolios.members.gid = projects.members.gid portfolios.owner.gid = projects.members.gid portfolios.created_by.gid = projects.owner.gid portfolios.members.gid = projects.owner.gid portfolios.owner.gid = projects.owner.gid portfolios.workspace.gid = projects.workspace.gid tags portfolios.created_by.gid = tags.followers.gid portfolios.members.gid = tags.followers.gid portfolios.owner.gid = tags.followers.gid portfolios.workspace.gid = tags.workspace.gid tasks portfolios.created_by.gid = tasks.assignee.gid portfolios.members.gid = tasks.assignee.gid portfolios.owner.gid = tasks.assignee.gid portfolios.created_by.gid = tasks.followers.gid portfolios.members.gid = tasks.followers.gid portfolios.owner.gid = tasks.followers.gid portfolios.workspace.gid = tasks.workspace.gid users portfolios.created_by.gid = users.gid portfolios.members.gid = users.gid portfolios.owner.gid = users.gid portfolios.workspace.gid = users.workspaces.gid stories portfolios.created_by.gid = stories.assignee.gid portfolios.members.gid = stories.assignee.gid portfolios.owner.gid = stories.assignee.gid portfolios.created_by.gid = stories.created_by.gid portfolios.members.gid = stories.created_by.gid portfolios.owner.gid = stories.created_by.gid portfolios.created_by.gid = stories.dependency.gid portfolios.members.gid = stories.dependency.gid portfolios.owner.gid = stories.dependency.gid teams portfolios.created_by.gid = teams.users.gid portfolios.members.gid = teams.users.gid portfolios.owner.gid = teams.users.gid portfolios.workspace.gid = teams.organization.gid workspaces portfolios.workspace.gid = workspaces.gid
portfolios table schema
color
STRING
created_at
DATE-TIME
created_by
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
current_status_update
OBJECT
*
This is a nested data structure:
gid: STRING resource_subtype: STRING resource_type: STRING title: STRING
custom_field_settings
ARRAY
This is a nested data structure:
custom_field: OBJECT, which is also a nested data structure.
created_by: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING currency_code: STRING custom_label: STRING custom_label_position: STRING date_value: OBJECT, which is also a nested data structure.
date: STRING date_time: DATE-TIME description: STRING display_value: STRING enabled: BOOLEAN enum_options: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING enum_value: OBJECT, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING format: STRING gid: STRING has_notifications_enabled: BOOLEAN is_global_to_workspace: BOOLEAN multi_enum_values: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING name: STRING number_value: NUMBER people_value: ARRAY, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING precision: INTEGER resource_subtype: STRING resource_type: STRING text_value: STRING type: STRING gid: STRING is_important: BOOLEAN parent: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING project: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING resource_type: STRING
custom_fields
ARRAY
This is a nested data structure:
date_value: OBJECT, which is also a nested data structure.
date: STRING date_time: DATE-TIME display_value: STRING enabled: BOOLEAN enum_options: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING enum_value: OBJECT, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING gid: STRING multi_enum_values: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING name: STRING number_value: NUMBER resource_subtype: STRING resource_type: STRING text_value: STRING type: STRING
due_on
STRING
gid
STRING
is_template
BOOLEAN
members
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
name
STRING
owner
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
permalink_url
STRING
portfolio_items
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
public
BOOLEAN
resource_type
STRING
start_on
STRING
workspace
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
projects
The projects table contains info about the projects the user who authorized the Asana integration in Stitch has access to.
projects table foreign keys Join projects with on tasks projects.gid = tasks.projects.gid projects.followers.gid = tasks.assignee.gid projects.members.gid = tasks.assignee.gid projects.owner.gid = tasks.assignee.gid projects.followers.gid = tasks.followers.gid projects.members.gid = tasks.followers.gid projects.owner.gid = tasks.followers.gid projects.workspace.gid = tasks.workspace.gid stories projects.gid = stories.project.gid projects.followers.gid = stories.assignee.gid projects.members.gid = stories.assignee.gid projects.owner.gid = stories.assignee.gid projects.followers.gid = stories.created_by.gid projects.members.gid = stories.created_by.gid projects.owner.gid = stories.created_by.gid projects.followers.gid = stories.dependency.gid projects.members.gid = stories.dependency.gid projects.owner.gid = stories.dependency.gid sections projects.gid = sections.project.gid projects.gid = sections.projects.gid tags projects.followers.gid = tags.followers.gid projects.members.gid = tags.followers.gid projects.owner.gid = tags.followers.gid projects.workspace.gid = tags.workspace.gid users projects.followers.gid = users.gid projects.members.gid = users.gid projects.owner.gid = users.gid projects.workspace.gid = users.workspaces.gid portfolios projects.followers.gid = portfolios.created_by.gid projects.members.gid = portfolios.created_by.gid projects.owner.gid = portfolios.created_by.gid projects.followers.gid = portfolios.members.gid projects.members.gid = portfolios.members.gid projects.owner.gid = portfolios.members.gid projects.followers.gid = portfolios.owner.gid projects.members.gid = portfolios.owner.gid projects.owner.gid = portfolios.owner.gid projects.workspace.gid = portfolios.workspace.gid teams projects.followers.gid = teams.users.gid projects.members.gid = teams.users.gid projects.owner.gid = teams.users.gid projects.workspace.gid = teams.organization.gid workspaces projects.workspace.gid = workspaces.gid
projects table schema
archived
BOOLEAN
color
STRING
completed
BOOLEAN
completed_at
DATE-TIME
completed_by
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
created_at
DATE-TIME
created_from_template
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
current_status
STRING
current_status_update
OBJECT
This is a nested data structure:
gid: STRING resource_subtype: STRING resource_type: STRING title: STRING
custom_field_settings
ARRAY
This is a nested data structure:
custom_field: OBJECT, which is also a nested data structure.
created_by: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING currency_code: STRING custom_label: STRING custom_label_position: STRING date_value: OBJECT, which is also a nested data structure.
date: STRING date_time: DATE-TIME description: STRING display_value: STRING enabled: BOOLEAN enum_options: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING enum_value: OBJECT, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING format: STRING gid: STRING has_notifications_enabled: BOOLEAN is_global_to_workspace: BOOLEAN multi_enum_values: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING name: STRING number_value: NUMBER people_value: ARRAY, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING precision: INTEGER resource_subtype: STRING resource_type: STRING text_value: STRING type: STRING gid: STRING is_important: BOOLEAN parent: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING project: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING resource_type: STRING
custom_fields
ARRAY
This is a nested data structure:
date_value: OBJECT, which is also a nested data structure.
date: STRING date_time: DATE-TIME description: STRING display_value: STRING enabled: BOOLEAN enum_options: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING enum_value: OBJECT, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING gid: STRING has_notifications_enabled: BOOLEAN is_global_to_workspace: BOOLEAN multi_enum_values: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING name: STRING number_value: NUMBER precision: INTEGER resource_subtype: STRING resource_type: STRING text_value: STRING type: STRING
default_view
STRING
due_date
STRING
due_on
STRING
followers
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
gid
STRING
html_notes
STRING
icon
STRING
is_template
BOOLEAN
members
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
modified_at
DATE-TIME
name
STRING
notes
STRING
owner
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
permalink_url
STRING
project_brief
OBJECT
This is a nested data structure:
gid: STRING resource_type: STRING
public
BOOLEAN
resource_type
STRING
start_on
STRING
team
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
workspace
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
sections
The sections table contains info about sections within specified projects in your Asana account.
sections table foreign keys Join sections with on projects sections.project.gid = projects.gid sections.projects.gid = projects.gid tasks sections.project.gid = tasks.projects.gid sections.projects.gid = tasks.projects.gid stories sections.project.gid = stories.project.gid sections.projects.gid = stories.project.gid sections.gid = stories.new_section.gid sections.gid = stories.old_section.gid
sections table schema
created_at
DATE-TIME
gid
STRING
name
STRING
project
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
projects
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
resource_type
STRING
stories
The stories table contains info about all stories within specified tasks in your Asana account.
stories table foreign keys Join stories with on projects stories.project.gid = projects.gid stories.assignee.gid = projects.followers.gid stories.created_by.gid = projects.followers.gid stories.dependency.gid = projects.followers.gid stories.assignee.gid = projects.members.gid stories.created_by.gid = projects.members.gid stories.dependency.gid = projects.members.gid stories.assignee.gid = projects.owner.gid stories.created_by.gid = projects.owner.gid stories.dependency.gid = projects.owner.gid tasks stories.project.gid = tasks.projects.gid stories.task.gid = tasks.gid stories.assignee.gid = tasks.assignee.gid stories.created_by.gid = tasks.assignee.gid stories.dependency.gid = tasks.assignee.gid stories.assignee.gid = tasks.followers.gid stories.created_by.gid = tasks.followers.gid stories.dependency.gid = tasks.followers.gid sections stories.project.gid = sections.project.gid stories.project.gid = sections.projects.gid stories.new_section.gid = sections.gid stories.old_section.gid = sections.gid tags stories.tag.gid = tags.gid stories.assignee.gid = tags.followers.gid stories.created_by.gid = tags.followers.gid stories.dependency.gid = tags.followers.gid users stories.assignee.gid = users.gid stories.created_by.gid = users.gid stories.dependency.gid = users.gid portfolios stories.assignee.gid = portfolios.created_by.gid stories.created_by.gid = portfolios.created_by.gid stories.dependency.gid = portfolios.created_by.gid stories.assignee.gid = portfolios.members.gid stories.created_by.gid = portfolios.members.gid stories.dependency.gid = portfolios.members.gid stories.assignee.gid = portfolios.owner.gid stories.created_by.gid = portfolios.owner.gid stories.dependency.gid = portfolios.owner.gid teams stories.assignee.gid = teams.users.gid stories.created_by.gid = teams.users.gid stories.dependency.gid = teams.users.gid
stories table schema
assignee
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
created_at
DATE-TIME
created_by
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
custom_field
OBJECT
This is a nested data structure:
date_value: OBJECT, which is also a nested data structure.
date: STRING date_time: DATE-TIME display_value: STRING enabled: BOOLEAN enum_options: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING enum_value: OBJECT, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING gid: STRING multi_enum_values: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING name: STRING number_value: NUMBER resource_subtype: STRING resource_type: STRING text_value: STRING type: STRING
dependency
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_subtype: STRING resource_type: STRING
duplicate_of
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_subtype: STRING resource_type: STRING
duplicated_from
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_subtype: STRING resource_type: STRING
follower
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
gid
STRING
hearted
BOOLEAN
hearts
ARRAY
This is a nested data structure:
gid: STRING user: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
html_text
STRING
is_editable
BOOLEAN
is_edited
BOOLEAN
is_pinned
BOOLEAN
liked
BOOLEAN
likes
ARRAY
This is a nested data structure:
gid: STRING user: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
new_approval_status
BOOLEAN
new_date_value
OBJECT
This is a nested data structure:
due_at: DATE-TIME due_on: STRING start_on: STRING
new_dates
OBJECT
This is a nested data structure:
due_at: DATE-TIME due_on: STRING start_on: STRING
new_enum_value
OBJECT
This is a nested data structure:
color: STRING enabled: ENABLED gid: STRING name: STRING resource_type: STRING
new_multi_enum_values
ARRAY
This is a nested data structure:
color: STRING enabled: ENABLED gid: STRING name: STRING resource_type: STRING
new_name
STRING
new_number_value
NUMBER
new_people_value
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
new_resource_subtype
STRING
new_section
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
new_text_value
STRING
num_hearts
INTEGER
num_likes
INTEGER
old_approval_status
STRING
old_date_value
OBJECT
This is a nested data structure:
due_at: DATE-TIME due_on: STRING start_on: STRING
old_dates
OBJECT
This is a nested data structure:
due_at: DATE-TIME due_on: STRING start_on: STRING
old_enum_value
OBJECT
This is a nested data structure:
color: STRING enabled: ENABLED gid: STRING name: STRING resource_type: STRING
old_multi_enum_values
ARRAY
This is a nested data structure:
color: STRING enabled: ENABLED gid: STRING name: STRING resource_type: STRING
old_name
STRING
old_number_value
NUMBER
old_people_value
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
old_resource_subtype
STRING
old_section
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
old_text_value
STRING
previews
ARRAY
This is a nested data structure:
fallback: STRING footer: STRING header: STRING header_link: STRING html_text: STRING text: STRING title: STRING title: STRING
project
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
resource_subtype
STRING
resource_type
STRING
source
STRING
sticker_name
STRING
story
OBJECT
This is a nested data structure:
created_at: DATE-TIME created_by: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING gid: STRING name: STRING resource_subtype: STRING resource_type: STRING text: STRING
tag
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
target
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_subtype: STRING resource_type: STRING
task
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_subtype: STRING resource_type: STRING
text
STRING
type
STRING
subtasks
The subtasks table contains info about the subtasks associated with tasks in your Asana account.
Replication Method
CDC
Primary Key
gid
Replication Key
modified_at
Useful links
Asana API method
subtasks table schema
assignee
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
assignee_status
STRING
completed
BOOLEAN
completed_at
DATE-TIME
completed_by
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
created_at
DATE-TIME
custom_fields
ARRAY
This is a nested data structure:
created_by: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING currency_code: STRING custom_label: STRING custom_label_position: STRING date_value: OBJECT, which is also a nested data structure.
date: STRING date_time: DATE-TIME description: STRING display_value: STRING enabled: BOOLEAN enum_options: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING enum_value: OBJECT, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING format: STRING gid: STRING has_notifications_enabled: BOOLEAN is_global_to_workspace: BOOLEAN multi_enum_values: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING name: STRING number_value: NUMBER people_value: ARRAY, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING precision: INTEGER resource_subtype: STRING resource_type: STRING text_value: STRING type: STRING
dependencies
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
dependents
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
due_at
DATE-TIME
due_on
DATE-TIME
followers
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
gid
STRING
hearted
BOOLEAN
hearts
ARRAY
This is a nested data structure:
gid: STRING user: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
html_notes
STRING
is_rendered_as_separator
BOOLEAN
liked
BOOLEAN
likes
ARRAY
This is a nested data structure:
gid: STRING user: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
memberships
ARRAY
This is a nested data structure:
project: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING section: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
modified_at
DATE-TIME
name
STRING
notes
STRING
num_hearts
INTEGER
num_likes
INTEGER
num_subtasks
INTEGER
parent
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_subtype: STRING resource_type: STRING
permalink_url
STRING
projects
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
resource_subtype
STRING
resource_type
STRING
start_at
DATE-TIME
start_on
STRING
tags
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
workspace
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
The tags table contains info about the tags in your Asana account. A tag is a label that can be attached to any task in Asana.
tasks
The tasks table contains info about the tasks 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.
tasks table foreign keys Join tasks with on projects tasks.projects.gid = projects.gid tasks.assignee.gid = projects.followers.gid tasks.followers.gid = projects.followers.gid tasks.assignee.gid = projects.members.gid tasks.followers.gid = projects.members.gid tasks.assignee.gid = projects.owner.gid tasks.followers.gid = projects.owner.gid tasks.workspace.gid = projects.workspace.gid stories tasks.projects.gid = stories.project.gid tasks.gid = stories.task.gid tasks.assignee.gid = stories.assignee.gid tasks.followers.gid = stories.assignee.gid tasks.assignee.gid = stories.created_by.gid tasks.followers.gid = stories.created_by.gid tasks.assignee.gid = stories.dependency.gid tasks.followers.gid = stories.dependency.gid sections tasks.projects.gid = sections.project.gid tasks.projects.gid = sections.projects.gid tags tasks.assignee.gid = tags.followers.gid tasks.followers.gid = tags.followers.gid tasks.workspace.gid = tags.workspace.gid users tasks.assignee.gid = users.gid tasks.followers.gid = users.gid tasks.workspace.gid = users.workspaces.gid portfolios tasks.assignee.gid = portfolios.created_by.gid tasks.followers.gid = portfolios.created_by.gid tasks.assignee.gid = portfolios.members.gid tasks.followers.gid = portfolios.members.gid tasks.assignee.gid = portfolios.owner.gid tasks.followers.gid = portfolios.owner.gid tasks.workspace.gid = portfolios.workspace.gid teams tasks.assignee.gid = teams.users.gid tasks.followers.gid = teams.users.gid tasks.workspace.gid = teams.organization.gid workspaces tasks.workspace.gid = workspaces.gid
tasks table schema
approval_status
STRING
assignee
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
assignee_section
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
assignee_status
STRING
completed
BOOLEAN
completed_at
DATE-TIME
completed_by
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
created_at
DATE-TIME
custom_fields
ARRAY
This is a nested data structure:
created_by: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING currency_code: STRING custom_label: STRING custom_label_position: STRING date_value: OBJECT, which is also a nested data structure.
date: STRING date_time: DATE-TIME description: STRING display_value: STRING enabled: BOOLEAN enum_options: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING enum_value: OBJECT, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING format: STRING gid: STRING has_notifications_enabled: BOOLEAN is_global_to_workspace: BOOLEAN multi_enum_values: ARRAY, which is also a nested data structure.
color: STRING enabled: BOOLEAN gid: STRING name: STRING resource_type: STRING name: STRING number_value: NUMBER people_value: ARRAY, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING precision: INTEGER resource_subtype: STRING resource_type: STRING text_value: STRING type: STRING
dependencies
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
dependents
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
due_at
DATE-TIME
due_on
DATE-TIME
external
OBJECT
This is a nested data structure:
followers
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
gid
STRING
hearted
BOOLEAN
hearts
ARRAY
This is a nested data structure:
gid: STRING user: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
html_notes
STRING
is_rendered_as_seperator
BOOLEAN
liked
BOOLEAN
likes
ARRAY
This is a nested data structure:
gid: STRING user: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
memberships
ARRAY
This is a nested data structure:
project: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING section: OBJECT, which is also a nested data structure.
gid: STRING name: STRING resource_type: STRING
modified_at
DATE-TIME
name
STRING
notes
STRING
num_hearts
INTEGER
num_likes
INTEGER
num_subtasks
INTEGER
parent
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_subtype: STRING resource_type: STRING
permalink_url
STRING
projects
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
resource_subtype
STRING
resource_type
STRING
start_at
DATE-TIME
start_on
STRING
tags
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
workspace
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
teams
The teams table contains info about teams that belong to a specified user in your Asana account.
teams table foreign keys Join teams with on projects teams.users.gid = projects.followers.gid teams.users.gid = projects.members.gid teams.users.gid = projects.owner.gid teams.organization.gid = projects.workspace.gid tags teams.users.gid = tags.followers.gid teams.organization.gid = tags.workspace.gid tasks teams.users.gid = tasks.assignee.gid teams.users.gid = tasks.followers.gid teams.organization.gid = tasks.workspace.gid users teams.users.gid = users.gid teams.organization.gid = users.workspaces.gid stories teams.users.gid = stories.assignee.gid teams.users.gid = stories.created_by.gid teams.users.gid = stories.dependency.gid portfolios teams.users.gid = portfolios.created_by.gid teams.users.gid = portfolios.members.gid teams.users.gid = portfolios.owner.gid teams.organization.gid = portfolios.workspace.gid workspaces teams.organization.gid = workspaces.gid
teams table schema
description
STRING
gid
STRING
html_description
STRING
name
STRING
organization
OBJECT
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
permalink_url
STRING
resource_type
STRING
users
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
visibility
STRING
users
The users table contains info about the users in your Asana account.
users table foreign keys Join users with on projects users.gid = projects.followers.gid users.gid = projects.members.gid users.gid = projects.owner.gid users.workspaces.gid = projects.workspace.gid tags users.gid = tags.followers.gid users.workspaces.gid = tags.workspace.gid tasks users.gid = tasks.assignee.gid users.gid = tasks.followers.gid users.workspaces.gid = tasks.workspace.gid stories users.gid = stories.assignee.gid users.gid = stories.created_by.gid users.gid = stories.dependency.gid portfolios users.gid = portfolios.created_by.gid users.gid = portfolios.members.gid users.gid = portfolios.owner.gid users.workspaces.gid = portfolios.workspace.gid teams users.gid = teams.users.gid users.workspaces.gid = teams.organization.gid workspaces users.workspaces.gid = workspaces.gid
users table schema
email
STRING
gid
STRING
name
STRING
photo
OBJECT
This is a nested data structure:
image_1024x1024: STRING image_128x128: STRING image_21x21: STRING image_27x27: STRING image_36x36: STRING image_60x60: STRRING
resource_type
STRING
workspaces
ARRAY
This is a nested data structure:
gid: STRING name: STRING resource_type: STRING
workspaces
The workspaces table contains info about the workspaces associated with your Asana account.
workspaces table foreign keys Join workspaces with on projects workspaces.gid = projects.workspace.gid tags workspaces.gid = tags.workspace.gid tasks workspaces.gid = tasks.workspace.gid users workspaces.gid = users.workspaces.gid portfolios workspaces.gid = portfolios.workspace.gid teams workspaces.gid = teams.organization.gid
workspaces table schema
email_domains
ARRAY
This is a nested data structure.
gid
STRING
is_organization
BOOLEAN
name
STRING
resource_type
STRING
