EndPoint Orders: Get Single Order Information

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

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	Label	Required	Options	Description
AmazonOrderIdList	AmazonOrderIdList	YES		A list of AmazonOrderId values. An AmazonOrderId is an Amazon-defined order identifier, in 3-7-7 format. (Example: 058-1233752-8214740).
Version	Version	NO

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
AmazonOrderId	`DT_WSTR`	`nvarchar(76)`	76	False
PurchaseDate	`DT_DBTIMESTAMP`	`datetime`		False
LatestShipDate	`DT_DBTIMESTAMP`	`datetime`		False
OrderType	`DT_WSTR`	`nvarchar(52)`	52	False
BuyerEmail	`DT_WSTR`	`nvarchar(255)`	255	False
LastUpdateDate	`DT_DBTIMESTAMP`	`datetime`		False
IsReplacementOrder	`DT_WSTR`	`nvarchar(20)`	20	False
NumberOfItemsShipped	`DT_I4`	`int`		False
ShipServiceLevel	`DT_WSTR`	`nvarchar(36)`	36	False
OrderStatus	`DT_WSTR`	`nvarchar(28)`	28	False
SalesChannel	`DT_WSTR`	`nvarchar(40)`	40	False
IsBusinessOrder	`DT_WSTR`	`nvarchar(20)`	20	False
NumberOfItemsUnshipped	`DT_I4`	`int`		False
PaymentMethodDetails_PaymentMethodDetail	`DT_WSTR`	`nvarchar(32)`	32	False
IsGlobalExpressEnabled	`DT_WSTR`	`nvarchar(20)`	20	False
IsSoldByAB	`DT_WSTR`	`nvarchar(20)`	20	False
BuyerName	`DT_WSTR`	`nvarchar(52)`	52	False
IsPremiumOrder	`DT_WSTR`	`nvarchar(20)`	20	False
OrderTotal_Amount	`DT_NUMERIC`	`decimal(19,5)`		False
OrderTotal_CurrencyCode	`DT_WSTR`	`nvarchar(12)`	12	False
EarliestShipDate	`DT_DBTIMESTAMP`	`datetime`		False
MarketplaceId	`DT_WSTR`	`nvarchar(52)`	52	False
FulfillmentChannel	`DT_WSTR`	`nvarchar(12)`	12	False
PaymentMethod	`DT_WSTR`	`nvarchar(20)`	20	False
ShippingAddress_City	`DT_WSTR`	`nvarchar(255)`	255	False
ShippingAddress_PostalCode	`DT_WSTR`	`nvarchar(40)`	40	False
ShippingAddress_isAddressSharingConfidential	`DT_WSTR`	`nvarchar(20)`	20	False
ShippingAddress_StateOrRegion	`DT_WSTR`	`nvarchar(50)`	50	False
ShippingAddress_CountryCode	`DT_WSTR`	`nvarchar(8)`	8	False
ShippingAddress_Name	`DT_WSTR`	`nvarchar(255)`	255	False
ShippingAddress_AddressLine1	`DT_WSTR`	`nvarchar(255)`	255	False
IsPrime	`DT_WSTR`	`nvarchar(20)`	20	False
SellerOrderId	`DT_WSTR`	`nvarchar(76)`	76	False
ShipmentServiceLevelCategory	`DT_WSTR`	`nvarchar(36)`	36	False

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.