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 项目。不支持数据管道项目。 |
复制任务：
在数据湖任务中登陆数据：
| |
| 无需手动生成元数据。 | |
| 只支持更改列数据类型操作。 | |
| 复制 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.
To retrieve your client ID and secret:
- Log into your Asana account.
- In the My apps section, click Create new app.
- Complete the required information, then click Create app.
- Select the OAuth tab.
- Make sure Redirect URLs is set to https://connector.qlik.com/auth/oauth/v3.htm.
- In the Permission scopes section, select Full permissions.
- Select the Manage distribution tab.
- Click Add workspace.
- From the dropdown menu, select the workspace you want to replicate data from, then click Add.
- In the OAuth section, copy and paste your client secret and client ID into a secured file.
Creating the connection
有关更多信息，请参阅连接到 SaaS 应用程序。
填写完所需的连接设置后，单击身份验证。
您可能会被要求登录源应用程序。
将显示一个带有身份验证代码的窗口。
将代码复制到剪贴板，然后返回到连接对话框。
粘贴使用源提供的代码完成身份验证中的代码，然后单击验证。
提示注释您可能需要向下滚动才能查看此字段。在状态为已验证时，身份验证即得到验证。
在连接名称中提供连接的名称。
选择打开连接元数据以定义创建连接时的元数据。
| Setting | Description |
|---|---|
| Data gateway | 如果您的用例需要，请选择一个 数据移动网关。 信息注释 此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动。 |
| Start Date | 按格式 |
| 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 |
| 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:
|
current_status_update OBJECT * This is a nested data structure:
|
custom_field_settings ARRAY This is a nested data structure:
|
custom_fields ARRAY This is a nested data structure:
|
due_on STRING |
gid STRING |
is_template BOOLEAN |
members ARRAY This is a nested data structure:
|
name STRING |
owner OBJECT This is a nested data structure:
|
permalink_url STRING |
portfolio_items ARRAY This is a nested data structure:
|
public BOOLEAN |
resource_type STRING |
start_on STRING |
workspace OBJECT This is a nested data structure:
|
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 |
| 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:
|
created_at DATE-TIME |
created_from_template OBJECT This is a nested data structure:
|
current_status STRING |
current_status_update OBJECT This is a nested data structure:
|
custom_field_settings ARRAY This is a nested data structure:
|
custom_fields ARRAY This is a nested data structure:
|
default_view STRING |
due_date STRING |
due_on STRING |
followers ARRAY This is a nested data structure:
|
gid STRING |
html_notes STRING |
icon STRING |
is_template BOOLEAN |
members ARRAY This is a nested data structure:
|
modified_at DATE-TIME |
name STRING |
notes STRING |
owner OBJECT This is a nested data structure:
|
permalink_url STRING |
project_brief OBJECT This is a nested data structure:
|
public BOOLEAN |
resource_type STRING |
start_on STRING |
team OBJECT This is a nested data structure:
|
workspace OBJECT This is a nested data structure:
|
sections
The sections table contains info about sections within specified projects in your Asana account.
Replication Method | Full Table |
Primary Key | gid |
| Useful links |
| 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 |
created_at DATE-TIME |
gid STRING |
name STRING |
project OBJECT This is a nested data structure:
|
projects ARRAY This is a nested data structure:
|
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 |
| 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:
|
created_at DATE-TIME |
created_by OBJECT This is a nested data structure:
|
custom_field OBJECT This is a nested data structure:
|
dependency OBJECT This is a nested data structure:
|
duplicate_of OBJECT This is a nested data structure:
|
duplicated_from OBJECT This is a nested data structure:
|
follower OBJECT This is a nested data structure:
|
gid STRING |
hearted BOOLEAN |
hearts ARRAY This is a nested data structure:
|
html_text STRING |
is_editable BOOLEAN |
is_edited BOOLEAN |
is_pinned BOOLEAN |
liked BOOLEAN |
likes ARRAY This is a nested data structure:
|
new_approval_status BOOLEAN |
new_date_value OBJECT This is a nested data structure:
|
new_dates OBJECT This is a nested data structure:
|
new_enum_value OBJECT This is a nested data structure:
|
new_multi_enum_values ARRAY This is a nested data structure:
|
new_name STRING |
new_number_value NUMBER |
new_people_value ARRAY This is a nested data structure:
|
new_resource_subtype STRING |
new_section OBJECT This is a nested data structure:
|
new_text_value STRING |
num_hearts INTEGER |
num_likes INTEGER |
old_approval_status STRING |
old_date_value OBJECT This is a nested data structure:
|
old_dates OBJECT This is a nested data structure:
|
old_enum_value OBJECT This is a nested data structure:
|
old_multi_enum_values ARRAY This is a nested data structure:
|
old_name STRING |
old_number_value NUMBER |
old_people_value ARRAY This is a nested data structure:
|
old_resource_subtype STRING |
old_section OBJECT This is a nested data structure:
|
old_text_value STRING |
previews ARRAY This is a nested data structure:
|
project OBJECT This is a nested data structure:
|
resource_subtype STRING |
resource_type STRING |
source STRING |
sticker_name STRING |
story OBJECT This is a nested data structure:
|
tag OBJECT This is a nested data structure:
|
target OBJECT This is a nested data structure:
|
task OBJECT This is a nested data structure:
|
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 |
assignee OBJECT This is a nested data structure:
|
assignee_status STRING |
completed BOOLEAN |
completed_at DATE-TIME |
completed_by OBJECT This is a nested data structure:
|
created_at DATE-TIME |
custom_fields ARRAY This is a nested data structure:
|
dependencies ARRAY This is a nested data structure:
|
dependents ARRAY This is a nested data structure:
|
due_at DATE-TIME |
due_on DATE-TIME |
followers ARRAY This is a nested data structure:
|
gid STRING |
hearted BOOLEAN |
hearts ARRAY This is a nested data structure:
|
html_notes STRING |
is_rendered_as_separator BOOLEAN |
liked BOOLEAN |
likes ARRAY This is a nested data structure:
|
memberships ARRAY This is a nested data structure:
|
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:
|
permalink_url STRING |
projects ARRAY This is a nested data structure:
|
resource_subtype STRING |
resource_type STRING |
start_at DATE-TIME |
start_on STRING |
tags ARRAY This is a nested data structure:
|
workspace OBJECT This is a nested data structure:
|
tags
The tags table contains info about the tags in your Asana account. A tag is a label that can be attached to any task in Asana.
Replication Method | CDC |
Primary Key | gid |
Replication Key | created_at |
| Useful links |
| 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 |
color STRING |
created_at DATE-TIME |
followers ARRAY This is a nested data structure:
|
gid STRING |
name STRING |
notes STRING |
permalink_url STRING |
resource_type STRING |
workspace OBJECT This is a nested data structure:
|
tasks
The tasks table contains info about the tasks in your Asana account.
Custom fields
To replicate task custom fields, select the custom_fields attribute in Stitch. If your destination doesn’t natively support nested data structures, two subtables (tasks__custom_fields, tasks__custom_fields__enum_options) will be created.
Replication Method | CDC |
Primary Key | gid |
Replication Key | modified_at |
| Useful links |
| 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:
|
assignee_section OBJECT This is a nested data structure:
|
assignee_status STRING |
completed BOOLEAN |
completed_at DATE-TIME |
completed_by OBJECT This is a nested data structure:
|
created_at DATE-TIME |
custom_fields ARRAY This is a nested data structure:
|
dependencies ARRAY This is a nested data structure:
|
dependents ARRAY This is a nested data structure:
|
due_at DATE-TIME |
due_on DATE-TIME |
external OBJECT This is a nested data structure:
|
followers ARRAY This is a nested data structure:
|
gid STRING |
hearted BOOLEAN |
hearts ARRAY This is a nested data structure:
|
html_notes STRING |
is_rendered_as_seperator BOOLEAN |
liked BOOLEAN |
likes ARRAY This is a nested data structure:
|
memberships ARRAY This is a nested data structure:
|
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:
|
permalink_url STRING |
projects ARRAY This is a nested data structure:
|
resource_subtype STRING |
resource_type STRING |
start_at DATE-TIME |
start_on STRING |
tags ARRAY This is a nested data structure:
|
workspace OBJECT This is a nested data structure:
|
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 |
| 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:
|
permalink_url STRING |
resource_type STRING |
users ARRAY This is a nested data structure:
|
visibility STRING |
users
The users table contains info about the users in your Asana account.
Replication Method | Full Table |
Primary Key | gid |
| Useful links |
| 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 |
STRING |
gid STRING |
name STRING |
photo OBJECT This is a nested data structure:
|
resource_type STRING |
workspaces ARRAY This is a nested data structure:
|
workspaces
The workspaces table contains info about the workspaces associated with your Asana account.
Replication Method | Full Table |
Primary Key | gid |
| Useful links |
email_domains ARRAY This is a nested data structure. |
gid STRING |
is_organization BOOLEAN |
name STRING |
resource_type STRING |