Reference

Endpoint List Tables

Name

get_metadata_tables

No description available

Parameter	Required	Options
There are no parameters

Label	Data Type (SSIS)	Data Type (SQL)	Length
EntityName	`DT_WSTR`	`nvarchar(500)`	500
KeyPropertyName	`DT_WSTR`	`nvarchar(100)`	100
Property	`DT_NTEXT`	`nvarchar(MAX)`
NavigationPropertyName	`DT_WSTR`	`nvarchar(50)`	50
NavigationRelationship	`DT_WSTR`	`nvarchar(500)`	500
NavigationToRole	`DT_WSTR`	`nvarchar(50)`	50
NavigationFromRole	`DT_WSTR`	`nvarchar(100)`	100
Navigation	`DT_WSTR`	`nvarchar(4000)`	4000
KeyProperty	`DT_WSTR`	`nvarchar(1364)`	1364
DataServiceVersion	`DT_R8`	`float`
MaxDataServiceVersion	`DT_R8`	`float`
Version	`DT_R8`	`float`

If the column you are looking for is missing, consider customizing OData Connector.

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.

Use OData Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source - OData

Read and write OData API data effortlessly. Query, integrate, and manage entities and feeds — almost no coding required.

OData

List Tables

Optional Parameters
MetaDetectionOrder	Dynamic

API Destination - OData

Read and write OData API data effortlessly. Query, integrate, and manage entities and feeds — almost no coding required.

OData

List Tables

Optional Parameters
MetaDetectionOrder	Dynamic

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_metadata_tables

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_metadata_tables';

EXEC (@MyQuery) AT [LS_TO_ODATA_IN_GATEWAY];