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.

進一步查看此連接器，包括實用的連結和支援的功能。

功能	支援詳細資訊
支援的 Qlik Talend Data Integration 專案	僅複寫專案。不支援資料管道專案。
目標更新方法	複寫任務：套用變更儲存變更在資料湖中登陸資料任務：變更資料擷取 (CDC)
管理中繼資料	不需要手動產生中繼資料。
結構描述演進	僅支援變更欄資料類型操作。
LOB 欄 (NCLOB、CLOB 和 BLOB) 複寫	不支援。
已排程 CDC	必填。此為目標與來源的變更保持同步的方式。對於複寫任務，請參閱排程任務對於湖登陸任務，請參閱排程湖登陸任務的 CDC
通知	部分支援設定變更進行時的通知
監控	僅限 CDC，因為此連接器與完整載入無關。監控個別資料任務
自動解除 JSON 欄裝載的巢狀結構	不支援。來源資料集中的 JSON 欄裝載不會在目標上自動解除巢狀結構。

Preparing for authentication

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

確認您使用的帳戶可讀取您要擷取的表格。

Creating the connection

For more information, see 連線到 SaaS 應用程式.

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.
提示備註You 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	如您的使用情況有需要，選取資料移動閘道。資訊備註此欄位無法用於 Qlik Talend Cloud 啟動器訂閱，因為不支援資料移動閘道。若您有另一個訂閱層級且不想使用資料移動閘道，選取無。如需關於資料移動閘道福利的資訊以及需要此項的使用案例，請參閱 Qlik 資料閘道 - 資料移動。
Start Date	以 `MM/DD/YYYY` 格式輸入資料必須從來源複寫到目標的日期。
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

此頁面是否對您有幫助？

若您發現此頁面或其內容有任何問題——錯字、遺漏步驟或技術錯誤——請告知我們！

在此留下意見回饋