Skip to content

Asana

Asana is a software-as-a-service platform designed for team collaboration and work management. Teams can create projects, assign tasks, set deadlines, and communicate directly within Asana. It also includes reporting tools, file attachments, calendars, and goal tracking.

URI format

The URI format for Asana is as follows:

asana://<workspace_id>?access_token=<access_token>

URI parameters:

  • workspace_id is the gid of the workspace.
  • access_token is a personal access token.

You can obtain workspace_id by going to the admin console. The URL in your browser will look something like this:

https://app.asana.com/admin/fake-123456789/

In this example fake-123456789 is your workspace id.

Setting up an Asana Integration

You can obtain a personal access token from the developer console. For more information, see Asana developers documentation.

Example

Let's say you have a workspace with id workspace-1337 and you want to ingest all tasks into a duckdb database called work.db. For this example the value of access_token will be fake_token

You can run the following to achieve this:

sh
ingestr ingest \
  --source-uri "asana://workspace-1337?access_token=fake_token" \
  --source-table "tasks" \
  --dest-uri "duckdb://./work.db" \
  --dest-table "public.tasks"

Tables

Asana source allows ingesting the following sources into separate tables:

TableDescription
workspacesInformation about people, materials, or assets required to complete a task or project successfully.
projectsCollections of tasks and related information.
tasksTasks within a project. Only tasks that belong to a project can be ingested. Users private tasks are not ingested, for example.
projectsCollections of tasks and related information.
tagsLabels that can be attached to tasks, projects, or conversations to help categorize and organize them.
storiesUpdates or comments that team members can add to a task or project.
teamsGroups of individuals who work together to complete projects and tasks.
usersIndividuals who have access to the Asana platform.

Use these as --source-table parameter in the ingestr ingest command.

WARNING

Asana does not support incremental loading for many endpoints in its APIs, which means ingestr will load endpoints incrementally if they support it, and do a full-refresh if not.