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 Google Search Console 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 - Google Search Console
Read Google Search Console report (Organic Traffic) about site performance, ranking, clicks, ctr and impressions by date, page, country, query, country, device and searchAppearance.
Google Search Console
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 - Google Search Console
Read Google Search Console report (Organic Traffic) about site performance, ranking, clicks, ctr and impressions by date, page, country, query, country, device and searchAppearance.
Google Search Console
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_GOOGLE_SEARCH_CONSOLE_IN_GATEWAY];