ManagedEngine ServiceDesk Plus (Zoho) Endpoint - get_requests - Get Requests | ZappySys | SSIS

EndPoint Get Requests

Contents

1 Name
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

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

Input Columns

Name	DataType	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.