Référence du connecteur Asana

info

Bêta

Cette fonctionnalité est en version Bêta. Pour l'utiliser, un administrateur du workspace doit activer Lakeflow Connect for Asana à partir de la page Prévisualisations . Consultez Gérer les aperçus Databricks.

Le connecteur Asana géré dans Lakeflow Connect prend en charge 24 tables sources dans le schéma default. Toutes les tables utilisent un refresh complet, de sorte que chaque mise à jour du pipeline ingère à nouveau chaque enregistrement.

Tables sources prises en charge

Le connecteur Asana prend en charge les tables source suivantes, toutes sous le schéma source default :

Table source	Clé primaire	Description	Mode de synchronisation
`workspaces`	`gid`	Workspace et organisations auxquels l’utilisateur autorisant appartient.	refresh complète uniquement
`users`	`workspace_gid`, `gid`	Membres de chaque workspace, y compris leurs adresses e-mail et photos de profil.	refresh complète uniquement
`teams`	`workspace_gid`, `gid`	Les équipes de chaque organisation, ainsi que leurs descriptions et leurs paramètres d’accès.	refresh complète uniquement
`team_memberships`	`team_gid`, `gid`	Adhésions des utilisateurs dans chaque équipe.	refresh complète uniquement
`projects`	`team_gid`, `gid`	Projets de chaque équipe, y compris leur statut, leurs dates, leurs propriétaires et leurs membres.	refresh complète uniquement
`sections`	`project_gid`, `gid`	Sections dans chaque projet.	refresh complète uniquement
`tasks`	`section_gid`, `gid`	Tâches dans chaque section de projet, y compris les personnes affectées, les dates, les appartenances et les valeurs de champ personnalisées.	refresh complète uniquement
`stories`	`section_gid`, `task_gid`, `gid`	Historique de chaque tâche, y compris les commentaires et les activités comme les modifications de champ.	refresh complète uniquement
`tags`	`workspace_gid`, `gid`	Tags dans chaque workspace.	refresh complète uniquement
`custom_fields`	`workspace_gid`, `gid`	Définitions de champ personnalisées dans chaque Workspace.	refresh complète uniquement
`task_attachments`	`section_gid`, `task_gid`, `gid`	Pièces jointes à chaque tâche.	refresh complète uniquement
`portfolios`	`workspace_gid`, `gid`	Portefeuilles détenus par l’utilisateur autorisant dans chaque workspace.	refresh complète uniquement
`portfolio_memberships`	`portfolio_gid`, `gid`	Appartenance des utilisateurs à chaque portefeuille détenu par l'utilisateur autorisant.	refresh complète uniquement
`portfolio_items`	`portfolio_gid`, `gid`	Éléments de chaque portefeuille que l’utilisateur autorisateur possède.	refresh complète uniquement
`project_memberships`	`project_gid`, `gid`	Appartenance aux projets pour les utilisateurs et les équipes.	refresh complète uniquement
`custom_field_settings`	`project_gid`, `gid`	Champs personnalisés associés à chaque projet.	refresh complète uniquement
`project_status_updates`	`project_gid`, `gid`	Mises à jour du statut de chaque projet.	refresh complète uniquement
`portfolio_status_updates`	`portfolio_gid`, `gid`	Mises à jour de l'état d'avancement de chaque portefeuille appartenant à l'utilisateur autorisé.	refresh complète uniquement
`goal_status_updates`	`goal_gid`, `gid`	Mises à jour du statut pour chaque objectif.	refresh complète uniquement
`workspace_memberships`	`workspace_gid`, `gid`	Appartenances des utilisateurs à chaque workspace.	refresh complète uniquement
`goals`	`workspace_gid`, `gid`	Objectifs dans chaque workspace.	refresh complète uniquement
`goal_relationships`	`goal_gid`, `gid`	Relations entre chaque objectif et les projets, portefeuilles ou objectifs qui le soutiennent.	refresh complète uniquement
`time_tracking_entries`	`section_gid`, `task_gid`, `gid`	Entrées de suivi du temps sur chaque tâche.	refresh complète uniquement
`project_attachments`	`project_gid`, `gid`	Pièces jointes sur chaque projet.	refresh complète uniquement

Table source	Clé primaire	Description	Mode de synchronisation
`workspaces`	`gid`	Workspace et organisations auxquels l’utilisateur autorisant appartient.	refresh complète uniquement
`users`	`workspace_gid`, `gid`	Membres de chaque workspace, y compris leurs adresses e-mail et photos de profil.	refresh complète uniquement
`teams`	`workspace_gid`, `gid`	Les équipes de chaque organisation, ainsi que leurs descriptions et leurs paramètres d’accès.	refresh complète uniquement
`team_memberships`	`team_gid`, `gid`	Adhésions des utilisateurs dans chaque équipe.	refresh complète uniquement
`projects`	`team_gid`, `gid`	Projets de chaque équipe, y compris leur statut, leurs dates, leurs propriétaires et leurs membres.	refresh complète uniquement
`sections`	`project_gid`, `gid`	Sections dans chaque projet.	refresh complète uniquement
`tasks`	`section_gid`, `gid`	Tâches dans chaque section de projet, y compris les personnes affectées, les dates, les appartenances et les valeurs de champ personnalisées.	refresh complète uniquement
`stories`	`section_gid`, `task_gid`, `gid`	Historique de chaque tâche, y compris les commentaires et les activités comme les modifications de champ.	refresh complète uniquement
`tags`	`workspace_gid`, `gid`	Tags dans chaque workspace.	refresh complète uniquement
`custom_fields`	`workspace_gid`, `gid`	Définitions de champ personnalisées dans chaque Workspace.	refresh complète uniquement
`task_attachments`	`section_gid`, `task_gid`, `gid`	Pièces jointes à chaque tâche.	refresh complète uniquement
`portfolios`	`workspace_gid`, `gid`	Portefeuilles détenus par l’utilisateur autorisant dans chaque workspace.	refresh complète uniquement
`portfolio_memberships`	`portfolio_gid`, `gid`	Appartenance des utilisateurs à chaque portefeuille détenu par l'utilisateur autorisant.	refresh complète uniquement
`portfolio_items`	`portfolio_gid`, `gid`	Éléments de chaque portefeuille que l’utilisateur autorisateur possède.	refresh complète uniquement
`project_memberships`	`project_gid`, `gid`	Appartenance aux projets pour les utilisateurs et les équipes.	refresh complète uniquement
`custom_field_settings`	`project_gid`, `gid`	Champs personnalisés associés à chaque projet.	refresh complète uniquement
`project_status_updates`	`project_gid`, `gid`	Mises à jour du statut de chaque projet.	refresh complète uniquement
`portfolio_status_updates`	`portfolio_gid`, `gid`	Mises à jour de l'état d'avancement de chaque portefeuille appartenant à l'utilisateur autorisé.	refresh complète uniquement
`goal_status_updates`	`goal_gid`, `gid`	Mises à jour du statut pour chaque objectif.	refresh complète uniquement
`workspace_memberships`	`workspace_gid`, `gid`	Appartenances des utilisateurs à chaque workspace.	refresh complète uniquement
`goals`	`workspace_gid`, `gid`	Objectifs dans chaque workspace.	refresh complète uniquement
`goal_relationships`	`goal_gid`, `gid`	Relations entre chaque objectif et les projets, portefeuilles ou objectifs qui le soutiennent.	refresh complète uniquement
`time_tracking_entries`	`section_gid`, `task_gid`, `gid`	Entrées de suivi du temps sur chaque tâche.	refresh complète uniquement
`project_attachments`	`project_gid`, `gid`	Pièces jointes sur chaque projet.	refresh complète uniquement

Options du connecteur

Le connecteur Asana ne possède pas d'autres options de configuration au-delà des paramètres de pipeline disponibles pour tous les connecteurs gérés. Voir Ingérer des données depuis Asana.

Schémas de table de destination

`workspaces`

Clé primaire : gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`gid`	`STRING`
`resource_type`	`STRING`
`name`	`STRING`
`email_domains`	`ARRAY<STRING>`
`is_organization`	`BOOLEAN`

`users`

Clé primaire : workspace_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : workspace_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : team_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : team_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : project_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : section_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé principale : section_gid, task_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : workspace_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : workspace_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé principale : section_gid, task_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : workspace_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : portfolio_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : portfolio_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : project_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : project_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : project_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : portfolio_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : goal_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : workspace_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : workspace_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : goal_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé principale : section_gid, task_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Clé primaire : project_gid, gid

Mode de synchronisation : refresh complète uniquement

Champ	Type de données
`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`

Champ	Type de données
`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`

Tables sources prises en charge​

Options du connecteur​

Schémas de table de destination​

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​

Tables sources prises en charge

Options du connecteur

Schémas de table de destination

`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`