EndPoint Get Goals

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

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

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.