ADO.NET Provider for Asana

Build 20.0.7655

テーブル

本製品 は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.
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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655