Amazon MWS Connector

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

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.

Integrate Amazon MWS with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC 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.

Download for SSIS Download for SQL Server and ODBC