Endpoint Orders: Read Orders
Name
ListOrders
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. [API reference]
Parameters
Parameter | Required | Options | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Name:
Label: MarketplaceIdList |
YES |
|
||||||||||||||||||||||||||||||||||||||
Name:
Label: CreatedAfter A UTC date used for selecting orders created after (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z). If LastUpdatedAfter is not specified. Specifying both CreatedAfter and LastUpdatedAfter returns an error. |
||||||||||||||||||||||||||||||||||||||||
Name:
Label: CreatedBefore A UTC date used for selecting orders created before (or at) a specified time. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z) |
||||||||||||||||||||||||||||||||||||||||
Name:
Label: LastUpdatedAfter A UTC date used for selecting orders that were last updated after (or at) a specified time. An update is defined as any change in order status, including the creation of a new order. Includes updates made by Amazon and by the seller. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z). If CreatedAfter is not specified.Specifying both CreatedAfter and LastUpdatedAfter returns an error.If LastUpdatedAfter is specified, then BuyerEmail and SellerOrderId cannot be specified. |
||||||||||||||||||||||||||||||||||||||||
Name:
Label: LastUpdatedBefore A UTC date used for selecting orders that were last updated before (or at) a specified time. An update is defined as any change in order status, including the creation of a new order. Includes updates made by Amazon and by the seller. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z) |
||||||||||||||||||||||||||||||||||||||||
Name:
Label: OrderStatus A list of OrderStatus values. Used to select orders with a current status that matches one of the status values that you specify. |
|
|||||||||||||||||||||||||||||||||||||||
Name:
Label: FulfillmentChannel A list that indicates how an order was fulfilled. |
|
|||||||||||||||||||||||||||||||||||||||
Name:
Label: PaymentMethod A list of PaymentMethod values. Used to select orders paid for with the payment methods that you specify. |
|
|||||||||||||||||||||||||||||||||||||||
Name:
Label: BuyerEmail The e-mail address of a buyer. Used to select only the orders that contain the specified e-mail address. If BuyerEmail is specified, then FulfillmentChannel, OrderStatus, PaymentMethod, LastUpdatedAfter, LastUpdatedBefore, and SellerOrderId cannot be specified. |
||||||||||||||||||||||||||||||||||||||||
Name:
Label: SellerOrderId An order identifier that is specified by the seller. Not an Amazon order identifier. Used to select only the orders that match a seller-specified order identifier. If SellerOrderId is specified, then FulfillmentChannel, OrderStatus, PaymentMethod, LastUpdatedAfter, LastUpdatedBefore, and BuyerEmail cannot be specified. |
||||||||||||||||||||||||||||||||||||||||
Name:
Label: EasyShipShipmentStatus A list of EasyShipShipmentStatus values. Used to select Easy Ship orders with current statuses that match the status values that you specify. If EasyShipShipmentStatus is specified, only Amazon Easy Ship orders are returned.This parameter is valid only in the India marketplace. |
|
|||||||||||||||||||||||||||||||||||||||
Name:
Label: Version |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
---|---|---|---|---|
AmazonOrderId |
DT_WSTR
|
nvarchar(76)
|
76 | |
OrderTotal_Amount |
DT_NUMERIC
|
decimal(19,5)
|
||
OrderTotal_CurrencyCode |
DT_WSTR
|
nvarchar(255)
|
255 | |
BuyerName |
DT_WSTR
|
nvarchar(255)
|
255 | |
OrderStatus |
DT_WSTR
|
nvarchar(32)
|
32 | |
OrderType |
DT_WSTR
|
nvarchar(52)
|
52 | |
PurchaseDate |
DT_DBTIMESTAMP
|
datetime
|
||
LatestShipDate |
DT_DBTIMESTAMP
|
datetime
|
||
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(255)
|
255 | |
ShippingAddress_CountryCode |
DT_WSTR
|
nvarchar(255)
|
255 | |
ShippingAddress_Name |
DT_WSTR
|
nvarchar(255)
|
255 | |
ShippingAddress_AddressLine1 |
DT_WSTR
|
nvarchar(255)
|
255 | |
ShippingAddress_AddressLine2 |
DT_WSTR
|
nvarchar(255)
|
255 | |
ShippingAddress_County |
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 | |
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 | |
IsPremiumOrder |
DT_WSTR
|
nvarchar(20)
|
20 | |
EarliestShipDate |
DT_DBTIMESTAMP
|
datetime
|
||
MarketplaceId |
DT_WSTR
|
nvarchar(52)
|
52 | |
FulfillmentChannel |
DT_WSTR
|
nvarchar(12)
|
12 | |
IsPrime |
DT_WSTR
|
nvarchar(20)
|
20 | |
SellerOrderId |
DT_WSTR
|
nvarchar(76)
|
76 | |
ShipmentServiceLevelCategory |
DT_WSTR
|
nvarchar(36)
|
36 | |
BuyerEmail |
DT_WSTR
|
nvarchar(255)
|
255 |
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
Optional Parameters | |
---|---|
CreatedAfter | 1900-01-01T00:00:00Z |
CreatedBefore | |
LastUpdatedAfter | |
LastUpdatedBefore | |
OrderStatus | |
FulfillmentChannel | |
PaymentMethod | |
BuyerEmail | |
SellerOrderId | |
EasyShipShipmentStatus | |
NextUrlAttributeOrExpr | $.ListOrders[$tag$]Response.ListOrders[$tag$]Result.NextToken |
ElementsToTreatAsArray | Order |
NextUrlWaitInMs | 10000 |
Version | 2013-09-01 |
DateParseHandling | DateTime |

API Destination
Optional Parameters | |
---|---|
CreatedAfter | 1900-01-01T00:00:00Z |
CreatedBefore | |
LastUpdatedAfter | |
LastUpdatedBefore | |
OrderStatus | |
FulfillmentChannel | |
PaymentMethod | |
BuyerEmail | |
SellerOrderId | |
EasyShipShipmentStatus | |
NextUrlAttributeOrExpr | $.ListOrders[$tag$]Response.ListOrders[$tag$]Result.NextToken |
ElementsToTreatAsArray | Order |
NextUrlWaitInMs | 10000 |
Version | 2013-09-01 |
DateParseHandling | DateTime |

ODBC application
Use these SQL queries in your ODBC application data source:
Orders: read orders
SELECT * FROM ListOrders
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Orders: read orders
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM ListOrders';
EXEC (@MyQuery) AT [LS_TO_AMAZON_MWS_IN_GATEWAY];