Amazon MWS Connector
Documentation
Version: 2
Documentation
Amazon's MWS (Marketplace Web Service) is being deprecated and replaced by the newer AWS Selling Partner API (SP-API). For a more robust and secure integration, we recommend using our AWS Selling Partner (SP-API) Connector. As Amazon is phasing out MWS functionality and eventually plans to fully deprecate it.
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 Label Required Options Description
ReportType 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_
StartDate StartDate NO Report Start date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z).
EndDate EndDate NO Report End date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z).
ReportOptions ReportOptions NO
Option Value
Return Custom Report custom=true
Version Version NO
MarketplaceIdList MarketplaceIdList NO
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 Raw 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 Raw 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 component to read data or in API Destination component to read/write data:

Get XML Report (Live) using API Source

Amazon MWS
Get XML Report (Live)
SSIS API Source - Read from table or endpoint

Get XML Report (Live) using API Destination

Amazon MWS
Get XML Report (Live)
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];