EndPoint Get Change Details

Contents

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

Name

get_change_details

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
ChangeId	ChangeId	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(50)`	50	False
title	`DT_WSTR`	`nvarchar(500)`	500	False
template_inactive	`DT_BOOL`	`bit`		False
template_name	`DT_WSTR`	`nvarchar(255)`	255	False
template_id	`DT_WSTR`	`nvarchar(100)`	100	False
display_id_display_value	`DT_WSTR`	`nvarchar(20)`	20	False
display_id_value	`DT_WSTR`	`nvarchar(8)`	8	False
emergency	`DT_BOOL`	`bit`		False
description	`DT_WSTR`	`nvarchar(2000)`	2000	False
change_type_color	`DT_WSTR`	`nvarchar(28)`	28	False
change_type_pre_approved	`DT_BOOL`	`bit`		False
change_type_name	`DT_WSTR`	`nvarchar(255)`	255	False
change_type_id	`DT_WSTR`	`nvarchar(50)`	50	False
change_owner_email_id	`DT_WSTR`	`nvarchar(255)`	255	False
change_owner_cost_per_hour	`DT_R8`	`float`		False
change_owner_phone	`DT_WSTR`	`nvarchar(40)`	40	False
change_owner_name	`DT_WSTR`	`nvarchar(255)`	255	False
change_owner_mobile	`DT_WSTR`	`nvarchar(44)`	44	False
change_owner_id	`DT_WSTR`	`nvarchar(50)`	50	False
change_owner_photo_url	`DT_WSTR`	`nvarchar(56)`	56	False
change_owner_sms_mail_id	`DT_WSTR`	`nvarchar(50)`	50	False
urgency_name	`DT_WSTR`	`nvarchar(255)`	255	False
urgency_id	`DT_WSTR`	`nvarchar(50)`	50	False
workflow_instance_details_id	`DT_WSTR`	`nvarchar(50)`	50	False
workflow_instance_details_status_name	`DT_WSTR`	`nvarchar(255)`	255	False
workflow_instance_details_status_id	`DT_WSTR`	`nvarchar(50)`	50	False
change_requester_email_id	`DT_WSTR`	`nvarchar(68)`	68	False
change_requester_is_technician	`DT_BOOL`	`bit`		False
change_requester_sms_mail	`DT_WSTR`	`nvarchar(72)`	72	False
change_requester_phone	`DT_WSTR`	`nvarchar(40)`	40	False
change_requester_name	`DT_WSTR`	`nvarchar(255)`	255	False
change_requester_mobile	`DT_WSTR`	`nvarchar(44)`	44	False
change_requester_id	`DT_WSTR`	`nvarchar(50)`	50	False
change_requester_photo_url	`DT_WSTR`	`nvarchar(56)`	56	False
change_requester_is_vip_user	`DT_BOOL`	`bit`		False
group_deleted	`DT_BOOL`	`bit`		False
group_name	`DT_WSTR`	`nvarchar(255)`	255	False
group_id	`DT_WSTR`	`nvarchar(50)`	50	False
item_name	`DT_WSTR`	`nvarchar(255)`	255	False
item.id	`DT_WSTR`	`nvarchar(50)`	50	False
workflow.validated	`DT_BOOL`	`bit`		False
workflow_name	`DT_WSTR`	`nvarchar(255)`	255	False
workflow.id	`DT_WSTR`	`nvarchar(50)`	50	False
approval_status_name	`DT_WSTR`	`nvarchar(255)`	255	False
approval_status.id	`DT_WSTR`	`nvarchar(50)`	50	False
change_manager_email_id	`DT_WSTR`	`nvarchar(52)`	52	False
change_manager_cost_per_hour	`DT_R8`	`float`		False
change_manager_phone	`DT_WSTR`	`nvarchar(40)`	40	False
change_manager_name	`DT_WSTR`	`nvarchar(255)`	255	False
change_manager_mobile	`DT_WSTR`	`nvarchar(44)`	44	False
change_manager_id	`DT_WSTR`	`nvarchar(50)`	50	False
change_manager_photo_url	`DT_WSTR`	`nvarchar(56)`	56	False
change_manager_sms_mail_id	`DT_WSTR`	`nvarchar(50)`	50	False
impact_name	`DT_WSTR`	`nvarchar(255)`	255	False
impact_id	`DT_WSTR`	`nvarchar(50)`	50	False
retrospective	`DT_BOOL`	`bit`		False
delete_pre_template_tasks	`DT_BOOL`	`bit`		False
priority_color	`DT_WSTR`	`nvarchar(28)`	28	False
priority_name	`DT_WSTR`	`nvarchar(255)`	255	False
priority_id	`DT_WSTR`	`nvarchar(50)`	50	False
scheduled_end_time_display_value	`DT_WSTR`	`nvarchar(84)`	84	False
scheduled_end_time	`DT_DBTIMESTAMP`	`datetime`		False
releases_display_id_display_value	`DT_WSTR`	`nvarchar(20)`	20	False
releases_display_id_value	`DT_WSTR`	`nvarchar(8)`	8	False
releases_id	`DT_WSTR`	`nvarchar(50)`	50	False
releases_title	`DT_WSTR`	`nvarchar(40)`	40	False
site.deleted	`DT_BOOL`	`bit`		False
site_name	`DT_WSTR`	`nvarchar(255)`	255	False
site_id	`DT_WSTR`	`nvarchar(50)`	50	False
completed_time	`DT_WSTR`	`nvarchar(1020)`	1020	False
reason_for_change_name	`DT_WSTR`	`nvarchar(255)`	255	False
reason_for_change_id	`DT_WSTR`	`nvarchar(50)`	50	False
stage_internal_name	`DT_WSTR`	`nvarchar(255)`	255	False
stage_stage_index	`DT_I8`	`bigint`		False
stage_name	`DT_WSTR`	`nvarchar(255)`	255	False
stage_id	`DT_WSTR`	`nvarchar(50)`	50	False
comment	`DT_WSTR`	`nvarchar(48)`	48	False
risk_name	`DT_WSTR`	`nvarchar(255)`	255	False
risk_id	`DT_WSTR`	`nvarchar(50)`	50	False
category_deleted	`DT_BOOL`	`bit`		False
category_name	`DT_WSTR`	`nvarchar(255)`	255	False
category_id	`DT_WSTR`	`nvarchar(50)`	50	False
subcategory_name	`DT_WSTR`	`nvarchar(255)`	255	False
subcategory_id	`DT_WSTR`	`nvarchar(50)`	50	False
deleted_time	`DT_WSTR`	`nvarchar(1020)`	1020	False
notes_present	`DT_BOOL`	`bit`		False
scheduled_start_time_display_value	`DT_WSTR`	`nvarchar(84)`	84	False
scheduled_start_time	`DT_DBTIMESTAMP`	`datetime`		False
status_internal_name	`DT_WSTR`	`nvarchar(255)`	255	False
status_stage_id	`DT_WSTR`	`nvarchar(50)`	50	False
status_name	`DT_WSTR`	`nvarchar(255)`	255	False
status_id	`DT_WSTR`	`nvarchar(50)`	50	False
created_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
created_time	`DT_DBTIMESTAMP`	`datetime`		False
last_updated_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
last_updated_time	`DT_DBTIMESTAMP`	`datetime`		False
created_by_email_id	`DT_WSTR`	`nvarchar(180)`	180	False
created_by_is_technician	`DT_BOOL`	`bit`		False
created_by_sms_mail	`DT_WSTR`	`nvarchar(2550)`	2550	False
created_by_mobile	`DT_WSTR`	`nvarchar(200)`	200	False
created_by_last_name	`DT_WSTR`	`nvarchar(40)`	40	False
created_by_user_scope	`DT_WSTR`	`nvarchar(200)`	200	False
created_by_phone	`DT_WSTR`	`nvarchar(120)`	120	False
created_by_name	`DT_WSTR`	`nvarchar(130)`	130	False
created_by_id	`DT_WSTR`	`nvarchar(180)`	180	False
created_by_photo_url	`DT_WSTR`	`nvarchar(750)`	750	False
created_by_is_vip_user	`DT_BOOL`	`bit`		False
created_by_department	`DT_WSTR`	`nvarchar(2550)`	2550	False
created_by_first_name	`DT_WSTR`	`nvarchar(80)`	80	False
created_by_job_title	`DT_WSTR`	`nvarchar(2550)`	2550	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.