JDBC Driver for Asana

Build 23.0.8839

GoalMembership

To Create, Delete and Query memberships in the Goal.

Table Specific Information

Select

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

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

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