TDV Adapter for Asana

Build 21.0.8137


To Create, Delete and Query memberships in the Workspace

Table Specific Information


The adapter 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 adapter.

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


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

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


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

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


Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the membership.

userId [KEY] String True

Globally unique ID of the user.

userName String True

The user`s name.

WorkspaceId [KEY] String True

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

A user task list represents the tasks assigned to a particular user.

ResourceType String True

The base type of this resource.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137