Asana

Asana is a team communication manager.

Asana integration replicates data using the Asana API.

See the Schema section for a list of objects available for replication.

Общий обзор этого коннектора, включая полезные ссылки и поддерживаемые функции.

Функция/возможность	Сведения о поддержке
Поддерживаемые проекты Qlik Talend Data Integration	Только проекты репликации. Проекты конвейера данных не поддерживаются.
Методы обновления целей	Задачи репликации: Применить изменения Сохранить изменения Промежуточное хранение данных в озере данных: Захват изменений данных (CDC)
Управление метаданными	Создание метаданных вручную не требуется.
Эволюция схемы	Поддерживается только операция Изменить тип данных столбца.
Репликация столбцов LOB (NCLOB, CLOB и BLOB)	Не поддерживается.
Запланированный CDC	Требуется. Так целевой объект обновляется в соответствии с изменениями в источнике. Для получения информации о задачах репликации см. раздел Планирование задач Для получения информации о задачах промежуточного хранения в озере см. раздел Планирование CDC для задач промежуточного хранения в озере
Уведомления	Частично поддерживается Настройка уведомлений об изменениях в работе
Мониторинг	Только CDC, так как полная загрузка для этого коннектора не актуальна. Мониторинг индивидуальной задачи данных
Автоматическое извлечение вложенной полезной нагрузки столбцов JSON	Не поддерживается. Вложенная полезная нагрузка столбцов JSON в исходных наборах данных не извлекается автоматически в цели.

Preparing for authentication

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

Убедитесь, что используемая учетная запись имеет доступ для чтения к таблицам, которые требуется получить.

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.

Щелкните Проверить подлинность, когда будут настроены необходимые параметры подключения.
Может появиться запрос на вход в исходное приложение.
Открывается окно с кодом для проверки подлинности.
Скопируйте код в буфер обмена и вернитесь в диалоговое окно подключения.
Вставьте код в поле Завершите проверку подлинности с помощью кода, предоставленного источником и нажмите кнопку Проверить.
Примечание к подсказкеМожет потребоваться прокрутить вниз, чтобы увидеть это поле.
Когда статус Проверено, аутентификация подтверждена.
Заполните поле Имя подключения.
Установите флажок Открыть метаданные подключения, чтобы определить метаданные для подключения, когда оно будет создано.

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

Помогла ли вам эта страница?

Если вы обнаружили какую-либо проблему на этой странице или с ее содержанием — будь то опечатка, пропущенный шаг или техническая ошибка, сообщите нам об этом!

Оставьте свой отзыв здесь