xls.objects
The xls.objects table allows configuring the following features:
- Saving changes
- Merging data
- Defining objects based on SQL codes
- Defining objects based on HTTP commands
- Defining objects based on text file queries
- Hiding objects from users
The table has the following structure:
| ID | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | TABLE_CODE | INSERT_OBJECT | UPDATE_OBJECT | DELETE_OBJECT |
|---|---|---|---|---|---|---|---|
The table has two logical parts.
The left part is used to specify configured objects.
| ID | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | TABLE_CODE |
|---|---|---|---|---|
| <schema> | <table name> | TABLE | ||
| <schema> | <view name> | VIEW | ||
| <schema> | <procedure name> | PROCEDURE | ||
| <schema> | <new name> | CODE | <SQL> | |
| <schema> | <new name> | HTTP | <HTTP Command> | |
| <schema> | <new name> | TEXT | <Text file query> | |
| <schema> | <object name> | HIDDEN |
Objects defined using SQL codes, HTTP commands, or text file queries have nearly the same features as native database objects.
See additional details:
- Getting Data from Tables and Views
- Getting Data from Stored Procedures
- Getting Data Using SQL Queries
- Getting Data Using OData
- Getting Data Using REST API
- Getting Data from the Web
- Getting Data from Text Files
The right part is used to configure saving changes and merging data.
Below are available options:
| INSERT_OBJECT | UPDATE_OBJECT | DELETE_OBJECT |
|---|---|---|
| <schema>.<table name> | <schema>.<table name> | <schema>.<table name> |
| <schema>.<view name> | <schema>.<view name> | <schema>.<view name> |
| <schema>.<procedure name> | <schema>.<procedure name> | <schema>.<procedure name> |
| <schema>.<procedure name> | ||
| <SQL> | <SQL> | <SQL> |
| <SQL> | ||
| <schema>.<table name> | ||
| <schema>.<view name> | ||
| <schema>.<procedure name> | ||
| <SQL> | ||
| <HTTP Command> | <HTTP Command> | <HTTP Command> |
See additional notes: