Reference

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 reference]

Parameters

Parameter Required Options
Name: PagingRowCount

Label: Page Size (Default=2000, Max=10000)

Max can be 10000 but it may decrease performance if you fetching less than 10K rows in some requests. 		YES
Name: SysId

Label: SysId
Name: Query

Label: Query
Option Value
Filter by active status active=true
Order By name column ORDERBYname
Order By name column (Descending) ORDERBYDESCname
Order By Multiple Fields (ASC + DESC) ORDERBYcolumn1^ORDERBYDESCcolumn2
Name: Fields

Label: Fields

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
sys_id DT_WSTR nvarchar(500) 500
name DT_WSTR nvarchar(500) 500
label DT_WSTR nvarchar(500) 500
sys_name DT_WSTR nvarchar(500) 500
create_access DT_WSTR nvarchar(50) 50
alter_access DT_WSTR nvarchar(50) 50
access DT_WSTR nvarchar(500) 500
live_feed_enabled DT_WSTR nvarchar(50) 50
sys_updated_on DT_DBTIMESTAMP datetime
sys_class_name DT_WSTR nvarchar(500) 500
is_extendable DT_WSTR nvarchar(50) 50
user_role DT_WSTR nvarchar(500) 500
create_access_controls DT_WSTR nvarchar(50) 50
delete_access DT_WSTR nvarchar(50) 50
sys_updated_by DT_WSTR nvarchar(100) 100
sys_class_path DT_WSTR nvarchar(500) 500
sys_created_on DT_DBTIMESTAMP datetime
caller_access DT_WSTR nvarchar(500) 500
client_scripts_access DT_WSTR nvarchar(50) 50
extension_model DT_WSTR nvarchar(500) 500
actions_access DT_WSTR nvarchar(50) 50
sys_scope_link DT_WSTR nvarchar(1000) 1000
sys_scope_value DT_WSTR nvarchar(500) 500
sys_created_by DT_WSTR nvarchar(100) 100
sys_class_code DT_WSTR nvarchar(500) 500
read_access DT_WSTR nvarchar(50) 50
super_class DT_WSTR nvarchar(500) 500
sys_mod_count DT_WSTR nvarchar(50) 50
ws_access DT_WSTR nvarchar(50) 50
update_access DT_WSTR nvarchar(50) 50
sys_package_link DT_WSTR nvarchar(1000) 1000
sys_package_value DT_WSTR nvarchar(500) 500
sys_update_name DT_WSTR nvarchar(500) 500
scriptable_table DT_WSTR nvarchar(50) 50
configuration_access DT_WSTR nvarchar(50) 50
number_ref DT_WSTR nvarchar(500) 500
sys_policy DT_WSTR nvarchar(500) 500
sys_scope DT_WSTR nvarchar(500) 500
sys_package DT_WSTR nvarchar(500) 500
super_class_link DT_WSTR nvarchar(1000) 1000
super_class_value DT_WSTR nvarchar(500) 500
number_ref_link DT_WSTR nvarchar(1000) 1000
number_ref_value DT_WSTR nvarchar(500) 500
user_role_link DT_WSTR nvarchar(1000) 1000
user_role_value DT_WSTR nvarchar(500) 500
If the column you are looking for is missing, consider customizing ServiceNow Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use ServiceNow Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - ServiceNow
Allows the reading and writing of incidents, attachments, and more in ServiceNow without coding! The ZappySys ServiceNow API Connector provides easy-to-use, high-performance API access.
ServiceNow
Get List Of Tables Admin Use Sys Db Object
Optional Parameters
SysId
Query ORDERBYname
Fields
SSIS API Source - Read from table or endpoint

API Destination

API Destination - ServiceNow
Allows the reading and writing of incidents, attachments, and more in ServiceNow without coding! The ZappySys ServiceNow API Connector provides easy-to-use, high-performance API access.
ServiceNow
Get List Of Tables Admin Use Sys Db Object
Optional Parameters
SysId
Query ORDERBYname
Fields
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get list of tables admin use sys db object 

SELECT * FROM get_tables_admin

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get list of tables admin use sys db object 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_tables_admin';

EXEC (@MyQuery) AT [LS_TO_SERVICENOW_IN_GATEWAY];