テーブル
本製品 はAsana のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData Cmdlets PowerShell Module for Asana テーブル
| 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. |
| StatusUpdates | A status update is an update on the progress of a particular object, and is sent out to all followers when created. |
| 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. |
| TimeTrackingEntries | Returns time tracking entries for a given task. |
| 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. |