Endpoint Get CSV Report By ID - Cached Copy (Previously Generated)
Name
GetReportCsv
Description
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: ReportId Enter Report ID returned by GetReportRequestList (With status of _DONE_ or _DONE_NO_DATA_) or GetReportList (only done reports) |
YES | |
|
Name:
Label: Version |
Output Columns
| 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 Amazon MWS Connector.
Input Columns
| 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Amazon MWS Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - Amazon MWS
Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.
Amazon MWS
Get CSV Report By ID - Cached Copy (Previously Generated)
| Required Parameters | |
|---|---|
| ReportId | Fill-in the parameter... |
| Optional Parameters | |
| ColumnDelimiter | {TAB} |
| ResponseCharset | Windows-1252 |
| Version | 2009-01-01 |
| DateParseHandling | DateTime |
API Destination
API Destination - Amazon MWS
Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.
Amazon MWS
Get CSV Report By ID - Cached Copy (Previously Generated)
| Required Parameters | |
|---|---|
| ReportId | Fill-in the parameter... |
| Optional Parameters | |
| ColumnDelimiter | {TAB} |
| ResponseCharset | Windows-1252 |
| Version | 2009-01-01 |
| DateParseHandling | DateTime |
ODBC application
Use these SQL queries in your ODBC application data source:
Get csv report by id - cached copy
SELECT * FROM GetReportCsv
WITH
(
"ReportId" = 'abcd-1234-reportid'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get csv report by id - cached copy
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM GetReportCsv
WITH
(
"ReportId" = ''abcd-1234-reportid''
)';
EXEC (@MyQuery) AT [LS_TO_AMAZON_MWS_IN_GATEWAY];