EndPoint Get Projects

Contents

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

Name

get_projects

Description

No description available

Parameters

Parameter	Label	Required	Options	Description
There are no parameters

Output Columns

Label	DataType	Length	Raw
id	DT_WSTR	100	False
title	DT_WSTR	200	False
project_template_name	DT_WSTR	50	False
project_template_id	DT_WSTR	100	False
project_template_title	DT_WSTR	50	False
project_template_active	DT_BOOL	0	False
display_id_display_value	DT_WSTR	50	False
display_id_value	DT_WSTR	50	False
percentage_completion	DT_WSTR	50	False
description	DT_WSTR	2000	False
actual_hours	DT_WSTR	50	False
actual_end_time_display_value	DT_WSTR	100	False
actual_end_time	DT_DBTIMESTAMP	0	False
actual_start_time_display_value	DT_WSTR	100	False
actual_start_time	DT_DBTIMESTAMP	0	False
department_name	DT_WSTR	100	False
department_id	DT_WSTR	100	False
owner_email_id	DT_WSTR	100	False
owner_is_technician	DT_BOOL	0	False
owner_sms_mail	DT_WSTR	100	False
owner_phone	DT_WSTR	50	False
owner_name	DT_WSTR	50	False
owner_mobile	DT_WSTR	50	False
owner_id	DT_WSTR	100	False
owner_photo_url	DT_WSTR	100	False
owner_is_vip_user	DT_BOOL	0	False
owner_department	DT_WSTR	1020	False
project_type_color	DT_WSTR	50	False
project_type_name	DT_WSTR	50	False
project_type_id	DT_WSTR	100	False
project_code	DT_WSTR	100	False
priority_color	DT_WSTR	50	False
priority_name	DT_WSTR	50	False
priority_id	DT_WSTR	100	False
scheduled_end_time_display_value	DT_WSTR	100	False
scheduled_end_time	DT_DBTIMESTAMP	0	False
site_deleted	DT_BOOL	0	False
site_name	DT_WSTR	50	False
site_id	DT_WSTR	100	False
actual_cost	DT_WSTR	50	False
estimated_cost	DT_WSTR	50	False
project_requester_email_id	DT_WSTR	100	False
project_requester_is_technician	DT_BOOL	0	False
project_requester_sms_mail	DT_WSTR	100	False
project_requester_phone	DT_WSTR	50	False
project_requester_name	DT_WSTR	50	False
project_requester_mobile	DT_WSTR	50	False
project_requester_id	DT_WSTR	100	False
project_requester_photo_url	DT_WSTR	100	False
project_requester_is_vip_user	DT_BOOL	0	False
estimated_hours	DT_WSTR	50	False
udf_fields_udf_long1	DT_WSTR	100	False
udf_fields_udf_date1_display_value	DT_WSTR	100	False
udf_fields_udf_date1_value	DT_WSTR	100	False
udf_fields_udf_char1	DT_WSTR	100	False
projected_end_display_value	DT_WSTR	100	False
projected_end_value	DT_WSTR	100	False
scheduled_start_time_display_value	DT_WSTR	100	False
scheduled_start_time	DT_DBTIMESTAMP	0	False
status_internal_name	DT_WSTR	50	False
status_color	DT_WSTR	50	False
status_name	DT_WSTR	50	False
status_id	DT_WSTR	100	False
created_time_display_value	DT_WSTR	210	False
created_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.