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 / Order By (Server Side Filter)

Server-side encoded query for filtering and ordering records. Supports string, numeric, date, NULL checks, AND/OR logic, and ORDER BY clauses.
Option Value
Equals (String) name=Test
Equals (Number) priority=1
Not Equal state!=closed
AND Condition state=active^priority=1
OR Condition state=active^ORstate=pending
IN List stateINactive,pending,closed
NOT IN List stateNOT INactive,closed
Starts With nameSTARTSWITHTest
Ends With nameENDSWITH001
Contains (LIKE) short_descriptionLIKEerror
Does Not Contain short_descriptionNOT LIKEpassword
Greater Than (Number) priority>2
Less Than (Number) priority<4
Between Numbers priority>=2^priority<=4
Is Empty assigned_toISEMPTY
Is Not Empty assigned_toISNOTEMPTY
Created After Date sys_created_on>=2026-01-01
Created Before Date sys_created_on<=2026-01-31 23:59:59
Created Today sys_created_on>=<>^sys_created_on<=<>
Updated Last 2 Days sys_updated_on>=<>
Multiple Conditions Mixed state=active^priority>1^short_descriptionLIKEerror
Order By Column ORDERBYname
Order By Column Desc ORDERBYDESCsys_created_on
Order By Multiple Columns ORDERBYpriority^ORDERBYDESCsys_created_on
Filter + Order state=active^ORDERBYsys_updated_on
Name: Fields

Label: Fields
Name: PagingOffset

Label: PagingOffset

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
Read and write ServiceNow data effortlessly. Integrate, manage, and automate incidents, tasks, attachments, and records — almost no coding required.
ServiceNow
Get List Of Tables Admin Use Sys Db Object
Optional Parameters
SysId
Query / Order By (Server Side Filter)
Fields
SSIS API Source - Read from table or endpoint

API Destination

API Destination - ServiceNow
Read and write ServiceNow data effortlessly. Integrate, manage, and automate incidents, tasks, attachments, and records — almost no coding required.
ServiceNow
Get List Of Tables Admin Use Sys Db Object
Optional Parameters
SysId
Query / Order By (Server Side Filter)
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];