Asana Connector
Documentation
Version: 1
Documentation
Endpoint

Get Goals

Name

get_goals

Description

Related Tables

Goals

Parameters

Parameter Label Required Options Description
Workspace Workspace Id NO
Project Project Id NO
Portfolio Portfolio Id NO
Team Team Id NO
IsWorkspaceLevel Is Workspace Level NO
Option Value
true true
false false
TimePeriods Time Periods (e.g. Id1,Id2) NO
Fields Fields NO
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
Limit Limit NO 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 Raw Description
Id DT_WSTR nvarchar(50) 50 False
Name DT_WSTR nvarchar(255) 255 False
DueOn DT_WSTR nvarchar(50) 50 False
HtmlNotes DT_NTEXT nvarchar(MAX) False
IsWorkspaceLevel DT_BOOL bit False
Liked DT_BOOL bit False
Notes DT_WSTR nvarchar(2000) 2000 False
StartOn DT_WSTR nvarchar(50) 50 False
Status DT_WSTR nvarchar(50) 50 False
CurrentStatusUpdateId DT_WSTR nvarchar(50) 50 False
CurrentStatusUpdateResourceSubtype DT_WSTR nvarchar(100) 100 False
CurrentStatusUpdateTitle DT_WSTR nvarchar(100) 100 False
Followers DT_WSTR nvarchar(500) 500 False
Likes DT_WSTR nvarchar(1000) 1000 False
MetricId DT_WSTR nvarchar(50) 50 False
MetricCurrencyCode DT_WSTR nvarchar(50) 50 False
MetricCurrentDisplayValue DT_WSTR nvarchar(50) 50 False
MetricCurrentNumberValue DT_R8 float False
MetricInitialNumberValue DT_R8 float False
MetricPrecision DT_I4 int False
MetricProgressSource DT_WSTR nvarchar(50) 50 False
MetricResourceSubtype DT_WSTR nvarchar(50) 50 False
MetricTargetNumberValue DT_R8 float False
MetricUnit DT_WSTR nvarchar(50) 50 False
MetricCanManage DT_BOOL bit False
NumLikes DT_I4 int False
OwnerId DT_WSTR nvarchar(50) 50 False
OwnerName DT_WSTR nvarchar(255) 255 False
TeamId DT_WSTR nvarchar(50) 50 False
TeamName DT_WSTR nvarchar(255) 255 False
TimePeriodId DT_WSTR nvarchar(50) 50 False
TimePeriodDisplayName DT_WSTR nvarchar(255) 255 False
TimePeriodEndOn DT_WSTR nvarchar(50) 50 False
TimePeriodPeriod DT_WSTR nvarchar(50) 50 False
TimePeriodStartOn DT_WSTR nvarchar(50) 50 False
WorkspaceId DT_WSTR nvarchar(50) 50 False
WorkspaceName DT_WSTR nvarchar(255) 255 False
If the column you are looking for is missing, consider customizing Asana Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw 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 component to read data or in API Destination component to read/write data:

Read from Goals table using API Destination

This Endpoint belongs to Goals table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Asana
Goals
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get goals 

SELECT * FROM get_goals

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:

Get goals 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_goals';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_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).