Goals
To Create, Update, Delete and Query the Goals table.
Table Specific Information
Select
The connector 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 connector.
- Id supports the '=' comparison.
- IsWorkspaceLevel supports the '=' comparison.
- TeamId supports the '=' comparison.
- TimeId supports the '=' comparison.
- WorkspaceId 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'
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. |