JDBC Driver for Asana

Build 23.0.8839

Tables

The driver models the data in Asana as a list of tables in a relational database that can be queried using standard SQL statements.

CData JDBC Driver for Asana Tables

Name Description
Attachments To Delete and Query from the Attachments in the tasks.
GoalMembership To Create, Delete and Query memberships in the Goal.
Goals To Create, Update, Delete and Query the Goals table.
PortfolioItems To Create, delete, and Query Items in the Portfolio.
PortfolioMembership To Create, Delete and Query memberships in the Portfolio.
Portfolios To Create, update, delete, and query from Portfolios table.
ProjectMembership To Create, Delete and Query memberships in the Project.
Projects To Create, Update, Delete and Query the Projects table.
ProjectStatuses To Create, Delete and Query from ProjectStatuses table. A project status is an update on the progress of a particular project, and is sent out to all project followers when created.
Sections To Create, Update, Delete, and Query from Sections table. A section is a subdivision of a project that groups tasks together.
Stories To Create, Update, Delete and Query from stories table. A story represents an activity associated with an object in the Asana system. Stories are generated by the system whenever users take actions such as creating or assigning tasks, or moving tasks between projects.
SubTasks To Create, update, delete, and query from SubTasks table.
Tags To Create, Update and Query from Tags table. A tag is a label that can be attached to any task in Asana. It exists in a single workspace.
Tasks To Create, Update, Delete and Query from Tasks table.
TeamMembership To represents a users connection to a team.
Teams A team is used to group related projects and people together within an organization. Each project in an organization is associated with a team.
WorkspaceMembership To Create, Delete and Query memberships in the Workspace.
Workspaces To Update and Query from Workspaces table. A workspace is the highest-level organizational unit in Asana. All projects and tasks have an associated workspace.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839