EndPoint Get Requests

Contents

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

Name

get_requests

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
There are no parameters

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(180)`	180	False
subject	`DT_WSTR`	`nvarchar(1000)`	1000	False
description	`DT_NTEXT`	`nvarchar(MAX)`		False
email_to	`DT_WSTR`	`nvarchar(255)`	255	False
status_color	`DT_WSTR`	`nvarchar(70)`	70	False
status_name	`DT_WSTR`	`nvarchar(40)`	40	False
status_id	`DT_WSTR`	`nvarchar(180)`	180	False
status_in_progress	`DT_BOOL`	`bit`		False
status_internal_name	`DT_WSTR`	`nvarchar(40)`	40	False
status_stop_timer	`DT_BOOL`	`bit`		False
resolution_content	`DT_NTEXT`	`nvarchar(MAX)`		False
resolution_submitted_by	`DT_WSTR`	`nvarchar(255)`	255	False
update_reason	`DT_WSTR`	`nvarchar(4000)`	4000	False
requester_email_id	`DT_WSTR`	`nvarchar(255)`	255	False
requester_is_technician	`DT_BOOL`	`bit`		False
requester_sms_mail	`DT_WSTR`	`nvarchar(255)`	255	False
requester_mobile	`DT_WSTR`	`nvarchar(255)`	255	False
requester_last_name	`DT_WSTR`	`nvarchar(255)`	255	False
requester_user_scope	`DT_WSTR`	`nvarchar(255)`	255	False
requester_phone	`DT_WSTR`	`nvarchar(255)`	255	False
requester_name	`DT_WSTR`	`nvarchar(255)`	255	False
requester_id	`DT_WSTR`	`nvarchar(180)`	180	False
requester_photo_url	`DT_WSTR`	`nvarchar(750)`	750	False
requester_is_vip_user	`DT_BOOL`	`bit`		False
requester_department	`DT_WSTR`	`nvarchar(2550)`	2550	False
requester_first_name	`DT_WSTR`	`nvarchar(255)`	255	False
requester_job_title	`DT_WSTR`	`nvarchar(2550)`	2550	False
project	`DT_WSTR`	`nvarchar(1000)`	1000	False
resolution	`DT_WSTR`	`nvarchar(4000)`	4000	False
linked_to_request	`DT_WSTR`	`nvarchar(2550)`	2550	False
mode_name	`DT_WSTR`	`nvarchar(255)`	255	False
mode_id	`DT_WSTR`	`nvarchar(180)`	180	False
lifecycle	`DT_WSTR`	`nvarchar(2550)`	2550	False
assets	`DT_WSTR`	`nvarchar(400)`	400	False
cancellation_requested	`DT_BOOL`	`bit`		False
is_trashed	`DT_BOOL`	`bit`		False
has_change_initiated_request	`DT_BOOL`	`bit`		False
group_name	`DT_WSTR`	`nvarchar(255)`	255	False
group_id	`DT_WSTR`	`nvarchar(255)`	255	False
on_behalf_of_email_id	`DT_WSTR`	`nvarchar(180)`	180	False
on_behalf_of_is_technician	`DT_BOOL`	`bit`		False
on_behalf_of_sms_mail	`DT_WSTR`	`nvarchar(2550)`	2550	False
on_behalf_of_mobile	`DT_WSTR`	`nvarchar(200)`	200	False
on_behalf_of_last_name	`DT_WSTR`	`nvarchar(40)`	40	False
on_behalf_of_user_scope	`DT_WSTR`	`nvarchar(200)`	200	False
on_behalf_of_phone	`DT_WSTR`	`nvarchar(120)`	120	False
on_behalf_of_name	`DT_WSTR`	`nvarchar(130)`	130	False
on_behalf_of_id	`DT_WSTR`	`nvarchar(180)`	180	False
responded_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
responded_time	`DT_DBTIMESTAMP`	`datetime`		False
completed_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
completed_time	`DT_DBTIMESTAMP`	`datetime`		False
assigned_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
assigned_time	`DT_DBTIMESTAMP`	`datetime`		False
resolved_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
resolved_time	`DT_DBTIMESTAMP`	`datetime`		False
scheduled_start_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
scheduled_start_time	`DT_DBTIMESTAMP`	`datetime`		False
scheduled_end_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
scheduled_end_time	`DT_DBTIMESTAMP`	`datetime`		False
first_response_due_by_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
first_response_due_by_time	`DT_DBTIMESTAMP`	`datetime`		False
deleted_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
deleted_time	`DT_DBTIMESTAMP`	`datetime`		False
due_by_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
due_by_time	`DT_DBTIMESTAMP`	`datetime`		False
item_name	`DT_WSTR`	`nvarchar(4000)`	4000	False
item_id	`DT_WSTR`	`nvarchar(255)`	255	False
cancel_flag_comments_name	`DT_WSTR`	`nvarchar(400)`	400	False
cancel_flag_comment	`DT_NTEXT`	`nvarchar(MAX)`		False
cancel_flag_comments_id	`DT_WSTR`	`nvarchar(400)`	400	False
level_name	`DT_WSTR`	`nvarchar(400)`	400	False
level_id	`DT_WSTR`	`nvarchar(255)`	255	False
impact_name	`DT_WSTR`	`nvarchar(400)`	400	False
impact_id	`DT_WSTR`	`nvarchar(255)`	255	False
sla_name	`DT_WSTR`	`nvarchar(400)`	400	False
sla_id	`DT_WSTR`	`nvarchar(255)`	255	False
approval_status_name	`DT_WSTR`	`nvarchar(400)`	400	False
approval_status_id	`DT_WSTR`	`nvarchar(255)`	255	False
priority_name	`DT_WSTR`	`nvarchar(400)`	400	False
priority_id	`DT_WSTR`	`nvarchar(255)`	255	False
has_notes	`DT_BOOL`	`bit`		False
impact_details	`DT_WSTR`	`nvarchar(400)`	400	False
email_cc	`DT_WSTR`	`nvarchar(4000)`	4000	False
email_bcc	`DT_WSTR`	`nvarchar(4000)`	4000	False
subcategory_name	`DT_WSTR`	`nvarchar(150)`	150	False
subcategory_id	`DT_WSTR`	`nvarchar(180)`	180	False
template_name	`DT_WSTR`	`nvarchar(150)`	150	False
template_id	`DT_WSTR`	`nvarchar(180)`	180	False
email_ids_to_notify	`DT_WSTR`	`nvarchar(4000)`	4000	False
attachments	`DT_WSTR`	`nvarchar(4000)`	4000	False
completed_by_denial	`DT_BOOL`	`bit`		False
display_id	`DT_WSTR`	`nvarchar(100)`	100	False
time_elapsed	`DT_WSTR`	`nvarchar(100)`	100	False
notification_status	`DT_WSTR`	`nvarchar(2550)`	2550	False
service_cost	`DT_R4`	`real`		False
total_cost	`DT_R4`	`real`		False
urgency_name	`DT_WSTR`	`nvarchar(400)`	400	False
urgency_id	`DT_WSTR`	`nvarchar(255)`	255	False
has_request_initiated_change	`DT_BOOL`	`bit`		False
request_template_task_ids	`DT_WSTR`	`nvarchar(1000)`	1000	False
department_name	`DT_WSTR`	`nvarchar(400)`	400	False
department_id	`DT_WSTR`	`nvarchar(255)`	255	False
is_service_request	`DT_BOOL`	`bit`		False
is_reopened	`DT_BOOL`	`bit`		False
is_overdue	`DT_BOOL`	`bit`		False
is_escalated	`DT_BOOL`	`bit`		False
is_read	`DT_BOOL`	`bit`		False
is_fcr	`DT_BOOL`	`bit`		False
has_problem	`DT_BOOL`	`bit`		False
has_project	`DT_BOOL`	`bit`		False
has_draft	`DT_BOOL`	`bit`		False
has_attachments	`DT_BOOL`	`bit`		False
has_linked_requests	`DT_BOOL`	`bit`		False
site_name	`DT_WSTR`	`nvarchar(400)`	400	False
site_id	`DT_WSTR`	`nvarchar(255)`	255	False
is_first_response_overdue	`DT_BOOL`	`bit`		False
technician_email_id	`DT_WSTR`	`nvarchar(180)`	180	False
technician_is_technician	`DT_BOOL`	`bit`		False
technician_sms_mail	`DT_WSTR`	`nvarchar(2550)`	2550	False
technician_mobile	`DT_WSTR`	`nvarchar(200)`	200	False
technician_last_name	`DT_WSTR`	`nvarchar(40)`	40	False
technician_user_scope	`DT_WSTR`	`nvarchar(200)`	200	False
technician_phone	`DT_WSTR`	`nvarchar(120)`	120	False
technician_name	`DT_WSTR`	`nvarchar(130)`	130	False
technician_id	`DT_WSTR`	`nvarchar(180)`	180	False
technician_photo_url	`DT_WSTR`	`nvarchar(750)`	750	False
technician_is_vip_user	`DT_BOOL`	`bit`		False
technician_department	`DT_WSTR`	`nvarchar(2550)`	2550	False
technician_first_name	`DT_WSTR`	`nvarchar(80)`	80	False
technician_job_title	`DT_WSTR`	`nvarchar(2550)`	2550	False
unreplied_count	`DT_I4`	`int`		False
status_code	`DT_I8`	`bigint`		False
status	`DT_WSTR`	`nvarchar(70)`	70	False
category_name	`DT_WSTR`	`nvarchar(400)`	400	False
category_id	`DT_WSTR`	`nvarchar(255)`	255	False
maintenance_name	`DT_WSTR`	`nvarchar(400)`	400	False
maintenance_id	`DT_WSTR`	`nvarchar(255)`	255	False
request_type_name	`DT_WSTR`	`nvarchar(80)`	80	False
request_type_id	`DT_WSTR`	`nvarchar(180)`	180	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.