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

SSIS API Source - Read from table or endpoint

Orders: Read Order Items using API Destination

Amazon MWS

Orders: Read Order Items

SSIS API Destination - Access table or endpoint

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