EndPoint Get Goals

Name

get_goals

Description

Parameters

Parameter

Label

Required

Options

Description

Workspace

Workspace Id

Project

Project Id

Portfolio

Portfolio Id

Team

Team Id

IsWorkspaceLevel

Is Workspace Level

Option	Value
true	true
false	false

TimePeriods

Time Periods (e.g. Id1,Id2)

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

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	Raw
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`

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:

Get Goals using API Source

Asana

Get Goals

SSIS API Source - Read from table or endpoint

Get Goals using API Destination

Asana

Get Goals