Asana OP DEZE PAGINA
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.
Momentopname functie Een beknopt overzicht van deze connector, inclusief nuttige koppelingen en ondersteunde functies.
Functie/mogelijkheden Ondersteuningsdetails Ondersteunde Qlik Talend Data Integration -projecten Alleen replicatieprojecten . Gegevenspijplijnprojecten worden niet ondersteund. Bijwerkmethoden doel
Replicatietaken:
Wijzigingen toepassen
Wijzigingen opslaan
Gegevens tijdelijk opslaan in een datalaketaak:
Metagegevens beheren
Handmatig metagegevens genereren is niet nodig. Schema-evolutie
Alleen de bewerking Type kolomgegevens wijzigen wordt ondersteund. Replicatie van LOB-kolommen (NCLOB, CLOB en BLOB) Niet ondersteund. Gepland CDC Vereist. Zo wordt het doel up-to-date gehouden met wijzigingen in de bron.
Voor replicatietaken raadpleegt u Taken plannen
Voor tussenopslagtaken voor lake, raadpleegt u CDC plannen voor tussenopslagtaken in lake
Meldingen Gedeeltelijk ondersteund
Meldingen instellen voor wijzigingen van de bewerking
Bewaking Alleen CDC, omdat volledige lading niet relevant is voor deze connector.
Een afzonderlijke gegevenstaak bewaken
Automatisch denesten van nettoladingen van JSON-kolommen Niet ondersteund. Nettoladingen van JSON-kolommen in brongegevensverzamelingen worden niet automatisch gedenest op het doel.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Informatie Zorg dat het account dat u gebruikt leestoegang heeft voor de tabellen die u wilt ophalen.
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 Ga voor meer informatie naar Verbinding maken met SaaS-applicaties
Klik op Authenticeren nadat u de vereiste verbindingsinstellingen hebt ingevuld.
U wordt mogelijk verzocht om u aan te melden bij de bronapplicatie.
Er wordt een venster met de authentiecode weergegeven.
Kopieer de code naar het klembord en ga terug naar het verbindingsvenster.
Plak de code in Voltooi de verificatie met de door de bron geleverde code en klik op Verifiëren .
Tip U moet mogelijk naar beneden scrollen om dit veld te kunnen zien.
De authenticatie is geverifieerd als de status op Geverifieerd staat.
Geef in Verbindingsnaam een naam voor de verbinding op.
Selecteer Metagegevens verbinding openen om metagegevens te definiëren voor de verbinding nadat deze is gemaakt.
Connection settings Setting Description Data gateway
Selecteer een Data Movement gateway als dit is vereist voor uw usecase.
Informatie Dit veld is niet beschikbaar met het Qlik Talend Cloud Starter -abonnement, omdat het geen ondersteuning biedt voor Data Movement gateway . Als u een ander abonnementsniveau hebt en Data Movement gateway niet wilt gebruiken, selecteer dan Geen .
Raadpleeg Qlik Gegevensgateway - Gegevensverplaatsing Data Movement gateway en usecases waarvoor deze is vereist.
Start Date Voer de datum in, in het formaat MM/DD/YYYY, vanaf wanneer de gegevens van uw gegevensbron naar uw doel moeten worden gerepliceerd.
Client ID Client ID. Client Secret Client secret.
Informatie 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
