Reference

Endpoint List Tables (JSON API)

Name

list_tables_json

No description available

Parameter

Required

Options

Name: Format

Label: Format

Response format

Name: PageSize

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: SearchCriteria

Label: Search Criteria

Data filter (e.g. somecolumn -eq 'somevalue' )

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.

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 (JSON API)

There are no parameters to configure.

API Destination - OData

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

OData

List Tables (JSON API)

There are no parameters to configure.

Use these SQL queries in your ODBC application data source:

SELECT * FROM list_tables_json

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

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

EXEC (@MyQuery) AT [LS_TO_ODATA_IN_GATEWAY];