EndPoint Get Order Items by OrderId

Contents

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

Name

get_order_item

Description

Parameters

Parameter	Label	Required	Options	Description
OrderId	Order Id	NO

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
OrderId	`DT_WSTR`	`nvarchar(100)`	100	False
ProductId	`DT_WSTR`	`nvarchar(255)`	255	False
Quantity	`DT_I8`	`bigint`		False
Display	`DT_WSTR`	`nvarchar(4000)`	4000	False
Sku	`DT_WSTR`	`nvarchar(255)`	255	False
ShortDisplay	`DT_WSTR`	`nvarchar(1000)`	1000	False
SubscriptionId	`DT_WSTR`	`nvarchar(88)`	88	False
ImageUrl	`DT_WSTR`	`nvarchar(1000)`	1000	False
SubtotalDisplay	`DT_WSTR`	`nvarchar(52)`	52	False
Subtotal	`DT_R8`	`float`		False
SubtotalInPayoutCurrency	`DT_R8`	`float`		False
SubtotalInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(48)`	48	False
AttributesPathFrom	`DT_WSTR`	`nvarchar(60)`	60	False
AttributesPathTo	`DT_WSTR`	`nvarchar(60)`	60	False
AttributesQuantityFrom	`DT_I8`	`bigint`		False
AttributesQuantityTo	`DT_I8`	`bigint`		False
AttributesDisplay	`DT_WSTR`	`nvarchar(2048)`	2048	False
AttributesTotalChange	`DT_R8`	`float`		False
AttributesTotalProratedCharge	`DT_R8`	`float`		False
AttributesTotalProratedCredit	`DT_R8`	`float`		False
AttributesTotalNetCharge	`DT_R8`	`float`		False
AttributesPreviousCharge	`DT_R8`	`float`		False
AttributesUpcomingCharge	`DT_R8`	`float`		False
AttributesUtilizedPrevious	`DT_R8`	`float`		False
AttributesLapsedPrevious	`DT_R8`	`float`		False
Discount	`DT_R8`	`float`		False
DiscountDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
DiscountInPayoutCurrency	`DT_R8`	`float`		False
DiscountInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
IsSubscription	`DT_BOOL`	`bit`		False
ChangeQuantity	`DT_BOOL`	`bit`		False
WithholdingsTaxWithholdings	`DT_BOOL`	`bit`		False
ProratedItemChangeAmount	`DT_R8`	`float`		False
ProratedItemChangeAmountDisplay	`DT_WSTR`	`nvarchar(28)`	28	False
ProratedItemChangeAmountInPayoutCurrency	`DT_R8`	`float`		False
ProratedItemChangeAmountInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(32)`	32	False
ProratedItemProratedCharge	`DT_R8`	`float`		False
ProratedItemProratedChargeDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
ProratedItemProratedChargeInPayoutCurrency	`DT_R8`	`float`		False
ProratedItemProratedChargeInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
ProratedItemCreditAmount	`DT_R8`	`float`		False
ProratedItemCreditAmountDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
ProratedItemCreditAmountInPayoutCurrency	`DT_R8`	`float`		False
ProratedItemCreditAmountInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
ProratedItemTaxAmount	`DT_R8`	`float`		False
ProratedItemTaxAmountDisplay	`DT_WSTR`	`nvarchar(24)`	24	False
ProratedItemTaxAmountInPayoutCurrency	`DT_R8`	`float`		False
ProratedItemTaxAmountInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(32)`	32	False
ProratedItemTotal	`DT_R8`	`float`		False
ProratedItemTotalDisplay	`DT_WSTR`	`nvarchar(28)`	28	False
ProratedItemTotalInPayoutCurrency	`DT_R8`	`float`		False
ProratedItemTotalInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(32)`	32	False
AttributesMigratedProductId	`DT_WSTR`	`nvarchar(88)`	88	False
AttributesClassicProduct	`DT_WSTR`	`nvarchar(1068)`	1068	False
IsAddon	`DT_BOOL`	`bit`		False
Reference	`DT_WSTR`	`nvarchar(100)`	100	False
BuyerReference	`DT_WSTR`	`nvarchar(100)`	100	False
IpAddress	`DT_WSTR`	`nvarchar(50)`	50	False
Completed	`DT_BOOL`	`bit`		False
Changed	`DT_I8`	`bigint`		False
ChangedValue	`DT_I8`	`bigint`		False
ChangedInSeconds	`DT_I8`	`bigint`		False
ChangedDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
OrderDate	`DT_DBDATE`	`date`		False
ChangedDisplayEmailEnhancements	`DT_WSTR`	`nvarchar(50)`	50	False
ChangedDisplayEmailEnhancementsWithTime	`DT_WSTR`	`nvarchar(96)`	96	False
Language	`DT_WSTR`	`nvarchar(8)`	8	False
Live	`DT_BOOL`	`bit`		False
Currency	`DT_WSTR`	`nvarchar(12)`	12	False
PayoutCurrency	`DT_WSTR`	`nvarchar(12)`	12	False
QuoteId	`DT_WSTR`	`nvarchar(1020)`	1020	False
InvoiceUrl	`DT_WSTR`	`nvarchar(440)`	440	False
SiteId	`DT_WSTR`	`nvarchar(50)`	50	False
AccountId	`DT_WSTR`	`nvarchar(88)`	88	False
Total	`DT_R8`	`float`		False
TotalDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
TotalInPayoutCurrency	`DT_R8`	`float`		False
TotalInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
Tax	`DT_R8`	`float`		False
TaxDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
TaxInPayoutCurrency	`DT_R8`	`float`		False
TaxInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
OrderSubtotal	`DT_R8`	`float`		False
OrderSubtotalDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
OrderSubtotalInPayoutCurrency	`DT_R8`	`float`		False
OrderSubtotalInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
OrderDiscount	`DT_R8`	`float`		False
OrderDiscountDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
OrderDiscountInPayoutCurrency	`DT_R8`	`float`		False
OrderDiscountInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
OrderDiscountWithTax	`DT_R8`	`float`		False
OrderDiscountWithTaxDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
OrderDiscountWithTaxInPayoutCurrency	`DT_R8`	`float`		False
OrderDiscountWithTaxInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(50)`	50	False
BillDescriptor	`DT_WSTR`	`nvarchar(50)`	50	False
PaymentType	`DT_WSTR`	`nvarchar(50)`	50	False
PaymentCardEnding	`DT_WSTR`	`nvarchar(50)`	50	False
CustomerFirst	`DT_WSTR`	`nvarchar(50)`	50	False
CustomerLast	`DT_WSTR`	`nvarchar(50)`	50	False
CustomerEmail	`DT_WSTR`	`nvarchar(255)`	255	False
CustomerCompany	`DT_WSTR`	`nvarchar(255)`	255	False
CustomerPhone	`DT_WSTR`	`nvarchar(100)`	100	False
CustomerSubscribed	`DT_BOOL`	`bit`		False
AddressCity	`DT_WSTR`	`nvarchar(255)`	255	False
AddressRegionCode	`DT_WSTR`	`nvarchar(10)`	10	False
AddressRegionDisplay	`DT_WSTR`	`nvarchar(255)`	255	False
AddressRegion	`DT_WSTR`	`nvarchar(50)`	50	False
AddressPostalCode	`DT_WSTR`	`nvarchar(20)`	20	False
AddressCountry	`DT_WSTR`	`nvarchar(255)`	255	False
AddressDisplay	`DT_WSTR`	`nvarchar(128)`	128	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.