Integrate Asana using Fiber

Sync your customers' dataFiber pulls data from your customers' Asana accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.

→

Fiber

→

postgres-prod

asana_projects

asana_goals

asana_events

Your customers' Asana accounts

Your production database

Meet your new integration toolkit: SQLReplace calls to the Asana API with an interface you already use. Access the data you need straight from your database.

-- Fetch all the Tasks belonging to the Asana account 
-- of a particular user. 

SELECT *
FROM fiber.asana_task
WHERE account_id = '{user.asana_id}'

-- Fetch all the Tasks belonging to the Asana account 
-- of a particular user. 

SELECT *
FROM fiber.asana_task
WHERE account_id = '{user.asana_id}'

Code

CREATE TABLE fiber.asana_task (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  gid TEXT,
  resource_type TEXT,
  name TEXT,
  resource_subtype TEXT,
  created_by JSONB,
  approval_status TEXT,
  assignee_status TEXT,
  completed BOOLEAN,
  completed_at TIMESTAMP WITH TIME ZONE,
  completed_by JSONB,
  created_at TIMESTAMP WITH TIME ZONE,
  dependencies JSONB,
  dependents JSONB,
  due_at TIMESTAMP WITH TIME ZONE,
  due_on TIMESTAMP WITH TIME ZONE,
  external JSONB,
  html_notes TEXT,
  hearted BOOLEAN,
  hearts JSONB,
  is_rendered_as_separator BOOLEAN,
  liked BOOLEAN,
  likes JSONB,
  memberships JSONB,
  modified_at TIMESTAMP WITH TIME ZONE,
  notes TEXT,
  num_hearts INT,
  num_likes INT,
  num_subtasks INT,
  start_at TIMESTAMP WITH TIME ZONE,
  start_on TIMESTAMP WITH TIME ZONE,
  actual_time_minutes DOUBLE PRECISION,
  assignee JSONB,
  assignee_section JSONB,
  custom_fields JSONB,
  followers JSONB,
  parent JSONB,
  projects JSONB,
  tags JSONB,
  workspace JSONB,
  permalink_url TEXT
)

CREATE TABLE fiber.asana_task (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  gid TEXT,
  resource_type TEXT,
  name TEXT,
  resource_subtype TEXT,
  created_by JSONB,
  approval_status TEXT,
  assignee_status TEXT,
  completed BOOLEAN,
  completed_at TIMESTAMP WITH TIME ZONE,
  completed_by JSONB,
  created_at TIMESTAMP WITH TIME ZONE,
  dependencies JSONB,
  dependents JSONB,
  due_at TIMESTAMP WITH TIME ZONE,
  due_on TIMESTAMP WITH TIME ZONE,
  external JSONB,
  html_notes TEXT,
  hearted BOOLEAN,
  hearts JSONB,
  is_rendered_as_separator BOOLEAN,
  liked BOOLEAN,
  likes JSONB,
  memberships JSONB,
  modified_at TIMESTAMP WITH TIME ZONE,
  notes TEXT,
  num_hearts INT,
  num_likes INT,
  num_subtasks INT,
  start_at TIMESTAMP WITH TIME ZONE,
  start_on TIMESTAMP WITH TIME ZONE,
  actual_time_minutes DOUBLE PRECISION,
  assignee JSONB,
  assignee_section JSONB,
  custom_fields JSONB,
  followers JSONB,
  parent JSONB,
  projects JSONB,
  tags JSONB,
  workspace JSONB,
  permalink_url TEXT
)

Model definition

About this source

AsanaProject management tool for team collaboration.asana.com ↗

Productivity

Available resources

Projects

Goals

Events

Users

Workspaces

Attachments

Rules

Stories

Sections

Subtasks