Reference

Endpoint Get Goals

Name

get_goals

Description

Related Tables

Goals

Parameters

Parameter Required Options
Name: Workspace

Label: Workspace Id
Name: Project

Label: Project Id
Name: Portfolio

Label: Portfolio Id
Name: Team

Label: Team Id
Name: IsWorkspaceLevel

Label: Is Workspace Level
Option Value
true true
false false
Name: TimePeriods

Label: Time Periods (e.g. Id1,Id2)
Name: Fields

Label: Fields
Option Value
due_on due_on
html_notes html_notes
is_workspace_level is_workspace_level
liked liked
name name
notes notes
start_on start_on
status status
current_status_update current_status_update
current_status_update.resource_subtype current_status_update.resource_subtype
current_status_update.title current_status_update.title
followers followers
likes likes
metric metric
metric.currency_code metric.currency_code
metric.current_display_value metric.current_display_value
metric.current_number_value metric.current_number_value
metric.initial_number_value metric.initial_number_value
metric.precision metric.precision
metric.progress_source metric.progress_source
metric.resource_subtype metric.resource_subtype
metric.target_number_value metric.target_number_value
metric.unit metric.unit
metric.can_manage metric.can_manage
metric.is_custom_weight metric.is_custom_weight
num_likes num_likes
owner owner
owner.name owner.name
team team
team.name team.name
time_period time_period
time_period.display_name time_period.display_name
time_period.end_on time_period.end_on
time_period.period time_period.period
time_period.start_on time_period.start_on
workspace workspace
workspace.name workspace.name
Name: Limit

Label: Limit

Results per page. The number of objects to return per page. The value must be between 1 and 100.

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(50) 50
Name DT_WSTR nvarchar(255) 255
DueOn DT_WSTR nvarchar(50) 50
HtmlNotes DT_NTEXT nvarchar(MAX)
IsWorkspaceLevel DT_BOOL bit
Liked DT_BOOL bit
Notes DT_WSTR nvarchar(2000) 2000
StartOn DT_WSTR nvarchar(50) 50
Status DT_WSTR nvarchar(50) 50
CurrentStatusUpdateId DT_WSTR nvarchar(50) 50
CurrentStatusUpdateResourceSubtype DT_WSTR nvarchar(100) 100
CurrentStatusUpdateTitle DT_WSTR nvarchar(100) 100
Followers DT_WSTR nvarchar(500) 500
Likes DT_WSTR nvarchar(1000) 1000
MetricId DT_WSTR nvarchar(50) 50
MetricCurrencyCode DT_WSTR nvarchar(50) 50
MetricCurrentDisplayValue DT_WSTR nvarchar(50) 50
MetricCurrentNumberValue DT_R8 float
MetricInitialNumberValue DT_R8 float
MetricPrecision DT_I4 int
MetricProgressSource DT_WSTR nvarchar(50) 50
MetricResourceSubtype DT_WSTR nvarchar(50) 50
MetricTargetNumberValue DT_R8 float
MetricUnit DT_WSTR nvarchar(50) 50
MetricCanManage DT_BOOL bit
NumLikes DT_I4 int
OwnerId DT_WSTR nvarchar(50) 50
OwnerName DT_WSTR nvarchar(255) 255
TeamId DT_WSTR nvarchar(50) 50
TeamName DT_WSTR nvarchar(255) 255
TimePeriodId DT_WSTR nvarchar(50) 50
TimePeriodDisplayName DT_WSTR nvarchar(255) 255
TimePeriodEndOn DT_WSTR nvarchar(50) 50
TimePeriodPeriod DT_WSTR nvarchar(50) 50
TimePeriodStartOn DT_WSTR nvarchar(50) 50
WorkspaceId DT_WSTR nvarchar(50) 50
WorkspaceName DT_WSTR nvarchar(255) 255
If the column you are looking for is missing, consider customizing Asana Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Asana Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Goals table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Asana
Read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required.
Asana
Goals
Optional Parameters
Workspace Id
Project Id
Portfolio Id
Team Id
Is Workspace Level
Time Periods (e.g. Id1,Id2)
Continue On 404 Error (When record not found) False
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Goals table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get goals:

API Destination - Asana
Read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required.
Asana
Goals
Select
Optional Parameters
Workspace Id
Project Id
Portfolio Id
Team Id
Is Workspace Level
Time Periods (e.g. Id1,Id2)
Continue On 404 Error (When record not found) False
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List project goals

<p>Returns goals for a specific project. Supply the project ID. You can also filter goals by workspace, portfolio, or team when you want goals at different levels, and optionally narrow by workspace-level flag or time periods.</p> 

SELECT * FROM Goals WITH(Project='1206673375982078')

List workspace goals

<p>Returns goals for a specific workspace. Supply the workspace ID. You can narrow results by workspace-level flag and by time period IDs when needed.</p> 

SELECT * FROM Goals WITH(Workspace='1200442900140748')

List team goals

<p>Returns goals for a specific team. Supply the team ID. The same optional filters as other goal queries apply: workspace-level flag, time periods, and optionally workspace, project, or portfolio for cross-scope filtering.</p> 

SELECT * FROM Goals WITH(Team='1200442900140748')

get_goals endpoint belongs to Goals table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List project goals

<p>Returns goals for a specific project. Supply the project ID. You can also filter goals by workspace, portfolio, or team when you want goals at different levels, and optionally narrow by workspace-level flag or time periods.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Goals WITH(Project=''1206673375982078'')';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

List workspace goals

<p>Returns goals for a specific workspace. Supply the workspace ID. You can narrow results by workspace-level flag and by time period IDs when needed.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Goals WITH(Workspace=''1200442900140748'')';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

List team goals

<p>Returns goals for a specific team. Supply the team ID. The same optional filters as other goal queries apply: workspace-level flag, time periods, and optionally workspace, project, or portfolio for cross-scope filtering.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Goals WITH(Team=''1200442900140748'')';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

get_goals endpoint belongs to Goals table(s), and can therefore be used via those table(s).