Amazon MWS Connector
The high-performance Amazon MWS Connector provides read/write capabilities within your application, allowing you to perform numerous Amazon MWS operations with minimal coding or even no-coding at all. Integrate Amazon MWS data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.
Download for SSIS Download for SQL Server and ODBC Documentation
Integrate Amazon MWS with these applications
Actions supported by Amazon MWS Connector
Amazon MWS Connector supports following actions for REST API integration:
Get CSV Report By ID - Cached Copy (Previously Generated)
Description
Not available.
Parameters
You can provide the following parameters to this action:
-
ReportId
-
Version
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Get FlatFile Report (Live)
Description
Returns data from FlatFile Reports (TSV - Tab Seperated Values) listed here http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html. Depending which Report you choose, it can take upto 30 minutes to generate report. To get data from previously generated report, you can use [Get CSV Report By ID - Cached Copy] endpoint to fetch data by GeneratedReportId.
Parameters
You can provide the following parameters to this action:
-
ReportType
-
StartDate
-
EndDate
-
ReportOptions
-
Version
-
MarketplaceIdList
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Get Report Count
Description
Returns a count of the reports, created in the previous 90 days, with a status of _DONE_ and that are available for download.
Parameters
You can provide the following parameters to this action:
-
AmazonOrderId
-
ReportTypeList
-
Acknowledged
-
AvailableFromDate
-
AvailableToDate
-
Version
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Get Report List (Successful Only)
Description
Returns a list of reports that were created in the previous 90 days.
Parameters
You can provide the following parameters to this action:
-
ReportTypeList
-
Acknowledged
-
AvailableFromDate
-
AvailableToDate
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
ReportId
-
ReportType
-
Acknowledged
-
ReportRequestId
-
AvailableDate
Visit documentation for more information.
Get Report Requests
Description
Returns a list of report requests that you can use to get the ReportRequestId for a report.
Parameters
You can provide the following parameters to this action:
-
Version
-
ReportTypeList
-
MaxCount
-
ReportStatus
-
RequestedFromDate
-
RequestedToDate
-
ReportRequestId
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
ReportRequestId
-
ReportType
-
Acknowledged
-
GeneratedReportId
-
StartDate
-
EndDate
-
ReportProcessingStatus
-
SubmittedDate
-
StartedProcessingDate
-
CompletedDate
Visit documentation for more information.
Get XML Report (Live)
Description
Returns data from XML Reports listed here http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html.
Parameters
You can provide the following parameters to this action:
-
ReportType
-
StartDate
-
EndDate
-
ReportOptions
-
Version
-
MarketplaceIdList
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Get XML Report By ID - Cached Copy (Previously Generated)
Description
Not available.
Parameters
You can provide the following parameters to this action:
-
ReportId
-
Version
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Orders: Get Single Order Information
Description
The GetOrder operation returns an order for each AmazonOrderId that you specify, up to a maximum of 50. The GetOrder operation includes order information for each order returned, including PurchaseDate, OrderStatus, FulfillmentChannel, and LastUpdateDate.
Parameters
You can provide the following parameters to this action:
-
AmazonOrderIdList
-
Version
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
AmazonOrderId
-
PurchaseDate
-
LatestShipDate
-
OrderType
-
BuyerEmail
-
LastUpdateDate
-
IsReplacementOrder
-
NumberOfItemsShipped
-
ShipServiceLevel
-
OrderStatus
-
SalesChannel
-
IsBusinessOrder
-
NumberOfItemsUnshipped
-
PaymentMethodDetails_PaymentMethodDetail
-
IsGlobalExpressEnabled
-
IsSoldByAB
-
BuyerName
-
IsPremiumOrder
-
OrderTotal_Amount
-
OrderTotal_CurrencyCode
-
EarliestShipDate
-
MarketplaceId
-
FulfillmentChannel
-
PaymentMethod
-
ShippingAddress_City
-
ShippingAddress_PostalCode
-
ShippingAddress_isAddressSharingConfidential
-
ShippingAddress_StateOrRegion
-
ShippingAddress_CountryCode
-
ShippingAddress_Name
-
ShippingAddress_AddressLine1
-
IsPrime
-
SellerOrderId
-
ShipmentServiceLevelCategory
Visit documentation for more information.
Orders: Read Order Items
Description
The ListOrderItems operation returns order item information for an AmazonOrderId that you specify. The order item information includes Title, ASIN, SellerSKU, ItemPrice, ShippingPrice, as well as tax and promotion information.
Parameters
You can provide the following parameters to this action:
-
AmazonOrderId
-
Version
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
TaxCollection_ResponsibleParty
-
TaxCollection_Model
-
QuantityOrdered
-
Title
-
PromotionDiscount_Amount
-
PromotionDiscount_CurrencyCode
-
IsGift
-
ASIN
-
SellerSKU
-
OrderItemId
-
IsTransparency
-
ProductInfo_NumberOfItems
-
QuantityShipped
-
ItemPrice_Amount
-
ItemPrice_CurrencyCode
-
ItemTax_Amount
-
ItemTax_CurrencyCode
-
PromotionDiscountTax_Amount
-
PromotionDiscountTax_CurrencyCode
Visit documentation for more information.
Orders: Read Orders
Description
The ListOrders operation returns a list of orders created or updated during a time frame that you specify. You define that time frame using the CreatedAfter parameter or the LastUpdatedAfter parameter. You must use one of these parameters, but not both. You can also apply a range of filtering criteria to narrow the list of orders that is returned. The ListOrders operation includes order information for each order returned, including AmazonOrderId, OrderStatus, FulfillmentChannel, and LastUpdateDate.
Parameters
You can provide the following parameters to this action:
-
MarketplaceIdList
-
CreatedAfter
-
CreatedBefore
-
LastUpdatedAfter
-
LastUpdatedBefore
-
OrderStatus
-
FulfillmentChannel
-
PaymentMethod
-
BuyerEmail
-
SellerOrderId
-
EasyShipShipmentStatus
-
Version
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
AmazonOrderId
-
OrderTotal_Amount
-
OrderTotal_CurrencyCode
-
BuyerName
-
OrderStatus
-
OrderType
-
PurchaseDate
-
LatestShipDate
-
PaymentMethod
-
ShippingAddress_City
-
ShippingAddress_PostalCode
-
ShippingAddress_isAddressSharingConfidential
-
ShippingAddress_StateOrRegion
-
ShippingAddress_CountryCode
-
ShippingAddress_Name
-
ShippingAddress_AddressLine1
-
ShippingAddress_AddressLine2
-
ShippingAddress_County
-
LastUpdateDate
-
IsReplacementOrder
-
NumberOfItemsShipped
-
ShipServiceLevel
-
SalesChannel
-
IsBusinessOrder
-
NumberOfItemsUnshipped
-
PaymentMethodDetails_PaymentMethodDetail
-
IsGlobalExpressEnabled
-
IsSoldByAB
-
IsPremiumOrder
-
EarliestShipDate
-
MarketplaceId
-
FulfillmentChannel
-
IsPrime
-
SellerOrderId
-
ShipmentServiceLevelCategory
-
BuyerEmail
Visit documentation for more information.
Make Generic API Request
Description
This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.
Parameters
You can provide the following parameters to this action:
-
Url
-
Body
-
IsMultiPart
-
Filter
-
Headers
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Make Generic API Request (Bulk Write)
Description
This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.
Parameters
You can provide the following parameters to this action:
-
Url
-
IsMultiPart
-
Filter
-
Headers
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.