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
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

Read and write Amazon MWS data effortlessly. Integrate, manage, and automate listings, orders, payments, and reports — almost no coding required.

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

Read and write Amazon MWS data effortlessly. Integrate, manage, and automate listings, orders, payments, and reports — almost no coding required.

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];