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 OneDrive 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 - OneDrive
OneDrive Connector can be used to integrate OneDrive and your defined data source, e.g. Microsoft SQL, Oracle, Excel, Power BI, etc. Get, write, delete OneDrive data in a few clicks!
OneDrive
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 - OneDrive
OneDrive Connector can be used to integrate OneDrive and your defined data source, e.g. Microsoft SQL, Oracle, Excel, Power BI, etc. Get, write, delete OneDrive data in a few clicks!
OneDrive
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_ONEDRIVE_IN_GATEWAY];