EndPoint Get Requests

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.

Examples

SSIS

Use ManagedEngine ServiceDesk Plus (Zoho) Connector in API Source component to read data or in API Destination component to read/write data:

Get Requests using API Source

ManagedEngine ServiceDesk Plus (Zoho)

Get Requests

SSIS API Source - Read from table or endpoint

Get Requests using API Destination

ManagedEngine ServiceDesk Plus (Zoho)

Get Requests