xls.objects
The xls.objects table enables configuration of the following features:
- Saving changes
- Merging data
- Defining objects using SQL codes
- Defining objects using HTTP commands
- Defining objects using text file queries
- Hiding objects from users
The table structure is as follows:
| ID | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | TABLE_CODE | INSERT_OBJECT | UPDATE_OBJECT | DELETE_OBJECT |
|---|---|---|---|---|---|---|---|
The table consists of two logical parts.
The left part specifies the 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 offer nearly the same capabilities as native database objects.
For more details, check out the following resources:
- 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 for configuring saving changes and merging data.
Here are the 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> |
For additional notes, refer to: