Orders: Read Order Items
Name
ListOrderItems
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. [API reference]
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
AmazonOrderId | AmazonOrderId | YES | 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 | Description |
---|---|---|---|---|---|
TaxCollection_ResponsibleParty |
DT_WSTR
|
nvarchar(84)
|
84 | False |
|
TaxCollection_Model |
DT_WSTR
|
nvarchar(88)
|
88 | False |
|
QuantityOrdered |
DT_I4
|
int
|
False |
||
Title |
DT_WSTR
|
nvarchar(600)
|
600 | False |
|
PromotionDiscount_Amount |
DT_NUMERIC
|
decimal(19,5)
|
False |
||
PromotionDiscount_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 | False |
|
IsGift |
DT_WSTR
|
nvarchar(20)
|
20 | False |
|
ASIN |
DT_WSTR
|
nvarchar(40)
|
40 | False |
|
SellerSKU |
DT_WSTR
|
nvarchar(136)
|
136 | False |
|
OrderItemId |
DT_I8
|
bigint
|
False |
||
IsTransparency |
DT_WSTR
|
nvarchar(20)
|
20 | False |
|
ProductInfo_NumberOfItems |
DT_I4
|
int
|
False |
||
QuantityShipped |
DT_I4
|
int
|
False |
||
ItemPrice_Amount |
DT_NUMERIC
|
decimal(19,5)
|
False |
||
ItemPrice_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 | False |
|
ItemTax_Amount |
DT_NUMERIC
|
decimal(19,5)
|
False |
||
ItemTax_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 | False |
|
PromotionDiscountTax_Amount |
DT_NUMERIC
|
decimal(19,5)
|
False |
||
PromotionDiscountTax_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 | False |
If the column you are looking for is missing, consider customizing Amazon MWS Connector.
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. |
Examples
SSIS
Use Amazon MWS Connector in API Source component to read data or in API Destination component to read/write data:
Orders: Read Order Items using API Source
Amazon MWS
Orders: Read Order Items

Orders: Read Order Items using API Destination
Amazon MWS
Orders: Read Order Items

ODBC application
Use these SQL queries in your ODBC application data source:
Orders: read order items
SELECT * FROM ListOrderItems
WITH
(
"AmazonOrderId" = 'abcd-1234-amazonorderid'
)
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Orders: read order items
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM ListOrderItems
WITH
(
"AmazonOrderId" = ''abcd-1234-amazonorderid''
)';
EXEC (@MyQuery) AT [LS_TO_AMAZON_MWS_IN_GATEWAY];