Asana コネクタリファレンス

備考

ベータ版

この機能はベータ版です。使用するには、ワークスペース管理者は、 プレビュー ページから Asana向けLakeflow Connect を有効にする必要があります。Databricksのプレビューを管理するを参照してください。

Lakeflow Connect の管理対象 Asana コネクタは、default スキーマの 24 のソーステーブルをサポートしています。すべてのテーブルで完全更新が使用されるため、パイプラインが更新されるたびにすべてのレコードが再取り込みされます。

サポートされているソーステーブル

Asanaコネクタは、以下のソーステーブルをサポートしています。これらはすべてdefaultソーススキーマの下にあります。

ソーステーブル	プライマリーキー	説明	同期モード
`workspaces`	`gid`	承認ユーザーが属するワークスペースと組織。	フル更新のみ
`users`	`workspace_gid`, `gid`	各ワークスペースのユーザー（Eメールアドレスとプロフィール写真を含む）。	フル更新のみ
`teams`	`workspace_gid`, `gid`	各組織のチーム、およびその説明とアクセス設定。	フル更新のみ
`team_memberships`	`team_gid`, `gid`	各チームのユーザーのメンバーシップ。	フル更新のみ
`projects`	`team_gid`, `gid`	各チームのプロジェクト、ステータス、日付、所有者、メンバー。	フル更新のみ
`sections`	`project_gid`, `gid`	各プロジェクトのセクション。	フル更新のみ
`tasks`	`section_gid`, `gid`	担当者、日付、メンバーシップ、カスタムフィールドの値など、各プロジェクトセクションのタスク。	フル更新のみ
`stories`	`section_gid`、`task_gid`、 `gid`	コメントやフィールドの変更などのアクティビティを含む、各タスクのストーリー。	フル更新のみ
`tags`	`workspace_gid`, `gid`	各ワークスペースのタグ。	フル更新のみ
`custom_fields`	`workspace_gid`, `gid`	各ワークスペースのカスタムフィールド定義。	フル更新のみ
`task_attachments`	`section_gid`、`task_gid`、 `gid`	各タスクの添付ファイル。	フル更新のみ
`portfolios`	`workspace_gid`, `gid`	各ワークスペースで承認ユーザーが所有するポートフォリオ。	フル更新のみ
`portfolio_memberships`	`portfolio_gid`, `gid`	認可ユーザーが所有する各ポートフォリオのユーザーのメンバーシップ。	フル更新のみ
`portfolio_items`	`portfolio_gid`, `gid`	承認ユーザーが所有する各ポートフォリオの項目。	フル更新のみ
`project_memberships`	`project_gid`, `gid`	各プロジェクトにおけるユーザーおよびチームのメンバーシップ。	フル更新のみ
`custom_field_settings`	`project_gid`, `gid`	各プロジェクトに関連付けられたカスタムフィールド。	フル更新のみ
`project_status_updates`	`project_gid`, `gid`	各プロジェクトのステータスの更新。	フル更新のみ
`portfolio_status_updates`	`portfolio_gid`, `gid`	承認ユーザーが所有する各ポートフォリオのステータス更新。	フル更新のみ
`goal_status_updates`	`goal_gid`, `gid`	各目標に関するステータスの更新。	フル更新のみ
`workspace_memberships`	`workspace_gid`, `gid`	各ワークスペースのユーザーのメンバーシップ。	フル更新のみ
`goals`	`workspace_gid`, `gid`	各ワークスペースの目標。	フル更新のみ
`goal_relationships`	`goal_gid`, `gid`	各目標と、それをサポートするプロジェクト、ポートフォリオ、または目標との関係。	フル更新のみ
`time_tracking_entries`	`section_gid`、`task_gid`、 `gid`	各タスクのタイムトラッキングエントリ。	フル更新のみ
`project_attachments`	`project_gid`, `gid`	各プロジェクトの添付ファイル。	フル更新のみ

ソーステーブル	プライマリーキー	説明	同期モード
`workspaces`	`gid`	承認ユーザーが属するワークスペースと組織。	フル更新のみ
`users`	`workspace_gid`, `gid`	各ワークスペースのユーザー（Eメールアドレスとプロフィール写真を含む）。	フル更新のみ
`teams`	`workspace_gid`, `gid`	各組織のチーム、およびその説明とアクセス設定。	フル更新のみ
`team_memberships`	`team_gid`, `gid`	各チームのユーザーのメンバーシップ。	フル更新のみ
`projects`	`team_gid`, `gid`	各チームのプロジェクト、ステータス、日付、所有者、メンバー。	フル更新のみ
`sections`	`project_gid`, `gid`	各プロジェクトのセクション。	フル更新のみ
`tasks`	`section_gid`, `gid`	担当者、日付、メンバーシップ、カスタムフィールドの値など、各プロジェクトセクションのタスク。	フル更新のみ
`stories`	`section_gid`、`task_gid`、 `gid`	コメントやフィールドの変更などのアクティビティを含む、各タスクのストーリー。	フル更新のみ
`tags`	`workspace_gid`, `gid`	各ワークスペースのタグ。	フル更新のみ
`custom_fields`	`workspace_gid`, `gid`	各ワークスペースのカスタムフィールド定義。	フル更新のみ
`task_attachments`	`section_gid`、`task_gid`、 `gid`	各タスクの添付ファイル。	フル更新のみ
`portfolios`	`workspace_gid`, `gid`	各ワークスペースで承認ユーザーが所有するポートフォリオ。	フル更新のみ
`portfolio_memberships`	`portfolio_gid`, `gid`	認可ユーザーが所有する各ポートフォリオのユーザーのメンバーシップ。	フル更新のみ
`portfolio_items`	`portfolio_gid`, `gid`	承認ユーザーが所有する各ポートフォリオの項目。	フル更新のみ
`project_memberships`	`project_gid`, `gid`	各プロジェクトにおけるユーザーおよびチームのメンバーシップ。	フル更新のみ
`custom_field_settings`	`project_gid`, `gid`	各プロジェクトに関連付けられたカスタムフィールド。	フル更新のみ
`project_status_updates`	`project_gid`, `gid`	各プロジェクトのステータスの更新。	フル更新のみ
`portfolio_status_updates`	`portfolio_gid`, `gid`	承認ユーザーが所有する各ポートフォリオのステータス更新。	フル更新のみ
`goal_status_updates`	`goal_gid`, `gid`	各目標に関するステータスの更新。	フル更新のみ
`workspace_memberships`	`workspace_gid`, `gid`	各ワークスペースのユーザーのメンバーシップ。	フル更新のみ
`goals`	`workspace_gid`, `gid`	各ワークスペースの目標。	フル更新のみ
`goal_relationships`	`goal_gid`, `gid`	各目標と、それをサポートするプロジェクト、ポートフォリオ、または目標との関係。	フル更新のみ
`time_tracking_entries`	`section_gid`、`task_gid`、 `gid`	各タスクのタイムトラッキングエントリ。	フル更新のみ
`project_attachments`	`project_gid`, `gid`	各プロジェクトの添付ファイル。	フル更新のみ

コネクタオプション

Asana コネクタには、すべてのマネージドコネクタで使用できるパイプライン設定以外の追加の構成オプションはありません。「Asana からのデータの取り込み」を参照してください。

宛先テーブルのスキーマ

`workspaces`

プライマリーキー: gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`email_domains`	`ARRAY<STRING>`
`is_organization`	`BOOLEAN`

`users`

主キー： workspace_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`email`	`STRING`
`photo`	`STRUCT<image_21x21: STRING, image_27x27: STRING, image_36x36: STRING, image_60x60: STRING, image_128x128: STRING, image_1024x1024: STRING>`
`workspaces`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`workspace_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`email`	`STRING`
`photo`	`STRUCT<image_21x21: STRING, image_27x27: STRING, image_36x36: STRING, image_60x60: STRING, image_128x128: STRING, image_1024x1024: STRING>`
`workspaces`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`workspace_gid`	`STRING`

`teams`

主キー： workspace_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`description`	`STRING`
`edit_team_name_or_description_access_level`	`STRING`
`edit_team_visibility_or_trash_team_access_level`	`STRING`
`endorsed`	`BOOLEAN`
`guest_invite_management_access_level`	`STRING`
`html_description`	`STRING`
`join_request_management_access_level`	`STRING`
`member_invite_management_access_level`	`STRING`
`organization`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`team_content_management_access_level`	`STRING`
`team_member_removal_access_level`	`STRING`
`visibility`	`STRING`
`workspace_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`description`	`STRING`
`edit_team_name_or_description_access_level`	`STRING`
`edit_team_visibility_or_trash_team_access_level`	`STRING`
`endorsed`	`BOOLEAN`
`guest_invite_management_access_level`	`STRING`
`html_description`	`STRING`
`join_request_management_access_level`	`STRING`
`member_invite_management_access_level`	`STRING`
`organization`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`team_content_management_access_level`	`STRING`
`team_member_removal_access_level`	`STRING`
`visibility`	`STRING`
`workspace_gid`	`STRING`

`team_memberships`

主キー： team_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`is_admin`	`BOOLEAN`
`is_guest`	`BOOLEAN`
`is_limited_access`	`BOOLEAN`
`team`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`user`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`team_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`is_admin`	`BOOLEAN`
`is_guest`	`BOOLEAN`
`is_limited_access`	`BOOLEAN`
`team`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`user`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`team_gid`	`STRING`

`projects`

主キー： team_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`archived`	`BOOLEAN`
`color`	`STRING`
`completed`	`BOOLEAN`
`completed_at`	`TIMESTAMP`
`completed_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_at`	`TIMESTAMP`
`created_from_template`	`STRUCT<gid: STRING, resource_type: STRING>`
`current_status`	`STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`default_access_level`	`STRING`
`default_view`	`STRING`
`is_template`	`BOOLEAN`
`due_date`	`DATE`
`due_on`	`DATE`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`html_notes`	`STRING`
`icon`	`STRING`
`members`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`minimum_access_level_for_customization`	`STRING`
`minimum_access_level_for_sharing`	`STRING`
`modified_at`	`TIMESTAMP`
`notes`	`STRING`
`owner`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`privacy_setting`	`STRING`
`project_brief`	`STRUCT<gid: STRING, resource_type: STRING>`
`public`	`BOOLEAN`
`resource_subtype`	`STRING`
`start_on`	`DATE`
`team`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`team_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`archived`	`BOOLEAN`
`color`	`STRING`
`completed`	`BOOLEAN`
`completed_at`	`TIMESTAMP`
`completed_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_at`	`TIMESTAMP`
`created_from_template`	`STRUCT<gid: STRING, resource_type: STRING>`
`current_status`	`STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`default_access_level`	`STRING`
`default_view`	`STRING`
`is_template`	`BOOLEAN`
`due_date`	`DATE`
`due_on`	`DATE`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`html_notes`	`STRING`
`icon`	`STRING`
`members`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`minimum_access_level_for_customization`	`STRING`
`minimum_access_level_for_sharing`	`STRING`
`modified_at`	`TIMESTAMP`
`notes`	`STRING`
`owner`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`privacy_setting`	`STRING`
`project_brief`	`STRUCT<gid: STRING, resource_type: STRING>`
`public`	`BOOLEAN`
`resource_subtype`	`STRING`
`start_on`	`DATE`
`team`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`team_gid`	`STRING`

`sections`

主キー： project_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`created_at`	`TIMESTAMP`
`project`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`projects`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`project_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`created_at`	`TIMESTAMP`
`project`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`projects`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`project_gid`	`STRING`

`tasks`

主キー： section_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`actual_time_minutes`	`DOUBLE`
`approval_status`	`STRING`
`assigned_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`assignee`	`STRUCT<gid: STRING, resource_type: STRING>`
`assignee_section`	`STRUCT<gid: STRING, resource_type: STRING>`
`assignee_status`	`STRING`
`completed`	`BOOLEAN`
`completed_at`	`TIMESTAMP`
`completed_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_fields`	`VARIANT`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_type_status_option`	`STRUCT<gid: STRING, resource_type: STRING>`
`dependencies`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`dependents`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`due_at`	`TIMESTAMP`
`due_on`	`DATE`
`effective_memberships`	`VARIANT`
`external`	`STRUCT<gid: STRING, data: STRING>`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_notes`	`STRING`
`is_rendered_as_separator`	`BOOLEAN`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`memberships`	`VARIANT`
`modified_at`	`TIMESTAMP`
`notes`	`STRING`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`num_subtasks`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`projects`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`resource_subtype`	`STRING`
`start_at`	`TIMESTAMP`
`start_on`	`DATE`
`tags`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`project_gid`	`STRING`
`section_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`actual_time_minutes`	`DOUBLE`
`approval_status`	`STRING`
`assigned_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`assignee`	`STRUCT<gid: STRING, resource_type: STRING>`
`assignee_section`	`STRUCT<gid: STRING, resource_type: STRING>`
`assignee_status`	`STRING`
`completed`	`BOOLEAN`
`completed_at`	`TIMESTAMP`
`completed_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_fields`	`VARIANT`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_type_status_option`	`STRUCT<gid: STRING, resource_type: STRING>`
`dependencies`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`dependents`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`due_at`	`TIMESTAMP`
`due_on`	`DATE`
`effective_memberships`	`VARIANT`
`external`	`STRUCT<gid: STRING, data: STRING>`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_notes`	`STRING`
`is_rendered_as_separator`	`BOOLEAN`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`memberships`	`VARIANT`
`modified_at`	`TIMESTAMP`
`notes`	`STRING`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`num_subtasks`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`projects`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`resource_subtype`	`STRING`
`start_at`	`TIMESTAMP`
`start_on`	`DATE`
`tags`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`project_gid`	`STRING`
`section_gid`	`STRING`

`stories`

主キー: section_gid, task_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`assignee`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`custom_field`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`dependency`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`duplicate_of`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`duplicated_from`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`follower`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`is_editable`	`BOOLEAN`
`is_edited`	`BOOLEAN`
`is_pinned`	`BOOLEAN`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`new_approval_status`	`STRING`
`new_date_value`	`VARIANT`
`new_dates`	`VARIANT`
`new_enum_value`	`VARIANT`
`new_multi_enum_values`	`VARIANT`
`new_name`	`STRING`
`new_number_value`	`BIGINT`
`new_people_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`new_resource_subtype`	`STRING`
`new_section`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`new_text_value`	`STRING`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`old_approval_status`	`STRING`
`old_date_value`	`VARIANT`
`old_dates`	`VARIANT`
`old_enum_value`	`VARIANT`
`old_multi_enum_values`	`VARIANT`
`old_name`	`STRING`
`old_number_value`	`BIGINT`
`old_people_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`old_resource_subtype`	`STRING`
`old_section`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`old_text_value`	`STRING`
`previews`	`VARIANT`
`project`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`source`	`STRING`
`sticker_name`	`STRING`
`story`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`tag`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`target`	`STRUCT<gid: STRING, resource_type: STRING>`
`task`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`text`	`STRING`
`type`	`STRING`
`section_gid`	`STRING`
`task_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`assignee`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`custom_field`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`dependency`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`duplicate_of`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`duplicated_from`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`follower`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`is_editable`	`BOOLEAN`
`is_edited`	`BOOLEAN`
`is_pinned`	`BOOLEAN`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`new_approval_status`	`STRING`
`new_date_value`	`VARIANT`
`new_dates`	`VARIANT`
`new_enum_value`	`VARIANT`
`new_multi_enum_values`	`VARIANT`
`new_name`	`STRING`
`new_number_value`	`BIGINT`
`new_people_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`new_resource_subtype`	`STRING`
`new_section`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`new_text_value`	`STRING`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`old_approval_status`	`STRING`
`old_date_value`	`VARIANT`
`old_dates`	`VARIANT`
`old_enum_value`	`VARIANT`
`old_multi_enum_values`	`VARIANT`
`old_name`	`STRING`
`old_number_value`	`BIGINT`
`old_people_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`old_resource_subtype`	`STRING`
`old_section`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`old_text_value`	`STRING`
`previews`	`VARIANT`
`project`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`source`	`STRING`
`sticker_name`	`STRING`
`story`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`tag`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`target`	`STRUCT<gid: STRING, resource_type: STRING>`
`task`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`text`	`STRING`
`type`	`STRING`
`section_gid`	`STRING`
`task_gid`	`STRING`

`tags`

主キー： workspace_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`color`	`STRING`
`created_at`	`TIMESTAMP`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`notes`	`STRING`
`permalink_url`	`STRING`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`workspace_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`color`	`STRING`
`created_at`	`TIMESTAMP`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`notes`	`STRING`
`permalink_url`	`STRING`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`workspace_gid`	`STRING`

`custom_fields`

主キー： workspace_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`asana_created_field`	`STRING`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`currency_code`	`STRING`
`custom_label`	`STRING`
`custom_label_position`	`STRING`
`date_value`	`STRUCT<date: STRING, date_time: STRING>`
`default_access_level`	`STRING`
`description`	`STRING`
`display_value`	`STRING`
`enabled`	`BOOLEAN`
`enum_options`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>`
`enum_value`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>`
`format`	`STRING`
`has_notifications_enabled`	`BOOLEAN`
`html_text_value`	`STRING`
`id_prefix`	`STRING`
`input_restrictions`	`ARRAY<STRING>`
`is_formula_field`	`BOOLEAN`
`is_global_to_workspace`	`BOOLEAN`
`is_value_read_only`	`BOOLEAN`
`multi_enum_values`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>`
`number_value`	`DOUBLE`
`people_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`precision`	`BIGINT`
`privacy_setting`	`STRING`
`reference_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`representation_type`	`STRING`
`resource_subtype`	`STRING`
`text_value`	`STRING`
`type`	`STRING`
`workspace_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`asana_created_field`	`STRING`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`currency_code`	`STRING`
`custom_label`	`STRING`
`custom_label_position`	`STRING`
`date_value`	`STRUCT<date: STRING, date_time: STRING>`
`default_access_level`	`STRING`
`description`	`STRING`
`display_value`	`STRING`
`enabled`	`BOOLEAN`
`enum_options`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>`
`enum_value`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>`
`format`	`STRING`
`has_notifications_enabled`	`BOOLEAN`
`html_text_value`	`STRING`
`id_prefix`	`STRING`
`input_restrictions`	`ARRAY<STRING>`
`is_formula_field`	`BOOLEAN`
`is_global_to_workspace`	`BOOLEAN`
`is_value_read_only`	`BOOLEAN`
`multi_enum_values`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING, enabled: BOOLEAN, color: STRING>>`
`number_value`	`DOUBLE`
`people_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`precision`	`BIGINT`
`privacy_setting`	`STRING`
`reference_value`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`representation_type`	`STRING`
`resource_subtype`	`STRING`
`text_value`	`STRING`
`type`	`STRING`
`workspace_gid`	`STRING`

`task_attachments`

主キー: section_gid, task_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`connected_to_app`	`BOOLEAN`
`created_at`	`TIMESTAMP`
`download_url`	`STRING`
`host`	`STRING`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`permanent_url`	`STRING`
`resource_subtype`	`STRING`
`size`	`BIGINT`
`view_url`	`STRING`
`section_gid`	`STRING`
`task_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`connected_to_app`	`BOOLEAN`
`created_at`	`TIMESTAMP`
`download_url`	`STRING`
`host`	`STRING`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`permanent_url`	`STRING`
`resource_subtype`	`STRING`
`size`	`BIGINT`
`view_url`	`STRING`
`section_gid`	`STRING`
`task_gid`	`STRING`

`portfolios`

主キー： workspace_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`archived`	`BOOLEAN`
`color`	`STRING`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`default_access_level`	`STRING`
`due_on`	`DATE`
`members`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`owner`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`permalink_url`	`STRING`
`privacy_setting`	`STRING`
`project_templates`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`public`	`BOOLEAN`
`resource_subtype`	`STRING`
`start_on`	`DATE`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`archived`	`BOOLEAN`
`color`	`STRING`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`default_access_level`	`STRING`
`due_on`	`DATE`
`members`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`owner`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`permalink_url`	`STRING`
`privacy_setting`	`STRING`
`project_templates`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`public`	`BOOLEAN`
`resource_subtype`	`STRING`
`start_on`	`DATE`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace_gid`	`STRING`

`portfolio_memberships`

主キー： portfolio_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`access_level`	`STRING`
`member`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`parent`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`portfolio_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`access_level`	`STRING`
`member`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`parent`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`portfolio_gid`	`STRING`

`portfolio_items`

主キー： portfolio_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`archived`	`BOOLEAN`
`color`	`STRING`
`completed`	`BOOLEAN`
`completed_at`	`TIMESTAMP`
`completed_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_at`	`TIMESTAMP`
`created_from_template`	`STRUCT<gid: STRING, resource_type: STRING>`
`current_status`	`STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`default_access_level`	`STRING`
`default_view`	`STRING`
`is_template`	`BOOLEAN`
`due_date`	`DATE`
`due_on`	`DATE`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`html_notes`	`STRING`
`icon`	`STRING`
`members`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`minimum_access_level_for_customization`	`STRING`
`minimum_access_level_for_sharing`	`STRING`
`modified_at`	`TIMESTAMP`
`notes`	`STRING`
`owner`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`privacy_setting`	`STRING`
`project_brief`	`STRUCT<gid: STRING, resource_type: STRING>`
`public`	`BOOLEAN`
`resource_subtype`	`STRING`
`start_on`	`DATE`
`team`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`project_templates`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`portfolio_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`archived`	`BOOLEAN`
`color`	`STRING`
`completed`	`BOOLEAN`
`completed_at`	`TIMESTAMP`
`completed_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_at`	`TIMESTAMP`
`created_from_template`	`STRUCT<gid: STRING, resource_type: STRING>`
`current_status`	`STRUCT<gid: STRING, resource_type: STRING, title: STRING, text: STRING, html_text: STRING, color: STRING, author: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, created_at: TIMESTAMP, created_by: STRUCT<gid: STRING, resource_type: STRING, name: STRING>, modified_at: TIMESTAMP>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`custom_field_settings`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING>>`
`custom_fields`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`custom_type`	`STRUCT<gid: STRING, resource_type: STRING>`
`default_access_level`	`STRING`
`default_view`	`STRING`
`is_template`	`BOOLEAN`
`due_date`	`DATE`
`due_on`	`DATE`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`html_notes`	`STRING`
`icon`	`STRING`
`members`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`minimum_access_level_for_customization`	`STRING`
`minimum_access_level_for_sharing`	`STRING`
`modified_at`	`TIMESTAMP`
`notes`	`STRING`
`owner`	`STRUCT<gid: STRING, resource_type: STRING>`
`permalink_url`	`STRING`
`privacy_setting`	`STRING`
`project_brief`	`STRUCT<gid: STRING, resource_type: STRING>`
`public`	`BOOLEAN`
`resource_subtype`	`STRING`
`start_on`	`DATE`
`team`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`project_templates`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`portfolio_gid`	`STRING`

`project_memberships`

主キー： project_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`access_level`	`STRING`
`write_access`	`STRING`
`member`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`project_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`access_level`	`STRING`
`write_access`	`STRING`
`member`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`project_gid`	`STRING`

`custom_field_settings`

主キー： project_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`custom_field`	`VARIANT`
`is_important`	`BOOLEAN`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`project`	`STRUCT<gid: STRING, resource_type: STRING>`
`project_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`custom_field`	`VARIANT`
`is_important`	`BOOLEAN`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`project`	`STRUCT<gid: STRING, resource_type: STRING>`
`project_gid`	`STRING`

`project_status_updates`

主キー： project_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`author`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`modified_at`	`TIMESTAMP`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`status_type`	`STRING`
`text`	`STRING`
`title`	`STRING`
`project_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`author`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`modified_at`	`TIMESTAMP`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`status_type`	`STRING`
`text`	`STRING`
`title`	`STRING`
`project_gid`	`STRING`

`portfolio_status_updates`

主キー： portfolio_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`author`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`modified_at`	`TIMESTAMP`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`status_type`	`STRING`
`text`	`STRING`
`title`	`STRING`
`portfolio_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`author`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`modified_at`	`TIMESTAMP`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`status_type`	`STRING`
`text`	`STRING`
`title`	`STRING`
`portfolio_gid`	`STRING`

`goal_status_updates`

主キー： goal_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`author`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`modified_at`	`TIMESTAMP`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`status_type`	`STRING`
`text`	`STRING`
`title`	`STRING`
`goal_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`author`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`hearted`	`BOOLEAN`
`hearts`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`html_text`	`STRING`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`modified_at`	`TIMESTAMP`
`num_hearts`	`BIGINT`
`num_likes`	`BIGINT`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`reaction_summary`	`ARRAY<STRUCT<emoji_base: STRING, variant: STRING, count: DOUBLE, reacted: BOOLEAN>>`
`resource_subtype`	`STRING`
`status_type`	`STRING`
`text`	`STRING`
`title`	`STRING`
`goal_gid`	`STRING`

`workspace_memberships`

主キー： workspace_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`created_at`	`TIMESTAMP`
`is_active`	`BOOLEAN`
`is_admin`	`BOOLEAN`
`is_guest`	`BOOLEAN`
`is_view_only`	`BOOLEAN`
`user`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`user_task_list`	`STRUCT<gid: STRING, resource_type: STRING>`
`vacation_dates`	`STRUCT<start_on: STRING, end_on: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`workspace_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`created_at`	`TIMESTAMP`
`is_active`	`BOOLEAN`
`is_admin`	`BOOLEAN`
`is_guest`	`BOOLEAN`
`is_view_only`	`BOOLEAN`
`user`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`user_task_list`	`STRUCT<gid: STRING, resource_type: STRING>`
`vacation_dates`	`STRUCT<start_on: STRING, end_on: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`workspace_gid`	`STRING`

`goals`

主キー： workspace_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`owner`	`STRUCT<gid: STRING, resource_type: STRING>`
`team`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`html_notes`	`STRING`
`notes`	`STRING`
`due_on`	`DATE`
`start_on`	`DATE`
`status`	`STRING`
`metric`	`STRUCT<gid: STRING, resource_subtype: STRING, precision: BIGINT, unit: STRING, currency_code: STRING, initial_number_value: DOUBLE, target_number_value: DOUBLE, current_number_value: DOUBLE, current_display_value: STRING, progress_source: STRING, is_custom_weight: BOOLEAN, can_manage: BOOLEAN>`
`time_period`	`STRUCT<gid: STRING, resource_type: STRING>`
`is_workspace_level`	`BOOLEAN`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`num_likes`	`BIGINT`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`owner`	`STRUCT<gid: STRING, resource_type: STRING>`
`team`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace`	`STRUCT<gid: STRING, resource_type: STRING>`
`html_notes`	`STRING`
`notes`	`STRING`
`due_on`	`DATE`
`start_on`	`DATE`
`status`	`STRING`
`metric`	`STRUCT<gid: STRING, resource_subtype: STRING, precision: BIGINT, unit: STRING, currency_code: STRING, initial_number_value: DOUBLE, target_number_value: DOUBLE, current_number_value: DOUBLE, current_display_value: STRING, progress_source: STRING, is_custom_weight: BOOLEAN, can_manage: BOOLEAN>`
`time_period`	`STRUCT<gid: STRING, resource_type: STRING>`
`is_workspace_level`	`BOOLEAN`
`liked`	`BOOLEAN`
`likes`	`ARRAY<STRUCT<gid: STRING, user: STRUCT<gid: STRING, resource_type: STRING, name: STRING>>>`
`num_likes`	`BIGINT`
`followers`	`ARRAY<STRUCT<gid: STRING, resource_type: STRING, name: STRING>>`
`current_status_update`	`STRUCT<gid: STRING, resource_type: STRING>`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING>`
`workspace_gid`	`STRING`

`goal_relationships`

主キー： goal_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`resource_subtype`	`STRING`
`supporting_resource`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`supported_goal`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`contribution_weight`	`DOUBLE`
`goal_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`resource_subtype`	`STRING`
`supporting_resource`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`supported_goal`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`contribution_weight`	`DOUBLE`
`goal_gid`	`STRING`

`time_tracking_entries`

主キー: section_gid, task_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`duration_minutes`	`BIGINT`
`entered_on`	`DATE`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`section_gid`	`STRING`
`task_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`duration_minutes`	`BIGINT`
`entered_on`	`DATE`
`created_by`	`STRUCT<gid: STRING, resource_type: STRING, name: STRING>`
`created_at`	`TIMESTAMP`
`section_gid`	`STRING`
`task_gid`	`STRING`

`project_attachments`

主キー： project_gid, gid

同期モード: フル更新のみ

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`connected_to_app`	`BOOLEAN`
`created_at`	`TIMESTAMP`
`download_url`	`STRING`
`host`	`STRING`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`permanent_url`	`STRING`
`resource_subtype`	`STRING`
`size`	`BIGINT`
`view_url`	`STRING`
`project_gid`	`STRING`

フィールド	データ型
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`connected_to_app`	`BOOLEAN`
`created_at`	`TIMESTAMP`
`download_url`	`STRING`
`host`	`STRING`
`parent`	`STRUCT<gid: STRING, resource_type: STRING>`
`permanent_url`	`STRING`
`resource_subtype`	`STRING`
`size`	`BIGINT`
`view_url`	`STRING`
`project_gid`	`STRING`

サポートされているソーステーブル​

コネクタオプション​

宛先テーブルのスキーマ​

workspaces​

users​

teams​

team_memberships​

projects​

sections​

tasks​

stories​

tags​

custom_fields​

task_attachments​

portfolios​

portfolio_memberships​

portfolio_items​

project_memberships​

custom_field_settings​

project_status_updates​

portfolio_status_updates​

goal_status_updates​

workspace_memberships​

goals​

goal_relationships​

time_tracking_entries​

project_attachments​

サポートされているソーステーブル

コネクタオプション

宛先テーブルのスキーマ

`workspaces`

`users`

`teams`

`team_memberships`

`projects`

`sections`

`tasks`

`stories`

`tags`

`custom_fields`

`task_attachments`

`portfolios`

`portfolio_memberships`

`portfolio_items`

`project_memberships`

`custom_field_settings`

`project_status_updates`

`portfolio_status_updates`

`goal_status_updates`

`workspace_memberships`

`goals`

`goal_relationships`

`time_tracking_entries`

`project_attachments`