Reference

Endpoint Orders: Get Single Order Information

Name

GetOrder

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. [API reference]

Parameters

Parameter Required Options
Name: AmazonOrderIdList

Label: AmazonOrderIdList

A list of AmazonOrderId values. An AmazonOrderId is an Amazon-defined order identifier, in 3-7-7 format. (Example: 058-1233752-8214740). 		YES
Name: Version

Label: Version

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
AmazonOrderId DT_WSTR nvarchar(76) 76
PurchaseDate DT_DBTIMESTAMP datetime
LatestShipDate DT_DBTIMESTAMP datetime
OrderType DT_WSTR nvarchar(52) 52
BuyerEmail DT_WSTR nvarchar(255) 255
LastUpdateDate DT_DBTIMESTAMP datetime
IsReplacementOrder DT_WSTR nvarchar(20) 20
NumberOfItemsShipped DT_I4 int
ShipServiceLevel DT_WSTR nvarchar(36) 36
OrderStatus DT_WSTR nvarchar(28) 28
SalesChannel DT_WSTR nvarchar(40) 40
IsBusinessOrder DT_WSTR nvarchar(20) 20
NumberOfItemsUnshipped DT_I4 int
PaymentMethodDetails_PaymentMethodDetail DT_WSTR nvarchar(32) 32
IsGlobalExpressEnabled DT_WSTR nvarchar(20) 20
IsSoldByAB DT_WSTR nvarchar(20) 20
BuyerName DT_WSTR nvarchar(52) 52
IsPremiumOrder DT_WSTR nvarchar(20) 20
OrderTotal_Amount DT_NUMERIC decimal(19,5)
OrderTotal_CurrencyCode DT_WSTR nvarchar(12) 12
EarliestShipDate DT_DBTIMESTAMP datetime
MarketplaceId DT_WSTR nvarchar(52) 52
FulfillmentChannel DT_WSTR nvarchar(12) 12
PaymentMethod DT_WSTR nvarchar(20) 20
ShippingAddress_City DT_WSTR nvarchar(255) 255
ShippingAddress_PostalCode DT_WSTR nvarchar(40) 40
ShippingAddress_isAddressSharingConfidential DT_WSTR nvarchar(20) 20
ShippingAddress_StateOrRegion DT_WSTR nvarchar(50) 50
ShippingAddress_CountryCode DT_WSTR nvarchar(8) 8
ShippingAddress_Name DT_WSTR nvarchar(255) 255
ShippingAddress_AddressLine1 DT_WSTR nvarchar(255) 255
IsPrime DT_WSTR nvarchar(20) 20
SellerOrderId DT_WSTR nvarchar(76) 76
ShipmentServiceLevelCategory DT_WSTR nvarchar(36) 36
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
Orders: Get Single Order Information
Required Parameters
AmazonOrderIdList Fill-in the parameter...
Optional Parameters
ElementsToTreatAsArray Order
Version 2013-09-01
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
Orders: Get Single Order Information
Required Parameters
AmazonOrderIdList Fill-in the parameter...
Optional Parameters
ElementsToTreatAsArray Order
Version 2013-09-01
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Orders: get single order information 

SELECT * FROM GetOrder
WITH
(
    "AmazonOrderIdList" = 'abcd-1234-amazonorderidlist'
)

SQL Server

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

Orders: get single order information 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM GetOrder
WITH
(
    "AmazonOrderIdList" = ''abcd-1234-amazonorderidlist''
)';

EXEC (@MyQuery) AT [LS_TO_AMAZON_MWS_IN_GATEWAY];