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 | ユース ケースに応じて Data Movement gateway を選択します。 情報メモ Qlik Talend Cloud スターター サブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプション ティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユース ケースの詳細については、「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 |