EndPoint Get Table Columns
Name
get_table_columns
Description
Get a list of columns of a table
[API Help]
Parameters
Parameter |
Label |
Required |
Options |
Description |
TableName |
TableName |
YES |
|
Table name
|
Output Columns
Label |
DataType |
Length |
Raw |
Description |
name |
DT_WSTR |
128 |
False |
|
element |
DT_WSTR |
128 |
False |
|
label |
DT_WSTR |
96 |
False |
|
internal_type |
DT_WSTR |
128 |
False |
|
max_length |
DT_I8 |
0 |
False |
|
column_type |
DT_WSTR |
128 |
False |
|
type |
DT_WSTR |
60 |
False |
|
filterable |
DT_BOOL |
0 |
False |
|
reference_display_field |
DT_WSTR |
60 |
False |
|
reference_attributes_display_field |
DT_WSTR |
60 |
False |
|
reference_attributes_ref_ac_columns |
DT_WSTR |
108 |
False |
|
reference_attributes_ref_ac_columns_search |
DT_WSTR |
80 |
False |
|
reference_attributes_ref_ac_display_value |
DT_BOOL |
0 |
False |
|
reference_attributes_ref_auto_completer |
DT_WSTR |
80 |
False |
|
canmatch |
DT_BOOL |
0 |
False |
|
cangroup |
DT_BOOL |
0 |
False |
|
max_unit |
DT_WSTR |
80 |
False |
|
mandatory |
DT_BOOL |
0 |
False |
|
reference |
DT_WSTR |
100 |
False |
|
default |
DT_WSTR |
255 |
False |
|
base_type |
DT_WSTR |
32 |
False |
|
read_only |
DT_BOOL |
0 |
False |
|
hint |
DT_WSTR |
388 |
False |
|
attributes |
DT_WSTR |
4000 |
False |
|
cansort |
DT_BOOL |
0 |
False |
|
multitext |
DT_BOOL |
0 |
False |
|
choice_type |
DT_I8 |
0 |
False |
|
choices |
DT_NTEXT |
0 |
False |
|
Input Columns
Label |
DataType |
Length |
Raw |
Description |
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |