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 | Required | Options |
|---|---|---|
|
Name:
Label: AmazonOrderId An Amazon-defined order identifier, in 3-7-7 format (Example: 058-1233752-8214740). |
YES | |
|
Name:
Label: Version |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| TaxCollection_ResponsibleParty |
DT_WSTR
|
nvarchar(84)
|
84 | |
| TaxCollection_Model |
DT_WSTR
|
nvarchar(88)
|
88 | |
| QuantityOrdered |
DT_I4
|
int
|
||
| Title |
DT_WSTR
|
nvarchar(600)
|
600 | |
| PromotionDiscount_Amount |
DT_NUMERIC
|
decimal(19,5)
|
||
| PromotionDiscount_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 | |
| IsGift |
DT_WSTR
|
nvarchar(20)
|
20 | |
| ASIN |
DT_WSTR
|
nvarchar(40)
|
40 | |
| SellerSKU |
DT_WSTR
|
nvarchar(136)
|
136 | |
| OrderItemId |
DT_I8
|
bigint
|
||
| IsTransparency |
DT_WSTR
|
nvarchar(20)
|
20 | |
| ProductInfo_NumberOfItems |
DT_I4
|
int
|
||
| QuantityShipped |
DT_I4
|
int
|
||
| ItemPrice_Amount |
DT_NUMERIC
|
decimal(19,5)
|
||
| ItemPrice_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 | |
| ItemTax_Amount |
DT_NUMERIC
|
decimal(19,5)
|
||
| ItemTax_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 | |
| PromotionDiscountTax_Amount |
DT_NUMERIC
|
decimal(19,5)
|
||
| PromotionDiscountTax_CurrencyCode |
DT_WSTR
|
nvarchar(12)
|
12 |
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
Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.
Amazon MWS
Orders: Read Order Items
| Required Parameters | |
|---|---|
| AmazonOrderId | Fill-in the parameter... |
| Optional Parameters | |
| NextUrlAttributeOrExpr | $.ListOrderItems[$tag$]Response.ListOrderItems[$tag$]Result.NextToken |
| NextUrlWaitInMs | 1000 |
| ElementsToTreatAsArray | OrderItem |
| Version | 2013-09-01 |
API Destination
API Destination - Amazon MWS
Amazon MWS (Marketplace Web Service) Connector can be used to integrated web service API that helps Amazon sellers to programmatically exchange data on listings, orders, payments, reports, and more.
Amazon MWS
Orders: Read Order Items
| Required Parameters | |
|---|---|
| AmazonOrderId | Fill-in the parameter... |
| Optional Parameters | |
| NextUrlAttributeOrExpr | $.ListOrderItems[$tag$]Response.ListOrderItems[$tag$]Result.NextToken |
| NextUrlWaitInMs | 1000 |
| ElementsToTreatAsArray | OrderItem |
| Version | 2013-09-01 |
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];