Reference

Endpoint Get XML Report (Live)

Name

RequestReportXml

Description

Returns data from XML Reports listed here http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html

Parameters

Parameter Required Options
Name: ReportType

Label: ReportType

 YES
Option Value
Order: Scheduled XML Order Report _GET_ORDERS_DATA_
Order Tracking: XML Orders By Last Update Report _GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_
Order Tracking: XML Orders By Order Date Report _GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_
Pending Order: XML Pending Orders Report _GET_PENDING_ORDERS_DATA_
Returns: XML Returns Report by Return Date _GET_XML_RETURNS_DATA_BY_RETURN_DATE_
Returns: XML Prime Returns Report by Return Date _GET_XML_MFN_PRIME_RETURNS_REPORT_
Returns: XML Return Attributes Report by Return Date _GET_XML_MFN_SKU_RETURN_ATTRIBUTES_REPORT_
Performance: XML Customer Metrics Report _GET_V1_SELLER_PERFORMANCE_REPORT_
Settlement: XML Settlement Report _GET_V2_SETTLEMENT_REPORT_DATA_XML_
Browse Tree: Browse Tree Report _GET_XML_BROWSE_TREE_DATA_
Name: StartDate

Label: StartDate

Report Start date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z).
Name: EndDate

Label: EndDate

Report End date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z).
Name: ReportOptions

Label: ReportOptions
Option Value
Return Custom Report custom=true
Name: Version

Label: Version
Name: MarketplaceIdList

Label: MarketplaceIdList
Option Value
US ATVPDKIKX0DER
Brazil A2Q3Y263D00KWC
Canada A2EUQ1WTGCTBG2
Mexico A1AM78C64UM0Y8
United Arab Emirates (U.A.E.) A2VIGQ35RCS4UG
Germany A1PA6795UKMFR9
Egypt ARBP9OOSHTCHU
Spain A1RKKUPIHCS9HS
France A13V1IB3VIYZZH
UK A1F83G8C2ARO7P
India A21TJRUUN4KGV
Italy APJ6JRA9NG5V4
Netherlands A1805IZSGTT6HS
Saudi Arabia A17E79C6D8DWNP
Turkey A33AVAJ2PDY3EV
Singapore A19VAU5U5O7RUS
Australia A39IBJ37TRP1C6
Japan A1VC38T7YXB528

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 XML Report (Live)
Required Parameters
ReportType Fill-in the parameter...
Optional Parameters
StartDate
EndDate
ReportOptions
Version 2009-01-01
DateParseHandling DateTime
SSIS API Source - Read from table or endpoint

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 XML Report (Live)
Required Parameters
ReportType Fill-in the parameter...
Optional Parameters
StartDate
EndDate
ReportOptions
Version 2009-01-01
DateParseHandling DateTime
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get xml report 

SELECT * FROM RequestReportXml
WITH
(
    "ReportType" = 'abcd-1234-reporttype'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get xml report 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM RequestReportXml
WITH
(
    "ReportType" = ''abcd-1234-reporttype''
)';

EXEC (@MyQuery) AT [LS_TO_AMAZON_MWS_IN_GATEWAY];