EndPoint Get Release Details

Contents

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

Name

get_release_details

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
ReleaseId	ReleaseId	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(100)`	100	False
title	`DT_WSTR`	`nvarchar(300)`	300	False
template_inactive	`DT_BOOL`	`bit`		False
template_name	`DT_WSTR`	`nvarchar(100)`	100	False
template_id	`DT_WSTR`	`nvarchar(100)`	100	False
display_id_display_value	`DT_WSTR`	`nvarchar(50)`	50	False
display_id_value	`DT_WSTR`	`nvarchar(50)`	50	False
emergency	`DT_BOOL`	`bit`		False
release_requester	`DT_WSTR`	`nvarchar(1020)`	1020	False
description	`DT_WSTR`	`nvarchar(1020)`	1020	False
release_engineer	`DT_WSTR`	`nvarchar(1020)`	1020	False
next_review_on	`DT_WSTR`	`nvarchar(1020)`	1020	False
urgency	`DT_WSTR`	`nvarchar(1020)`	1020	False
workflow_instance_details_id	`DT_WSTR`	`nvarchar(100)`	100	False
workflow_instance_details_status_name	`DT_WSTR`	`nvarchar(50)`	50	False
workflow_instance_details_status_id	`DT_WSTR`	`nvarchar(100)`	100	False
group	`DT_WSTR`	`nvarchar(1020)`	1020	False
reason_for_release	`DT_WSTR`	`nvarchar(1020)`	1020	False
created_time_display_value	`DT_WSTR`	`nvarchar(100)`	100	False
created_time	`DT_DBTIMESTAMP`	`datetime`		False
item	`DT_WSTR`	`nvarchar(1020)`	1020	False
workflow_validated	`DT_BOOL`	`bit`		False
workflow_name	`DT_WSTR`	`nvarchar(100)`	100	False
workflow_id	`DT_WSTR`	`nvarchar(100)`	100	False
workflow_allowed_stages_config	`DT_WSTR`	`nvarchar(50)`	50	False
release_manager	`DT_WSTR`	`nvarchar(1020)`	1020	False
impact	`DT_WSTR`	`nvarchar(1020)`	1020	False
release_type	`DT_WSTR`	`nvarchar(1020)`	1020	False
priority	`DT_WSTR`	`nvarchar(1020)`	1020	False
scheduled_end_time	`DT_WSTR`	`nvarchar(1020)`	1020	False
site	`DT_WSTR`	`nvarchar(1020)`	1020	False
completed_time	`DT_WSTR`	`nvarchar(1020)`	1020	False
stage_internal_name	`DT_WSTR`	`nvarchar(50)`	50	False
stage_inactive	`DT_BOOL`	`bit`		False
stage_stage_index	`DT_I4`	`int`		False
stage_name	`DT_WSTR`	`nvarchar(50)`	50	False
stage_id	`DT_WSTR`	`nvarchar(100)`	100	False
risk	`DT_WSTR`	`nvarchar(1020)`	1020	False
category	`DT_WSTR`	`nvarchar(1020)`	1020	False
subcategory	`DT_WSTR`	`nvarchar(1020)`	1020	False
deleted_time	`DT_WSTR`	`nvarchar(1020)`	1020	False
notes_present	`DT_BOOL`	`bit`		False
scheduled_start_time	`DT_WSTR`	`nvarchar(1020)`	1020	False
status_in_progress	`DT_BOOL`	`bit`		False
status_internal_name	`DT_WSTR`	`nvarchar(50)`	50	False
status_stage_id	`DT_WSTR`	`nvarchar(100)`	100	False
status_name	`DT_WSTR`	`nvarchar(50)`	50	False
status_id	`DT_WSTR`	`nvarchar(100)`	100	False
release_engineer_email_id	`DT_WSTR`	`nvarchar(100)`	100	False
release_engineer_cost_per_hour	`DT_WSTR`	`nvarchar(50)`	50	False
release_engineer_phone	`DT_WSTR`	`nvarchar(1020)`	1020	False
release_engineer_name	`DT_WSTR`	`nvarchar(50)`	50	False
release_engineer_mobile	`DT_WSTR`	`nvarchar(1020)`	1020	False
release_engineer_last_name	`DT_WSTR`	`nvarchar(100)`	100	False
release_engineer_id	`DT_WSTR`	`nvarchar(100)`	100	False
release_engineer_photo_url	`DT_WSTR`	`nvarchar(500)`	500	False
release_engineer_sms_mail_id	`DT_WSTR`	`nvarchar(1020)`	1020	False
release_engineer_first_name	`DT_WSTR`	`nvarchar(50)`	50	False
urgency_name	`DT_WSTR`	`nvarchar(50)`	50	False
urgency_id	`DT_WSTR`	`nvarchar(100)`	100	False
reason_for_release_name	`DT_WSTR`	`nvarchar(500)`	500	False
reason_for_release_id	`DT_WSTR`	`nvarchar(100)`	100	False
release_type_color	`DT_WSTR`	`nvarchar(50)`	50	False
release_type_pre_approved	`DT_BOOL`	`bit`		False
release_type_name	`DT_WSTR`	`nvarchar(50)`	50	False
release_type_id	`DT_WSTR`	`nvarchar(100)`	100	False
priority_color	`DT_WSTR`	`nvarchar(50)`	50	False
priority_name	`DT_WSTR`	`nvarchar(50)`	50	False
priority_id	`DT_WSTR`	`nvarchar(100)`	100	False
risk_name	`DT_WSTR`	`nvarchar(50)`	50	False
risk_id	`DT_WSTR`	`nvarchar(100)`	100	False
category_deleted	`DT_BOOL`	`bit`		False
category_name	`DT_WSTR`	`nvarchar(100)`	100	False
category_id	`DT_WSTR`	`nvarchar(100)`	100	False
subcategory_name	`DT_WSTR`	`nvarchar(100)`	100	False
subcategory_id	`DT_WSTR`	`nvarchar(100)`	100	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.