Reference

Endpoint Get Requests

Name

get_requests

Description

No description available

Related Tables

Requests

Parameters

Parameter	Required	Options
There are no parameters

Output Columns

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

If the column you are looking for is missing, consider customizing ManagedEngine ServiceDesk Plus (Zoho) Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	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 or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Requests table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - ManagedEngine ServiceDesk Plus (Zoho)

ManagedEngine (Zoho) ServiceDesk Plus Connector can be used to integrate ServiceDesk Plus data in your App / BI Tools. You can read/write Requests, Tasks, Comments, Worklogs and many other items.

ManagedEngine ServiceDesk Plus (Zoho)

Requests

Optional Parameters
MetaDetectionOrder	Default

SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Requests table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get requests:

API Destination - ManagedEngine ServiceDesk Plus (Zoho)

ManagedEngine (Zoho) ServiceDesk Plus Connector can be used to integrate ServiceDesk Plus data in your App / BI Tools. You can read/write Requests, Tasks, Comments, Worklogs and many other items.

ManagedEngine ServiceDesk Plus (Zoho)

Requests

Select

Optional Parameters
MetaDetectionOrder	Default

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List requests

This example shows how to list requests.

SELECT * FROM Requests

get_requests endpoint belongs to Requests table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List requests

This example shows how to list requests.

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Requests';

EXEC (@MyQuery) AT [LS_TO_MANAGEDENGINE_SERVICEDESK_PLUS_ZOHO_IN_GATEWAY];

get_requests endpoint belongs to Requests table(s), and can therefore be used via those table(s).