JDBC Driver for Asana

Build 23.0.8839


To Create, Delete and Query memberships in the Goal.

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


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

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


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

DELETE FROM GoalMembership WHERE Id = '1161963899354167'


Name Type ReadOnly References Description
Id [KEY] String True

Globally unique Id of the goal membership.

GoalId String False


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.

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