# Asana

Asana is a team communication manager.

Asana integration replicates data using the [Asana API](https://asana.com/developers/documentation/examples-tutorials/overview).

See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#Schema) section for a list of objects available for replication.

## Preparing for authentication

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

Information noteMake sure that the account you use has read access to the tables you want to fetch.

To retrieve your client ID and secret:

1. Log into your [Asana](https://app.asana.com/-/login?u=%2F0%2Fmy-apps) account.
2. In the My apps section, click Create new app.
3. Complete the required information, then click Create app.
4. Select the OAuth tab.
5. Make sure Redirect URLs is set to https://connector.qlik.com/auth/oauth/v3.htm.
6. In the Permission scopes section, select Full permissions.
7. Select the Manage distribution tab.
8. Click Add workspace.
9. From the dropdown menu, select the workspace you want to replicate data from, then click Add.
10. In the OAuth section, copy and paste your client secret and client ID into a secured file.

## Creating the connection

For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm).

1. Click Authenticate when you have filled in the required connection settings.

   You may be asked to log in to the source application.

   A window is displayed with an authentication code.

2. Copy the code to the clipboard and return to the connection dialog.

3. Paste the code in Complete authentication with the code provided by the source and click Verify.

   Tip noteYou may need to scroll down to see this field.

   When status is Verified, the authentication is verified.

4. Provide a name for the connection in Connection name.

5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings

| Setting | Description |
| --- | --- |
| Data gateway | Select a Data Movement gateway if required by your use case.<br><br>Information note<br><br>This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.<br><br>For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). |
| Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. |
| Client ID | Client ID. |
| Client Secret | Client secret. |

## Schema

Information note

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

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](https://developers.asana.com/Content/portfolios)<br><br>[Asana API method](https://developers.asana.com/Content/get-multiple-portfolios "Opens in new tab: Asana API method") |

portfolios table foreign keys

| Join portfolios with | on |
| --- | --- |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>portfolios.created_by.gid = projects.followers.gid<br>```<br><br>```<br>portfolios.members.gid = projects.followers.gid<br>```<br><br>```<br>portfolios.owner.gid = projects.followers.gid<br>```<br><br>```<br>portfolios.created_by.gid = projects.members.gid<br>```<br><br>```<br>portfolios.members.gid = projects.members.gid<br>```<br><br>```<br>portfolios.owner.gid = projects.members.gid<br>```<br><br>```<br>portfolios.created_by.gid = projects.owner.gid<br>```<br><br>```<br>portfolios.members.gid = projects.owner.gid<br>```<br><br>```<br>portfolios.owner.gid = projects.owner.gid<br>```<br><br>```<br>portfolios.workspace.gid = projects.workspace.gid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tags) | ```<br>portfolios.created_by.gid = tags.followers.gid<br>```<br><br>```<br>portfolios.members.gid = tags.followers.gid<br>```<br><br>```<br>portfolios.owner.gid = tags.followers.gid<br>```<br><br>```<br>portfolios.workspace.gid = tags.workspace.gid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>portfolios.created_by.gid = tasks.assignee.gid<br>```<br><br>```<br>portfolios.members.gid = tasks.assignee.gid<br>```<br><br>```<br>portfolios.owner.gid = tasks.assignee.gid<br>```<br><br>```<br>portfolios.created_by.gid = tasks.followers.gid<br>```<br><br>```<br>portfolios.members.gid = tasks.followers.gid<br>```<br><br>```<br>portfolios.owner.gid = tasks.followers.gid<br>```<br><br>```<br>portfolios.workspace.gid = tasks.workspace.gid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#users) | ```<br>portfolios.created_by.gid = users.gid<br>```<br><br>```<br>portfolios.members.gid = users.gid<br>```<br><br>```<br>portfolios.owner.gid = users.gid<br>```<br><br>```<br>portfolios.workspace.gid = users.workspaces.gid<br>``` |
| [stories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#stories) | ```<br>portfolios.created_by.gid = stories.assignee.gid<br>```<br><br>```<br>portfolios.members.gid = stories.assignee.gid<br>```<br><br>```<br>portfolios.owner.gid = stories.assignee.gid<br>```<br><br>```<br>portfolios.created_by.gid = stories.created_by.gid<br>```<br><br>```<br>portfolios.members.gid = stories.created_by.gid<br>```<br><br>```<br>portfolios.owner.gid = stories.created_by.gid<br>```<br><br>```<br>portfolios.created_by.gid = stories.dependency.gid<br>```<br><br>```<br>portfolios.members.gid = stories.dependency.gid<br>```<br><br>```<br>portfolios.owner.gid = stories.dependency.gid<br>``` |
| [teams](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#teams) | ```<br>portfolios.created_by.gid = teams.users.gid<br>```<br><br>```<br>portfolios.members.gid = teams.users.gid<br>```<br><br>```<br>portfolios.owner.gid = teams.users.gid<br>```<br><br>```<br>portfolios.workspace.gid = teams.organization.gid<br>``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#workspaces) | ```<br>portfolios.workspace.gid = workspaces.gid<br>``` |

portfolios table schema

| **color**<br><br><br>STRING |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **created\_by**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **current\_status\_update**<br><br><br>OBJECT<br>\*<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>title: STRING</li></ul> |
| **custom\_field\_settings**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>custom_field: OBJECT, which is also a nested data structure.											<ul><li>created_by: OBJECT, which is also a nested data structure.													<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>currency_code: STRING</li><li>custom_label: STRING</li><li>custom_label_position: STRING</li><li>date_value: OBJECT, which is also a nested data structure.													<ul><li>date: STRING</li><li>date_time: DATE-TIME</li></ul></li><li>description: STRING</li><li>display_value: STRING</li><li>enabled: BOOLEAN</li><li>enum_options: ARRAY, which is also a nested data structure.													<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>enum_value: OBJECT, which is also a nested data structure.													<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>format: STRING</li><li>gid: STRING</li><li>has_notifications_enabled: BOOLEAN</li><li>is_global_to_workspace: BOOLEAN</li><li>multi_enum_values: ARRAY, which is also a nested data structure.													<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>name: STRING</li><li>number_value: NUMBER</li><li>people_value: ARRAY, which is also a nested data structure.													<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>precision: INTEGER</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text_value: STRING</li><li>type: STRING</li></ul></li><li>gid: STRING</li><li>is_important: BOOLEAN</li><li>parent: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>project: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>resource_type: STRING</li></ul> |
| **custom\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>date_value: OBJECT, which is also a nested data structure.											<ul><li>date: STRING</li><li>date_time: DATE-TIME</li></ul></li><li>display_value: STRING</li><li>enabled: BOOLEAN</li><li>enum_options: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>enum_value: OBJECT, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>gid: STRING</li><li>multi_enum_values: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>name: STRING</li><li>number_value: NUMBER</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text_value: STRING</li><li>type: STRING</li></ul> |
| **due\_on**<br><br><br>STRING |
| **gid**<br><br><br>STRING |
| **is\_template**<br><br><br>BOOLEAN |
| **members**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **name**<br><br><br>STRING |
| **owner**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **permalink\_url**<br><br><br>STRING |
| **portfolio\_items**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **public**<br><br><br>BOOLEAN |
| **resource\_type**<br><br><br>STRING |
| **start\_on**<br><br><br>STRING |
| **workspace**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |

### 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](https://asana.com/developers/api-reference/projects) |

projects table foreign keys

| Join projects with | on |
| --- | --- |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>projects.gid = tasks.projects.gid<br>```<br><br>```<br>projects.followers.gid = tasks.assignee.gid<br>```<br><br>```<br>projects.members.gid = tasks.assignee.gid<br>```<br><br>```<br>projects.owner.gid = tasks.assignee.gid<br>```<br><br>```<br>projects.followers.gid = tasks.followers.gid<br>```<br><br>```<br>projects.members.gid = tasks.followers.gid<br>```<br><br>```<br>projects.owner.gid = tasks.followers.gid<br>```<br><br>```<br>projects.workspace.gid = tasks.workspace.gid<br>``` |
| [stories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#stories) | ```<br>projects.gid = stories.project.gid<br>```<br><br>```<br>projects.followers.gid = stories.assignee.gid<br>```<br><br>```<br>projects.members.gid = stories.assignee.gid<br>```<br><br>```<br>projects.owner.gid = stories.assignee.gid<br>```<br><br>```<br>projects.followers.gid = stories.created_by.gid<br>```<br><br>```<br>projects.members.gid = stories.created_by.gid<br>```<br><br>```<br>projects.owner.gid = stories.created_by.gid<br>```<br><br>```<br>projects.followers.gid = stories.dependency.gid<br>```<br><br>```<br>projects.members.gid = stories.dependency.gid<br>```<br><br>```<br>projects.owner.gid = stories.dependency.gid<br>``` |
| [sections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#sections) | ```<br>projects.gid = sections.project.gid<br>```<br><br>```<br>projects.gid = sections.projects.gid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tags) | ```<br>projects.followers.gid = tags.followers.gid<br>```<br><br>```<br>projects.members.gid = tags.followers.gid<br>```<br><br>```<br>projects.owner.gid = tags.followers.gid<br>```<br><br>```<br>projects.workspace.gid = tags.workspace.gid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#users) | ```<br>projects.followers.gid = users.gid<br>```<br><br>```<br>projects.members.gid = users.gid<br>```<br><br>```<br>projects.owner.gid = users.gid<br>```<br><br>```<br>projects.workspace.gid = users.workspaces.gid<br>``` |
| [portfolios](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#portfolios) | ```<br>projects.followers.gid = portfolios.created_by.gid<br>```<br><br>```<br>projects.members.gid = portfolios.created_by.gid<br>```<br><br>```<br>projects.owner.gid = portfolios.created_by.gid<br>```<br><br>```<br>projects.followers.gid = portfolios.members.gid<br>```<br><br>```<br>projects.members.gid = portfolios.members.gid<br>```<br><br>```<br>projects.owner.gid = portfolios.members.gid<br>```<br><br>```<br>projects.followers.gid = portfolios.owner.gid<br>```<br><br>```<br>projects.members.gid = portfolios.owner.gid<br>```<br><br>```<br>projects.owner.gid = portfolios.owner.gid<br>```<br><br>```<br>projects.workspace.gid = portfolios.workspace.gid<br>``` |
| [teams](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#teams) | ```<br>projects.followers.gid = teams.users.gid<br>```<br><br>```<br>projects.members.gid = teams.users.gid<br>```<br><br>```<br>projects.owner.gid = teams.users.gid<br>```<br><br>```<br>projects.workspace.gid = teams.organization.gid<br>``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#workspaces) | ```<br>projects.workspace.gid = workspaces.gid<br>``` |

projects table schema

| **archived**<br><br><br>BOOLEAN |
| --- |
| **color**<br><br><br>STRING |
| **completed**<br><br><br>BOOLEAN |
| **completed\_at**<br><br><br>DATE-TIME |
| **completed\_by**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **created\_at**<br><br><br>DATE-TIME |
| **created\_from\_template**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **current\_status**<br><br><br>STRING |
| **current\_status\_update**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>title: STRING</li></ul> |
| **custom\_field\_settings**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>custom_field: OBJECT, which is also a nested data structure.											<ul><li>created_by: OBJECT, which is also a nested data structure.													<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>currency_code: STRING</li><li>custom_label: STRING</li><li>custom_label_position: STRING</li><li>date_value: OBJECT, which is also a nested data structure.													<ul><li>date: STRING</li><li>date_time: DATE-TIME</li></ul></li><li>description: STRING</li><li>display_value: STRING</li><li>enabled: BOOLEAN</li><li>enum_options: ARRAY, which is also a nested data structure.													<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>enum_value: OBJECT, which is also a nested data structure.													<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>format: STRING</li><li>gid: STRING</li><li>has_notifications_enabled: BOOLEAN</li><li>is_global_to_workspace: BOOLEAN</li><li>multi_enum_values: ARRAY, which is also a nested data structure.													<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>name: STRING</li><li>number_value: NUMBER</li><li>people_value: ARRAY, which is also a nested data structure.													<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>precision: INTEGER</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text_value: STRING</li><li>type: STRING</li></ul></li><li>gid: STRING</li><li>is_important: BOOLEAN</li><li>parent: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>project: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>resource_type: STRING</li></ul> |
| **custom\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>date_value: OBJECT, which is also a nested data structure.											<ul><li>date: STRING</li><li>date_time: DATE-TIME</li></ul></li><li>description: STRING</li><li>display_value: STRING</li><li>enabled: BOOLEAN</li><li>enum_options: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>enum_value: OBJECT, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>gid: STRING</li><li>has_notifications_enabled: BOOLEAN</li><li>is_global_to_workspace: BOOLEAN</li><li>multi_enum_values: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>name: STRING</li><li>number_value: NUMBER</li><li>precision: INTEGER</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text_value: STRING</li><li>type: STRING</li></ul> |
| **default\_view**<br><br><br>STRING |
| **due\_date**<br><br><br>STRING |
| **due\_on**<br><br><br>STRING |
| **followers**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **gid**<br><br><br>STRING |
| **html\_notes**<br><br><br>STRING |
| **icon**<br><br><br>STRING |
| **is\_template**<br><br><br>BOOLEAN |
| **members**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **modified\_at**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **notes**<br><br><br>STRING |
| **owner**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **permalink\_url**<br><br><br>STRING |
| **project\_brief**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>resource_type: STRING</li></ul> |
| **public**<br><br><br>BOOLEAN |
| **resource\_type**<br><br><br>STRING |
| **start\_on**<br><br><br>STRING |
| **team**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **workspace**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |

### 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](https://developers.asana.com/Content/sections)<br><br>[Asana API method](https://developers.asana.com/Content/get-sections-in-a-project "Opens in new tab: Asana API method") |

sections table foreign keys

| Join sections with | on |
| --- | --- |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>sections.project.gid = projects.gid<br>```<br><br>```<br>sections.projects.gid = projects.gid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>sections.project.gid = tasks.projects.gid<br>```<br><br>```<br>sections.projects.gid = tasks.projects.gid<br>``` |
| [stories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#stories) | ```<br>sections.project.gid = stories.project.gid<br>```<br><br>```<br>sections.projects.gid = stories.project.gid<br>```<br><br>```<br>sections.gid = stories.new_section.gid<br>```<br><br>```<br>sections.gid = stories.old_section.gid<br>``` |

sections table schema

| **created\_at**<br><br><br>DATE-TIME |
| --- |
| **gid**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **project**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **projects**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **resource\_type**<br><br><br>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](https://developers.asana.com/Content/stories)<br><br>[Asana API method](https://developers.asana.com/Content/get-stories-from-a-task "Opens in new tab: Asana API method") |

stories table foreign keys

| Join stories with | on |
| --- | --- |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>stories.project.gid = projects.gid<br>```<br><br>```<br>stories.assignee.gid = projects.followers.gid<br>```<br><br>```<br>stories.created_by.gid = projects.followers.gid<br>```<br><br>```<br>stories.dependency.gid = projects.followers.gid<br>```<br><br>```<br>stories.assignee.gid = projects.members.gid<br>```<br><br>```<br>stories.created_by.gid = projects.members.gid<br>```<br><br>```<br>stories.dependency.gid = projects.members.gid<br>```<br><br>```<br>stories.assignee.gid = projects.owner.gid<br>```<br><br>```<br>stories.created_by.gid = projects.owner.gid<br>```<br><br>```<br>stories.dependency.gid = projects.owner.gid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>stories.project.gid = tasks.projects.gid<br>```<br><br>```<br>stories.task.gid = tasks.gid<br>```<br><br>```<br>stories.assignee.gid = tasks.assignee.gid<br>```<br><br>```<br>stories.created_by.gid = tasks.assignee.gid<br>```<br><br>```<br>stories.dependency.gid = tasks.assignee.gid<br>```<br><br>```<br>stories.assignee.gid = tasks.followers.gid<br>```<br><br>```<br>stories.created_by.gid = tasks.followers.gid<br>```<br><br>```<br>stories.dependency.gid = tasks.followers.gid<br>``` |
| [sections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#sections) | ```<br>stories.project.gid = sections.project.gid<br>```<br><br>```<br>stories.project.gid = sections.projects.gid<br>```<br><br>```<br>stories.new_section.gid = sections.gid<br>```<br><br>```<br>stories.old_section.gid = sections.gid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tags) | ```<br>stories.tag.gid = tags.gid<br>```<br><br>```<br>stories.assignee.gid = tags.followers.gid<br>```<br><br>```<br>stories.created_by.gid = tags.followers.gid<br>```<br><br>```<br>stories.dependency.gid = tags.followers.gid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#users) | ```<br>stories.assignee.gid = users.gid<br>```<br><br>```<br>stories.created_by.gid = users.gid<br>```<br><br>```<br>stories.dependency.gid = users.gid<br>``` |
| [portfolios](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#portfolios) | ```<br>stories.assignee.gid = portfolios.created_by.gid<br>```<br><br>```<br>stories.created_by.gid = portfolios.created_by.gid<br>```<br><br>```<br>stories.dependency.gid = portfolios.created_by.gid<br>```<br><br>```<br>stories.assignee.gid = portfolios.members.gid<br>```<br><br>```<br>stories.created_by.gid = portfolios.members.gid<br>```<br><br>```<br>stories.dependency.gid = portfolios.members.gid<br>```<br><br>```<br>stories.assignee.gid = portfolios.owner.gid<br>```<br><br>```<br>stories.created_by.gid = portfolios.owner.gid<br>```<br><br>```<br>stories.dependency.gid = portfolios.owner.gid<br>``` |
| [teams](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#teams) | ```<br>stories.assignee.gid = teams.users.gid<br>```<br><br>```<br>stories.created_by.gid = teams.users.gid<br>```<br><br>```<br>stories.dependency.gid = teams.users.gid<br>``` |

stories table schema

| **assignee**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **created\_by**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **custom\_field**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>date_value: OBJECT, which is also a nested data structure.											<ul><li>date: STRING</li><li>date_time: DATE-TIME</li></ul></li><li>display_value: STRING</li><li>enabled: BOOLEAN</li><li>enum_options: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>enum_value: OBJECT, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>gid: STRING</li><li>multi_enum_values: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>name: STRING</li><li>number_value: NUMBER</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text_value: STRING</li><li>type: STRING</li></ul> |
| **dependency**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li></ul> |
| **duplicate\_of**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li></ul> |
| **duplicated\_from**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li></ul> |
| **follower**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **gid**<br><br><br>STRING |
| **hearted**<br><br><br>BOOLEAN |
| **hearts**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>user: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **html\_text**<br><br><br>STRING |
| **is\_editable**<br><br><br>BOOLEAN |
| **is\_edited**<br><br><br>BOOLEAN |
| **is\_pinned**<br><br><br>BOOLEAN |
| **liked**<br><br><br>BOOLEAN |
| **likes**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>user: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **new\_approval\_status**<br><br><br>BOOLEAN |
| **new\_date\_value**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>due_at: DATE-TIME</li><li>due_on: STRING</li><li>start_on: STRING</li></ul> |
| **new\_dates**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>due_at: DATE-TIME</li><li>due_on: STRING</li><li>start_on: STRING</li></ul> |
| **new\_enum\_value**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>color: STRING</li><li>enabled: ENABLED</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **new\_multi\_enum\_values**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>color: STRING</li><li>enabled: ENABLED</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **new\_name**<br><br><br>STRING |
| **new\_number\_value**<br><br><br>NUMBER |
| **new\_people\_value**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **new\_resource\_subtype**<br><br><br>STRING |
| **new\_section**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **new\_text\_value**<br><br><br>STRING |
| **num\_hearts**<br><br><br>INTEGER |
| **num\_likes**<br><br><br>INTEGER |
| **old\_approval\_status**<br><br><br>STRING |
| **old\_date\_value**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>due_at: DATE-TIME</li><li>due_on: STRING</li><li>start_on: STRING</li></ul> |
| **old\_dates**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>due_at: DATE-TIME</li><li>due_on: STRING</li><li>start_on: STRING</li></ul> |
| **old\_enum\_value**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>color: STRING</li><li>enabled: ENABLED</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **old\_multi\_enum\_values**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>color: STRING</li><li>enabled: ENABLED</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **old\_name**<br><br><br>STRING |
| **old\_number\_value**<br><br><br>NUMBER |
| **old\_people\_value**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **old\_resource\_subtype**<br><br><br>STRING |
| **old\_section**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **old\_text\_value**<br><br><br>STRING |
| **previews**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>fallback: STRING</li><li>footer: STRING</li><li>header: STRING</li><li>header_link: STRING</li><li>html_text: STRING</li><li>text: STRING</li><li>title: STRING</li><li>title: STRING</li></ul> |
| **project**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **resource\_subtype**<br><br><br>STRING |
| **resource\_type**<br><br><br>STRING |
| **source**<br><br><br>STRING |
| **sticker\_name**<br><br><br>STRING |
| **story**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>created_at: DATE-TIME</li><li>created_by: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text: STRING</li></ul> |
| **tag**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **target**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li></ul> |
| **task**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li></ul> |
| **text**<br><br><br>STRING |
| **type**<br><br><br>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](https://developers.asana.com/reference/getsubtasksfortask "Opens in new tab: Asana API method") |

subtasks table schema

| **assignee**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| --- |
| **assignee\_status**<br><br><br>STRING |
| **completed**<br><br><br>BOOLEAN |
| **completed\_at**<br><br><br>DATE-TIME |
| **completed\_by**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **created\_at**<br><br><br>DATE-TIME |
| **custom\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>created_by: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>currency_code: STRING</li><li>custom_label: STRING</li><li>custom_label_position: STRING</li><li>date_value: OBJECT, which is also a nested data structure.											<ul><li>date: STRING</li><li>date_time: DATE-TIME</li></ul></li><li>description: STRING</li><li>display_value: STRING</li><li>enabled: BOOLEAN</li><li>enum_options: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>enum_value: OBJECT, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>format: STRING</li><li>gid: STRING</li><li>has_notifications_enabled: BOOLEAN</li><li>is_global_to_workspace: BOOLEAN</li><li>multi_enum_values: ARRAY, which is also a nested data structure.											<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>name: STRING</li><li>number_value: NUMBER</li><li>people_value: ARRAY, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>precision: INTEGER</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text_value: STRING</li><li>type: STRING</li></ul> |
| **dependencies**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **dependents**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **due\_at**<br><br><br>DATE-TIME |
| **due\_on**<br><br><br>DATE-TIME |
| **followers**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **gid**<br><br><br>STRING |
| **hearted**<br><br><br>BOOLEAN |
| **hearts**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>user: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **html\_notes**<br><br><br>STRING |
| **is\_rendered\_as\_separator**<br><br><br>BOOLEAN |
| **liked**<br><br><br>BOOLEAN |
| **likes**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>user: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **memberships**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>project: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>section: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **modified\_at**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **notes**<br><br><br>STRING |
| **num\_hearts**<br><br><br>INTEGER |
| **num\_likes**<br><br><br>INTEGER |
| **num\_subtasks**<br><br><br>INTEGER |
| **parent**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li></ul> |
| **permalink\_url**<br><br><br>STRING |
| **projects**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **resource\_subtype**<br><br><br>STRING |
| **resource\_type**<br><br><br>STRING |
| **start\_at**<br><br><br>DATE-TIME |
| **start\_on**<br><br><br>STRING |
| **tags**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **workspace**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |

### tags

The `tags` table contains info about the tags in your Asana account. A tag is a label that can be attached to any task in Asana.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | gid |
| **Replication Key** | created\_at |
| **Useful links** | [Asana documentation](https://asana.com/developers/api-reference/tags) |

tags table foreign keys

| Join tags with | on |
| --- | --- |
| [stories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#stories) | ```<br>tags.gid = stories.tag.gid<br>```<br><br>```<br>tags.followers.gid = stories.assignee.gid<br>```<br><br>```<br>tags.followers.gid = stories.created_by.gid<br>```<br><br>```<br>tags.followers.gid = stories.dependency.gid<br>``` |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>tags.followers.gid = projects.followers.gid<br>```<br><br>```<br>tags.followers.gid = projects.members.gid<br>```<br><br>```<br>tags.followers.gid = projects.owner.gid<br>```<br><br>```<br>tags.workspace.gid = projects.workspace.gid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>tags.followers.gid = tasks.assignee.gid<br>```<br><br>```<br>tags.followers.gid = tasks.followers.gid<br>```<br><br>```<br>tags.workspace.gid = tasks.workspace.gid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#users) | ```<br>tags.followers.gid = users.gid<br>```<br><br>```<br>tags.workspace.gid = users.workspaces.gid<br>``` |
| [portfolios](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#portfolios) | ```<br>tags.followers.gid = portfolios.created_by.gid<br>```<br><br>```<br>tags.followers.gid = portfolios.members.gid<br>```<br><br>```<br>tags.followers.gid = portfolios.owner.gid<br>```<br><br>```<br>tags.workspace.gid = portfolios.workspace.gid<br>``` |
| [teams](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#teams) | ```<br>tags.followers.gid = teams.users.gid<br>```<br><br>```<br>tags.workspace.gid = teams.organization.gid<br>``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#workspaces) | ```<br>tags.workspace.gid = workspaces.gid<br>``` |

tags table schema

| **color**<br><br><br>STRING |
| --- |
| **created\_at**<br><br><br>DATE-TIME |
| **followers**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **gid**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **notes**<br><br><br>STRING |
| **permalink\_url**<br><br><br>STRING |
| **resource\_type**<br><br><br>STRING |
| **workspace**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |

### tasks

The `tasks` table contains info about the tasks in your Asana account.

#### Custom fields

To replicate task custom fields, select the `custom_fields` attribute in Stitch. If your destination doesn’t natively support nested data structures, two subtables (`tasks__custom_fields`, `tasks__custom_fields__enum_options`) will be created.

| **Replication Method** | CDC |
| --- | --- |
| **Primary Key** | gid |
| **Replication Key** | modified\_at |
| **Useful links** | [Asana documentation](https://asana.com/developers/api-reference/tasks) |

tasks table foreign keys

| Join tasks with | on |
| --- | --- |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>tasks.projects.gid = projects.gid<br>```<br><br>```<br>tasks.assignee.gid = projects.followers.gid<br>```<br><br>```<br>tasks.followers.gid = projects.followers.gid<br>```<br><br>```<br>tasks.assignee.gid = projects.members.gid<br>```<br><br>```<br>tasks.followers.gid = projects.members.gid<br>```<br><br>```<br>tasks.assignee.gid = projects.owner.gid<br>```<br><br>```<br>tasks.followers.gid = projects.owner.gid<br>```<br><br>```<br>tasks.workspace.gid = projects.workspace.gid<br>``` |
| [stories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#stories) | ```<br>tasks.projects.gid = stories.project.gid<br>```<br><br>```<br>tasks.gid = stories.task.gid<br>```<br><br>```<br>tasks.assignee.gid = stories.assignee.gid<br>```<br><br>```<br>tasks.followers.gid = stories.assignee.gid<br>```<br><br>```<br>tasks.assignee.gid = stories.created_by.gid<br>```<br><br>```<br>tasks.followers.gid = stories.created_by.gid<br>```<br><br>```<br>tasks.assignee.gid = stories.dependency.gid<br>```<br><br>```<br>tasks.followers.gid = stories.dependency.gid<br>``` |
| [sections](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#sections) | ```<br>tasks.projects.gid = sections.project.gid<br>```<br><br>```<br>tasks.projects.gid = sections.projects.gid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tags) | ```<br>tasks.assignee.gid = tags.followers.gid<br>```<br><br>```<br>tasks.followers.gid = tags.followers.gid<br>```<br><br>```<br>tasks.workspace.gid = tags.workspace.gid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#users) | ```<br>tasks.assignee.gid = users.gid<br>```<br><br>```<br>tasks.followers.gid = users.gid<br>```<br><br>```<br>tasks.workspace.gid = users.workspaces.gid<br>``` |
| [portfolios](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#portfolios) | ```<br>tasks.assignee.gid = portfolios.created_by.gid<br>```<br><br>```<br>tasks.followers.gid = portfolios.created_by.gid<br>```<br><br>```<br>tasks.assignee.gid = portfolios.members.gid<br>```<br><br>```<br>tasks.followers.gid = portfolios.members.gid<br>```<br><br>```<br>tasks.assignee.gid = portfolios.owner.gid<br>```<br><br>```<br>tasks.followers.gid = portfolios.owner.gid<br>```<br><br>```<br>tasks.workspace.gid = portfolios.workspace.gid<br>``` |
| [teams](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#teams) | ```<br>tasks.assignee.gid = teams.users.gid<br>```<br><br>```<br>tasks.followers.gid = teams.users.gid<br>```<br><br>```<br>tasks.workspace.gid = teams.organization.gid<br>``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#workspaces) | ```<br>tasks.workspace.gid = workspaces.gid<br>``` |

tasks table schema

| **approval\_status**<br><br><br>STRING |
| --- |
| **assignee**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **assignee\_section**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **assignee\_status**<br><br><br>STRING |
| **completed**<br><br><br>BOOLEAN |
| **completed\_at**<br><br><br>DATE-TIME |
| **completed\_by**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **created\_at**<br><br><br>DATE-TIME |
| **custom\_fields**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>created_by: OBJECT, which is also a nested data structure.										<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>currency_code: STRING</li><li>custom_label: STRING</li><li>custom_label_position: STRING</li><li>date_value: OBJECT, which is also a nested data structure.										<ul><li>date: STRING</li><li>date_time: DATE-TIME</li></ul></li><li>description: STRING</li><li>display_value: STRING</li><li>enabled: BOOLEAN</li><li>enum_options: ARRAY, which is also a nested data structure.										<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>enum_value: OBJECT, which is also a nested data structure.										<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>format: STRING</li><li>gid: STRING</li><li>has_notifications_enabled: BOOLEAN</li><li>is_global_to_workspace: BOOLEAN</li><li>multi_enum_values: ARRAY, which is also a nested data structure.										<ul><li>color: STRING</li><li>enabled: BOOLEAN</li><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>name: STRING</li><li>number_value: NUMBER</li><li>people_value: ARRAY, which is also a nested data structure.									<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>precision: INTEGER</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li><li>text_value: STRING</li><li>type: STRING</li></ul> |
| **dependencies**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **dependents**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **due\_at**<br><br><br>DATE-TIME |
| **due\_on**<br><br><br>DATE-TIME |
| **external**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>data: STRING</li><li>gid: STRING</li></ul> |
| **followers**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **gid**<br><br><br>STRING |
| **hearted**<br><br><br>BOOLEAN |
| **hearts**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>user: OBJECT, which is also a nested data structure.																						<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **html\_notes**<br><br><br>STRING |
| **is\_rendered\_as\_seperator**<br><br><br>BOOLEAN |
| **liked**<br><br><br>BOOLEAN |
| **likes**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>user: OBJECT, which is also a nested data structure.																						<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **memberships**<br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>project: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li><li>section: OBJECT, which is also a nested data structure.											<ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul></li></ul> |
| **modified\_at**<br><br><br>DATE-TIME |
| **name**<br><br><br>STRING |
| **notes**<br><br><br>STRING |
| **num\_hearts**<br><br><br>INTEGER |
| **num\_likes**<br><br><br>INTEGER |
| **num\_subtasks**<br><br><br>INTEGER |
| **parent**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_subtype: STRING</li><li>resource_type: STRING</li></ul> |
| **permalink\_url**<br><br><br>STRING |
| **projects**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **resource\_subtype**<br><br><br>STRING |
| **resource\_type**<br><br><br>STRING |
| **start\_at**<br><br><br>DATE-TIME |
| **start\_on**<br><br><br>STRING |
| **tags**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **workspace**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |

### 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](https://developers.asana.com/Content/teams)<br><br>[Asana API method](https://developers.asana.com/Content/get-teams-for-a-user "Opens in new tab: Asana API method") |

teams table foreign keys

| Join teams with | on |
| --- | --- |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>teams.users.gid = projects.followers.gid<br>```<br><br>```<br>teams.users.gid = projects.members.gid<br>```<br><br>```<br>teams.users.gid = projects.owner.gid<br>```<br><br>```<br>teams.organization.gid = projects.workspace.gid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tags) | ```<br>teams.users.gid = tags.followers.gid<br>```<br><br>```<br>teams.organization.gid = tags.workspace.gid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>teams.users.gid = tasks.assignee.gid<br>```<br><br>```<br>teams.users.gid = tasks.followers.gid<br>```<br><br>```<br>teams.organization.gid = tasks.workspace.gid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#users) | ```<br>teams.users.gid = users.gid<br>```<br><br>```<br>teams.organization.gid = users.workspaces.gid<br>``` |
| [stories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#stories) | ```<br>teams.users.gid = stories.assignee.gid<br>```<br><br>```<br>teams.users.gid = stories.created_by.gid<br>```<br><br>```<br>teams.users.gid = stories.dependency.gid<br>``` |
| [portfolios](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#portfolios) | ```<br>teams.users.gid = portfolios.created_by.gid<br>```<br><br>```<br>teams.users.gid = portfolios.members.gid<br>```<br><br>```<br>teams.users.gid = portfolios.owner.gid<br>```<br><br>```<br>teams.organization.gid = portfolios.workspace.gid<br>``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#workspaces) | ```<br>teams.organization.gid = workspaces.gid<br>``` |

teams table schema

| **description**<br><br><br>STRING |
| --- |
| **gid**<br><br><br>STRING |
| **html\_description**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **organization**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **permalink\_url**<br><br><br>STRING |
| **resource\_type**<br><br><br>STRING |
| **users**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |
| **visibility**<br><br><br>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](https://asana.com/developers/api-reference/users) |

users table foreign keys

| Join users with | on |
| --- | --- |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>users.gid = projects.followers.gid<br>```<br><br>```<br>users.gid = projects.members.gid<br>```<br><br>```<br>users.gid = projects.owner.gid<br>```<br><br>```<br>users.workspaces.gid = projects.workspace.gid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tags) | ```<br>users.gid = tags.followers.gid<br>```<br><br>```<br>users.workspaces.gid = tags.workspace.gid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>users.gid = tasks.assignee.gid<br>```<br><br>```<br>users.gid = tasks.followers.gid<br>```<br><br>```<br>users.workspaces.gid = tasks.workspace.gid<br>``` |
| [stories](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#stories) | ```<br>users.gid = stories.assignee.gid<br>```<br><br>```<br>users.gid = stories.created_by.gid<br>```<br><br>```<br>users.gid = stories.dependency.gid<br>``` |
| [portfolios](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#portfolios) | ```<br>users.gid = portfolios.created_by.gid<br>```<br><br>```<br>users.gid = portfolios.members.gid<br>```<br><br>```<br>users.gid = portfolios.owner.gid<br>```<br><br>```<br>users.workspaces.gid = portfolios.workspace.gid<br>``` |
| [teams](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#teams) | ```<br>users.gid = teams.users.gid<br>```<br><br>```<br>users.workspaces.gid = teams.organization.gid<br>``` |
| [workspaces](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#workspaces) | ```<br>users.workspaces.gid = workspaces.gid<br>``` |

users table schema

| **email**<br><br><br>STRING |
| --- |
| **gid**<br><br><br>STRING |
| **name**<br><br><br>STRING |
| **photo**<br><br><br>OBJECT<br><br>This is a nested data structure:<br><br><ul><li>image_1024x1024: STRING</li><li>image_128x128: STRING</li><li>image_21x21: STRING</li><li>image_27x27: STRING</li><li>image_36x36: STRING</li><li>image_60x60: STRRING</li></ul> |
| **resource\_type**<br><br><br>STRING |
| **workspaces**<br><br><br>ARRAY<br><br>This is a nested data structure:<br><br><ul><li>gid: STRING</li><li>name: STRING</li><li>resource_type: STRING</li></ul> |

### 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](https://asana.com/developers/api-reference/workspaces) |

workspaces table foreign keys

| Join workspaces with | on |
| --- | --- |
| [projects](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#projects) | ```<br>workspaces.gid = projects.workspace.gid<br>``` |
| [tags](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tags) | ```<br>workspaces.gid = tags.workspace.gid<br>``` |
| [tasks](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#tasks) | ```<br>workspaces.gid = tasks.workspace.gid<br>``` |
| [users](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#users) | ```<br>workspaces.gid = users.workspaces.gid<br>``` |
| [portfolios](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#portfolios) | ```<br>workspaces.gid = portfolios.workspace.gid<br>``` |
| [teams](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Asana-v2.htm#teams) | ```<br>workspaces.gid = teams.organization.gid<br>``` |

workspaces table schema

| **email\_domains**<br><br>ARRAY<br><br>This is a nested data structure. |
| --- |
| **gid**<br><br><br>STRING |
| **is\_organization**<br><br><br>BOOLEAN |
| **name**<br><br><br>STRING |
| **resource\_type**<br><br><br>STRING |