EndPoint Get Request Task Worklog Details

Contents

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

Name

get_request_task_worklog_details

Description

No description available

Parameters

Parameter	Label	Required
RequestId	RequestId	YES
TaskId	TaskId	YES
WorklogId	WorklogId	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(180)`	180	False
description	`DT_WSTR`	`nvarchar(64)`	64	False
other_charge	`DT_R8`	`float`		False
total_charge	`DT_R8`	`float`		False
tech_charge	`DT_R8`	`float`		False
time_spent_hours	`DT_I8`	`bigint`		False
time_spent_minutes	`DT_I8`	`bigint`		False
start_time_display_value	`DT_WSTR`	`nvarchar(84)`	84	False
start_time	`DT_DBTIMESTAMP`	`datetime`		False
end_time_display_value	`DT_WSTR`	`nvarchar(84)`	84	False
end_time	`DT_DBTIMESTAMP`	`datetime`		False
worklog_type_name	`DT_WSTR`	`nvarchar(36)`	36	False
worklog_type_id	`DT_WSTR`	`nvarchar(64)`	64	False
recorded_time_display_value	`DT_WSTR`	`nvarchar(84)`	84	False
recorded_time	`DT_DBTIMESTAMP`	`datetime`		False
mark_first_response	`DT_BOOL`	`bit`		False
last_updated_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
last_updated_time	`DT_DBTIMESTAMP`	`datetime`		False
created_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
created_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.