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 项目	仅 Replication 项目。不支持数据管道项目。
目标更新方法	复制任务：应用更改存储更改在数据湖任务中登陆数据：更改数据捕获 (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 Starter 订阅，因为它不支持数据移动网关。如果您有另一个订阅层并且不想使用数据移动网关，请选择无。有关数据移动网关的优势和需要它的用例的信息，请参阅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

本页面有帮助吗？

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们！

在此处留下您的反馈