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. |