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 프로젝트 | 복제 프로젝트에만 해당됩니다. 데이터 파이프라인 프로젝트는 지원되지 않습니다. |
복제 작업:
데이터 레이크 작업에 데이터 랜딩:
| |
| 수동 메타데이터 생성이 필요하지 않습니다. | |
| 열 데이터 유형 변경 작업만 지원됩니다. | |
| 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 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 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 |