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