Establishing a Connection

Adding a Connection to Asana

To add a connection to Asana:

In the application console, navigate to the Connections page.
At the Add Connections panel, select the icon for the connection you want to add.
If the Asana icon is not available, click the Add More icon to download and install the Asana connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

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 Scopes and Endpoints

Required Scopes and Endpoint Domains for Asana

When integrating with Asana, your application needs specific permissions to interact with the API.

These permissions are defined by access scopes, which determine what data your application can access and what actions it can perform.

This topic provides information about the required access scopes and endpoint domains for the Asana Sync App.

Understanding Scopes

Scopes are a way to limit an application's access to a user's data. They define the specific actions that an application can perform on behalf of the user.

For example, a read-only scope might allow an application to view data, while a full access scope might allow it to modify data.

Required Scopes for 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.

Understanding Endpoint Domains

Endpoint domains are the specific URLs that the application needs to communicate with in order to authenticate, retrieve records, and perform other essential operations.

Allowlisting these domains ensures that the network traffic between your application and the API is not blocked by firewalls or security settings.

Note: Most users do not need to make any special configurations. Allowlisting is typically only necessary for environments with strict security measures, such as restricted outbound network traffic.

Required Endpoint Domains for Asana


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

Advanced Features

This section details a selection of advanced features of the Asana Sync App.

User Defined Views

The Sync App supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to Asana and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Logging

For an overview of configuration settings that can be used to refine CData logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.

SSL Configuration

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Firewall and Proxy

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
ProxyPort: the TCP port that the proxy server is running on.
ProxyAuthScheme: the authentication method the Sync App uses when authenticating to the proxy server.
ProxyUser: the username of a user account registered with the proxy server.
ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
To tunnel the connection, set FirewallType to TUNNEL.
To authenticate, specify FirewallUser and FirewallPassword.
To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

Data Model

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

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

Stored Procedures

Stored Procedures are function-like interfaces to Asana. Stored procedures allow you to execute operations to Asana, including downloading documents and moving envelopes.

Tables

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

Asana Connector for CData Sync Tables


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 the 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 The allowed values are 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.
PortfolioId supports the '=' comparison.
ProjectId 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'

SELECT * FROM Goals WHERE PortfolioId = '1205440033794767'

SELECT * FROM Goals WHERE ProjectId = '1203125557018928'

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. The allowed values are 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. The allowed values are 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.

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
PortfolioId	String	Globally unique identifier for supporting portfolio.
ProjectId	String	Globally unique identifier for supporting project.

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 portfolio 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 user's 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 pseudocolumn and is used in SELECT queries.
AccessLevel	String	True		Whether the member has admin, editor, or viewer access to the portfolio. Portfolios do not support commenter access yet.

Portfolios

To create, update, delete, and query from the 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. The allowed values are 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 who created this portfolio.
CreatorName	String	True		The user's 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 owner's 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 in the 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		The value is 'true' if the portfolio is public to its workspace members.
ProjectTemplates	String	True		Array of project templates that are in the portfolio.
DefaultAccessLevel	String	True		The default access level when inviting new members to the portfolio.
Archived	Boolean	False		The value is 'true' if the portfolio is archived, 'false' if not. Archived portfolios do not show in the UI by default and may be treated differently for queries.

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

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

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

Note : MemberId should be Id of a user for insert.

Delete

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

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

Note : MemberId should be Id of a user for delete.

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.
MemberId [KEY]	String	False		The Id of user or team 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'

In case of UseTypeaheadSearch property set to true, only Name and WorkspaceId columns would be filterable server side with Name supporting '=, LIKE' comparison when LIKE used only in the following ways:

SELECT * FROM Projects WHERE Name = 'abc'

SELECT * FROM Projects WHERE Name LIKE 'abc'

SELECT * FROM Projects WHERE Name LIKE 'abc%'

SELECT * FROM Projects WHERE Name LIKE 'abc%' AND WorkspaceId = '1126938837961830'

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. The allowed values are 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. The allowed values are 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	True		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.
Members	String	True		Array of users who are members of this project.
PrivacySetting	String	False		The privacy setting of the project. The allowed values are public_to_workspace, private_to_team, private.
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. The allowed values are admin, editor, commenter, viewer.
MinimumAccessLevelForCustomization	String	False		The minimum access level needed for project members to modify this project's workflow and appearance. The allowed values are admin, editor.
MinimumAccessLevelForSharing	String	False		The minimum access level needed for project members to share the project and manage project memberships. The allowed values are 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. The allowed values are 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. The allowed values are 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. The allowed values are 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	Tasks.Id	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. The allowed values are 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. The allowed values are 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. The allowed values are 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 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.
ProjectId supports the '=' comparison.
Assignee supports the '=' comparison. Note: Assignee must be provided with WorkspaceId, either in the query or in the 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.

If the UseTypeaheadSearch connection property is set to true, only the Name and WorkspaceId columns are filterable server-side. The Name column supports '=' and 'LIKE' comparisons, but only when 'LIKE' is used in one of the following forms:

SELECT * FROM Tasks WHERE Name = 'abc'

SELECT * FROM Tasks WHERE Name LIKE 'abc'

SELECT * FROM Tasks WHERE Name LIKE 'abc%'

SELECT * FROM Tasks WHERE Name LIKE 'abc%' AND WorkspaceId = '1126938837961830'

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

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

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

Delete

The following is an example of how to delete from the 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. The allowed values are 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		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 and should not be used together with start_at. Note: due_on or due_at must be present in the request when setting or unsetting the start_on parameter.
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. The allowed values are 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. The allowed values are 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.
RecurrenceType	String	True		The type of recurrence.
RecurrenceData	String	True		The data of recurrence.
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	Time	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		The user's name. Read-only except when the same user is the requester.
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 formatted 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. The allowed values are secret, request_to_join, public.
TeamContentManagementAccessLevel	String	False		Controls who can create and share content with the team. The allowed values are no_restriction, only_team_admins.
EditTeamNameOrDescriptionAccessLevel	String	True		Controls who can edit team name and description. The allowed values are all_team_members, only_team_admins.
EditTeamVisibilityOrTrashTeamAccessLevel	String	True		Controls who can edit team visibility and trash teams. The allowed values are all_team_members, only_team_admins.
MemberInviteManagementAccessLevel	String	True		Controls who can accept or deny member invites for a given team. The allowed values are all_team_members, only_team_admins.
GuestInviteManagementAccessLevel	String	True		Controls who can accept or deny guest invites for a given team. The allowed values are all_team_members, only_team_admins.
JoinRequestManagementAccessLevel	String	True		Controls who can accept or deny join team requests for a Membership by Request team. The allowed values are all_team_members, only_team_admins.
TeamMemberRemovalAccessLevel	String	True		Controls who can remove team members. The allowed values are 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.
Endorsed	Boolean	False		Whether the team has been endorsed.

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.
IsViewOnly	Boolean	True		Reflects if this user has a view-only license 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.

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.

Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Asana Connector for CData Sync Views


Name	Description
CustomFields	To view the Custom Fields in the project or workspace.
Events	To view the events in projects and tasks.
PremiumWorkspaceTasks	To search tasks in premium workspaces.
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.
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.

PremiumWorkspaceTasks

To search tasks in premium workspaces.

Table Specific Information

Select

This table fetches all the tasks belonging to a premium workspace. It would also fetch orphaned tasks which do not belong to any project. Without WorkspaceId, the table will first fetch all the workspaces, and then fetch the data only for premium workspaces.

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.

Assignee supports the '=,IN' comparison.
ModifiedAt supports the '=,<,<=,>,>=' comparison.
StartOn supports the '=,<,<=,>,>=' comparison.
DueAt supports the '=,<,<=,>,>=' comparison.
DueOn supports the '=,<,<=,>,>=' comparison.
Completed supports the '=' comparison.
CompletedAt supports the '=,<,<=,>,>=' comparison.
ProjectId supports the '=' comparison.
WorkspaceId supports the '=' comparison.
CreatedById supports the '=' comparison.
SectionId supports the '=' comparison.
TagId supports the '=' comparison.
FollowerId supports the '=' comparison.
TextSearch supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PremiumWorkspaceTasks

SELECT * FROM Tasks WHERE WorkspaceId = '1126938837961830'

SELECT * FROM PremiumWorkspaceTasks WHERE ProjectId = '1128092964672848'

SELECT * FROM PremiumWorkspaceTasks WHERE Assignee IN ('1206041702093338', '1134886242100800')

SELECT * FROM PremiumWorkspaceTasks WHERE TagId = '1129517083601713'

SELECT * FROM PremiumWorkspaceTasks WHERE SectionId = '1127092449876457'

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

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

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. The allowed values are 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.
ProjectId	String	Projects.Id	Projectid of this task is associated with.
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. The allowed values are 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. The allowed values are 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.
SectionId	String	Sections.Id	PseudoColumn: Globally unique ID of the section.
TagId	String	Tags.Id	PseudoColumn: Globally unique ID of the tag.
FollowerId	String		PseudoColumn: Globally unique ID of the follower.
TextSearch	String		PseudoColumn: Performs full-text search on both task name and description.

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.

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.
TeamId supports the '=' comparison.
WorkspaceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ProjectTemplates where Id = '1208187943633195'

SELECT * FROM ProjectTemplates where TeamId = '1207673648001734'

SELECT * FROM ProjectTemplates WHERE WorkspaceId = '1208200246477352'

In case of UseTypeaheadSearch property set to true, only Name and WorkspaceId columns would be filterable server side with Name supporting '=, LIKE' comparison when LIKE used only in the following ways:

SELECT * FROM ProjectTemplates WHERE Name = 'abc'

SELECT * FROM ProjectTemplates WHERE Name LIKE 'abc'

SELECT * FROM ProjectTemplates WHERE Name LIKE 'abc%'

SELECT * FROM ProjectTemplates WHERE Name LIKE 'abc%' AND WorkspaceId = '1208200246477352'

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. The allowed values are 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. The allowed values are 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. The allowed values are 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 [KEY]	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. The allowed values are 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. The allowed values are 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. The allowed values are 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 [KEY]	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'

In case of UseTypeaheadSearch property set to true, only Name and WorkspaceId columns would be filterable server side with Name supporting '=, LIKE' comparison when LIKE used only in the following ways:

SELECT * FROM Users WHERE Name = 'abc'

SELECT * FROM Users WHERE Name LIKE 'abc'

SELECT * FROM Users WHERE Name LIKE 'abc%'

SELECT * FROM Users WHERE Name LIKE 'abc%' AND WorkspaceId = '1126938837961830'

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 [KEY]	String	Workspaces.Id	The User access in workspaces.
TeamId	String	Teams.Id	Globally unique ID of the team.
Workspaces	String		The User access in workspaces.

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.

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the Sync App beyond simple SELECT/INSERT/UPDATE/DELETE operations with Asana.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Asana, along with an indication of whether the procedure succeeded or failed.

Asana Connector for CData Sync Stored Procedures


Name	Description
AddDependenciesToTask	To set of tasks as dependencies of this task, if they are not already dependencies. A task can have at most 15 dependencies.
AddDependentsToTask	To Set or Unlink dependents to the task.
AddFollowers	To add followers to the tasks or projects.
AddProjectToTask	Add a project to a task.
AddTagsToTask	To Set or Unlink dependents to the task.
AddTaskToSection	Add a task to a specific, existing section. This will remove the task from other sections of the project.
DuplicateProject	To create a duplicate copy of the project.
DuplicateTask	To Set or Unlink dependencies to the task.
InstantiateTaskFromTemplate	Creates a task from the task template.
MoveSectionsinProject	To reorder the section in the project.
RemoveDependenciesFromTask	To Set or Unlink dependencies to the task.
RemoveDependentsFromTask	To Set or Unlink dependents to the task.
RemoveFollowers	To remove followers from the tasks or projects.
RemoveProjectsFromTask	Remove a project from a task.
RemoveTagsFromTask	To Set or Unlink dependents to the task.
SetParentofTask	To Set the parent of a task.

AddDependenciesToTask

To set of tasks as dependencies of this task, if they are not already dependencies. A task can have at most 15 dependencies.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
Dependencies	String	True	Task ids to add dependencies. For more than One task Id please separate with comma(,).

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

AddDependentsToTask

To Set or Unlink dependents to the task.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
DependentTaskId	String	True	Task ids to add or remove as dependents. For more than One task Id please separate with comma(,).

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

AddFollowers

To add followers to the tasks or projects.

Input


Name	Type	Required	Description
Id	String	True	The Tasks Id or Project Id to operate on.
User	String	True	Users.Id OR Users.EMail to Add.
TableName	String	True	To add the followers in. The allowed values are projects, tasks.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

AddProjectToTask

Add a project to a task.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
ProjectId	String	True	The project Id to add the task.
SectionId	String	False	A section Id in the project to insert the task into. The task will be inserted at the bottom of the section.
AddAfter	String	False	A task Id in the project to insert the task after, or null to insert at the beginning of the list.
AddBefore	String	False	A task Id in the project to insert the task before, or null to insert at the end of the list.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

AddTagsToTask

To Set or Unlink dependents to the task.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
TagId	String	True	Tags Id to add in the task.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

AddTaskToSection

Add a task to a specific, existing section. This will remove the task from other sections of the project.

Input


Name	Type	Required	Description
SectionId	String	True	A section Id in the project to move the task into.
TaskId	String	True	The task Id to add to this section.
AddAfter	String	False	An existing task id within this section before which the added task should be inserted. Cannot be provided together with insert_after.
AddBefore	String	False	An existing task id within this section after which the added task should be inserted. Cannot be provided together with insert_before.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

DownloadAttachment

To Download an Attachment.

Input


Name	Type	Required	Description
AttachmentId	String	False	Attachment Id to download.
TaskId	String	False	Task Id to download all the attachments in the Task.
DownloadLocation	String	False	Download location. This is required when TaskId is specified.
Encoding	String	False	The FileData input encoding type. The allowed values are NONE, BASE64. The default value is BASE64.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.
FileData	String	If the DownloadLocation and FileStream are not provided, this contains the content of the file.

DuplicateProject

To create a duplicate copy of the project.

Input


Name	Type	Required	Description
ProjectId	String	True	Globally unique identifier for the project.
NewProjectName	String	True	The name of the new project.
Include	String	True	The fields that will be duplicated to the new task. The accepted values are members, notes, task_notes, task_assignee, task_subtasks, task_attachments, task_dates, task_dependencies, task_followers, task_tags, task_projects. For more than One values, please separate with comma(,).
TeamId	String	False	Sets the team of the new project. If team is not defined, the new project will be in the same team as the the original project.
DueOn	Date	False	Sets the last due date in the duplicated project to the given date. The rest of the due dates will be offset by the same amount as the due dates in the original project. This takes a date with format YYYY-MM-DD.
StartOn	Date	False	Sets the first start date in the duplicated project to the given date. The rest of the start dates will be offset by the same amount as the start dates in the original project. This takes a date with format YYYY-MM-DD.
SkipWeekends	Boolean	False	Determines if the auto-shifted dates should skip weekends.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

DuplicateTask

To Set or Unlink dependencies to the task.

Input


Name	Type	Required	Description
TaskId	String	True	The Task Id to operate on.
NewTaskName	String	True	The name of the new task.
Include	String	True	The fields that will be duplicated to the new task. The accepted values are notes,assignee,subtasks,attachments,tags,followers,projects,dates,dependencies,parent. For more than One values please separate with comma(,).

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

GetOAuthAccessToken

Gets an authentication token from Asana.

Input


Name	Type	Required	Description
AuthMode	String	False	The type of authentication mode to use. Select App for getting authentication tokens via a desktop app. Select Web for getting authentication tokens via a Web app. The allowed values are APP, WEB. The default value is APP.
CallbackUrl	String	False	The URL the user will be redirected to after authorizing your application. This value must match the Redirect URL you have specified in the Asana app settings. Only needed when the Authmode parameter is Web.
Verifier	String	False	The verifier returned from Asana after the user has authorized your app to have access to their data. This value will be returned as a parameter to the callback URL.
State	String	False	Encodes state of the app, which will be returned verbatim in the response and can be used to match the response up to a given request.
Scope	String	False	A space-delimited set of one or more scopes to get the user's permission to access. If no scopes are specified, the default OAuth scope will be used—provided the app was originally registered with Full permissions. The supported scopes are 'attachments:delete attachments:read attachments:write custom_fields:read custom_fields:write goals:read portfolios:read portfolios:write project_templates:read projects:delete projects:read projects:write stories:read stories:write tags:read tags:write task_templates:read tasks:delete tasks:read tasks:write teams:read workspace.typeahead:read users:read webhooks:delete webhooks:read webhooks:write workspaces:read'.

Result Set Columns


Name	Type	Description
OAuthAccessToken	String	The access token used for communication with Asana.
OAuthRefreshToken	String	The OAuth refresh token. This is the same as the access token in the case of Asana.
ExpiresIn	String	The remaining lifetime on the access token. A -1 denotes that it will not expire.

GetOAuthAuthorizationURL

Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL.

Input


Name	Type	Required	Description
CallbackUrl	String	False	The URL the user will be redirected to after authorizing your application. This value must match the Redirect URL in the Asana app settings.
State	String	False	Encodes state of the app, which will be returned verbatim in the response and can be used to match the response up to a given request.
Scope	String	False	A space-delimited set of one or more scopes to get the user's permission to access. If no scopes are specified, the default OAuth scope will be used—provided the app was originally registered with Full permissions. The supported scopes are 'attachments:delete attachments:read attachments:write custom_fields:read custom_fields:write goals:read portfolios:read portfolios:write project_templates:read projects:delete projects:read projects:write stories:read stories:write tags:read tags:write task_templates:read tasks:delete tasks:read tasks:write teams:read workspace.typeahead:read users:read webhooks:delete webhooks:read webhooks:write workspaces:read'.

Result Set Columns


Name	Type	Description
URL	String	The authorization URL, entered into a Web browser to obtain the verifier token and authorize your app.

InstantiateTaskFromTemplate

Creates a task from the task template.

Input


Name	Type	Required	Description
TaskTemplateId	String	True	Globally unique identifier for the task template.
Name	String	True	The name of the new task.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.
TaskId	String	Id of the new task created.
TaskName	String	Name of the new task created.

MoveSectionsinProject

To reorder the section in the project.

Input


Name	Type	Required	Description
ProjectId	String	True	The project in which to reorder the given section.
SectionId	String	True	The section to reorder.
BeforeSection	String	False	Insert the given section immediately before the section specified by this parameter.
AfterSection	String	False	Insert the given section immediately after the section specified by this parameter.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

RefreshOAuthAccessToken

Refreshes the OAuth access token used for authentication with Asana.

Input


Name	Type	Required	Description
OAuthRefreshToken	String	True	Set this to the token value that expired.

Result Set Columns


Name	Type	Description
OAuthAccessToken	String	The authentication token returned from Asana. This can be used in subsequent calls to other operations for this particular service.
OAuthRefreshToken	String	This is the same as the access token.
ExpiresIn	String	The remaining lifetime on the access token.

RemoveDependenciesFromTask

To Set or Unlink dependencies to the task.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
DependentTaskId	String	False	Dependencies column should be used instead of this.
Dependencies	String	False	Task ids to add or remove as dependencies. For more than One task Id please separate with comma(,).

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

RemoveDependentsFromTask

To Set or Unlink dependents to the task.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
DependentTaskId	String	True	Task ids to add or remove as dependents. For more than One task Id please separate with comma(,).

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

RemoveFollowers

To remove followers from the tasks or projects.

Input


Name	Type	Required	Description
Id	String	True	The Tasks Id or Project Id to operate on.
User	String	True	Users.Id OR Users.EMail to remove.
TableName	String	True	To remove the followers in. The allowed values are projects, tasks.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

RemoveProjectsFromTask

Remove a project from a task.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
ProjectId	String	True	The project Id to add or remove the task to.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

RemoveTagsFromTask

To Set or Unlink dependents to the task.

Input


Name	Type	Required	Description
TaskId	String	True	The Tasks Id to operate on.
TagId	String	True	Tags Id to remove from the task.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

SetParentofTask

To Set the parent of a task.

Input


Name	Type	Required	Description
TaskId	String	True	The TaskId to update.
ParentTaskId	String	True	The new parent of the task, or null for no parent..
AddBefore	String	False	A subtask of the parent to insert the task after, or null to insert at the beginning of the list.
AddAfter	String	False	A subtask of the parent to insert the task before, or null to insert at the end of the list.

Result Set Columns


Name	Type	Description
Status	String	The status of the operation.

UploadAttachment

Uploads an Attachment to Asana.

Input


Name	Type	Required	Description
TaskId	String	True	Specify Task Id to upload the attachment.
FilePath	String	False	Specify the location of the attachment to upload.
Name	String	False	The title for the Attachment, including the extension. This value will be used, if Content is not null.

Result Set Columns


Name	Type	Description
AttachmentId	String	Globally unique ID of the attachment.
FileName	String	The name of the file.
Status	String	The status of the operation.

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Establishing a Connection.

Authentication

Property	Description
AuthScheme	The type of authentication to use when connecting to Asana.

Connection

Property	Description
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

Property	Description
OAuthClientId	Specifies the client ID (also known as the consumer key) assigned to your custom OAuth application. This ID is required to identify the application to the OAuth authorization server during authentication.
OAuthClientSecret	Specifies the client secret assigned to your custom OAuth application. This confidential value is used to authenticate the application to the OAuth authorization server. (Custom OAuth applications only.).
Scope	Specifies the scope of the authenticating user's access to the application, to ensure they get appropriate access to data. If a custom OAuth application is needed, this is generally specified at the time the application is created.

SSL

Property	Description
SSLServerCert	Specifies the certificate to be accepted from the server when connecting using TLS/SSL.

Firewall

Property	Description
FirewallType	Specifies the protocol the provider uses to tunnel traffic through a proxy-based firewall.
FirewallServer	Identifies the IP address, DNS name, or host name of a proxy used to traverse a firewall and relay user queries to network resources.
FirewallPort	Specifies the TCP port to be used for a proxy-based firewall.
FirewallUser	Identifies the user ID of the account authenticating to a proxy-based firewall.
FirewallPassword	Specifies the password of the user account authenticating to a proxy-based firewall.

Proxy

Property	Description
ProxyAutoDetect	Specifies whether the provider checks your system proxy settings for existing proxy server configurations, rather than using a manually specified proxy server.
ProxyServer	Identifies the hostname or IP address of the proxy server through which you want to route HTTP traffic.
ProxyPort	Identifies the TCP port on your specified proxy server that has been reserved for routing HTTP traffic to and from the client.
ProxyAuthScheme	Specifies the authentication method the provider uses when authenticating to the proxy server specified in the ProxyServer connection property.
ProxyUser	Provides the username of a user account registered with the proxy server specified in the ProxyServer connection property.
ProxyPassword	Specifies the password of the user specified in the ProxyUser connection property.
ProxySSLType	Specifies the SSL type to use when connecting to the proxy server specified in the ProxyServer connection property.
ProxyExceptions	Specifies a semicolon-separated list of destination hostnames or IPs that are exempt from connecting through the proxy server set in the ProxyServer connection property.

Logging

Property	Description
LogModules	Specifies the core modules to include in the log file. Use a semicolon-separated list of module names. By default, all modules are logged.

Schema

Property	Description
Location	Specifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path.
BrowsableSchemas	Optional setting that restricts the schemas reported to a subset of all available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC .
Tables	Optional setting that restricts the tables reported to a subset of all available tables. For example, Tables=TableA,TableB,TableC .
Views	Optional setting that restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC .

Miscellaneous

Property	Description
MaxRows	Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
Other	Specifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues.
PseudoColumns	Specifies the pseudocolumns to expose as table columns, expressed as a string in the format 'TableName=ColumnName;TableName=ColumnName'.
Timeout	Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.
UserDefinedViews	Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file.
UseTypeaheadSearch	Typeahead endpoint will be utilized to fetch the results for Projects, Tasks, Users and ProjectTemplates tables.

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.

Property	Description
AuthScheme	The type of authentication to use when connecting to Asana.

AuthScheme

The type of authentication to use when connecting to Asana.

Remarks

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

This section provides a complete list of the Connection properties you can configure in the connection string for this provider.

Property	Description
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.

Remarks

Requests will return the data mapped under this project.

WorkspaceId

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

Remarks

Requests will return the projects mapped under this WorkspaceId.

IncludeCustomFields

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

Remarks

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

This section provides a complete list of the OAuth properties you can configure in the connection string for this provider.

Property	Description
OAuthClientId	Specifies the client ID (also known as the consumer key) assigned to your custom OAuth application. This ID is required to identify the application to the OAuth authorization server during authentication.
OAuthClientSecret	Specifies the client secret assigned to your custom OAuth application. This confidential value is used to authenticate the application to the OAuth authorization server. (Custom OAuth applications only.).
Scope	Specifies the scope of the authenticating user's access to the application, to ensure they get appropriate access to data. If a custom OAuth application is needed, this is generally specified at the time the application is created.

OAuthClientId

Specifies the client ID (also known as the consumer key) assigned to your custom OAuth application. This ID is required to identify the application to the OAuth authorization server during authentication.

Remarks

This property is required in two cases:

When using a custom OAuth application, such as in web-based authentication flows, service-based authentication, or certificate-based flows that require application registration.
If the driver does not provide embedded OAuth credentials.

(When the driver provides embedded OAuth credentials, this value may already be provided by the Sync App and thus not require manual entry.)

OAuthClientId is generally used alongside other OAuth-related properties such as OAuthClientSecret and OAuthSettingsLocation when configuring an authenticated connection.

OAuthClientId is one of the key connection parameters that need to be set before users can authenticate via OAuth. You can usually find this value in your identity provider’s application registration settings. Look for a field labeled Client ID, Application ID, or Consumer Key.

While the client ID is not considered a confidential value like a client secret, it is still part of your application's identity and should be handled carefully. Avoid exposing it in public repositories or shared configuration files.

For more information on how this property is used when configuring a connection, see Establishing a Connection.

OAuthClientSecret

Specifies the client secret assigned to your custom OAuth application. This confidential value is used to authenticate the application to the OAuth authorization server. (Custom OAuth applications only.).

Remarks

This property (sometimes called the application secret or consumer secret) is required when using a custom OAuth application in any flow that requires secure client authentication, such as web-based OAuth, service-based connections, or certificate-based authorization flows. It is not required when using an embedded OAuth application.

The client secret is used during the token exchange step of the OAuth flow, when the driver requests an access token from the authorization server. If this value is missing or incorrect, authentication fails with either an invalid_client or an unauthorized_client error.

OAuthClientSecret is one of the key connection parameters that need to be set before users can authenticate via OAuth. You can obtain this value from your identity provider when registering the OAuth application.

Notes:

This value should be stored securely and never exposed in public repositories, scripts, or unsecured environments.
Client secrets may also expire after a set period. Be sure to monitor expiration dates and rotate secrets as needed to maintain uninterrupted access.

For more information on how this property is used when configuring a connection, see Establishing a Connection

Scope

Specifies the scope of the authenticating user's access to the application, to ensure they get appropriate access to data. If a custom OAuth application is needed, this is generally specified at the time the application is created.

Remarks

Scopes are set to define what kind of access the authenticating user will have; for example, read, read and write, restricted access to sensitive information. System administrators can use scopes to selectively enable access by functionality or security clearance.

When InitiateOAuth is set to GETANDREFRESH, you must use this property if you want to change which scopes are requested.

When InitiateOAuth is set to either REFRESH or OFF, you can change which scopes are requested using either this property or the Scope input.

SSL

This section provides a complete list of the SSL properties you can configure in the connection string for this provider.

Property	Description
SSLServerCert	Specifies the certificate to be accepted from the server when connecting using TLS/SSL.

SSLServerCert

Specifies the certificate to be accepted from the server when connecting using TLS/SSL.

Remarks

If you are using a TLS/SSL connection, use this property to specify the TLS/SSL certificate to be accepted from the server. If you specify a value for this property, all other certificates that are not trusted by the machine are rejected.

This property can take the following forms:


Description	Example
A full PEM Certificate (example shortened for brevity)	`-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----`
A path to a local file containing the certificate	C:\cert.cer
The public key (example shortened for brevity)	`-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----`
The MD5 Thumbprint (hex values can also be either space- or colon-separated)	`ecadbdda5a1529c58a1e9e09828d70e4`
The SHA1 Thumbprint (hex values can also be either space- or colon-separated)	`34a929226ae0819f2ec14b4a3d904f801cbb150d`

Note: It is possible to use '*' to signify that all certificates should be accepted, but due to security concerns this is not recommended.

Firewall

This section provides a complete list of the Firewall properties you can configure in the connection string for this provider.

Property	Description
FirewallType	Specifies the protocol the provider uses to tunnel traffic through a proxy-based firewall.
FirewallServer	Identifies the IP address, DNS name, or host name of a proxy used to traverse a firewall and relay user queries to network resources.
FirewallPort	Specifies the TCP port to be used for a proxy-based firewall.
FirewallUser	Identifies the user ID of the account authenticating to a proxy-based firewall.
FirewallPassword	Specifies the password of the user account authenticating to a proxy-based firewall.

FirewallType

Specifies the protocol the provider uses to tunnel traffic through a proxy-based firewall.

Remarks

A proxy-based firewall (or proxy firewall) is a network security device that acts as an intermediary between user requests and the resources they access. The proxy accepts the request of an authenticated user, tunnels through the firewall, and transmits the request to the appropriate server.

Because the proxy evaluates and transfers data backets on behalf of the requesting users, the users never connect directly with the servers, only with the proxy.

Note: By default, the Sync App connects to the system proxy. To disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.

The following table provides port number information for each of the supported protocols.


Protocol	Default Port	Description
TUNNEL	80	The port where the Sync App opens a connection to Asana. Traffic flows back and forth via the proxy at this location.
SOCKS4	1080	The port where the Sync App opens a connection to Asana. SOCKS 4 then passes theFirewallUser value to the proxy, which determines whether the connection request should be granted.
SOCKS5	1080	The port where the Sync App sends data to Asana. If the SOCKS 5 proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.

FirewallServer

Identifies the IP address, DNS name, or host name of a proxy used to traverse a firewall and relay user queries to network resources.

Remarks

A proxy-based firewall (or proxy firewall) is a network security device that acts as an intermediary between user requests and the resources they access. The proxy accepts the request of an authenticated user, tunnels through the firewall, and transmits the request to the appropriate server.

Because the proxy evaluates and transfers data backets on behalf of the requesting users, the users never connect directly with the servers, only with the proxy.

FirewallPort

Specifies the TCP port to be used for a proxy-based firewall.

Remarks

A proxy-based firewall (or proxy firewall) is a network security device that acts as an intermediary between user requests and the resources they access. The proxy accepts the request of an authenticated user, tunnels through the firewall, and transmits the request to the appropriate server.

Because the proxy evaluates and transfers data backets on behalf of the requesting users, the users never connect directly with the servers, only with the proxy.

FirewallUser

Identifies the user ID of the account authenticating to a proxy-based firewall.

Remarks

A proxy-based firewall (or proxy firewall) is a network security device that acts as an intermediary between user requests and the resources they access. The proxy accepts the request of an authenticated user, tunnels through the firewall, and transmits the request to the appropriate server.

Because the proxy evaluates and transfers data backets on behalf of the requesting users, the users never connect directly with the servers, only with the proxy.

FirewallPassword

Specifies the password of the user account authenticating to a proxy-based firewall.

Remarks

A proxy-based firewall (or proxy firewall) is a network security device that acts as an intermediary between user requests and the resources they access. The proxy accepts the request of an authenticated user, tunnels through the firewall, and transmits the request to the appropriate server.

Because the proxy evaluates and transfers data backets on behalf of the requesting users, the users never connect directly with the servers, only with the proxy.

Proxy

This section provides a complete list of the Proxy properties you can configure in the connection string for this provider.

Property	Description
ProxyAutoDetect	Specifies whether the provider checks your system proxy settings for existing proxy server configurations, rather than using a manually specified proxy server.
ProxyServer	Identifies the hostname or IP address of the proxy server through which you want to route HTTP traffic.
ProxyPort	Identifies the TCP port on your specified proxy server that has been reserved for routing HTTP traffic to and from the client.
ProxyAuthScheme	Specifies the authentication method the provider uses when authenticating to the proxy server specified in the ProxyServer connection property.
ProxyUser	Provides the username of a user account registered with the proxy server specified in the ProxyServer connection property.
ProxyPassword	Specifies the password of the user specified in the ProxyUser connection property.
ProxySSLType	Specifies the SSL type to use when connecting to the proxy server specified in the ProxyServer connection property.
ProxyExceptions	Specifies a semicolon-separated list of destination hostnames or IPs that are exempt from connecting through the proxy server set in the ProxyServer connection property.

ProxyAutoDetect

Specifies whether the provider checks your system proxy settings for existing proxy server configurations, rather than using a manually specified proxy server.

Remarks

When this connection property is set to True, the Sync App checks your system proxy settings for existing proxy server configurations (no need to manually supply proxy server details).

This connection property takes precedence over other proxy settings. If you want to configure the Sync App to connect to a specific proxy server, set ProxyAutoDetect to False.

To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.

ProxyServer

Identifies the hostname or IP address of the proxy server through which you want to route HTTP traffic.

Remarks

The Sync App only routes HTTP traffic through the proxy server specified in this connection property when ProxyAutoDetect is set to False.

If ProxyAutoDetect is set to True (the default), the Sync App instead routes HTTP traffic through the proxy server specified in your system proxy settings.

ProxyPort

Identifies the TCP port on your specified proxy server that has been reserved for routing HTTP traffic to and from the client.

Remarks

The Sync App only routes HTTP traffic through the ProxyServer port specified in this connection property when ProxyAutoDetect is set to False.

If ProxyAutoDetect is set to True (the default), the Sync App instead routes HTTP traffic through the proxy server port specified in your system proxy settings.

For other proxy types, see FirewallType.

ProxyAuthScheme

Specifies the authentication method the provider uses when authenticating to the proxy server specified in the ProxyServer connection property.

Remarks

Supported authentication types :

BASIC: The Sync App performs HTTP basic authentication.
DIGEST: The Sync App performs HTTP digest authentication.
NTLM: The Sync App retrieves an NTLM token.
NEGOTIATE: The Sync App retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
NONE: Signifies that the ProxyServer does not require authentication.

For all values other than NONE, you must also set the ProxyUser and ProxyPassword connection properties.

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.

ProxyUser

Provides the username of a user account registered with the proxy server specified in the ProxyServer connection property.

Remarks

The ProxyUser and ProxyPassword connection properties are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

After selecting one of the available authentication types in ProxyAuthScheme, set this property as follows:


ProxyAuthScheme Value	Value to set for ProxyUser
BASIC	The username of a user registered with the proxy server.
DIGEST	The username of a user registered with the proxy server.
NEGOTIATE	The username of a Windows user who is a valid user in the domain or trusted domain that the proxy server is part of, in the format `user@domain` or `domain\user`.
NTLM	The username of a Windows user who is a valid user in the domain or trusted domain that the proxy server is part of, in the format `user@domain` or `domain\user`.
NONE	Do not set the ProxyPassword connection property.

Note: The Sync App only uses this username if ProxyAutoDetect is set to False. If ProxyAutoDetect is set to True (the default), the Sync App instead uses the username specified in your system proxy settings.

ProxyPassword

Specifies the password of the user specified in the ProxyUser connection property.

Remarks

The ProxyUser and ProxyPassword connection properties are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

After selecting one of the available authentication types in ProxyAuthScheme, set this property as follows:


ProxyAuthScheme Value	Value to set for ProxyPassword
BASIC	The password associated with the proxy server user specified in ProxyUser.
DIGEST	The password associated with the proxy server user specified in ProxyUser.
NEGOTIATE	The password associated with the Windows user account specified in ProxyUser.
NTLM	The password associated with the Windows user account specified in ProxyUser.
NONE	Do not set the ProxyPassword connection property.

For SOCKS 5 authentication or tunneling, see FirewallType.

Note: The Sync App only uses this password if ProxyAutoDetect is set to False. If ProxyAutoDetect is set to True (the default), the Sync App instead uses the password specified in your system proxy settings.

ProxySSLType

Specifies the SSL type to use when connecting to the proxy server specified in the ProxyServer connection property.

Remarks

This property determines when to use SSL for the connection to the HTTP proxy specified by ProxyServer. You can set this connection property to the following values :


AUTO	Default setting. If ProxyServer is set to an HTTPS URL, the Sync App uses the TUNNEL option. If ProxyServer is set to an HTTP URL, the component uses the NEVER option.
ALWAYS	The connection is always SSL enabled.
NEVER	The connection is not SSL enabled.
TUNNEL	The connection is made through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

ProxyExceptions

Specifies a semicolon-separated list of destination hostnames or IPs that are exempt from connecting through the proxy server set in the ProxyServer connection property.

Remarks

The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note: The Sync App uses the system proxy settings by default, without further configuration needed. If you want to explicitly configure proxy exceptions for this connection, set ProxyAutoDetect to False.

Logging

This section provides a complete list of the Logging properties you can configure in the connection string for this provider.

Property	Description
LogModules	Specifies the core modules to include in the log file. Use a semicolon-separated list of module names. By default, all modules are logged.

LogModules

Specifies the core modules to include in the log file. Use a semicolon-separated list of module names. By default, all modules are logged.

Remarks

The Sync App writes details about each operation it performs into the logfile specified by the Logfile connection property.

Each of these logged operations are assigned to a themed category called a module, and each module has a corresponding short code used to labels individual Sync App operations as belonging to that module.

When this connection property is set to a semicolon-separated list of module codes, only operations belonging to the specified modules are written to the logfile. Note that this only affects which operations are logged moving forward and doesn't retroactively alter the existing contents of the logfile. For example: INFO;EXEC;SSL;META;

By default, logged operations from all modules are included.

You can explicitly exclude a module by prefixing it with a "-". For example: -HTTP

To apply filters to submodules, identify them with the syntax <module name>.<submodule name>. For example, the following value causes the Sync App to only log actions belonging to the HTTP module, and further refines it to exclude actions belonging to the Res submodule of the HTTP module: HTTP;-HTTP.Res

Note that the logfile filtering triggered by the Verbosity connection property takes precedence over the filtering imposed by this connection property. This means that operations of a higher verbosity level than the level specified in the Verbosity connection property are not printed in the logfile, even if they belong to one of the modules specified in this connection property.

The available modules and submodules are:


Module Name	Module Description	Submodules
INFO	General Information. Includes the connection string, product version (build number), and initial connection messages.	Connec – Information related to creating or destroying connections. Messag – Generic label for messages pertaining to connections, the connection string, and product version. These messages are typically specific to the Sync App, rather than being received and passed along directly from the service.
EXEC	Query Execution. Includes execution messages for user-written SQL queries, parsed SQL queries, and normalized SQL queries. Success/failure messages for queries and query pages appear here as well.	Messag – Messages pertaining to query execution. These messages are typically specific to the Sync App, rather than being received and passed along directly from the service. Normlz – Query normalization steps. Query normalization is when the product takes the user-submitted query and rewrites the query to get the same results with optimal performance. Origin – This label applies to any messages recording a user's original query (the exact, unaltered, non-normalized query executed by the user). Page – Messages related to query paging. Parsed – Query parsing steps. Parsing is the process of converting the user-submitted query into a standardized format for easier processing.
HTTP	HTTP protocol messages. Includes HTTP requests/responses (including POST messages), as well as Kerberos related messages.	KERB – HTTP requests related to Kerberos. Messag – Messages pertaining to HTTP protocols. These messages are typically specific to the Sync App, rather than being received and passed along directly from the service. Unpack – This label applies to messages about zipped data being returned from the service API and unpacked by the product. Res – Messages containing HTTP responses. Req – Messages containing HTTP requests.
WSDL	Messages pertaining to the generation of WSDL/XSD files.	—
SSL	SSL certificate messages.	Certif – Messages pertaining to SSL certificates.
AUTH	Authentication related failure/success messages.	Messag – Messages pertaining to authentication. These messages are typically specific to the Sync App, rather than being received and passed along directly from the service. OAuth – Messages related to OAuth authentication. Krbros – Kerberos-related authentication messages.
SQL	Includes SQL transactions, SQL bulk transfer messages, and SQL result set messages.	Bulk – Messages pertaining to bulk query execution. Cache – Messages related to reading row data from and writing row data to the product's cache for better performance. Messag – Messages pertaining to SQL transactions. These messages are typically specific to the Sync App, rather than being received and passed along directly from the service. ResSet – Query resultsets. Transc – Messages related to handling transactions, including information about the number of jobs executed and backup table handling.
META	Metadata cache and schema messages.	Cache – Messages related to reading from and modifying column and table definitions in the product's cache for better performance. Schema – Messages related to retrieving metadata from or modifying the service schema. MemSto – Messages related to writing to or reading from in-memory metadata cache. Storag – Messages relating to storing metadata on disk or in an external data store, rather than in memory.
FUNC	Information related to executing SQL functions.	Errmsg – Error messages related to executing SQL functions.
TCP	Incoming and outgoing raw bytes on TCP transport layer messages.	Send – Raw data sent via the TCP protocol. Receiv – Raw data received via the TCP protocol.
FTP	Messages pertaining to the File Transfer Protocol.	Info – Status messages related to communication in the FTP protocol. Client – Messages related to actions taken by the FTP client (the product) during FTP communication. Server – Messages related to actions taken by the FTP server during FTP communication.
SFTP	Messages pertaining to the Secure File Transfer Protocol.	Info – Status messages related to communication in the SFTP protocol. To_Server – Messages related to actions taken by the SFTP client (the product) during SFTP communication. From_Server – Messages related to actions taken by the SFTP server during SFTP communication.
POP	Messages pertaining to data transferred via the Post Office Protocol.	Client – Messages related to actions taken by the POP client (the product) during POP communication. Server – Messages related to actions taken by the POP server during POP communication. Status – Status messages related to communication in the POP protocol.
SMTP	Messages pertaining to data transferred via the Simple Mail Transfer Protocol.	Client – Messages related to actions taken by the SMTP client (the product) during SMTP communication. Server – Messages related to actions taken by the SMTP server during SMTP communication. Status – Status messages related to communication in the SMTP protocol.
CORE	Messages relating to various internal product operations not covered by other modules.	—
DEMN	Messages related to SQL remoting.	—
CLJB	Messages about bulk data uploads (cloud job).	Commit – Submissions for bulk data uploads.
SRCE	Miscellaneous messages produced by the product that don't belong in any other module.	—
TRANCE	Advanced messages concerning low-level product operations.	—

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.

Property	Description
Location	Specifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path.
BrowsableSchemas	Optional setting that restricts the schemas reported to a subset of all available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC .
Tables	Optional setting that restricts the tables reported to a subset of all available tables. For example, Tables=TableA,TableB,TableC .
Views	Optional setting that restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC .

Location

Specifies the location of a directory containing schema files that define tables, views, and stored procedures. Depending on your service's requirements, this may be expressed as either an absolute path or a relative path.

Remarks

The Location property is only needed if you want to either customize definitions (for example, change a column name, ignore a column, etc.) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is %APPDATA%\\CData\\Asana Data Provider\\Schema, where %APPDATA% is set to the user's configuration directory:


Platform	%APPDATA%
Windows	The value of the APPDATA environment variable
Linux	~/.config

BrowsableSchemas

Optional setting that restricts the schemas reported to a subset of all available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC .

Remarks

Listing all available database schemas can take extra time, thus degrading performance. Providing a list of schemas in the connection string saves time and improves performance.

Tables

Optional setting that restricts the tables reported to a subset of all available tables. For example, Tables=TableA,TableB,TableC .

Remarks

Listing all available tables from some databases can take extra time, thus degrading performance. Providing a list of tables in the connection string saves time and improves performance.

If there are lots of tables available and you already know which ones you want to work with, you can use this property to restrict your viewing to only those tables. To do this, specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note: If you are connecting to a data source with multiple schemas or catalogs, you must specify each table you want to view by its fully qualified name. This avoids ambiguity between tables that may exist in multiple catalogs or schemas.

Views

Optional setting that restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC .

Remarks

Listing all available views from some databases can take extra time, thus degrading performance. Providing a list of views in the connection string saves time and improves performance.

If there are lots of views available and you already know which ones you want to work with, you can use this property to restrict your viewing to only those views. To do this, specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

Note: If you are connecting to a data source with multiple schemas or catalogs, you must specify each view you want to examine by its fully qualified name. This avoids ambiguity between views that may exist in multiple catalogs or schemas.

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.

Property	Description
MaxRows	Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
Other	Specifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues.
PseudoColumns	Specifies the pseudocolumns to expose as table columns, expressed as a string in the format 'TableName=ColumnName;TableName=ColumnName'.
Timeout	Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.
UserDefinedViews	Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file.
UseTypeaheadSearch	Typeahead endpoint will be utilized to fetch the results for Projects, Tasks, Users and ProjectTemplates tables.

MaxRows

Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.

Remarks

The default value for this property, -1, means that no row limit is enforced unless the query explicitly includes a LIMIT clause. (When a query includes a LIMIT clause, the value specified in the query takes precedence over the MaxRows setting.)

Setting MaxRows to a whole number greater than 0 ensures that queries do not return excessively large result sets by default.

This property is useful for optimizing performance and preventing excessive resource consumption when executing queries that could otherwise return very large datasets.

Other

Specifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues.

Remarks

This property allows advanced users to configure hidden properties for specialized situations, with the advice of our Support team. These settings are not required for normal use cases but can address unique requirements or provide additional functionality. To define multiple properties, use a semicolon-separated list.

Note: It is strongly recommended to set these properties only when advised by the Support team to address specific scenarios or issues.

Integration and Formatting


Property	Description
DefaultColumnSize	Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMT=True	Converts date-time values to GMT, instead of the local time of the machine. The default value is False (use local time).
RecordToFile=filename	Records the underlying socket data transfer to the specified file.

PseudoColumns

Specifies the pseudocolumns to expose as table columns, expressed as a string in the format 'TableName=ColumnName;TableName=ColumnName'.

Remarks

This property allows you to define which pseudocolumns the Sync App exposes as table columns.

To specify individual pseudocolumns, use the following format:

Table1=Column1;Table1=Column2;Table2=Column3

To include all pseudocolumns for all tables use:

*=*

Timeout

Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.

Remarks

The timeout applies to each individual communication with the server rather than the entire query or operation. For example, a query could continue running beyond 60 seconds if each paging call completes within the timeout limit.

Timeout is set to 60 seconds by default. To disable timeouts, set this property to 0.

Disabling the timeout allows operations to run indefinitely until they succeed or fail due to other conditions such as server-side timeouts, network interruptions, or resource limits on the server.

Note: Use this property cautiously to avoid long-running operations that could degrade performance or result in unresponsive behavior.

UserDefinedViews

Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file.

Remarks

UserDefinedViews allows you to define and manage custom views through a JSON-formatted configuration file called UserDefinedViews.json. These views are automatically recognized by the Sync App and enable you to execute custom SQL queries as if they were standard database views. The JSON file defines each view as a root element with a child element called "query", which contains the SQL query for the view.

For example:

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

You can use this property to define multiple views in a single file and specify the filepath. For example:

UserDefinedViews=C:\Path\To\UserDefinedViews.json

When you specify a view in UserDefinedViews, the Sync App only sees that view.

For further information, see User Defined Views.

UseTypeaheadSearch

Typeahead endpoint will be utilized to fetch the results for Projects, Tasks, Users and ProjectTemplates tables.

Remarks

This property works with Projects, Tasks, Users and ProjectTemplates tables.
With this property, only Name column is filterable supporting "=" and "LIKE" operators server side with limitation of supporting "starts with" with LIKE (LIKE 'abc%').
The results are unstable with maximum limit of 100 and no pagination, so it does not guarantee complete result set.

Third Party Copyrights

LZMA from 7Zip LZMA SDK

LZMA SDK is placed in the public domain.

Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original LZMA SDK code, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.

LZMA2 from XZ SDK

Version 1.9 and older are in the public domain.

Xamarin.Forms

Xamarin SDK

The MIT License (MIT)

Copyright (c) .NET Foundation Contributors

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

NSIS 3.10

Copyright (C) 1999-2025 Contributors THE ACCOMPANYING PROGRAM IS PROVIDED UNDER THE TERMS OF THIS COMMON PUBLIC LICENSE ("AGREEMENT"). ANY USE, REPRODUCTION OR DISTRIBUTION OF THE PROGRAM CONSTITUTES RECIPIENT'S ACCEPTANCE OF THIS AGREEMENT.

1. DEFINITIONS

"Contribution" means:

a) in the case of the initial Contributor, the initial code and documentation distributed under this Agreement, and b) in the case of each subsequent Contributor:

i) changes to the Program, and

ii) additions to the Program;

where such changes and/or additions to the Program originate from and are distributed by that particular Contributor. A Contribution 'originates' from a Contributor if it was added to the Program by such Contributor itself or anyone acting on such Contributor's behalf. Contributions do not include additions to the Program which: (i) are separate modules of software distributed in conjunction with the Program under their own license agreement, and (ii) are not derivative works of the Program.

"Contributor" means any person or entity that distributes the Program.

"Licensed Patents " mean patent claims licensable by a Contributor which are necessarily infringed by the use or sale of its Contribution alone or when combined with the Program.

"Program" means the Contributions distributed in accordance with this Agreement.

"Recipient" means anyone who receives the Program under this Agreement, including all Contributors.

2. GRANT OF RIGHTS

a) Subject to the terms of this Agreement, each Contributor hereby grants Recipient a non-exclusive, worldwide, royalty-free copyright license to reproduce, prepare derivative works of, publicly display, publicly perform, distribute and sublicense the Contribution of such Contributor, if any, and such derivative works, in source code and object code form.

b) Subject to the terms of this Agreement, each Contributor hereby grants Recipient a non-exclusive, worldwide, royalty-free patent license under Licensed Patents to make, use, sell, offer to sell, import and otherwise transfer the Contribution of such Contributor, if any, in source code and object code form. This patent license shall apply to the combination of the Contribution and the Program if, at the time the Contribution is added by the Contributor, such addition of the Contribution causes such combination to be covered by the Licensed Patents. The patent license shall not apply to any other combinations which include the Contribution. No hardware per se is licensed hereunder.

c) Recipient understands that although each Contributor grants the licenses to its Contributions set forth herein, no assurances are provided by any Contributor that the Program does not infringe the patent or other intellectual property rights of any other entity. Each Contributor disclaims any liability to Recipient for claims brought by any other entity based on infringement of intellectual property rights or otherwise. As a condition to exercising the rights and licenses granted hereunder, each Recipient hereby assumes sole responsibility to secure any other intellectual property rights needed, if any. For example, if a third party patent license is required to allow Recipient to distribute the Program, it is Recipient's responsibility to acquire that license before distributing the Program.

d) Each Contributor represents that to its knowledge it has sufficient copyright rights in its Contribution, if any, to grant the copyright license set forth in this Agreement.

3. REQUIREMENTS

A Contributor may choose to distribute the Program in object code form under its own license agreement, provided that:

a) it complies with the terms and conditions of this Agreement; and

b) its license agreement:

i) effectively disclaims on behalf of all Contributors all warranties and conditions, express and implied, including warranties or conditions of title and non-infringement, and implied warranties or conditions of merchantability and fitness for a particular purpose;

ii) effectively excludes on behalf of all Contributors all liability for damages, including direct, indirect, special, incidental and consequential damages, such as lost profits;

iii) states that any provisions which differ from this Agreement are offered by that Contributor alone and not by any other party; and

iv) states that source code for the Program is available from such Contributor, and informs licensees how to obtain it in a reasonable manner on or through a medium customarily used for software exchange.

When the Program is made available in source code form:

a) it must be made available under this Agreement; and

b) a copy of this Agreement must be included with each copy of the Program.

Contributors may not remove or alter any copyright notices contained within the Program.

Each Contributor must identify itself as the originator of its Contribution, if any, in a manner that reasonably allows subsequent Recipients to identify the originator of the Contribution.

4. COMMERCIAL DISTRIBUTION

Commercial distributors of software may accept certain responsibilities with respect to end users, business partners and the like. While this license is intended to facilitate the commercial use of the Program, the Contributor who includes the Program in a commercial product offering should do so in a manner which does not create potential liability for other Contributors. Therefore, if a Contributor includes the Program in a commercial product offering, such Contributor ("Commercial Contributor") hereby agrees to defend and indemnify every other Contributor ("Indemnified Contributor") against any losses, damages and costs (collectively "Losses") arising from claims, lawsuits and other legal actions brought by a third party against the Indemnified Contributor to the extent caused by the acts or omissions of such Commercial Contributor in connection with its distribution of the Program in a commercial product offering. The obligations in this section do not apply to any claims or Losses relating to any actual or alleged intellectual property infringement. In order to qualify, an Indemnified Contributor must: a) promptly notify the Commercial Contributor in writing of such claim, and b) allow the Commercial Contributor to control, and cooperate with the Commercial Contributor in, the defense and any related settlement negotiations. The Indemnified Contributor may participate in any such claim at its own expense.

For example, a Contributor might include the Program in a commercial product offering, Product X. That Contributor is then a Commercial Contributor. If that Commercial Contributor then makes performance claims, or offers warranties related to Product X, those performance claims and warranties are such Commercial Contributor's responsibility alone. Under this section, the Commercial Contributor would have to defend claims against the other Contributors related to those performance claims and warranties, and if a court requires any other Contributor to pay any damages as a result, the Commercial Contributor must pay those damages.

5. NO WARRANTY

EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, THE PROGRAM IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, EITHER EXPRESS OR IMPLIED INCLUDING, WITHOUT LIMITATION, ANY WARRANTIES OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Each Recipient is solely responsible for determining the appropriateness of using and distributing the Program and assumes all risks associated with its exercise of rights under this Agreement, including but not limited to the risks and costs of program errors, compliance with applicable laws, damage to or loss of data, programs or equipment, and unavailability or interruption of operations.

6. DISCLAIMER OF LIABILITY

EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, NEITHER RECIPIENT NOR ANY CONTRIBUTORS SHALL HAVE ANY LIABILITY FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING WITHOUT LIMITATION LOST PROFITS), HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OR DISTRIBUTION OF THE PROGRAM OR THE EXERCISE OF ANY RIGHTS GRANTED HEREUNDER, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

7. GENERAL

If any provision of this Agreement is invalid or unenforceable under applicable law, it shall not affect the validity or enforceability of the remainder of the terms of this Agreement, and without further action by the parties hereto, such provision shall be reformed to the minimum extent necessary to make such provision valid and enforceable.

If Recipient institutes patent litigation against a Contributor with respect to a patent applicable to software (including a cross-claim or counterclaim in a lawsuit), then any patent licenses granted by that Contributor to such Recipient under this Agreement shall terminate as of the date such litigation is filed. In addition, if Recipient institutes patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Program itself (excluding combinations of the Program with other software or hardware) infringes such Recipient's patent(s), then such Recipient's rights granted under Section 2(b) shall terminate as of the date such litigation is filed.

All Recipient's rights under this Agreement shall terminate if it fails to comply with any of the material terms or conditions of this Agreement and does not cure such failure in a reasonable period of time after becoming aware of such noncompliance. If all Recipient's rights under this Agreement terminate, Recipient agrees to cease use and distribution of the Program as soon as reasonably practicable. However, Recipient's obligations under this Agreement and any licenses granted by Recipient relating to the Program shall continue and survive.

Everyone is permitted to copy and distribute copies of this Agreement, but in order to avoid inconsistency the Agreement is copyrighted and may only be modified in the following manner. The Agreement Steward reserves the right to publish new versions (including revisions) of this Agreement from time to time. No one other than the Agreement Steward has the right to modify this Agreement. IBM is the initial Agreement Steward. IBM may assign the responsibility to serve as the Agreement Steward to a suitable separate entity. Each new version of the Agreement will be given a distinguishing version number. The Program (including Contributions) may always be distributed subject to the version of the Agreement under which it was received. In addition, after a new version of the Agreement is published, Contributor may elect to distribute the Program (including its Contributions) under the new version. Except as expressly stated in Sections 2(a) and 2(b) above, Recipient receives no rights or licenses to the intellectual property of any Contributor under this Agreement, whether expressly, by implication, estoppel or otherwise. All rights in the Program not expressly granted under this Agreement are reserved.

This Agreement is governed by the laws of the State of New York and the intellectual property laws of the United States of America. No party to this Agreement will bring a legal action under this Agreement more than one year after the cause of action arose. Each party waives its rights to a jury trial in any resulting litigation.

Asana Connector for CData Sync

Asana Connector for CData Sync

Overview

Asana Version Support

Establishing a Connection

Adding a Connection to Asana

Connecting to Asana

Authenticating to Asana

User Accounts (OAuth)

OAuth PKCE

Service Accounts

OAuth Scopes and Endpoints

Required Scopes and Endpoint Domains for Asana

Understanding Scopes

Required Scopes for Asana

Understanding Endpoint Domains

Required Endpoint Domains for Asana

Advanced Features

User Defined Views

SSL Configuration

Firewall and Proxy

Query Processing

Logging

SSL Configuration

Customizing the SSL Configuration

Firewall and Proxy

Connecting Through a Firewall or Proxy

HTTP Proxies

Other Proxies

Data Model

Overview

Key Features

Views

Stored Procedures

Tables

Asana Connector for CData Sync Tables

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

Pseudo-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