EndPoint Get Problem Details

Contents

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

Name

get_problem_details

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
ProblemId	ProblemId	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(50)`	50	False
title	`DT_WSTR`	`nvarchar(255)`	255	False
template_name	`DT_WSTR`	`nvarchar(50)`	50	False
template_id	`DT_WSTR`	`nvarchar(100)`	100	False
updated_time_display_value	`DT_WSTR`	`nvarchar(100)`	100	False
updated_time	`DT_DBTIMESTAMP`	`datetime`		False
display_id_display_value	`DT_WSTR`	`nvarchar(50)`	50	False
display_id_value	`DT_WSTR`	`nvarchar(50)`	50	False
description	`DT_WSTR`	`nvarchar(100)`	100	False
urgency_name	`DT_WSTR`	`nvarchar(50)`	50	False
urgency_id	`DT_WSTR`	`nvarchar(100)`	100	False
reported_by_email_id	`DT_WSTR`	`nvarchar(100)`	100	False
reported_by_is_technician	`DT_BOOL`	`bit`		False
reported_by_sms_mail	`DT_WSTR`	`nvarchar(100)`	100	False
reported_by_phone	`DT_WSTR`	`nvarchar(50)`	50	False
reported_by_name	`DT_WSTR`	`nvarchar(50)`	50	False
reported_by_mobile	`DT_WSTR`	`nvarchar(50)`	50	False
reported_by_id	`DT_WSTR`	`nvarchar(100)`	100	False
reported_by_photo_url	`DT_WSTR`	`nvarchar(100)`	100	False
reported_by_is_vip_user	`DT_BOOL`	`bit`		False
reported_by_job_title	`DT_WSTR`	`nvarchar(100)`	100	False
group_site_id	`DT_WSTR`	`nvarchar(100)`	100	False
group_deleted	`DT_BOOL`	`bit`		False
group_name	`DT_WSTR`	`nvarchar(100)`	100	False
group_id	`DT_WSTR`	`nvarchar(100)`	100	False
item_name	`DT_WSTR`	`nvarchar(50)`	50	False
item_id	`DT_WSTR`	`nvarchar(100)`	100	False
impact_name	`DT_WSTR`	`nvarchar(100)`	100	False
impact_id	`DT_WSTR`	`nvarchar(100)`	100	False
technician_email_id	`DT_WSTR`	`nvarchar(100)`	100	False
technician_cost_per_hour	`DT_R8`	`float`		False
technician_phone	`DT_WSTR`	`nvarchar(50)`	50	False
technician_name	`DT_WSTR`	`nvarchar(50)`	50	False
technician_mobile	`DT_WSTR`	`nvarchar(50)`	50	False
technician_id	`DT_WSTR`	`nvarchar(100)`	100	False
technician_photo_url	`DT_WSTR`	`nvarchar(100)`	100	False
technician_sms_mail_id	`DT_WSTR`	`nvarchar(100)`	100	False
closed_time	`DT_WSTR`	`nvarchar(1020)`	1020	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
due_by_time_display_value	`DT_WSTR`	`nvarchar(100)`	100	False
due_by_time	`DT_DBTIMESTAMP`	`datetime`		False
site_deleted	`DT_BOOL`	`bit`		False
site_name	`DT_WSTR`	`nvarchar(50)`	50	False
site_id	`DT_WSTR`	`nvarchar(100)`	100	False
udf_fields_udf_long1	`DT_WSTR`	`nvarchar(100)`	100	False
udf_fields_udf_char1	`DT_WSTR`	`nvarchar(100)`	100	False
category_deleted	`DT_BOOL`	`bit`		False
category_name	`DT_WSTR`	`nvarchar(50)`	50	False
category_id	`DT_WSTR`	`nvarchar(100)`	100	False
subcategory_name	`DT_WSTR`	`nvarchar(50)`	50	False
subcategory_id	`DT_WSTR`	`nvarchar(100)`	100	False
notes_present	`DT_BOOL`	`bit`		False
status_in_progress	`DT_BOOL`	`bit`		False
status_internal_name	`DT_WSTR`	`nvarchar(100)`	100	False
status_stop_timer	`DT_BOOL`	`bit`		False
status_color	`DT_WSTR`	`nvarchar(50)`	50	False
status_name	`DT_WSTR`	`nvarchar(50)`	50	False
status_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.