テーブル

本製品はAsana のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、Asana テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData ADO.NET Provider for Asana テーブル


Name	Description
Attachments	To Delete and Query from the Attachments in the tasks.
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.