Reference

Endpoint Generic Read Data (JSON API)

Name

read_data_json

No description available

Parameter

Required

Options

Name: TableName

Label: TableName

Read data from specified module (Json Format API)

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

Generic Read Data (JSON API)

Optional Parameters
TableName

API Destination - OData

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

OData

Generic Read Data (JSON API)

Optional Parameters
TableName

Use these SQL queries in your ODBC application data source:

SELECT * FROM read_data_json

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

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

EXEC (@MyQuery) AT [LS_TO_ODATA_IN_GATEWAY];