Asana

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.

En översiktlig beskrivning av denna koppling, inklusive användbara länkar och funktioner som stöds.

Funktion/förmåga	Supportinformation
Stöd till Qlik Talend Data Integration-projekt	Endast replikeringsprojekt. Datapipelineprojekt stöds inte.
Metoder för uppdatering av mål	Replikeringsuppgifter: Tillämpa ändringar Lagra ändringar Mellanlagra data i datareservoar-uppgifter: Sammanställning av ändringsdata (CDC)
Hantera metadata	Manuell generering av metadata är inte nödvändig.
Utveckling av schema	Endast åtgärden Ändra kolumndatatyp stöds.
Replikering av LOB-kolumner (NCLOB, CLOB och BLOB)	Stöds inte.
Schemalagd CDC	Krävs. Det är på detta sätt som målet hålls uppdaterat med ändringar i källan. För uppgifter om replikering, se Schemalägga datauppgifter För mellanlagringsuppgifter i datasjöar, se Schemaläggning av CDC för mellanlagringsuppgift i datasjö
Meddelanden	Stöds delvis Konfigurera aviseringar vid ändringar under drift
Övervakning	Endast CDC, eftersom fullständig laddning inte är relevant för denna koppling. Övervaka en enskild datauppgift
Automatisk denestning av JSON-kolumners nyttolast	Stöds inte. Nyttolaster för JSON-kolumner i källdatauppsättningen avnästlas inte automatiskt på målet.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Kontrollera att kontot du använder har läsåtkomst till de tabeller som du vill hämta.

Creating the connection

For more information, see Koppla till SaaS-program.

Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
Anteckning om tipsYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting	Description
Data gateway	Välj en Gateway för dataflytt om det krävs för ditt användningsfall. Anteckning om information Detta fält är inte tillgängligt med Qlik Talend Cloud Starter-prenumerationen eftersom den inte stöder Gateway för dataflytt. Om du har en annan prenumerationsnivå och inte vill använda Gateway för dataflytt väljer du Inget. Information om fördelarna med Gateway för dataflytt och användningsfall som kräver det finns i Qlik Data Gateway – dataflytt.
Start Date	Ange det datum, i formatet `MM/DD/YYYY`, från vilket data måste replikeras från din källa till ditt mål.
Client ID	Client ID.
Client Secret	Client secret.

Schema

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.

Replication Method

Full Table

Primary Key

gid

Useful links

Asana documentation

Asana API method

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

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.

Replication Method	CDC
Primary Key	gid
Replication Key	modified_at
Useful links	Asana documentation

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

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.

Replication Method

Full Table

Primary Key

gid

Useful links

Asana documentation

Asana API method

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

Join sections with

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

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.

Replication Method	CDC
Primary Key	gid
Replication Key	created_at
Useful links	Asana documentation Asana API method

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

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

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

Join tags with	on
stories	tags.gid = stories.tag.gid tags.followers.gid = stories.assignee.gid tags.followers.gid = stories.created_by.gid tags.followers.gid = stories.dependency.gid
projects	tags.followers.gid = projects.followers.gid tags.followers.gid = projects.members.gid tags.followers.gid = projects.owner.gid tags.workspace.gid = projects.workspace.gid
tasks	tags.followers.gid = tasks.assignee.gid tags.followers.gid = tasks.followers.gid tags.workspace.gid = tasks.workspace.gid
users	tags.followers.gid = users.gid tags.workspace.gid = users.workspaces.gid
portfolios	tags.followers.gid = portfolios.created_by.gid tags.followers.gid = portfolios.members.gid tags.followers.gid = portfolios.owner.gid tags.workspace.gid = portfolios.workspace.gid
teams	tags.followers.gid = teams.users.gid tags.workspace.gid = teams.organization.gid
workspaces	tags.workspace.gid = workspaces.gid

tasks

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

Custom fields

Replication Method	CDC
Primary Key	gid
Replication Key	modified_at
Useful links	Asana documentation

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

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:

data: STRING
gid: STRING

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.

Replication Method

Full Table

Primary Key

gid

Useful links

Asana documentation

Asana API method

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

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.

Replication Method

Full Table

Primary Key

gid

Useful links

Asana documentation

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

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.

Replication Method

Full Table

Primary Key

gid

Useful links

Asana documentation

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

email_domains

ARRAY

This is a nested data structure.

gid

STRING

is_organization

BOOLEAN

name

STRING

resource_type

STRING

Var den här sidan till hjälp för dig?

Om du stöter på några problem med den här sidan eller innehållet på den, t.ex. ett stavfel, ett saknat steg eller ett tekniskt fel – meddela oss!

Lämna din feedback här