EndPoint Get Table Columns

Contents

Name

get_table_columns

Get a list of columns of a table [API reference]

Parameter	Label	Required	Options	Description
TableName	TableName	YES		Table name

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
name	`DT_WSTR`	`nvarchar(128)`	128	False
element	`DT_WSTR`	`nvarchar(128)`	128	False
label	`DT_WSTR`	`nvarchar(96)`	96	False
internal_type	`DT_WSTR`	`nvarchar(128)`	128	False
max_length	`DT_I8`	`bigint`		False
column_type	`DT_WSTR`	`nvarchar(128)`	128	False
type	`DT_WSTR`	`nvarchar(60)`	60	False
filterable	`DT_BOOL`	`bit`		False
reference_display_field	`DT_WSTR`	`nvarchar(60)`	60	False
reference_attributes_display_field	`DT_WSTR`	`nvarchar(60)`	60	False
reference_attributes_ref_ac_columns	`DT_WSTR`	`nvarchar(108)`	108	False
reference_attributes_ref_ac_columns_search	`DT_WSTR`	`nvarchar(80)`	80	False
reference_attributes_ref_ac_display_value	`DT_BOOL`	`bit`		False
reference_attributes_ref_auto_completer	`DT_WSTR`	`nvarchar(80)`	80	False
canmatch	`DT_BOOL`	`bit`		False
cangroup	`DT_BOOL`	`bit`		False
max_unit	`DT_WSTR`	`nvarchar(80)`	80	False
mandatory	`DT_BOOL`	`bit`		False
reference	`DT_WSTR`	`nvarchar(100)`	100	False
default	`DT_WSTR`	`nvarchar(255)`	255	False
base_type	`DT_WSTR`	`nvarchar(32)`	32	False
read_only	`DT_BOOL`	`bit`		False
hint	`DT_WSTR`	`nvarchar(388)`	388	False
attributes	`DT_WSTR`	`nvarchar(4000)`	4000	False
cansort	`DT_BOOL`	`bit`		False
multitext	`DT_BOOL`	`bit`		False
choice_type	`DT_I8`	`bigint`		False
choices	`DT_NTEXT`	`nvarchar(MAX)`		False

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.