ADO.NET Provider for Asana

Build 23.0.8839


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


The 本製品 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 本製品.

  • 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'


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')


Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the team.

Name String True

The name of the team.

Description String True

The description of the team.

WorkspaceId String True


The workspace or organization this team is associated with.

HTMLDescrption String True

The description of the team with formatting as HTML.

ResourceType String True

The resource type of this resource.

UserId String True


Globally unique ID of the user.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839