EndPoint Get Assets

Contents

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

Name

get_assets

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
name	`DT_WSTR`	`nvarchar(200)`	200	False
loan_start_time_display_value	`DT_WSTR`	`nvarchar(100)`	100	False
loan_start_time	`DT_DBTIMESTAMP`	`datetime`		False
loan_id	`DT_WSTR`	`nvarchar(100)`	100	False
loan_returned_time_display_value	`DT_WSTR`	`nvarchar(100)`	100	False
loan_returned_time	`DT_DBTIMESTAMP`	`datetime`		False
loan_barcode	`DT_WSTR`	`nvarchar(50)`	50	False
loan_due_by_time_display_value	`DT_WSTR`	`nvarchar(100)`	100	False
loan_due_by_time	`DT_DBTIMESTAMP`	`datetime`		False
loan_loan_id_display_value	`DT_WSTR`	`nvarchar(50)`	50	False
loan_loan_id_value	`DT_WSTR`	`nvarchar(50)`	50	False
retain_user_site	`DT_BOOL`	`bit`		False
type_name	`DT_WSTR`	`nvarchar(50)`	50	False
type_id	`DT_WSTR`	`nvarchar(100)`	100	False
purchase_cost	`DT_R8`	`float`		False
state_name	`DT_WSTR`	`nvarchar(50)`	50	False
state_description	`DT_WSTR`	`nvarchar(100)`	100	False
state_id	`DT_WSTR`	`nvarchar(100)`	100	False
barcode	`DT_WSTR`	`nvarchar(50)`	50	False
product_part_no	`DT_WSTR`	`nvarchar(50)`	50	False
product_name	`DT_WSTR`	`nvarchar(50)`	50	False
product_id	`DT_WSTR`	`nvarchar(100)`	100	False
product_manufacturer	`DT_WSTR`	`nvarchar(100)`	100	False
site_deleted	`DT_BOOL`	`bit`		False
site_name	`DT_WSTR`	`nvarchar(50)`	50	False
site_id	`DT_WSTR`	`nvarchar(100)`	100	False
product_type_image	`DT_WSTR`	`nvarchar(50)`	50	False
product_type_name	`DT_WSTR`	`nvarchar(50)`	50	False
product_type_id	`DT_WSTR`	`nvarchar(100)`	100	False
location	`DT_WSTR`	`nvarchar(100)`	100	False
is_loanable	`DT_BOOL`	`bit`		False
category_name	`DT_WSTR`	`nvarchar(50)`	50	False
category_description	`DT_WSTR`	`nvarchar(100)`	100	False
category_id	`DT_WSTR`	`nvarchar(100)`	100	False
state_history_comments	`DT_WSTR`	`nvarchar(2000)`	2000	False
last_updated_time_display_value	`DT_WSTR`	`nvarchar(210)`	210	False
last_updated_time	`DT_DBTIMESTAMP`	`datetime`		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.