EndPoint Get Order Items (For Single Order)

Contents

Name

get_order_items

Returns the order items information for a specified OrderId [API reference]

Parameter	Label	Required	Options	Description
AmazonOrderId	AmazonOrderId	NO		Filters purchase orders based on the specified orderid.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
AmazonOrderId	`DT_WSTR`	`nvarchar(50)`	50	False
OrderItemId	`DT_WSTR`	`nvarchar(50)`	50	False
Title	`DT_WSTR`	`nvarchar(300)`	300	False
ASIN	`DT_WSTR`	`nvarchar(50)`	50	False
SellerSKU	`DT_WSTR`	`nvarchar(50)`	50	False
QuantityOrdered	`DT_I8`	`bigint`		False
QuantityShipped	`DT_I8`	`bigint`		False
Model	`DT_WSTR`	`nvarchar(100)`	100	False
NumberOfItems	`DT_WSTR`	`nvarchar(4)`	4	False
PriceCurrencyCode	`DT_WSTR`	`nvarchar(10)`	10	False
PriceAmount	`DT_WSTR`	`nvarchar(20)`	20	False
TaxCurrencyCode	`DT_WSTR`	`nvarchar(10)`	10	False
TaxAmount	`DT_WSTR`	`nvarchar(20)`	20	False
ResponsibleParty	`DT_WSTR`	`nvarchar(84)`	84	False
IsBuyerRequestedCancel	`DT_WSTR`	`nvarchar(20)`	20	False
BuyerCancelReason	`DT_WSTR`	`nvarchar(80)`	80	False
IsGift	`DT_WSTR`	`nvarchar(20)`	20	False
ConditionSubtypeId	`DT_WSTR`	`nvarchar(40)`	40	False
IsTransparency	`DT_BOOL`	`bit`		False
PromotionDiscountCurrencyCode	`DT_WSTR`	`nvarchar(10)`	10	False
PromotionDiscountAmount	`DT_WSTR`	`nvarchar(20)`	20	False
PromotionDiscountTaxCurrencyCode	`DT_WSTR`	`nvarchar(10)`	10	False
PromotionDiscountTaxAmount	`DT_WSTR`	`nvarchar(20)`	20	False
ConditionId	`DT_WSTR`	`nvarchar(20)`	20	False

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.