EndPoint Download Report File to Local Disk
Parameters
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Report |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
| Status |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
| TargetFilePath |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
| StatusCode |
DT_I4
|
int
|
False |
||
| ContentType |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
| ContentLength |
DT_I4
|
int
|
False |
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Amazon Selling Partner (SP-API) Connector in API Source component to read data or in API Destination component to read/write data:
Download Report File to Local Disk using API Source
Amazon Selling Partner (SP-API)
Download Report File to Local Disk
Download Report File to Local Disk using API Destination
Amazon Selling Partner (SP-API)
Download Report File to Local Disk
ODBC application
Use these SQL queries in your ODBC application data source:
Download Report to Local Disk
This example shows how to run a report and download data to local disk file. You can save any file format report by calling this endpoint.
SELECT * FROM download_report
WITH(
ReportType='GET_XML_BROWSE_TREE_DATA'
, TargetFilePath='c:\temp\GET_XML_BROWSE_TREE_DATA.gz'
, MarketplaceIds='ATVPDKIKX0DER'
--, FileOverwriteMode='FailIfExists' (Default is 'AlwaysOverwrite')
--, StartDate='2012-12-31'
--, EndDate='today-1d'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Download Report to Local Disk
This example shows how to run a report and download data to local disk file. You can save any file format report by calling this endpoint.
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM download_report
WITH(
ReportType=''GET_XML_BROWSE_TREE_DATA''
, TargetFilePath=''c:\temp\GET_XML_BROWSE_TREE_DATA.gz''
, MarketplaceIds=''ATVPDKIKX0DER''
--, FileOverwriteMode=''FailIfExists'' (Default is ''AlwaysOverwrite'')
--, StartDate=''2012-12-31''
--, EndDate=''today-1d''
)';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_AMAZON_SELLING_PARTNER_SP_API_IN_DATA_GATEWAY];