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 data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
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 data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
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:

Read Project Goals

Read Goals for a specified Project Id. 

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

Read Workspace Goals

Read Goals for a specified Workspace Id. 

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

Read Team Goals

Read Goals for a specified Team Id. 

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:

Read Project Goals

Read Goals for a specified Project Id. 

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

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

Read Workspace Goals

Read Goals for a specified Workspace Id. 

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

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

Read Team Goals

Read Goals for a specified Team Id. 

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