Table __DynamicRequest__
Description
This is a generic table. Use this to support Bulk read / write. You can supply Dynamic URL
Supported Operations
Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.| Method | Supported | Reference EndPoint |
|---|---|---|
| SELECT | generic_request | |
| INSERT | generic_request_bulk_write | |
| UPDATE | generic_request_bulk_write | |
| UPSERT | ||
| DELETE | ||
| LOOKUP |
Examples
SSIS
Use OData Connector in API Source component to read data or in API Destination component to read/write data:
Read from Generic Table (Bulk Read / Write) table using API Source
API Source - OData
OData Connector can be used to integrated any REST API which supports OData Standard. You can view tables, read data from tables using this connector. It also comes with some example OData Services to get started.
OData
Generic Table (Bulk Read / Write)
| Required Parameters | |
|---|---|
| Url | Fill-in the parameter... |
| Request Method | Fill-in the parameter... |
| Optional Parameters | |
| Body | |
| IsMultiPart | |
| Filter | |
| ExcludedProperties | |
| Encoding | |
| CharacterSet | |
| EnableCustomReplace | |
| SearchFor | |
| ReplaceWith | |
| JSON - Flatten Small Array (Not preferred for more than 10 items) | |
| JSON - Max Array Items To Flatten | 10 |
| JSON - Array Transform Type | |
| JSON - Array Transform Column Name Filter | |
| JSON - Array Transform Row Value Filter | |
| JSON - Array Transform Enable Custom Columns | |
| EnablePivot | |
| FileCompressionType | |
| DateFormatString | |
| Request Format (Content-Type) | ApplicationJson |
| Response Format | Default |
| Headers | Accept: */* || Cache-Control: no-cache |
| Pagination - Mode | |
| Pagination - Attribute Name | |
| Pagination - Increment By | 1 |
| Pagination - Expression for Next URL | |
| Pagination - Wait time after each request | 0 |
| Csv - Column Delimiter | , |
| Csv - Has Header Row | True |
| Xml - ElementsToTreatAsArray | |
Read/write to Generic Table (Bulk Read / Write) table using API Destination
API Destination - OData
OData Connector can be used to integrated any REST API which supports OData Standard. You can view tables, read data from tables using this connector. It also comes with some example OData Services to get started.
OData
Generic Table (Bulk Read / Write)
Select
| Required Parameters | |
|---|---|
| Url | Fill-in the parameter... |
| Request Method | Fill-in the parameter... |
| Optional Parameters | |
| Body | |
| IsMultiPart | |
| Filter | |
| ExcludedProperties | |
| Encoding | |
| CharacterSet | |
| EnableCustomReplace | |
| SearchFor | |
| ReplaceWith | |
| JSON - Flatten Small Array (Not preferred for more than 10 items) | |
| JSON - Max Array Items To Flatten | 10 |
| JSON - Array Transform Type | |
| JSON - Array Transform Column Name Filter | |
| JSON - Array Transform Row Value Filter | |
| JSON - Array Transform Enable Custom Columns | |
| EnablePivot | |
| FileCompressionType | |
| DateFormatString | |
| Request Format (Content-Type) | ApplicationJson |
| Response Format | Default |
| Headers | Accept: */* || Cache-Control: no-cache |
| Pagination - Mode | |
| Pagination - Attribute Name | |
| Pagination - Increment By | 1 |
| Pagination - Expression for Next URL | |
| Pagination - Wait time after each request | 0 |
| Csv - Column Delimiter | , |
| Csv - Has Header Row | True |
| Xml - ElementsToTreatAsArray | |
ODBC application
Use these SQL queries in your ODBC application data source:
Get __DynamicRequest__
SELECT * FROM __DynamicRequest__SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get __DynamicRequest__
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM __DynamicRequest__';
EXEC (@MyQuery) AT [LS_TO_ODATA_IN_GATEWAY];