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