Endpoint List Tables (XML API)
Name
list_tables_xml
Description
Parameters
| Parameter | Required | Options | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Name:
Label: Format Response format |
||||||||||||||
|
Name:
Label: PageSize (Keep blank for default) Number which indicates max rows per response. Keep it blank to use API default vlaue. Read your API documentation to findout default value. |
||||||||||||||
|
Name:
Label: Search Criteria Data filter (e.g. somecolumn -eq 'somevalue' ) |
|
Output 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
If the column you are looking for is missing, consider customizing OData 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 OData Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - OData
Read and write OData API data effortlessly. Query, integrate, and manage entities and feeds — almost no coding required.
OData
List Tables (XML API)
| There are no parameters to configure. |
API Destination
API Destination - OData
Read and write OData API data effortlessly. Query, integrate, and manage entities and feeds — almost no coding required.
OData
List Tables (XML API)
| There are no parameters to configure. |
ODBC application
Use these SQL queries in your ODBC application data source:
Read all tables (XML format)
<p>Gets the list of available entity sets (tables) when the service exposes metadata in XML-based format. Use this to discover table names for your SELECT queries.</p>
SELECT * FROM list_tables_xmlSQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Read all tables (XML format)
<p>Gets the list of available entity sets (tables) when the service exposes metadata in XML-based format. Use this to discover table names for your SELECT queries.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_tables_xml';
EXEC (@MyQuery) AT [LS_TO_ODATA_IN_GATEWAY];