EndPoint Orders: Read Order Items

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

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

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.