JDBC Driver for Asana

Build 23.0.8839

Goals

To Create, Update, Delete and Query the Goals table.

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

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.

CurrentStatusUpdate String True

The latest status_update posted to this goal.

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.

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