ServiceNow Connector Help

Version: 1

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.