接続の確立

Asana への接続を追加

Asana への接続を追加するには：

アプリケーションコンソールで、接続ページに移動します。
接続の追加パネルで、追加したい接続のアイコンを選択します。
Asana アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからAsana コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Connecting to Asana

You can optionally set the following to refine the data returned from Asana.

WorkspaceId: The globally unique identifier (gid) associated with your Asana Workspace to only return projects from the specified Workspace. To get your Workspace Id, navigate to https://app.asana.com/api/1.0/workspaces while logged into Asana. This displays a JSON object containing your Workspace name and Id.
ProjectId: The globally unique identifier (gid) associated with your Asana Project to only return data mapped under the specified Project. Project Ids can be found in the URL of your project's Overview page. This will be the numbers directly after /0/.

Authenticating to Asana

Asana uses the OAuth or OAuthPKCE authentication standard.

User Accounts (OAuth)

AuthScheme must be set to OAuth in all user account flows.

OAuth PKCE

Set AuthScheme to OAuthPKCE.

Service Accounts

To authenticate with a Server Account (Enterprise only), use a Personal Access Token by setting these connection properties:

InitiateOAuth: OFF.
OAuthAccessToken: Your access token value.

For more more information, see the Asana documentation for personal access tokens and service accounts.

OAuth のスコープおよびエンドポイント

Asana に必要なスコープおよびエンドポイントドメイン

Asana と連携する場合、アプリケーションはAPI とやりとりするために特定の権限が必要です。

これらの権限はアクセススコープによって定義され、アプリケーションがアクセス可能なデータと実行可能なアクションを決定します。

このトピックでは、Asana プロバイダーに必要なアクセススコープとエンドポイントドメインについての情報を提供します。

スコープについて

スコープは、ユーザーのデータへのアプリケーションによるアクセスを制限するための手段です。これは、アプリケーションがユーザーに代わって実行できる特定のアクションを定義します。

例えば、読み取り専用スコープではアプリケーションにデータの閲覧を許可し、フルアクセススコープではデータの変更を許可することができます。

Asana に必要なスコープ


Scope	Description
default	Asana does not provide the ability to limit read-only access. This is the default scope and the only scope available.

エンドポイントドメインについて

エンドポイントドメインとは、アプリケーションが認証、レコードの取得、その他の重要な操作を実行するために通信する必要がある特定のURL を指します。

これらのドメインを許可することで、アプリケーションとAPI 間のネットワークトラフィックがファイアウォールやセキュリティ設定によってブロックされることがなくなります。

Note： ほとんどのユーザーは特別な設定をする必要はありません。許可リストは通常、送信ネットワークトラフィックの制限など、厳格なセキュリティ対策が施された環境でのみ必要となります。

Asana に必要なエンドポイントドメイン


Domain	Always Required	Description
app.asana.com	TRUE	The domain of your Asana instance.

高度な機能

このセクションでは、Asana Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App はユーザー定義ビューの使用をサポートします。これは事前設定されたユーザー定義クエリによって内容が決定される仮想テーブルです。このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。カスタムビューの作成と設定の概要については、ユーザー定義ビューを参照してください。

SSL の設定

SSL の設定を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、「接続文字列オプション」にあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシに合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Asana にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくは、クエリ処理を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログを参照してください。基本的なロギングに必要なのは2つの接続プロパティだけですが、より詳細なロギングをサポートする多くの機能があり、LogModules 接続プロパティを使用してロギングする情報のサブセットを指定することができます。

SSL の設定

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
ProxyPort：プロキシサーバーが起動しているTCP ポート。
ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
接続をトンネルするには、FirewallType をTUNNEL に設定します。
認証するには、FirewallUser とFirewallPassword を設定します。
SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

データモデル

Overview

This section shows the available API objects and provides more information on executing SQL to Asana APIs.

Key Features

The Sync App models Asana entities as relational views, allowing you to write SQL to query Asana data.
Stored procedures allow you to execute operations to Asana, including retrieving the access token and keeping it refreshed in OAuth 2.0.
Live connectivity to these objects means any changes to your Asana account are immediately reflected when using the Sync App.
IncludeCustomFields connection property allows you to retrieve custom fields for Tasks view. Set this property to True, to enable this feature.

Views

ビュー describes the available views. Views are statically defined to model Projects, Users, Workspaces, and more.

Stored Procedures

ストアドプロシージャ are function-like interfaces to Asana. Stored procedures allow you to execute operations to Asana, including downloading documents and moving envelopes.

テーブル

Sync App はAsana のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

Asana Connector for CData Sync テーブル


Name	Description
Allocations	To Create, Update, Delete and Query the Allocations table.
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.
TaskTemplates	To Delete and Query the task templates.
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.

Allocations

To Create, Update, Delete and Query the Allocations table.

Table Specific Information

Select

The Sync App uses the Asana API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the Sync App.

Id supports the '=' comparison.
Assignee supports the '=' comparison. Note : Always include WorkspaceId when specifying Assignee, either in the query or the connection string.
Parent supports the '=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM Allocations WHERE Id = '1127092449876457'

SELECT * FROM Allocations WHERE Assignee = '1126938691750986' AND WorkspaceId = '1126938837961830'

SELECT * FROM Allocations WHERE Parent = '1208149945266501'

Insert

StartDate, EndDate, Assignee and Parent are mandatory columns for inserting into the Allocations table. For example:

INSERT INTO Allocations (StartDate, EndDate, AssigneeId, ParentId, EffortType, EffortValue) VALUES ('2024-01-11', '2024-02-11', '1208125247305564', '1207717475644852', 'hours', 20)

Update

The following is an example of how to update the Allocations table:

UPDATE Allocations SET StartDate = '2024-01-11', EndDate = '2024-02-11', Assignee = '1208125247305564', Parent = '1207717475644852', EffortType = 'hours', EffortValue = 20 WHERE Id = '12345'

Delete

The following is an example of how to delete from the Allocations table:

DELETE FROM Allocations WHERE Id = '1234'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the user.
ResourceType	String	True		The base type of this resource.
StartDate	Date	False		The localized day on which the allocation starts.
EndDate	Date	False		The localized day on which the allocation ends.
EffortType	String	False		The units used for tracking effort on an allocation, either 使用できる値は次のとおりです。hours, percent
EffortValue	Integer	False		The numeric effort value on the allocation.
Assignee	String	False	Users.Id	Globally unique identifier of the resource, as a string.
AssigneeName	String	True		The name of allocation resource.
CreatedById	String	True		Globally unique identifier of the resource, as a string.
CreatedByName	String	True		Read-only except when same user as requester. The user's name.
Parent	String	False	Projects.Id	Globally unique identifier of the resource, as a string.
ParentName	String	True		Name of the project. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer.
ResourceSubType	String	True		The subtype of the allocation.
WorkspaceId	String	True	Workspaces.Id	Globally unique ID of the workspace.

Attachments

To Delete and Query from the Attachments in the tasks.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The TaskId or Id is required to make a request and the rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
TaskId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Attachments WHERE Id = '1134618934491707'

SELECT * FROM Attachments WHERE TaskId = '1128092964672854'

Delete

Following is an example of how to delete from Attachments table:

DELETE FROM Attachments WHERE Id = '1134618934491707'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the attachment.
Name	String	True		The name of the file.
Host	String	True		The service hosting the attachment. Valid values are asana, dropbox, gdrive and box.
CreatedAt	Datetime	True		The time at which this attachment was uploaded.
ViewURL	String	True		The URL where the attachment can be viewed, which may be friendlier to users in a browser than just directing them to a raw file.
DownloadURL	String	True		May be null if the attachment is hosted by box. If present, this URL may only be valid for 1 hour from the time of retrieval. You should avoid persisting this URL somewhere and just refresh it on demand to ensure you do not keep stale URLs.
TaskId	String	True	Tasks.Id	The task this attachment is attached to.
ResourceType	String	True		The resource type of this resource.
ResourceSubtype	String	True		The service hosting the attachment. Valid values are asana, dropbox, gdrive, onedrive, box, vimeo, and external.
PermanentURL	String	True		PermanentURL
Size	Integer	True		The size of the attachment in bytes. Only present when the resource_subtype is asana.
ConnectedToApp	Boolean	True		Whether the attachment is connected to the app making the request for the purposes of showing an app components widget. Only present when the resource_subtype is external or gdrive.

GoalMembership

To Create, Delete and Query memberships in the Goal.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
GoalId supports the '=' comparison.
MemberId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM GoalMembership

SELECT * FROM GoalMembership WHERE Id = '1126938837961834'

SELECT * FROM GoalMembership WHERE MemberId = '1126938837961830'

SELECT * FROM GoalMembership WHERE GoalId = '1126938691750986'

Insert

GoalId and MemberId is a mandatory column for inserting into GoalMembership table. For example:

INSERT INTO GoalMembership (GoalId, MemberId) VALUES ('1161963899354167', '1126938837961830')

Delete

Following is an example of how to delete from GoalMembership table:

DELETE FROM GoalMembership WHERE Id = '1161963899354167'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique Id of the goal membership.
GoalId	String	False	Goals.Id	Globally unique identifier for goal.
GoalName	String	True		The name of the goal.
GoalOwnerGid	String	True		Globally unique identifier of the goal owner.
GoalOwnerName	String	True		The name of the goal owner.
Role	String	True		Describes if the member is a commenter or editor in goal.
MemberId	String	False		Globally unique identifier of the member of the goal.
MemberName	String	True		The name of the member.
MemberResourceType	String	True		The type of the member (team or user).
ResourceSubtype	String	True		The type of membership.
ResourceType	String	True		The base type of this resource.

Goals

To Create, Update, Delete and Query the Goals table.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
IsWorkspaceLevel supports the '=' comparison.
TeamId supports the '=' comparison.
TimeId supports the '=' comparison.
WorkspaceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Goals

SELECT * FROM Goals WHERE Id = '1126938837961834'

SELECT * FROM Goals WHERE IsWorkspaceLevel = 'false'

SELECT * FROM Goals WHERE TeamId = '122334345323466' AND WorkspaceId = '1126938837961830'

SELECT * FROM Goals WHERE TimeId = '1243436322145547'

SELECT * FROM Goals WHERE WorkspaceId = '1126938837961830'

Insert

UserId and Goals is a mandatory column for inserting into Goals table. For example:

INSERT INTO Goals (Name, DueOn, StartOn, IsWorkspaceLevel, liked, WorkspaceId, OwnerId, TimePeriodId) VALUES ('Sample Goal', '2023-10-31', '2023-09-15', 'false', 'false', '1203124527069362', '1203124437606434', '1203124434984659' )

Inserting multiple Followers into Goals table. For example:

INSERT INTO Goals (Name, WorkspaceId, OwnerId, Followers) VALUES ('Sample Goal', '1203124527069362', '1203124437606434', '1206414724399714,1207035318501516' )

Update

Following is an example of how to update a Goals table:

UPDATE Goals SET DueOn ='2023-10-20' WHERE Id = '1128092864672888'

Delete

Following is an example of how to delete from Goals table:

DELETE FROM Goals WHERE Id = '1161963899354167'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Globally unique Id of the goal.
ResourceType	String	True		The base type of this resource.
Name	String	False		The name of the goal.
OwnerId	String	False		Globally unique Id of the owner.
OwnerName	String	True		The name of the owner.
OwnerResourceType	String	True		The base type of this resource.
DueOn	Date	False		The localized day on which this goal is due.
StartOn	Date	False		The day on which work for this goal begins.
CurrentStatusUpdateId	String	True		Globally unique identifier of the resource, as a string.
CurrentStatusUpdateResourceSubtype	String	True		The base type of this resource.
CurrentStatusUpdateResourceType	String	True		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.
CurrentStatusUpdateResourceTitle	String	True		The title of the status update.
Followers	String	False		Array of users who are members of this goal.
IsWorkspaceLevel	Boolean	False		Whether the goal belongs to the workspace.
Liked	Boolean	False		True if the goal is liked by the authorized user, false if not.
Likes	String	True		Array of likes for users who have liked this goal.
MetricId	String	True		Globally unique identifier of the metric.
MetricCurrencyCode	String	True		ISO 4217 currency code to format this custom field. This will be null if the unit is not currency.
MetricCurrentDisplayValue	String	True		This string is the current value of a goal metric of type string.
MetricCurrentNumberValue	Integer	True		This number is the current value of a goal metric of type number.
MetricInitialNumberValue	Integer	True		This number is the start value of a goal metric of type number.
MetricPrecision	Integer	True		Only relevant for goal metrics of type 'Number'. This field dictates the number of places after the decimal to round to, i.e. 0 is integer values, 1 rounds to the nearest tenth, and so on. Must be between 0 and 6, inclusive.
MetricProgressSource	String	True		This field defines how the progress value of a goal metric is being calculated.
MetricResourceSubtype	String	True		The subtype of this resource.
MetricResourceType	String	True		The base type of this resource.
MetricTargetNumberValue	Integer	True		This number is the end value of a goal metric of type number. This number cannot equal initial_number_value.
MetricUnit	String	True		A supported unit of measure for the goal metric, or none. 使用できる値は次のとおりです。none, currency, percentage
Notes	String	False		Free-form textual information associated with the goal.
HtmlNotes	String	False		The notes of the goal with formatting as HTML.
NumLikes	Integer	True		The number of users who have liked this goal.
Status	String	False		The current status of this goal. When the goal is open, its status can be green, yellow, and red to reflect 'On Track', 'At Risk', and 'Off Track', respectively. When the goal is closed, the value can be missed, achieved, partial, or dropped.
TeamId	String	False	Teams.Id	Globally unique identifier of the team.
TeamName	String	True		The name of the team.
TimePeriodId	String	False		Globally unique identifier of the time period.
TimePeriodDisplayName	String	True		A string representing the cadence code and the fiscal year.
TimePeriodStartOn	Date	True		The localized end date of the time period.
TimePeriodEndOn	Date	True		The localized end date of the time period.
TimePeriodPeriod	String	True		The cadence and index of the time period. The value is one of: FY, H1, H2, Q1, Q2, Q3, or Q4. 使用できる値は次のとおりです。FY, H1, H2, Q1, Q2, Q3, Q4
WorkspaceId	String	False	Workspaces.Id	Globally unique identifier of the workspace.
WorkspaceName	String	True		The name of the workspace.

PortfolioItems

To Create, delete, and Query Items in the Portfolio.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The PortfolioId is required to make a request and rest of the filter is executed client side within the Sync App.

PortfolioId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PortfolioItems WHERE PortfolioId = '1173026173301164'

Insert

ProjectId and PortfolioId is a mandatory column for inserting into PortfolioItems table. For example:

INSERT INTO PortfolioItems (ProjectId, PortfolioId) VALUES ('1173023668354420', '1173026173301164')

Delete

Following is an example of how to delete from PortfolioItems table:

DELETE FROM PortfolioItems WHERE ProjectId = '1173023668354420' AND PortfolioId = '1173026173301164'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the Portfolio Item.
Name	String	True		Name of the Item.
PortfolioId [KEY]	String	True	Portfolios.Id	Globally unique ID of the portfolio.
OwnerId	String	True		Globally unique ID of the Owner.
StartOn	Date	True		The day on which work for this project begins, or null if the project has no start date.
DueOn	Date	True		The day on which this project is due. This takes a date with format YYYY-MM-DD.
ProjectId	String	True	Projects.Id	Globally unique ID of the Project. This column is a Pseudocolmn and its used for INSERT and UPDATE.

PortfolioMembership

To Create, Delete and Query memberships in the Portfolio.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The [WorkspaceId AND UserId] OR PortfolioId OR Id is required to make a request and rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
WorkspaceId supports the '=' comparison.
UserId supports the '=' comparison.
PortfolioId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PortfolioMembership WHERE WorkspaceId = '1172686716695308' AND UserId = '1172686741877880'

SELECT * FROM PortfolioMembership WHERE PortfolioId = '1172684730399265'

SELECT * FROM PortfolioMembership WHERE Id = '1172684730399266'

Insert

PortfolioId and UserId is a mandatory column for inserting into PortfolioMembership table. For example:

INSERT INTO PortfolioMembership (PortfolioId, UserId) VALUES ('1172684730399265', '1172686741877880')

Delete

Following is an example of how to delete from PortfolioMembership table:

DELETE FROM PortfolioMembership WHERE PortfolioId = '1172684730399265' AND UserId = '1172686741877880'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the portfoolio membership.
PortfolioId [KEY]	String	True	Portfolios.Id	The portfolio the user is a member of.
PortfolioName	String	True		The name of the portfolio.
UserId [KEY]	String	True	Users.Id	Globally unique ID of the user.
UserName	String	True		The users name.
ResourceType	String	True		The resource type of this resource.
WorkspaceId	String	True	Workspaces.Id	Globally unique ID of the workspace. This column is a Pseudocolmn and its used in SELECT Query.

Portfolios

To Create, update, delete, and query from Portfolios table.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The [WorkspaceId AND OwnerId] OR Id is required to make a request and rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
WorkspaceId supports the '=' comparison.
OwnerId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Portfolios WHERE WorkspaceId = '1172686716695308' AND OwnerId = '1172686741877880'

SELECT * FROM Portfolios WHERE Id = '1172684730399265'

Insert

WorkspaceId is a mandatory column for inserting into Portfolios table. For example:

INSERT INTO Portfolios (Name, Color, WorkspaceId)  VALUES ('Test', 'dark-pink', '1172686716695308'

Update

Following is an example of how to update a Portfolios table:

"UPDATE Portfolios SET Name = 'IT-Test' WHERE Id = '1173026173301164'

Delete

Following is an example of how to delete from Portfolios table:

DELETE FROM Portfolios WHERE Id = '1172684730399265'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the portfolio.
Name	String	False		Name of the portfolio.
Color	String	False		Color of the portfolio. 使用できる値は次のとおりです。dark-pink, dark-green, dark-blue, dark-red, dark-teal, dark-brown, dark-orange, dark-purple, dark-warm-gray, light-pink, light-green, light-blue, light-red, light-teal, light-brown, light-orange, light-purple, light-warm-gray
CreatedAt	Datetime	True		The time at which this portfolio was created.
CreatorId	String	True		Globally unique ID of the user created this portfolio.
CreatorName	String	True		The users name.
Members	String	False		Array of users who are members of this portfolio.
OwnerId	String	False	Users.Id	Globally unique ID of the Owner. API users can only get a list of portfolios that they themselves own.
OwnerName	String	True		The Owners Name.
ResourceType	String	True		The base type of this resource.
WorkspaceId	String	False	Workspaces.Id	The workspace or organization that the portfolio belongs to.
WorkspaceName	String	True		Name of the workspace.
ItemURL	String	True		A url that points directly to the object within Asana.
CurrentStatusUpdateId	String	True		Globally unique identifier of the resource, as a string.
CurrentStatusUpdateResourceType	String	True		The base type of this resource.
CurrentStatusUpdateTitle	String	True		The title of the status update.
CurrentStatusUpdateResourceSubtype	String	True		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.
StartOn	Date	True		The day on which work for this portfolio begins, or null if the portfolio has no start date. This takes a date with YYYY-MM-DD format. Note: due_on must be present in the request when setting or unsetting the start_on parameter. Additionally, start_on and due_on cannot be the same date.
Public	Boolean	False		True if the portfolio is public to its workspace members.
ProjectTemplates	String	True		Array of project templates that are in the portfolio

ProjectMembership

To Create, Delete and Query memberships in the Project.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
ProjectId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ProjectMembership WHERE Id = '1127092449876445'

SELECT * FROM ProjectMembership WHERE ProjectId = '1127092449876444'

Insert

UserId and ProjectId is a mandatory column for inserting into ProjectMembership table. For example:

INSERT INTO ProjectMembership (UserId, ProjectId) VALUES ('1161963899354167', '1128092964672848')

Delete

Following is an example of how to delete from ProjectMembership table:

DELETE FROM ProjectMembership WHERE UserId = '1161963899354167' AND ProjectId = '1128092964672848'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the project membership.
ProjectId [KEY]	String	False	Projects.Id	The project the user is a member of.
WriteAccess	String	True		Whether the user has full access to the project or has comment-only access.
UserId [KEY]	String	False	Users.Id	The user in the membership.
ResourceType	String	True		The resource type of this resource.
MemberResourceType	String	True		The resource type of the member (team or user).
ResourceSubtype	String	True		Type of the membership.

Projects

To Create, Update, Delete and Query the Projects table.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
workspaceId supports the '=' comparison.
TaskId supports the '=' comparison.
TeamId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM projects WHERE workspaceId = '1126938837961830'

SELECT * FROM projects WHERE Id = '1128092864672888'

SELECT * FROM projects WHERE TaskId = '1130092964672468'

SELECT * FROM projects WHERE TeamId = '1129514033997890'

Insert

WorkspaceId or TeamId is a mandatory column for inserting into Projects table. For example:

INSERT INTO Projects (Name, Color, StartOn, WorkspaceId, DueOn, public, UserId) VALUES ('ProjectName', 'dark-pink', '2020-03-01', '1126938837961830', '2020-04-30', false, '1130062547672468')

Inserting multiple Followers into Projects table. For example:

INSERT INTO Projects (WorkspaceId, Followers) VALUES ('1126938837961830', '1206414724399714,1207035318501516' )

Update

Following is an example of how to update a Projects table:

UPDATE Projects SET TeamId = '1129514033997890' WHERE Id = '1128092864672888'

Delete

Following is an example of how to delete from Projects table:

DELETE FROM Projects WHERE Id = '1128092864672888'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the project.
Name	String	False		Name of the project. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer.
Color	String	False		Color of the project. Must be either null or one of: dark-pink, dark-green, dark-blue, dark-red, dark-teal, dark-brown, dark-orange, dark-purple, dark-warm-gray, light-pink, light-green, light-blue, light-red, light-teal, light-yellow, light-orange, light-purple, light-warm-gray. 使用できる値は次のとおりです。dark-pink, dark-green, dark-blue, dark-red, dark-teal, dark-brown, dark-orange, dark-purple, dark-warm-gray, light-pink, light-green, light-blue, light-red, light-teal, light-brown, light-orange, light-purple, light-warm-gray, green, yellow, red
CreatedAt	Datetime	True		The time at which this project was created.
ModifiedAt	Datetime	True		The time at which this project was last modified.
StartOn	Date	False		The day on which work for this project begins, or null if the project has no start date. This takes a date with YYYY-MM-DD format. Note: due_on must be present in the request when setting or unsetting the start_on parameter.
DueOn	Date	False		The day on which this project is due. This takes a date with format YYYY-MM-DD.
DefaultView	String	False		The default view of a project. 使用できる値は次のとおりです。list, board, calendar, timeline
Followers	String	False		Followers are a subset of members who receive all notifications for a project.
Archived	Boolean	False		True if the project is archived, false if not. Archived projects do not show in the UI by default and may be treated differently for queries.
UserId	String	False	Users.Id	The current owner of the project.
TeamId	String	False	Teams.Id	The team that this project is shared with. This field only exists for projects in organizations.
WorkspaceId	String	True	Workspaces.Id	The workspace or organization this project is associated with. Once created, projects cannot be moved to a different workspace. This attribute can only be specified at creation time.
Public	Boolean	False		True if the project is public to the organization. If false, do not share this project with other users in this organization without explicitly checking to see if they have access. For new integrations, please refer to PrivacySetting column.
Notes	String	False		More detailed, free-form textual information associated with the project.
HTMLNotes	String	False		The notes of the project with formatting as HTML.
IsTemplate	Boolean	False		Determines if the project is a template.
Layout	String	True		The layout (board or list view) of a project.
Members	String	True		Array of users who are members of this project.
SectionMigrationStatus	String	True		The section migration status of this project.
PrivacySetting	String	False		The privacy setting of the project.
TaskId	String	True	Tasks.Id	Globally unique ID of the Task.
ItemURL	String	True		A url that points directly to the object within Asana.
CurrentStatusUpdateId	String	True		Globally unique identifier of the resource, as a string.
CurrentStatusUpdateResourceType	String	True		The base type of this resource.
CurrentStatusUpdateTitle	String	False		The title of the status update.
CurrentStatusUpdateResourceSubtype	String	True		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.
ResourceType	String	True		The base type of this resource.
DefaultAccessLevel	String	False		The default access for users or teams who join or are added as members to the project. 使用できる値は次のとおりです。admin, editor, commenter, viewer
MinimumAccessLevelForCustomization	String	False		The minimum access level needed for project members to modify this project's workflow and appearance. 使用できる値は次のとおりです。admin, editor
MinimumAccessLevelForSharing	String	False		The minimum access level needed for project members to share the project and manage project memberships. 使用できる値は次のとおりです。admin, editor
Completed	Boolean	True		True if the project is currently marked complete, false if not.
CompletedAt	Datetime	True		The time at which this project was completed, or null if the project is not completed.
CompletedById	String	True		Globally unique identifier of the resource, as a string.
CompletedByResourceType	String	True		The base type of this resource.
CompletedByName	String	True		Read-only except when same user as requester. The user�s name.
Icon	String	True		The icon for a project.
ProjectBriefId	String	True		The project brief associated with this project.
ProjectBriefResourceType	String	True		The project brief associated with this project.
CreatedFromTemplateId	String	True		Id of the project template from which this project was created. If the project was not created from a template, this field will be null.
CreatedFromTemplateResourceType	String	True		Resource type of the project template from which this project was created. If the project was not created from a template, this field will be null.
CreatedFromTemplateName	String	True		Name of the project template from which this project was created. If the project was not created from a template, this field will be null.

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.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
ProjectId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ProjectStatuses WHERE Id = '1127092449876445'

SELECT * FROM ProjectStatuses WHERE ProjectId = '1127092449876444'

Insert

ProjectId is a mandatory column for inserting into ProjectStatuses table. For example:

INSERT INTO projectstatuses (Color, Title, Text, ProjectId) VALUES ('red', 'Status1', 'StatusNotes', '1127092449876444')

Delete

Following is an example of how to delete from ProjectStatuses table:

DELETE FROM ProjectStatuses WHERE Id = '1127092449876445'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the project status update.
Color	String	True		The color associated with the status update. 使用できる値は次のとおりです。green, yellow, red
Title	String	True		The title of the project status update.
Text	String	True		The text content of the status update.
CreatedAt	Datetime	True		The time at which the status update was created.
CreatedBy	String	True	Users.Id	The creator of the status update.
ProjectId	String	True	Projects.Id	Globally unique ID of the project.
ResourceType	String	True		The resource type of this resource. The value for this resource is always project_status.
HTMLText	String	True		The notes of the project with formatting as HTML.

Sections

To Create, Update, Delete, and Query from Sections table. A section is a subdivision of a project that groups tasks together.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
ProjectId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Sections WHERE Id = '1127092449876457'

SELECT * FROM Sections WHERE ProjectId = '1128092964672848'

Insert

ProjectId is a mandatory column for inserting into Sections table. For example:

INSERT INTO Sections (Name, ProjectId) VALUES ('SectionName', '1128092964672848')

Update

Following is an example of how to update a Sections table:

UPDATE Sections SET Name = 'IT-Pending' WHERE Id = '1127092449876457'

Delete

Following is an example of how to delete from Sections table:

DELETE FROM Sections WHERE Id = '1127092449876457'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the section.
Name	String	False		The name of the section.
CreatedAt	Datetime	True		The time at which the section was created.
ResourceType	String	True		The resource type of this resource.
ProjectId	String	False	Projects.Id	The section under the project.

StatusUpdates

A status update is an update on the progress of a particular object, and is sent out to all followers when created.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
ParentId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM StatusUpdates

SELECT * FROM StatusUpdates WHERE Id = '1126938837961834'

SELECT * FROM StatusUpdates WHERE ParentId = '1126938837961834'

Insert

Text, StatusType and ParentId are mandatory columns for inserting into StatusUpdates table. For example:

INSERT INTO StatusUpdates(ParentId,Title,Text,StatusType) VALUES('1203125557018928','asd','tewr','on_track')

Delete

Following is an example of how to delete from StatusUpdates table:

DELETE FROM StatusUpdates WHERE Id = '1161963899354167'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique identifier of the resource, as a string.
AuthorId	String	True		A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. Globally unique identifier of the resource.
AuthorName	String	True		A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The user�s name.
AuthorResourceType	String	True		A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The base type of this resource.
CreatedAt	Datetime	True		The time at which this resource was created.
CreatedById	String	True		A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. Globally unique identifier of the resource.
CreatedByName	String	True		A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The user�s name.
CreatedByResourceType	String	True		A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The base type of this resource.
Liked	Boolean	True		True if the status is liked by the authorized user, false if not.
Likes	String	True		Array of likes for users who have liked this status.
ModifiedAt	Datetime	True		The time at which this project status was last modified.
NumLikes	Integer	True		The number of users who have liked this status.
ParentId	String	False		Id of parent of the status update.
ParentName	String	True		Name of parent of the status update.
ParentResourceType	String	True		Resource type of parent of the status update.
ResourceSubtype	String	True		The subtype of this resource.
ResourceType	String	True		The base type of this resource.
StatusType	String	False		The type associated with the status update. 使用できる値は次のとおりです。on_track, at_risk, off_track, on_hold, complete, achieved, partial, missed, dropped
Text	String	False		The text content of the status update.
HTMLText	String	False		The text content of the status update with formatting as HTML.
Title	String	False		The title of the status update.

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.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The TaskId or Id is required to make a request and rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
TaskId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Stories WHERE Id = '1126938691750986'

SELECT * FROM Stories WHERE TaskId = '1129514033997892'

Insert

TaskId is a mandatory column for inserting into Stories table. For example:

INSERT INTO Stories (Text, TaskId, IsPinned) VALUES ('InProgress', '1129514033997892', false)

Update

Following is an example of how to update a Stories table:

UPDATE Stories SET Text = 'story line' WHERE Id = '1126938691750986'

Delete

Following is an example of how to delete from Stories table:

DELETE FROM Stories WHERE Id = '1126938691750986'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the story.
Text	String	False		Formatted text for the story or comment.
CreatedAt	Datetime	True		The time at which this story was created.
creatorId	String	True	Users.Id	The user who created the story.
creatorName	String	False	Users.Name	The user who created the story.
Source	String	True		The component of the Asana product the user used to create the story.
TaskId	String	False	Tasks.Id	The story under the task.
Liked	Boolean	True		True if the story is liked by the authorized user, false if not.
IsPinned	Boolean	False		This field is only present on comment and attachment stories.
IsEdited	Boolean	True		Whether the text of the story has been edited after creation.
ResourceType	String	True		The resource type of this resource.
ResourceSubType	String	True		The type of story. This provides fine-grained information about what triggered the story creation.
HtmlText	String	True		HTML formatted text for a comment.
DuplicateTaskOf	String	True	Tasks.Id	The task is the basic object around which many operations in Asana are centered.
DependencyTaskId	String	True	Tasks.Id	The task is the basic object around which many operations in Asana are centered.
NumberofLikes	Integer	True		The number of users who have liked this story.
Likes	String	True		Array of likes for users who have liked this story.
StickerName	String	False		The name of the sticker in this story. null if there is no sticker. 使用できる値は次のとおりです。green_checkmark, people_dancing, dancing_unicorn, heart, party_popper, people_waving_flags, splashing_narwhal, trophy, yeti_riding_unicorn, celebrating_people, determined_climbers, phoenix_spreading_love
Type	String	True		Story type (comment or system)
Previews	String	True		A collection of previews to be displayed in the story. This property only exists for comment stories.
OldName	String	True		OldName
NewName	String	True		NewName
OldDatesStartOn	Date	True		The day on which work for this goal begins, or null if the goal has no start date. This takes a date with YYYY-MM-DD format, and cannot be set unless there is an accompanying due date.
OldDatesDueAt	Datetime	True		The UTC date and time on which this task is due, or null if the task has no due time. This takes an ISO 8601 date string in UTC and should not be used together with due_on.
OldDatesDueOn	Date	True		The localized day on which this goal is due. This takes a date with format YYYY-MM-DD.
NewDatesStartOn	Date	True		The day on which work for this goal begins, or null if the goal has no start date. This takes a date with YYYY-MM-DD format, and cannot be set unless there is an accompanying due date.
NewDatesDueAt	Datetime	True		The UTC date and time on which this task is due, or null if the task has no due time. This takes an ISO 8601 date string in UTC and should not be used together with due_on.
NewDatesDueOn	Date	True		The localized day on which this goal is due. This takes a date with format YYYY-MM-DD.
OldResourceSubtype	String	True		OldResourceSubtype
NewResourceSubtype	String	True		NewResourceSubtype
StoryId	String	True		Globally unique identifier of the resource, as a string.
StoryResourceType	String	True		The base type of this resource.
StoryCreatedAt	Datetime	True		The time at which this resource was created.
StoryCreatedById	String	True		Globally unique identifier of the resource, as a string.
StoryCreatedByResourceType	String	True		The base type of this resource.
StoryCreatedByName	String	True		Read-only except when same user as requester. The user�s name.
StoryResourceSubtype	String	True		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.
StoryText	String	True		Human-readable text for the story or comment. This will not include the name of the creator. This is not guaranteed to be stable for a given type of story. For example, text for a reassignment may not always say �assigned to �� as the text for a story can both be edited and change based on the language settings of the user making the request. Use the resource_subtype property to discover the action that created the story.
AssigneeId	String	True		Globally unique identifier of the resource, as a string.
AssigneeResourceType	String	True		The base type of this resource.
AssigneeName	String	True		Read-only except when same user as requester. The user�s name.
FollowerId	String	True		Globally unique identifier of the resource, as a string.
FollowerResourceType	String	True		The base type of this resource.
FollowerName	String	True		Read-only except when same user as requester. The user�s name.
OldSectionId	String	True		Globally unique identifier of the resource, as a string.
OldSectionResourceType	String	True		The base type of this resource.
OldSectionName	String	True		Read-only except when same user as requester. The user�s name.
NewSectionId	String	True		Globally unique identifier of the resource, as a string.
NewSectionResourceType	String	True		The base type of this resource.
NewSectionName	String	True		Read-only except when same user as requester. The user�s name.
StoryTaskId	String	True		Globally unique identifier of the resource, as a string.
StoryTaskResourceType	String	True		The base type of this resource.
StoryTaskName	String	True		The name of the task.
TaskResourceSubtype	String	True		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning.
TaskCreatedById	String	True		Globally unique identifier of the resource.
TaskCreatedByResourceType	String	True		The type of resource.
ProjectId	String	True		Globally unique identifier of the resource, as a string.
ProjectResourceType	String	True		The base type of this resource.
ProjectName	String	True		Name of the project. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer.
TagId	String	True		Globally unique identifier of the resource, as a string.
TagResourceType	String	True		The base type of this resource.
TagName	String	True		Name of the tag. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer.
CustomField	String	True		CustomField
OldTextValue	String	True		OldTextValue
NewTextValue	String	True		NewTextValue
OldNumberValue	Integer	True		OldNumberValue
NewNumberValue	Integer	True		NewNumberValue
OldEnumValue	String	True		OldEnumValue
NewEnumValue	String	True		NewEnumValue
OldDateValue	String	True		OldDateValue
NewDateValue	String	True		NewDateValue
OldPeopleValue	String	True		OldPeopleValue
NewPeopleValue	String	True		NewPeopleValue
OldMultiEnumValues	String	True		OldMultiEnumValues
NewMultiEnumValues	String	True		NewMultiEnumValues
NewApprovalStatus	String	True		The new value of approval status.
OldApprovalStatus	String	True		The old value of approval status.
DuplicateOf	String	True		DuplicateOf

SubTasks

To Create, update, delete, and query from SubTasks table.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

ParentTaskId supports the '=' comparison.

For example, the following query is processed on server side and it is a required filter:

SELECT * FROM SubTasks WHERE ParentTaskId = '1127092449876457'

A simple SELECT query will only return the first level of subtasks.

SELECT * FROM SubTasks

There may be up to five levels of subtasks below a task. (Note, Asana does not recommend using sub-subtasks). If additional levels of subtasks are needed, a subquery can be used:

SELECT * FROM SubTasks WHERE ParentTaskId IN (SELECT Id FROM SubTasks)

When executing a query without a ParentTaskId filter, due to the Asana API design, subtasks are only retrieved on a per task basis. The Sync App will first query the workspace to retrieve a list of projects. A separate request will then be made for each project to retrieve all the applicable tasks. Another request will be made for each task to retrieve any subtasks associated with the task. In theory, this is similar to executing the following query:

SELECT * FROM SubTasks WHERE ParentTaskId IN (SELECT Id FROM Tasks WHERE ProjectId IN (SELECT Id FROM Projects))

Due to the number of required requests, performance may be impacted.

Insert

ParentTaskId is a mandatory column for inserting into Projects table. For example:

INSERT INTO SubTasks (ParentTaskId, Name, Assignee, AssigneeStatus, startOn, DueOn, Completed, ProjectId, Notes, ApprovalStatus, Followers) VALUES ('1167713816822372', 'subtask1', '1167715005778471', 'later', '2020-03-25', '2020-04-01', false, 1167713816822364, 'SubTask Notes', 'changes_requested', '1167715005778471')

Inserting multiple Followers into SubTasks table. For example:

INSERT INTO SubTasks (ParentTaskId, Followers) VALUES ('1167713816822372', '1206414724399714,1207035318501516' )

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the Subtask.
ParentTaskId	String	True		Globally unique ID of the task.
Name	String	False		Name of the Subtask.
Assignee	String	False	Users.Id	User to which this subtask is assigned.
AssigneeStatus	String	False		Scheduling status of this subtask for the user it is assigned to. 使用できる値は次のとおりです。today, upcoming, later, new, inbox
CreatedAt	Datetime	True		The time at which this subtask was created.
ModifiedAt	Datetime	True		The time at which this subtask was last modified.
startOn	Date	False		The day on which work begins for the task , or null if the task has no start date. This takes a date with YYYY-MM-DD format.
DueAt	Datetime	False		Date and time on which this subtask is due, or null if the subtask has no due time.
DueOn	Date	False		Date on which this task is due, or null if the task has no due date. This takes a date with YYYY-MM-DD format.
Completed	Boolean	False		True if the subtask is currently marked complete, false if not.
CompletedAt	Datetime	True		The time at which this subtask was completed, or null if the subtask is incomplete.
completed_by	String	True	Users.Id	The user who completed this task.
ProjectId	String	False	Projects.Id	Globally unique ID of the Project.
WorkspaceId	String	False	Workspaces.Id	Globally unique ID of the Workspace.
Notes	String	False		More detailed, free-form textual information associated with the subtask.
ApprovalStatus	String	False		Reflects the approval status of this task. 使用できる値は次のとおりです。pending, approved, rejected, changes_requested
ResourceSubType	String	False		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning. 使用できる値は次のとおりです。default_task, milestone, section, approval
HtmlNotes	String	False		The notes of the text with formatting as HTML.
Dependencies	String	True		Array of resources referencing tasks that this task depends on.
Memberships	String	True		Array of projects this task is associated with and the section it is in.
Dependents	String	True		Array of resources referencing tasks that depend on this task.
Liked	Boolean	False		True if the task is liked by the authorized user, false if not.
NumberofLikes	Integer	True		The number of users who have liked this Task.
LikedBy	String	True		Array of likes for users who have liked this task.
ResourceType	String	True		The base type of this resource.
IsRenderedAsSeparator	Boolean	True		In some contexts tasks can be rendered as a visual separator.
Followers	String	False		Array of users following this task.
Tags	String	False		Array of tags associated with this task.
CreatedById	String	True		Globally unique identifier of the resource.
CreatedByResourceType	String	True		The type of resource.
NumSubTasks	Integer	True		NumSubTasks.
StartAt	Datetime	True		StartAt.
ActualTimeMinutes	Integer	True		ActualTimeMinutes.
AssigneeSection	String	True		AssigneeSection.

Tasks

To Create, Update, Delete and Query from Tasks table.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
ProjectId supports the '=' comparison.
Assignee supports the '=' comparison. Note : Assignee should always be provided with WorkspaceId, either in query or in connection string.
TagId supports the '=' comparison.
SectionId supports the '=' comparison.
UserTaskListId supports the '=' comparison.
ModifiedAt supports the '>, >=' comparison.
CompletedAt supports the '>, >=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Tasks WHERE Id = '1127092449876457'

SELECT * FROM Tasks WHERE ProjectId = '1128092964672848'

SELECT * FROM Tasks WHERE Assignee = '1126938691750986' AND WorkspaceId = '1126938837961830'

SELECT * FROM tasks WHERE TagId = '1129517083601713'

SELECT * FROM tasks WHERE SectionId = '1127092449876457'

SELECT * FROM tasks WHERE UserTaskListId = '1126938837961837'

SELECT * FROM Tasks WHERE ProjectId = '1200222223676674' AND ModifiedAt > '2024-10-09 02:43:21.933'

SELECT * FROM Tasks WHERE ProjectId = '1200222223676674' AND CompletedAt > '2024-10-31 17:10:28.268'

When executing a query without one of the above filters, due to the Asana API design, tasks must be retrieved per project. The Sync App will first query the workspace to retrieve a list of projects. A separate request will then be made for each project to retrieve all the applicable tasks. In theory, this is similar to executing the following query:

SELECT * FROM Tasks WHERE ProjectId IN (SELECT Id FROM Projects)

Note : ModifiedAt and CompletedAt filters could be passed without ProjectId also. For example:

SELECT * FROM Tasks WHERE ModifiedAt > '2024-10-09 02:43:21.933'

SELECT * FROM Tasks WHERE CompletedAt > '2024-10-31 17:10:28.268'

Due to the number of required requests, performance may be impacted. Note, tasks may also be orphaned and not belong to a project. The Sync App will not be able to retrieve orphaned tasks.

Insert

ProjectId is a mandatory column for inserting into Tasks table. For example:

INSERT INTO Tasks (Name, Assignee, AssigneeStatus, startOn, DueOn, Completed, ProjectId, Notes, ApprovalStatus, Followers) VALUES ('Task1', '1167715005778471', 'later', '2020-03-25', '2020-04-01', false, 1167713816822364, 'TaskNotes', 'changes_requested', '1167715005778471')

Update

Following is an example of how to update a Tasks table:

UPDATE Tasks SET Browser = 'ie' WHERE Id = '1167713816822371'

Delete

Following is an example of how to delete from Tasks table:

DELETE FROM Tasks WHERE Id = '1167713816822371'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the task.
Name	String	False		Name of the task.
Assignee	String	False	Users.Id	User to which this task is assigned.
AssigneeStatus	String	False		Scheduling status of this task for the user it is assigned to. 使用できる値は次のとおりです。today, upcoming, later, new, inbox
CreatedAt	Datetime	True		The time at which this task was created.
ModifiedAt	Datetime	True		The time at which this task was last modified.
startOn	Date	False		Date and time on which this task is due, or null if the task has no due time.
DueAt	Datetime	False		Date and time on which this task is due, or null if the task has no due time.
DueOn	Date	False		Date on which this task is due, or null if the task has no due date. This takes a date with YYYY-MM-DD format.
Completed	Boolean	False		True if the task is currently marked complete, false if not.
CompletedAt	Datetime	True		The time at which this task was completed, or null if the task is incomplete.
CompletedBy	String	True	Users.Id	The user who completed this task.
ProjectId	String	False	Projects.Id	Projectid of this task is associated with.
Projects	String	False		Projects of this task is associated with.
WorkspaceId	String	False	Workspaces.Id	Globally unique ID of the Workspace.
Notes	String	False		More detailed, free-form textual information associated with the task.
NumberofSubTasks	Integer	True		The number of subtasks on this task.
ApprovalStatus	String	False		Reflects the approval status of this task. 使用できる値は次のとおりです。pending, approved, rejected, changes_requested
ResourceSubType	String	False		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning. 使用できる値は次のとおりです。default_task, milestone, section, approval
HtmlNotes	String	False		The notes of the text with formatting as HTML.
Memberships	String	True		Array of projects this task is associated with and the section it is in.
Dependencies	String	True		Array of resources referencing tasks that this task depends on.
Dependents	String	True		Array of resources referencing tasks that depend on this task.
Liked	Boolean	True		True if the task is liked by the authorized user, false if not.
NumberofLikes	Integer	True		The number of users who have liked this Task.
LikedBy	String	True		Array of likes for users who have liked this task.
ResourceType	String	True		The base type of this resource.
IsRenderedAsSeparator	Boolean	True		In some contexts tasks can be rendered as a visual separator.
Followers	String	False		Array of users following this task.
Tags	String	False		Array of tags associated with this task.
ActualTimeMinutes	Double	True		This value represents the sum of all the Time Tracking entries in the Actual Time field on a given Task. It is represented as a nullable long value. Note: The time tracking feature is only available on the Asana Advanced or a higher subscription.
Parent	String	True		The parent of this task, or null if this is not a subtask.
ItemURL	String	True		A URL that points directly to the object within Asana.
External	String	False		The external field allows you to store app-specific metadata on tasks, including a gid that can be used to retrieve tasks and a data blob that can store app-specific character strings. Note that you will need to authenticate with OAuth to access or modify this data.
AssigneeResourceType	String	True		The base type of the Assignee resource.
AssigneeName	String	True		The Assignee user's name.
AssigneeSection	String	False		The assignee section is a subdivision of a project that groups tasks together in the assignee's 'My Tasks' list. The assignee_section property will be returned in the response only if the request was sent by the user who is the assignee of the task.
AssigneeSectionResourceType	String	True		The base type of the AssigneeSection resource.
AssigneeSectionName	String	True		The name of the The name of the section.
StartAt	Datetime	False		Date and time on which work begins for the task, or null if the task has no start time. It should not be used together with startOn.
CompletedByResourceType	String	True		The base type of the CompletedBy resource.
CompletedByName	String	True		The CompletedBy user's name.
WorkspaceResourceType	String	True		The base type of the Workspace resource.
WorkspaceName	String	True		The name of the workspace.
CreatedById	String	True		Globally unique identifier of the resource.
CreatedByResourceType	String	True		The type of resource.
SectionId	String	True	Sections.Id	PseudoColumn: Globally unique ID of the section.
UserTaskListId	String	True	WorkspaceMembership.UserTaskListId	PseudoColumn: A user task list represents the tasks assigned to a particular user.
TagId	String	True	Tags.Id	PseudoColumn: Globally unique ID of the tag.

TaskTemplates

To Delete and Query the task templates.

Table Specific Information

Select

The Sync App uses the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the Sync App.

Id supports the '=' comparison.
ProjectId supports the '=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM TaskTemplates WHERE Id = '1127092449876457'

SELECT * FROM TaskTemplates WHERE ProjectId = '1208149945266501'

Delete

The following is an example of how to delete from the TaskTemplates table:

DELETE FROM TaskTemplates WHERE Id = '1234'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the user.
ResourceType	String	True		The base type of this resource.
Name	String	True		Name of the task template.
ProjectId	String	True	Projects.Id	Globally unique identifier of the resource, as a string.
ProjectName	String	True		Name of the project. This is generally a short sentence fragment that fits on a line in the UI for maximum readability. However, it can be longer.
TemplateName	String	True		Globally unique identifier of the resource, as a string.
TemplateTaskResourceSubtype	String	True		The subtype of the task that will be created from this template.
TemplateDescription	String	True		Description of the task that will be created from this template.
TemplateHTMLDescription	String	True		HTML description of the task that will be created from this template.
TemplateMemberships	String	True		Array of projects that the task created from this template will be added to.
TemplateRelativeStartOn	Integer	True		The number of days after the task has been instantiated on which that the task will start.
TemplateRelativeDueOn	Integer	True		The number of days after the task has been instantiated on which that the task will be due.
TemplateDueTime	String	True		The time of day that the task will be due.
TemplateDependencies	String	True		Array of task templates that the task created from this template will depend on.
TemplateDependents	String	True		Array of task templates that will depend on the task created from this template.
TemplateFollowers	String	True		Array of users that will be added as followers to the task created from this template.
TemplateAttachments	String	True		Array of attachments that will be added to the task created from this template.
TemplateSubtasks	String	True		Array of subtasks that will be added to the task created from this template.
CreatedById	String	True		Globally unique identifier of the resource, as a string.
CreatedByName	String	True		Read-only except when same user as requester. The user�s name.
CreatedAt	Datetime	True		The time at which this task template was created.

TeamMembership

To represents a users connection to a team.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
UserId supports the '=' comparison.
WorkspaceId supports the '=' comparison.
TeamId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM TeamMembership WHERE UserId = '1126938691750986' AND WorkspaceId = '1126938837961830'

SELECT * FROM TeamMembership WHERE TeamId = '1126938837961832'

SELECT * FROM TeamMembership WHERE Id = '1126938837961832'

Insert

UserId and TeamId is a mandatory column for inserting into TeamMembership table. For example:

INSERT INTO TeamMembership (UserId, TeamId) VALUES ('1161963899354167', '1126938837961832')

Delete

Following is an example of how to delete from TeamMembership table:

DELETE FROM TeamMembership WHERE UserId = '1161963899354167' AND TeamId = '1126938837961832'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique identifier of the resource, as a string.
userId [KEY]	String	True	Users.Id	Globally unique ID of the user.
userName	String	True		The users name.
TeamId [KEY]	String	True	Teams.Id	Globally unique ID of the team.
TeamName	String	True		The name of the team.
IsGuest	Boolean	True		Describes if the user is a guest in the team.
ResourceType	String	True		The base type of this resource.
IsLimitedAccess	Boolean	True		Describes if the user has limited access to the team.
IsAdmin	Boolean	True		Describes if the user is a team admin.
WorkspaceId	String	True	Workspaces.Id	Globally unique ID of the workspace.

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.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
WorkspaceId supports the '=' comparison.
UserId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Teams WHERE Id = '1126938837961832'

SELECT * FROM Teams WHERE WorkspaceId = '1126938837961830'

SELECT * FROM Teams WHERE UserId = '1126938691750986' AND workspaceid = '1126938837961830'

Insert

WorkspaceId is a mandatory column for inserting into Teams table.In the WorkspaceId only the organisation ID can be used to create teams. Teams can not be created for workspaces which are not part of a organisation. For example:

INSERT INTO Teams (Name, Description, HTMLDescrption, WorkspaceId) VALUES ('Salessssk', 'sales developers should be members of this team.', '<body> <em>All</em> developers should be members of this team.</body>', '1126938837961830')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the team.
Name	String	False		The name of the team.
Description	String	False		The description of the team.
WorkspaceId	String	True	Workspaces.Id	The workspace or organization this team is associated with.
HTMLDescrption	String	False		The description of the team with formatting as HTML.
ResourceType	String	True		The resource type of this resource.
ItemURL	String	True		A url that points directly to the object within Asana.
Visibility	String	False		The visibility of the team to users in the same organization. 使用できる値は次のとおりです。secret, request_to_join, public
TeamContentManagementAccessLevel	String	False		Controls who can create and share content with the team. 使用できる値は次のとおりです。no_restriction, only_team_admins
EditTeamNameOrDescriptionAccessLevel	String	True		Controls who can edit team name and description. 使用できる値は次のとおりです。all_team_members, only_team_admins
EditTeamVisibilityOrTrashTeamAccessLevel	String	True		Controls who can edit team visibility and trash teams. 使用できる値は次のとおりです。all_team_members, only_team_admins
MemberInviteManagementAccessLevel	String	True		Controls who can accept or deny member invites for a given team. 使用できる値は次のとおりです。all_team_members, only_team_admins
GuestInviteManagementAccessLevel	String	True		Controls who can accept or deny guest invites for a given team. 使用できる値は次のとおりです。all_team_members, only_team_admins
JoinRequestManagementAccessLevel	String	True		Controls who can accept or deny join team requests for a Membership by Request team. 使用できる値は次のとおりです。all_team_members, only_team_admins
TeamMemberRemovalAccessLevel	String	True		Controls who can remove team members. 使用できる値は次のとおりです。all_team_members, only_team_admins
OrganizationResourceType	String	True		The base type of this resource.
OrganizationName	String	True		The name of the workspace.
UserId	String	True	Users.Id	Globally unique ID of the user.

TimeTrackingEntries

Returns time tracking entries for a given task.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
TaskId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM TimeTrackingEntries WHERE Id = '1204862911885011'

SELECT * FROM TimeTrackingEntries WHERE TaskId = '1203479447771600'

When executing a query without one of the above filters, due to the Asana API design, time tracking entries must be retrieved per task. The Sync App will first query the workspace to retrieve a list of projects. A separate request will then be made for each project to retrieve all the applicable tasks. Then requests to get time tracking entries on each task will be made. In theory, this is similar to executing the following query:

SELECT * FROM TimeTrackingEntries WHERE TaskId IN (SELECT Id FROM Tasks)

Insert

TaskId is a mandatory column for inserting into TimeTrackingEntries table. For example:

INSERT INTO TimeTrackingEntries (TaskId, DurationMinutes, EnteredOn) VALUES ('1203125557018947', 3600, '2024-01-01')

Update

Following is an example of how to update a TimeTrackingEntries table:

UPDATE TimeTrackingEntries SET DurationMinutes = 4000, EnteredOn = '2023-01-01' WHERE Id = '1208387811113769'

Delete

Following is an example of how to delete from TimeTrackingEntries table:

DELETE FROM TimeTrackingEntries WHERE Id = '1208387811113769'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the team.
ResourceType	String	True		The base type of this resource.
CreatedBy	String	True		A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks.
CreatedByResourceType	String	True		The base type of the CreatedBy user resource.
CreatedByName	String	True		The user's name.
DurationMinutes	Integer	False		Time in minutes tracked by the entry.
EnteredOn	Date	False		The day that this entry is logged on.
CreatedAt	Datetime	True		The time at which this resource was created.
TaskId	String	False		The associated Task's object Id. The task is the basic object around which many operations in Asana are centered.
TaskResourceType	String	True		The base type of the Task resource.
TaskName	String	True		The name of the task.
TaskResourceSubtype	String	True		The subtype of the Task resource.

WorkspaceMembership

To Create, Delete and Query memberships in the Workspace.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
UserId supports the '=' comparison.
WorkspaceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM WorkspaceMembership WHERE WorkspaceId = '1126938837961830'

SELECT * FROM WorkspaceMembership WHERE UserId = '1126938691750986'

SELECT * FROM WorkspaceMembership WHERE Id = '1126938837961834'

Insert

UserId and WorkspaceId is a mandatory column for inserting into WorkspaceMembership table. For example:

INSERT INTO WorkspaceMembership (UserId, WorkspaceId) VALUES ('1161963899354167', '1126938837961830')

Delete

Following is an example of how to delete from WorkspaceMembership table:

DELETE FROM WorkspaceMembership WHERE UserId = '1161963899354167' AND WorkspaceId = '1126938837961830'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the membership.
userId [KEY]	String	True	Users.Id	Globally unique ID of the user.
userName	String	True		The user`s name.
WorkspaceId [KEY]	String	True	Workspaces.Id	Globally unique ID of the workspace.
WorkspaceName	String	True		The Workspace name.
IsActive	Boolean	True		Reflects if this user still a member of the workspace.
IsAdmin	Boolean	True		Reflects if this user is an admin of the workspace.
IsGuest	Boolean	True		Reflects if this user is a guest of the workspace.
UserTaskListId	String	True	UserTaskList.Id	A user task list represents the tasks assigned to a particular user.
ResourceType	String	True		The base type of this resource.
VacationStartDate	String	True		The day on which the user's vacation in this workspace starts.
VacationEndDate	String	True		The day on which the user's vacation in this workspace ends.
CreatedAt	Datetime	True		The time at which this resource was created.

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.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
UserId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Workspaces WHERE Id = '1126938837961835'

SELECT * FROM Workspaces WHERE UserId = '1126938691750986'

Update

Following is an example of how to update a Workspaces table:

UPDATE Workspaces SET Name = 'IT-Eng' WHERE Id = '1126938837961835'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Globally unique ID of the workspace.
Name	String	False		The name of the workspace.
ResourceType	String	True		The resource type of this resource.
IsOrganization	Boolean	True		Whether the workspace is an organization.
EmailDomains	String	True		Whether the workspace is an organization.
ItemURL	String	True		A url that points directly to the object within Asana.
UserId	String	True	Users.Id	Globally unique ID of the user.

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

Asana Connector for CData Sync ビュー


Name	Description
CustomFields	To view the Custom Fields in the project or workspace.
Events	To view the events in projects and tasks.
ProjectFollowers	To view the Project follower details.
ProjectTemplates	TO get ProjectTemplates in the Team or workspace.
TaskDependencies	To query all of the dependencies of a task.
TaskDependents	To query all of the dependents of a task.
TaskStatuses	Get task count of a project.
TimePeriods	To query time period records or full record for a single time period.
Users	To view the users details.
UserTaskList	Generated schema file.

CustomFields

To view the Custom Fields in the project or workspace.

Table Specific Information

Select

The Sync App uses the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side in the Sync App.

ProjectId supports the '=' comparison.

For example, the following query is processed server side:

SELECT * FROM CustomFields WHERE ProjectId = '1126938691750986'

Columns


Name	Type	References	Description
Id	String		Globally unique identifier of the resource.
Name	String		The name of the custom field.
Description	String		The description of the custom field.
Type	String		The type of the custom field. It must be one of the given values.
ProjectId	String	Projects.Id	Globally unique Id of the project.
ProjectName	String		Name of the project.
IsImportant	Boolean		Name of the project.
Format	String		The format of the custom field.
TextValue	String		The value of a text custom field.
NumberValue	Double		The value of a number custom field.
Precision	Integer		Only relevant for custom fields of type 'Number'. This field specifies the number of digits after the decimal to round to.
CurrencyCode	String		The currency code for this custom field. This will be null if the format is not currency.
EnumOptions	String		Array of projects this task is associated with and the section it is in.
CreatedBy	String		Globally unique user identifier.
CreatedByName	String		The user's name.
IsGlobaltoWorkspace	Boolean		A boolean flag that specifies whether this custom field is available to every container in the workspace.
HasNotificationsEnabled	Boolean		A boolean flag that specifies whether a follower of a task with this field should receive inbox notifications about changes in this field.
WorkspaceId	String	Workspaces.Id	Globally unique ID of the workspace.

Events

To view the events in projects and tasks.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The resource id will be either Project or Task Id. The rest of the filter is executed client side within the Sync App.

ResourceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Events WHERE ResourceId = '1128092964672854'

Columns


Name	Type	References	Description
ResourceId [KEY]	String		The resource GID for the events were requested for.
ResourceType	String		The resource type for the events were requested for.
ResourceSubType	String		The resource sub type for the events were requested for.
ResourceName	String		The resource name for the events were requested for.
Parent	String		For added/removed events, the parent that resource was added to or removed from. null for other event types.
CreatedAt	Datetime		The timestamp when the event occurred.
UserId	String		The event may be triggered by a different user GID than the subscriber.
UserFullname	String		The event may be triggered by a different user name than the subscriber.
Action	String		The type of action taken that triggered the event.
ChangeField	String		The name of the field that has changed in the resource.
ChangeAction	String		The type of action taken on the field which has been changed. This can be one of changed, added, or removed depending on the nature of the change.
ChangeNewValue	String		This property is only present when the value of the event's change.action is changed and the new_value is an Asana resource. This will be only the gid and resource_type of the resource when the events come from webhooks.
ChangeAddedValue	String		This property is only present when the value of the event's change.action is added and the added_value is an Asana resource. This will be only the gid and resource_type of the resource when the events come from webhooks.
ChangeRemovedValue	String		This property is only present when the value of the event's change.action is removed and the removed_value is an Asana resource. This will be only the gid and resource_type of the resource when the events come from webhook.

ProjectFollowers

To view the Project follower details.

Columns


Name	Type	References	Description
ProjectId	String	Projects.Id	Globally unique ID of the Project.
UserId	String	Users.Id	Globally unique ID of the user.
UserName	String		The user`s name.
ResourceType	String		The resource type of this resource.
WorkspaceId	String	Workspaces.Id	The workspace this Project is associated with.

ProjectTemplates

TO get ProjectTemplates in the Team or workspace.

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique identifier of the resource, as a string.
Color	String		Color of the project template.
Description	String		Free-form textual information associated with the project template.
Html_description	String		The description of the project template with formatting as HTML.
Name	String		Name of the project template.
OwnerId	String	Users.Id	A user object. Globally unique identifier of the resource, as a string.
OwnerName	String		A user object. The base type of this resource.
OwnerResourceType	String		A user object. Read-only except when same user as requester. The name of the User.
IsPublic	Boolean		True if the project template is public to its team.
RequestedDates	String		Array of date variables in this project template. Calendar dates must be provided for these variables when instantiating a project.
ResourceType	String		The base type of this resource.
TeamId	String	Teams.Id	A team is used to group related projects and people together within an organization. Globally unique identifier of the resource, as a string.
TeamName	String		A team is used to group related projects and people together within an organization. The name of the team.
TeamResourceType	String		A team is used to group related projects and people together within an organization. The base type of this resource.
RequestedRoles	String		Array of template roles in this project template. User Ids can be provided for these variables when instantiating a project to assign template tasks to the user.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
WorkspaceId	String		The workspace Id to filter results on.

TaskDependencies

To query all of the dependencies of a task.

Table Specific Information

Select

The Sync App uses the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the Sync App.

TaskId supports the '=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM TaskDependencies WHERE TaskId = '1208618397035168'

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique ID of the task.
Name	String		Name of the task.
Assignee	String	Users.Id	User to which this task is assigned.
AssigneeStatus	String		Scheduling status of this task for the user it is assigned to. 使用できる値は次のとおりです。today, upcoming, later, new, inbox
CreatedAt	Datetime		The time at which this task was created.
ModifiedAt	Datetime		The time at which this task was last modified.
startOn	Date		Date and time on which this task is due, or null if the task has no due time.
DueAt	Datetime		Date and time on which this task is due, or null if the task has no due time.
DueOn	Date		Date on which this task is due, or null if the task has no due date. This takes a date with YYYY-MM-DD format.
Completed	Boolean		True if the task is currently marked complete, false if not.
CompletedAt	Datetime		The time at which this task was completed, or null if the task is incomplete.
CompletedBy	String	Users.Id	The user who completed this task.
Projects	String		Projects of this task is associated with.
WorkspaceId	String	Workspaces.Id	Globally unique ID of the Workspace.
Notes	String		More detailed, free-form textual information associated with the task.
NumberofSubTasks	Integer		The number of subtasks on this task.
ApprovalStatus	String		Reflects the approval status of this task. 使用できる値は次のとおりです。pending, approved, rejected, changes_requested
ResourceSubType	String		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning. 使用できる値は次のとおりです。default_task, milestone, section, approval
HtmlNotes	String		The notes of the text with formatting as HTML.
Memberships	String		Array of projects this task is associated with and the section it is in.
Dependencies	String		Array of resources referencing tasks that this task depends on.
Dependents	String		Array of resources referencing tasks that depend on this task.
Liked	Boolean		True if the task is liked by the authorized user, false if not.
NumberofLikes	Integer		The number of users who have liked this Task.
LikedBy	String		Array of likes for users who have liked this task.
ResourceType	String		The base type of this resource.
IsRenderedAsSeparator	Boolean		In some contexts tasks can be rendered as a visual separator.
Followers	String		Array of users following this task.
Tags	String		Array of tags associated with this task.
ActualTimeMinutes	Double		This value represents the sum of all the Time Tracking entries in the Actual Time field on a given Task. It is represented as a nullable long value. Note: The time tracking feature is only available on the Asana Advanced or a higher subscription.
Parent	String		The parent of this task, or null if this is not a subtask.
ItemURL	String		A URL that points directly to the object within Asana.
External	String		The external field allows you to store app-specific metadata on tasks, including a gid that can be used to retrieve tasks and a data blob that can store app-specific character strings. Note that you will need to authenticate with OAuth to access or modify this data.
AssigneeResourceType	String		The base type of the Assignee resource.
AssigneeName	String		The Assignee user's name.
AssigneeSection	String		The assignee section is a subdivision of a project that groups tasks together in the assignee's 'My Tasks' list. The assignee_section property will be returned in the response only if the request was sent by the user who is the assignee of the task.
AssigneeSectionResourceType	String		The base type of the AssigneeSection resource.
AssigneeSectionName	String		The name of the The name of the section.
StartAt	Datetime		Date and time on which work begins for the task, or null if the task has no start time. It should not be used together with startOn.
CompletedByResourceType	String		The base type of the CompletedBy resource.
CompletedByName	String		The CompletedBy user's name.
WorkspaceResourceType	String		The base type of the Workspace resource.
WorkspaceName	String		The name of the workspace.
CreatedById	String		Globally unique identifier of the resource.
CreatedByResourceType	String		The type of resource.
TaskId	String	Tasks.Id	The task to operate on.

TaskDependents

To query all of the dependents of a task.

Table Specific Information

Select

The Sync App uses the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the Sync App.

TaskId supports the '=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM TaskDependents WHERE TaskId = '1208618397035168'

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique ID of the task.
Name	String		Name of the task.
Assignee	String	Users.Id	User to which this task is assigned.
AssigneeStatus	String		Scheduling status of this task for the user it is assigned to. 使用できる値は次のとおりです。today, upcoming, later, new, inbox
CreatedAt	Datetime		The time at which this task was created.
ModifiedAt	Datetime		The time at which this task was last modified.
StartOn	Date		Date and time on which this task is due, or null if the task has no due time.
DueAt	Datetime		Date and time on which this task is due, or null if the task has no due time.
DueOn	Date		Date on which this task is due, or null if the task has no due date. This takes a date with YYYY-MM-DD format.
Completed	Boolean		True if the task is currently marked complete, false if not.
CompletedAt	Datetime		The time at which this task was completed, or null if the task is incomplete.
CompletedBy	String	Users.Id	The user who completed this task.
Projects	String		Projects of this task is associated with.
WorkspaceId	String	Workspaces.Id	Globally unique ID of the Workspace.
Notes	String		More detailed, free-form textual information associated with the task.
NumberofSubTasks	Integer		The number of subtasks on this task.
ApprovalStatus	String		Reflects the approval status of this task. 使用できる値は次のとおりです。pending, approved, rejected, changes_requested
ResourceSubType	String		The subtype of this resource. Different subtypes retain many of the same fields and behavior, but may render differently in Asana or represent resources with different semantic meaning. 使用できる値は次のとおりです。default_task, milestone, section, approval
HtmlNotes	String		The notes of the text with formatting as HTML.
Memberships	String		Array of projects this task is associated with and the section it is in.
Dependencies	String		Array of resources referencing tasks that this task depends on.
Dependents	String		Array of resources referencing tasks that depend on this task.
Liked	Boolean		True if the task is liked by the authorized user, false if not.
NumberofLikes	Integer		The number of users who have liked this Task.
LikedBy	String		Array of likes for users who have liked this task.
ResourceType	String		The base type of this resource.
IsRenderedAsSeparator	Boolean		In some contexts tasks can be rendered as a visual separator.
Followers	String		Array of users following this task.
Tags	String		Array of tags associated with this task.
ActualTimeMinutes	Double		This value represents the sum of all the Time Tracking entries in the Actual Time field on a given Task. It is represented as a nullable long value. Note: The time tracking feature is only available on the Asana Advanced or a higher subscription.
Parent	String		The parent of this task, or null if this is not a subtask.
ItemURL	String		A URL that points directly to the object within Asana.
External	String		The external field allows you to store app-specific metadata on tasks, including a gid that can be used to retrieve tasks and a data blob that can store app-specific character strings. Note that you will need to authenticate with OAuth to access or modify this data.
AssigneeResourceType	String		The base type of the Assignee resource.
AssigneeName	String		The Assignee user's name.
AssigneeSection	String		The assignee section is a subdivision of a project that groups tasks together in the assignee's 'My Tasks' list. The assignee_section property will be returned in the response only if the request was sent by the user who is the assignee of the task.
AssigneeSectionResourceType	String		The base type of the AssigneeSection resource.
AssigneeSectionName	String		The name of the The name of the section.
StartAt	Datetime		Date and time on which work begins for the task, or null if the task has no start time. It should not be used together with startOn.
CompletedByResourceType	String		The base type of the CompletedBy resource.
CompletedByName	String		The CompletedBy user's name.
WorkspaceResourceType	String		The base type of the Workspace resource.
WorkspaceName	String		The name of the workspace.
CreatedById	String		Globally unique identifier of the resource.
CreatedByResourceType	String		The type of resource.
TaskId	String	Tasks.Id	The task to operate on.

TaskStatuses

Get task count of a project.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

ProjectId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM TaskStatuses WHERE ProjectId = '1136437449978157'

Columns


Name	Type	References	Description
ProjectId	String	Projects.Id	Globally unique ID of the project.
NumberofTasks	Integer		The number of tasks in a project.
CompletedTasks	Integer		The number of completed tasks in a project.
IncompleteTasks	Integer		The number of incomplete tasks in a project.
NumberofMilestones	Integer		The number of milestones in a project.
CompletedMilestones	Integer		The number of completed milestones in a project.
InCompleteMilestones	Integer		The number of incomplete milestones in a project.

TimePeriods

To query time period records or full record for a single time period.

Table Specific Information

Select

The Sync App uses the Asana API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the Sync App.

Id supports the '=' comparison.
WorkspaceId supports the '=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM TimePeriods where Id = '1200585294122707'

SELECT * FROM TimePeriods where WorkspaceId = '1126938837961835'

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique ID of the user.
ResourceType	String		The base type of this resource.
EndOn	String		The localized end date of the time period in YYYY-MM-DD format.
StartOn	String		The localized start date of the time period in YYYY-MM-DD format.
Period	String		The cadence and index of the time period. The value is one of: FY, H1, H2, Q1, Q2, Q3, or Q4.
DisplayName	String		A string representing the cadence code and the fiscal year.
ParentId	String		Globally unique ID of the user.
ParentResourceType	String		The base type of this resource.
ParentEndOn	String		The localized end date of the time period in YYYY-MM-DD format.
ParentStartOn	String		The localized start date of the time period in YYYY-MM-DD format.
ParentPeriod	String		The cadence and index of the time period. The value is one of: FY, H1, H2, Q1, Q2, Q3, or Q4.
ParentDisplayName	String		A string representing the cadence code and the fiscal year.
WorkspaceId	String	Workspaces.Id	Globally unique ID of the workspace.

Users

To view the users details.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
WorkspaceId supports the '=' comparison.
TeamId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '1126938691750986'

SELECT * FROM Users WHERE WorkspaceId = '1126938837961835'

SELECT * FROM Users WHERE TeamId = '1129514033997892'

Columns


Name	Type	References	Description
Id [KEY]	String		Globally unique ID of the user.
Name	String		The user`s name.
Email	String		The user`s email address.
ResourceType	String		The resource type of this resource.
WorkspaceId	String	Workspaces.Id	The User access in workspaces.
TeamId	String	Teams.Id	Globally unique ID of the team.

UserTaskList

Generated schema file.

Table Specific Information

Select

The Sync App will use the Asana API to process WHERE clause conditions built with the following column and operator. The [UserId and workspaceId] or Id is required to make a request and the rest of the filter is executed client side within the Sync App.

Id supports the '=' comparison.
UserId supports the '=' comparison.
workspaceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM UserTaskList WHERE Id = '1126938837961837'

SELECT * FROM UserTaskList WHERE UserId = '1126938691750986' AND workspaceId = '1126938837961830'

Columns


Name	Type	References	Description
Id [KEY]	String	WorkspaceMembership.UserTaskListId	Globally unique ID of the user task list.
Name	String		The name of the user task list.
UserId	String	Users.Id	The owner of the user task list.
workspaceId	String	Workspaces.Id	The workspace in which the user task list is located.
ResourceType	String		The resource type of this resource.

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

接続を確立する方法について詳しくは、接続の確立を参照してください。

Authentication

プロパティ	説明
AuthScheme	The type of authentication to use when connecting to Asana.

Connection

プロパティ	説明
ProjectId	The globally unique identifier (gid) associated with your Asana Project.
WorkspaceId	The globally unique identifier (gid) associated with your Asana Workspace.
IncludeCustomFields	Custom fields may be added to the Tasks, SubTasks, and PortfolioItems tables.

OAuth

プロパティ	説明
OAuthClientId	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントId を指定します。（コンシューマーキーとも呼ばれます。）このID は、カスタムアプリケーションをOAuth 認可サーバーに登録します。
OAuthClientSecret	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントシークレットを指定します。（コンシューマーシークレットとも呼ばれます。）このシークレットは、カスタムアプリケーションをOAuth 認可サーバーに登録します。

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

Firewall

プロパティ	説明
FirewallType	provider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。
FirewallServer	ファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。
FirewallPort	プロキシベースのファイアウォールで使用するTCP ポートを指定します。
FirewallUser	プロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。
FirewallPassword	プロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

Proxy

プロパティ	説明
ProxyAutoDetect	provider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。
ProxyServer	HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
ProxyPort	クライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバー（ProxyServer 接続プロパティで設定）のTCP ポート。
ProxyAuthScheme	ProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。
ProxyUser	ProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名。
ProxyPassword	ProxyUser 接続プロパティで指定されたユーザーに紐付けられたパスワード。
ProxySSLType	ProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプ。
ProxyExceptions	ProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

Logging

プロパティ	説明
LogModules	ログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

Schema

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	レポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。
Views	レポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。

Miscellaneous

プロパティ	説明
MaxRows	集計やGROUP BY を使用しないクエリで返される最大行数を指定します。
Other	特定のユースケースに対して追加の隠しプロパティを指定します。これらは通常のprovider の機能では必要ありません。複数のプロパティを定義するには、セミコロンで区切られたリストを使用します。
PseudoColumns	テーブルカラムとして公開する擬似カラムを指定します。'TableName=ColumnName;TableName=ColumnName' という形式を使用します。デフォルトは空の文字列で、このプロパティを無効にします。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。デフォルトは60秒です。タイムアウトを無効にするには0を設定します。
UserDefinedViews	カスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。

Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

プロパティ	説明
AuthScheme	The type of authentication to use when connecting to Asana.

AuthScheme

The type of authentication to use when connecting to Asana.

解説

Current authentication methods supported for new apps:

OAuth: Authenticates you using OAuth with a client ID and secret.
OAuthPKCE: Authenticates you using OAuth with a client ID and secret and code challenge.

Connection

このセクションでは、本プロバイダーの接続文字列で設定可能なConnection プロパティの全リストを提供します。

プロパティ	説明
ProjectId	The globally unique identifier (gid) associated with your Asana Project.
WorkspaceId	The globally unique identifier (gid) associated with your Asana Workspace.
IncludeCustomFields	Custom fields may be added to the Tasks, SubTasks, and PortfolioItems tables.

ProjectId

The globally unique identifier (gid) associated with your Asana Project.

解説

Requests will return the data mapped under this project.

WorkspaceId

The globally unique identifier (gid) associated with your Asana Workspace.

解説

Requests will return the projects mapped under this WorkspaceId.

IncludeCustomFields

Custom fields may be added to the Tasks, SubTasks, and PortfolioItems tables.

解説

If set to TRUE, custom fields may be added to the Tasks, SubTasks, and PortfolioItems tables. The WorkspaceId should also be specified. Custom fields are related to a specific Workspace. If no WorkspaceId is specified, the first available WorkspaceId will be used.

OAuth

このセクションでは、本プロバイダーの接続文字列で設定可能なOAuth プロパティの全リストを提供します。

プロパティ	説明
OAuthClientId	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントId を指定します。（コンシューマーキーとも呼ばれます。）このID は、カスタムアプリケーションをOAuth 認可サーバーに登録します。
OAuthClientSecret	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントシークレットを指定します。（コンシューマーシークレットとも呼ばれます。）このシークレットは、カスタムアプリケーションをOAuth 認可サーバーに登録します。

OAuthClientId

カスタムOAuth アプリケーションの作成時に割り当てられたクライアントId を指定します。（コンシューマーキーとも呼ばれます。）このID は、カスタムアプリケーションをOAuth 認可サーバーに登録します。

解説

OAuthClientId は、ユーザーがOAuth 経由で認証を行う前に設定する必要があるいくつかの接続パラメータの1つです。詳細は接続の確立を参照してください。

OAuthClientSecret

カスタムOAuth アプリケーションの作成時に割り当てられたクライアントシークレットを指定します。（コンシューマーシークレットとも呼ばれます。）このシークレットは、カスタムアプリケーションをOAuth 認可サーバーに登録します。

解説

OAuthClientSecret は、ユーザーがOAuth 経由で認証を行う前に設定する必要があるいくつかの接続パラメータの1つです。詳細は接続の確立を参照してください。

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

SSLServerCert

TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

Firewall

このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。

プロパティ	説明
FirewallType	provider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。
FirewallServer	ファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。
FirewallPort	プロキシベースのファイアウォールで使用するTCP ポートを指定します。
FirewallUser	プロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。
FirewallPassword	プロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

FirewallType

provider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Note：デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し、次のプロキシタイプのいずれかに接続するには、ProxyAutoDetect をfalse に設定します。

次の表は、サポートされている各プロトコルのポート番号情報です。


プロトコル	デフォルトポート	説明
TUNNEL	80	Sync App がAsana への接続を開くポート。トラフィックはこの場所のプロキシを経由して行き来します。
SOCKS4	1080	Sync App がAsana への接続を開くポート。SOCKS 4 は次にFirewallUser 値をプロキシに渡し、接続リクエストが許容されるかどうかを決定します。
SOCKS5	1080	Sync App がAsana にデータを送信するポート。SOCKS 5 プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。

FirewallServer

ファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

FirewallPort

プロキシベースのファイアウォールで使用するTCP ポートを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

FirewallUser

プロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

FirewallPassword

プロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Proxy

このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。

プロパティ	説明
ProxyAutoDetect	provider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。
ProxyServer	HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
ProxyPort	クライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバー（ProxyServer 接続プロパティで設定）のTCP ポート。
ProxyAuthScheme	ProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。
ProxyUser	ProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名。
ProxyPassword	ProxyUser 接続プロパティで指定されたユーザーに紐付けられたパスワード。
ProxySSLType	ProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプ。
ProxyExceptions	ProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

ProxyAutoDetect

provider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。

解説

この接続プロパティをTrue に設定すると、Sync App は既存のプロキシサーバー構成についてシステムプロキシ設定をチェックします（プロキシサーバーの詳細を手動で入力する必要はありません）。

この接続プロパティは他のプロキシ設定より優先されます。特定のプロキシサーバーに接続するためにSync App を手動で構成する場合は、False に設定します。

HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。

ProxyServer

HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。

解説

ProxyAutoDetect がFalse に設定されている場合、Sync App はこの接続プロパティで指定されたプロキシサーバーを通じてのみHTTP トラフィックをルーティングします。ProxyAutoDetect がTrue に設定されている場合（デフォルト）、Sync App は代わりにシステムプロキシ設定で指定されたプロキシサーバーを介してHTTP トラフィックをルーティングします。

ProxyPort

クライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバー（ProxyServer 接続プロパティで設定）のTCP ポート。

解説

ProxyAutoDetect がFalse に設定されている場合、Sync App はこの接続プロパティで指定されたプロキシサーバーポートを通じてのみHTTP トラフィックをルーティングします。ProxyAutoDetect がTrue に設定されている場合（デフォルト）、Sync App は代わりにシステムプロキシ設定で指定されたプロキシサーバーポートを介してHTTP トラフィックをルーティングします。

その他のプロキシタイプについては、FirewallType を参照してください。

ProxyAuthScheme

ProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。

解説

認証タイプは次のいずれかです。

BASIC：Sync App はHTTP BASIC 認証を行います。
DIGEST：Sync App はHTTP DIGEST 認証を行います。
NTLM：Sync App はNTLM トークンを取得します。
NEGOTIATE：Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKerberos トークンを取得します。
NONE：ProxyServer が認証を必要としない場合に設定します。

"NONE" 以外のすべての値については、ProxyUser およびProxyPassword 接続プロパティも設定する必要があります。

SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。

ProxyUser

ProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名。

解説

ProxyUser および ProxyPassword 接続プロパティは、ProxyServer で指定されたHTTP プロキシに対して接続よび認証するために使用されます。

ProxyAuthScheme で利用可能な認証タイプを1つ選択した後、このプロパティを以下のように設定します。


ProxyAuthScheme の値	ProxyUser に設定する値
BASIC	プロキシサーバーに登録されているユーザーのユーザー名。
DIGEST	プロキシサーバーに登録されているユーザーのユーザー名。
NEGOTIATE	プロキシサーバーが属するドメインまたは信頼されたドメイン内の有効なユーザーであるWindows ユーザーのユーザー名。`user@domain` または`domain\user` の形式で指定。
NTLM	プロキシサーバーが属するドメインまたは信頼されたドメイン内の有効なユーザーであるWindows ユーザーのユーザー名。`user@domain` または`domain\user` の形式で指定。
NONE	ProxyPassword 接続プロパティは設定しないでください。

Sync App は、ProxyAutoDetect がFalse に設定されている場合にのみ、このユーザー名を使用します。ProxyAutoDetect がTrue に設定されている場合（デフォルト）、Sync App は代わりにシステムのプロキシ設定で指定されているユーザー名を使用します。

ProxyPassword

ProxyUser 接続プロパティで指定されたユーザーに紐付けられたパスワード。

解説

ProxyUser および ProxyPassword 接続プロパティは、ProxyServer で指定されたHTTP プロキシに対して接続よび認証するために使用されます。

ProxyAuthScheme で利用可能な認証タイプを1つ選択した後、このプロパティを以下のように設定します。


ProxyAuthScheme の値	ProxyPassword に設定する値
BASIC	ProxyUser で指定したプロキシサーバーユーザーに紐付けられたパスワード。
DIGEST	ProxyUser で指定したプロキシサーバーユーザーに紐付けられたパスワード。
NEGOTIATE	ProxyUser で指定したWindows ユーザーアカウントに紐付けられたパスワード。
NTLM	ProxyUser で指定したWindows ユーザーアカウントに紐付けられたパスワード。
NONE	ProxyPassword 接続プロパティは設定しないでください。

SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。

Sync App は、ProxyAutoDetect がFalse に設定されている場合にのみ、このパスワードを使用します。ProxyAutoDetect がTrue に設定されている場合（デフォルト）、Sync App は代わりにシステムのプロキシ設定で指定されているパスワードを使用します。

ProxySSLType

ProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプ。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この接続プロパティには、以下の値を設定できます。


AUTO	デフォルト設定。ProxyServer がHTTPS URL に設定されている場合、Sync App は、TUNNEL オプションを使用します。ProxyServer がHTTP URL に設定されている場合、コンポーネントはNEVER オプションを使用します。
ALWAYS	接続は、常にSSL 有効となります。
NEVER	接続は、SSL 有効になりません。
TUNNEL	接続はトンネリングプロキシ経由で行われます。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。

ProxyExceptions

ProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

解説

ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。

Sync App はデフォルトでシステムプロキシ設定を使用するため、それ以上の設定は必要ありません。この接続にプロキシ例外を明示的に設定する場合は、ProxyAutoDetect をFalse に設定します。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
LogModules	ログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

LogModules

ログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

解説

このプロパティは、含めるログモジュールを指定することでログファイルの内容をカスタマイズすることができます。ログモジュールは、クエリ実行、メタデータ、SSL 通信などの異なる領域にログ情報を分類します。各モジュールは4文字のコードで表され、文字の名前の場合は末尾にスペースが必要なものもあります。

例えば、EXEC はクエリ実行をログに記録し、INFO は一般的なプロバイダーメッセージをログに記録します。複数のモジュールを含めるには、次のように名前をセミコロンで区切ります：INFO;EXEC;SSL。

Verbosity 接続プロパティは、このプロパティで指定されたモジュールベースのフィルタリングよりも優先されます。 Verbosity レベルを満たし、指定されたモジュールに属するログエントリのみが記録されます。利用可能なすべてのモジュールをログファイルに含めるには、このプロパティを空白のままにします。

利用可能なモジュールの完全なリストとログの設定に関する詳細な手引きについては、ログの「高度なログの記録」セクションを参照してください。

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	レポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。
Views	レポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。

Location

テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。

解説

Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。

指定しない場合、デフォルトの場所は%APPDATA%\\CData\\Asana Data Provider\\Schema となり、%APPDATA%はユーザーのコンフィギュレーションディレクトリに設定されます：


プラットフォーム	%APPDATA%
Windows	APPDATA 環境変数の値
Linux	~/.config

BrowsableSchemas

レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

解説

利用可能なデータベーススキーマをすべてリストすると余分な時間がかかり、パフォーマンスが低下します。接続文字列にスキーマのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

Tables

レポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。

解説

データベースによっては、利用可能なすべてのテーブルをリストするのに時間がかかり、パフォーマンスが低下する場合があります。接続文字列にテーブルのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

利用可能なテーブルがたくさんあり、すでに作業したいテーブルが決まっている場合、このプロパティを使用して対象のテーブルのみに表示を制限することができます。これを行うには、カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。

Note：複数のスキーマまたはカタログを持つデータソースに接続する場合は、表示する各テーブルを完全修飾名で指定する必要があります。これにより、複数のカタログやスキーマに存在するテーブルが混同されることを防ぎます。

Views

レポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。

解説

データベースによっては、利用可能なすべてのビューをリストするのに時間がかかり、パフォーマンスが低下する場合があります。接続文字列にビューのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

利用可能なビューがたくさんあり、すでに作業したいビューが決まっている場合、このプロパティを使用して対象のビューのみに表示を制限することができます。これを行うには、カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。

Note：複数のスキーマまたはカタログを持つデータソースに接続する場合は、確認する各ビューを完全修飾名で指定する必要があります。これにより、複数のカタログやスキーマに存在するビューが混同されることを防ぎます。

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
MaxRows	集計やGROUP BY を使用しないクエリで返される最大行数を指定します。
Other	特定のユースケースに対して追加の隠しプロパティを指定します。これらは通常のprovider の機能では必要ありません。複数のプロパティを定義するには、セミコロンで区切られたリストを使用します。
PseudoColumns	テーブルカラムとして公開する擬似カラムを指定します。'TableName=ColumnName;TableName=ColumnName' という形式を使用します。デフォルトは空の文字列で、このプロパティを無効にします。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。デフォルトは60秒です。タイムアウトを無効にするには0を設定します。
UserDefinedViews	カスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。

MaxRows

集計やGROUP BY を使用しないクエリで返される最大行数を指定します。

解説

このプロパティは、集計やGROUP BY 句を含まないクエリに対してSync App が返す行数の上限を設定します。この制限により、クエリがデフォルトで過度に大きな結果セットを返さないようにします。

クエリにLIMIT 句が含まれている場合、クエリで指定された値がMaxRows 設定よりも優先されます。 MaxRows が"-1" に設定されている場合、LIMIT 句が明示的にクエリに含まれていない限り、行の制限は行われません。

このプロパティは、非常に大きなデータセットを返す可能性のあるクエリを実行する際に、パフォーマンスを最適化し過剰なリソース消費を防ぐのに役立ちます。

Other

特定のユースケースに対して追加の隠しプロパティを指定します。これらは通常のprovider の機能では必要ありません。複数のプロパティを定義するには、セミコロンで区切られたリストを使用します。

解説

このプロパティは、シニアユーザーが特定のシナリオに対して隠しプロパティを設定できるようにします。これらの設定は通常のユースケースには必要ありませんが、特定の要件に対応したり、追加の機能を提供したりすることができます。複数のプロパティをセミコロン区切りのリストで定義できます。

Note： 特定のシナリオや問題に対処するためにサポートチームから助言があった場合にのみ、これらのプロパティを設定することを強く推奨します。

複数のプロパティをセミコロン区切りリストで指定します。

統合およびフォーマット


DefaultColumnSize	データソースがメタデータにカラムの長さを提供しない場合に、文字列フィールドのデフォルトの長さを設定します。デフォルト値は2000です。
ConvertDateTimeToGMT	日時の値を、マシンのローカルタイムではなくGMT グリニッジ標準時に変換するかどうかを決定します。
RecordToFile=filename	基底のソケットデータ転送を指定のファイルに記録します。

PseudoColumns

テーブルカラムとして公開する擬似カラムを指定します。'TableName=ColumnName;TableName=ColumnName' という形式を使用します。デフォルトは空の文字列で、このプロパティを無効にします。

解説

このプロパティを使用すると、Sync App がテーブルカラムとして公開する擬似カラムを定義できます。

個々の擬似カラムを指定するには、以下の形式を使用します。"Table1=Column1;Table1=Column2;Table2=Column3"

すべてのテーブルのすべての擬似カラムを含めるには、次のようにします："*=*"

Timeout

provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。デフォルトは60秒です。タイムアウトを無効にするには0を設定します。

解説

このプロパティは、Sync App が操作をキャンセルする前に操作の完了を待機する最大時間を秒単位で制御します。操作の完了前にタイムアウト時間が経過すると、Sync App は操作をキャンセルして例外をスローします。

タイムアウトは、クエリや操作全体ではなくサーバーとの個々の通信に適用されます。例えば、各ページング呼び出しがタイムアウト制限内に完了する場合、クエリは60秒を超えて実行を続けることができます。

このプロパティを0に設定するとタイムアウトが無効になり、操作が成功するか、サーバー側のタイムアウト、ネットワークの中断、またはサーバーのリソース制限などの他の条件で失敗するまで無期限に実行されます。このプロパティは慎重に使用してください。長時間実行される操作がパフォーマンスを低下させたり、応答しなくなる可能性があるためです。

UserDefinedViews

カスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。

解説

このプロパティを使用すると、UserDefinedViews.json というJSON 形式の構成ファイルを通じてカスタムビューを定義および管理できます。これらのビューはSync App によって自動的に認識され、標準のデータベースビューのようにカスタムSQL クエリを実行できるようになります。 JSON ファイルは、各ビューをルート要素として定義し、その子要素として"query" を持ちます。この"query" にはビューのSQL クエリが含まれています。次に例を示します。

{
	"MyView": {
		"query": "SELECT * FROM projects WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

このプロパティを使用して、1つのファイルに複数のビューを定義し、ファイルパスを指定できます。例：UserDefinedViews=C:\Path\To\UserDefinedViews.json。このプロパティを使用すると、指定されたビューのみがSync App によって検知されます。

詳しくは、ユーザー定義ビューを参照してください。

Asana Connector for CData Sync

Asana Connector for CData Sync

概要

Asana バージョンサポート

接続の確立

Asana への接続を追加

Connecting to Asana

Authenticating to Asana

User Accounts (OAuth)

OAuth PKCE

Service Accounts

OAuth のスコープおよびエンドポイント

Asana に必要なスコープおよびエンドポイントドメイン

スコープについて

Asana に必要なスコープ

エンドポイントドメインについて

Asana に必要なエンドポイントドメイン

高度な機能

ユーザー定義ビュー

SSL の設定

ファイアウォールとプロキシ

クエリ処理

ログ

SSL の設定

SSL 設定のカスタマイズ

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

その他のプロキシ

データモデル

Overview

Key Features

Views

Stored Procedures

テーブル

Asana Connector for CData Sync テーブル

Allocations

Table Specific Information

Select

Insert

Update

Delete

Columns

Attachments

Table Specific Information

Select

Delete

Columns

GoalMembership

Table Specific Information

Select

Insert

Delete

Columns

Goals

Table Specific Information

Select

Insert

Update

Delete

Columns

PortfolioItems

Table Specific Information

Select

Insert

Delete

Columns

PortfolioMembership

Table Specific Information

Select

Insert

Delete

Columns

Portfolios

Table Specific Information

Select

Insert

Update

Delete

Columns