EndPoint Get Requests
Name
get_requests
Description
Parameters
Parameter | Label | Required | Options | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no parameters |
Output Columns
Label | DataType | Length | Raw | Description |
---|---|---|---|---|
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 | |
responded_time_display_value | DT_WSTR | 210 | False | |
responded_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 | |
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 | |
created_time_display_value | DT_WSTR | 210 | False | |
created_time | DT_DBTIMESTAMP | 0 | False | |
last_updated_time_display_value | DT_WSTR | 210 | False | |
last_updated_time | DT_DBTIMESTAMP | 0 | 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 |
Input Columns
Label | DataType | Length | Raw | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |