ServiceNow Connector
Documentation
Version: 1
Documentation

EndPoint Get List of Tables - Admin (Use sys_db_object)


Name

get_tables_admin

Description

Get a list of tables by quering sys_db_object. To read data from this object make sure user has read permission to this table. [API Help]

Parameters

Parameter Label Required Options Description
SysId SysId NO
Query Query NO
Fields Fields NO
PagingRowCount PagingRowCount YES

Output Columns

Label DataType Length Raw Description
sys_id DT_WSTR 500 False
name DT_WSTR 500 False
label DT_WSTR 500 False
sys_name DT_WSTR 500 False
create_access DT_WSTR 50 False
alter_access DT_WSTR 50 False
access DT_WSTR 500 False
live_feed_enabled DT_WSTR 50 False
sys_updated_on DT_DBTIMESTAMP 0 False
sys_class_name DT_WSTR 500 False
is_extendable DT_WSTR 50 False
user_role DT_WSTR 500 False
create_access_controls DT_WSTR 50 False
delete_access DT_WSTR 50 False
sys_updated_by DT_WSTR 100 False
sys_class_path DT_WSTR 500 False
sys_created_on DT_DBTIMESTAMP 0 False
caller_access DT_WSTR 500 False
client_scripts_access DT_WSTR 50 False
extension_model DT_WSTR 500 False
actions_access DT_WSTR 50 False
sys_scope_link DT_WSTR 1000 False
sys_scope_value DT_WSTR 500 False
sys_created_by DT_WSTR 100 False
sys_class_code DT_WSTR 500 False
read_access DT_WSTR 50 False
super_class DT_WSTR 500 False
sys_mod_count DT_WSTR 50 False
ws_access DT_WSTR 50 False
update_access DT_WSTR 50 False
sys_package_link DT_WSTR 1000 False
sys_package_value DT_WSTR 500 False
sys_update_name DT_WSTR 500 False
scriptable_table DT_WSTR 50 False
configuration_access DT_WSTR 50 False
number_ref DT_WSTR 500 False
sys_policy DT_WSTR 500 False
sys_scope DT_WSTR 500 False
sys_package DT_WSTR 500 False
super_class_link DT_WSTR 1000 False
super_class_value DT_WSTR 500 False
number_ref_link DT_WSTR 1000 False
number_ref_value DT_WSTR 500 False
user_role_link DT_WSTR 1000 False
user_role_value DT_WSTR 500 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.