EndPoint Get Request Task Details

Contents

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

Name

get_request_task_details

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
RequestId	RequestId	YES
TaskId	TaskId	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(180)`	180	False
title	`DT_WSTR`	`nvarchar(500)`	500	False
description	`DT_WSTR`	`nvarchar(4000)`	4000	False
percentage_completion	`DT_WSTR`	`nvarchar(20)`	20	False
request_id	`DT_WSTR`	`nvarchar(64)`	64	False
additional_cost	`DT_WSTR`	`nvarchar(20)`	20	False
estimated_effort_hours	`DT_WSTR`	`nvarchar(20)`	20	False
attachments	`DT_WSTR`	`nvarchar(4000)`	4000	False
email_before	`DT_WSTR`	`nvarchar(28)`	28	False
marked_technician_email_id	`DT_WSTR`	`nvarchar(255)`	255	False
marked_technician_is_technician	`DT_BOOL`	`bit`		False
marked_technician_sms_mail	`DT_WSTR`	`nvarchar(255)`	255	False
marked_technician_phone	`DT_WSTR`	`nvarchar(255)`	255	False
marked_technician_name	`DT_WSTR`	`nvarchar(255)`	255	False
marked_technician_mobile	`DT_WSTR`	`nvarchar(255)`	255	False
marked_technician_id	`DT_WSTR`	`nvarchar(255)`	255	False
marked_technician_photo_url	`DT_WSTR`	`nvarchar(500)`	500	False
marked_technician_is_vip_user	`DT_BOOL`	`bit`		False
marked_technician_department	`DT_WSTR`	`nvarchar(255)`	255	False
overdue	`DT_BOOL`	`bit`		False
actual_start_time_display_value	`DT_WSTR`	`nvarchar(255)`	255	False
actual_start_time	`DT_DBTIMESTAMP`	`datetime`		False
actual_end_time_display_value	`DT_WSTR`	`nvarchar(255)`	255	False
actual_end_time	`DT_DBTIMESTAMP`	`datetime`		False
associated_entity	`DT_WSTR`	`nvarchar(255)`	255	False
module	`DT_WSTR`	`nvarchar(255)`	255	False
priority_color	`DT_WSTR`	`nvarchar(255)`	255	False
priority_name	`DT_WSTR`	`nvarchar(255)`	255	False
priority_id	`DT_WSTR`	`nvarchar(255)`	255	False
scheduled_end_time_display_value	`DT_WSTR`	`nvarchar(255)`	255	False
scheduled_end_time	`DT_DBTIMESTAMP`	`datetime`		False
estimated_effort_minutes	`DT_WSTR`	`nvarchar(20)`	20	False
deleted	`DT_BOOL`	`bit`		False
estimated_effort	`DT_WSTR`	`nvarchar(20)`	20	False
estimated_effort_days	`DT_WSTR`	`nvarchar(20)`	20	False
task_type_color	`DT_WSTR`	`nvarchar(255)`	255	False
task_type_name	`DT_WSTR`	`nvarchar(255)`	255	False
task_type_id	`DT_WSTR`	`nvarchar(255)`	255	False
scheduled_start_time_display_value	`DT_WSTR`	`nvarchar(255)`	255	False
scheduled_start_time	`DT_DBTIMESTAMP`	`datetime`		False
status_in_progress	`DT_BOOL`	`bit`		False
status_internal_name	`DT_WSTR`	`nvarchar(255)`	255	False
status_stop_timer	`DT_BOOL`	`bit`		False
status_color	`DT_WSTR`	`nvarchar(255)`	255	False
status_name	`DT_WSTR`	`nvarchar(255)`	255	False
status_id	`DT_WSTR`	`nvarchar(255)`	255	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
owner_email_id	`DT_WSTR`	`nvarchar(255)`	255	False
owner_is_technician	`DT_BOOL`	`bit`		False
owner_sms_mail	`DT_WSTR`	`nvarchar(255)`	255	False
owner_phone	`DT_WSTR`	`nvarchar(255)`	255	False
owner_name	`DT_WSTR`	`nvarchar(255)`	255	False
owner_mobile	`DT_WSTR`	`nvarchar(255)`	255	False
owner_id	`DT_WSTR`	`nvarchar(255)`	255	False
owner_photo_url	`DT_WSTR`	`nvarchar(255)`	255	False
owner_is_vip_user	`DT_BOOL`	`bit`		False
owner_department	`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.