EndPoint Get Subscription By Id

Contents

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

Name

get_subscription

Description

Parameters

Parameter	Label	Required	Options	Description
Id	Subscription Id	NO

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(100)`	100	False
QuoteId	`DT_WSTR`	`nvarchar(1020)`	1020	False
AccountId	`DT_WSTR`	`nvarchar(100)`	100	False
ProductId	`DT_WSTR`	`nvarchar(100)`	100	False
Active	`DT_BOOL`	`bit`		False
State	`DT_WSTR`	`nvarchar(24)`	24	False
Sku	`DT_WSTR`	`nvarchar(1020)`	1020	False
Display	`DT_WSTR`	`nvarchar(1000)`	1000	False
Quantity	`DT_I8`	`bigint`		False
AutoRenew	`DT_BOOL`	`bit`		False
IsSubscriptionEligibleForPauseByBuyer	`DT_BOOL`	`bit`		False
IsPauseScheduled	`DT_BOOL`	`bit`		False
ChangedDate	`DT_DBDATE`	`date`		False
BeginDate	`DT_DBDATE`	`date`		False
NextDate	`DT_DBDATE`	`date`		False
EndDate	`DT_DBDATE`	`date`		False
CanceledDate	`DT_DBDATE`	`date`		False
DeactivationDate	`DT_DBDATE`	`date`		False
NextChargeDate	`DT_DBDATE`	`date`		False
InitialOrderId	`DT_WSTR`	`nvarchar(88)`	88	False
InitialOrderReference	`DT_WSTR`	`nvarchar(80)`	80	False
ImportIdentifier	`DT_WSTR`	`nvarchar(80)`	80	False
CustomReferenceId	`DT_WSTR`	`nvarchar(80)`	80	False
MigratedFromSubscriptionId	`DT_WSTR`	`nvarchar(80)`	80	False
MigratedFromSubscriptionReference	`DT_WSTR`	`nvarchar(80)`	80	False
MigratedIntoSubscriptionId	`DT_WSTR`	`nvarchar(80)`	80	False
MigratedIntoSubscriptionReference	`DT_WSTR`	`nvarchar(80)`	80	False
Adhoc	`DT_BOOL`	`bit`		False
Changed	`DT_I8`	`bigint`		False
ChangedValue	`DT_I8`	`bigint`		False
ChangedInSeconds	`DT_I8`	`bigint`		False
ChangedDisplay	`DT_WSTR`	`nvarchar(32)`	32	False
ChangedDisplayEmailEnhancements	`DT_WSTR`	`nvarchar(48)`	48	False
ChangedDisplayEmailEnhancementsWithTime	`DT_WSTR`	`nvarchar(96)`	96	False
Live	`DT_BOOL`	`bit`		False
Currency	`DT_WSTR`	`nvarchar(12)`	12	False
Price	`DT_R8`	`float`		False
PriceDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
PriceInPayoutCurrency	`DT_R8`	`float`		False
PriceInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
Discount	`DT_R8`	`float`		False
DiscountDisplay	`DT_WSTR`	`nvarchar(20)`	20	False
DiscountInPayoutCurrency	`DT_R8`	`float`		False
DiscountInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(20)`	20	False
Subtotal	`DT_R8`	`float`		False
SubtotalDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
SubtotalInPayoutCurrency	`DT_R8`	`float`		False
SubtotalInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
AttributesMigratedProductId	`DT_WSTR`	`nvarchar(88)`	88	False
AttributesClassicProduct	`DT_WSTR`	`nvarchar(984)`	984	False
Next	`DT_I8`	`bigint`		False
NextValue	`DT_I8`	`bigint`		False
NextInSeconds	`DT_I8`	`bigint`		False
NextDisplay	`DT_WSTR`	`nvarchar(32)`	32	False
End	`DT_WSTR`	`nvarchar(1020)`	1020	False
EndValue	`DT_WSTR`	`nvarchar(1020)`	1020	False
EndInSeconds	`DT_WSTR`	`nvarchar(1020)`	1020	False
EndDisplay	`DT_WSTR`	`nvarchar(1020)`	1020	False
CanceledDateValue	`DT_WSTR`	`nvarchar(1020)`	1020	False
CanceledDateInSeconds	`DT_WSTR`	`nvarchar(1020)`	1020	False
CanceledDateDisplay	`DT_WSTR`	`nvarchar(1020)`	1020	False
DeactivationDateNum	`DT_I8`	`bigint`	1020	False
DeactivationDateValue	`DT_WSTR`	`nvarchar(1020)`	1020	False
DeactivationDateInSeconds	`DT_WSTR`	`nvarchar(1020)`	1020	False
DeactivationDateDisplay	`DT_WSTR`	`nvarchar(1020)`	1020	False
Sequence	`DT_I8`	`bigint`		False
Periods	`DT_WSTR`	`nvarchar(1020)`	1020	False
RemainingPeriods	`DT_WSTR`	`nvarchar(1020)`	1020	False
Begin	`DT_I8`	`bigint`		False
BeginValue	`DT_I8`	`bigint`		False
BeginInSeconds	`DT_I8`	`bigint`		False
BeginDisplay	`DT_WSTR`	`nvarchar(32)`	32	False
BeginDisplayEmailEnhancements	`DT_WSTR`	`nvarchar(48)`	48	False
BeginDisplayEmailEnhancementsWithTime	`DT_WSTR`	`nvarchar(96)`	96	False
NextDisplayEmailEnhancements	`DT_WSTR`	`nvarchar(48)`	48	False
NextDisplayEmailEnhancementsWithTime	`DT_WSTR`	`nvarchar(96)`	96	False
IntervalUnit	`DT_WSTR`	`nvarchar(16)`	16	False
IntervalUnitAbbreviation	`DT_WSTR`	`nvarchar(8)`	8	False
IntervalLength	`DT_I8`	`bigint`		False
IntervalLengthGtOne	`DT_BOOL`	`bit`		False
NextChargeCurrency	`DT_WSTR`	`nvarchar(12)`	12	False
NextChargeDateNum	`DT_I8`	`bigint`		False
NextChargeDateValue	`DT_I8`	`bigint`		False
NextChargeDateInSeconds	`DT_I8`	`bigint`		False
NextChargeDateDisplay	`DT_WSTR`	`nvarchar(32)`	32	False
NextChargePreTax	`DT_R8`	`float`		False
NextChargePreTaxDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
NextChargePreTaxInPayoutCurrency	`DT_R8`	`float`		False
NextChargePreTaxInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
NextChargeTotal	`DT_R8`	`float`		False
NextChargeTotalDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
NextChargeTotalInPayoutCurrency	`DT_R8`	`float`		False
NextChargeTotalInPayoutCurrencyDisplay	`DT_WSTR`	`nvarchar(36)`	36	False
CancellationSettingCancellation	`DT_WSTR`	`nvarchar(84)`	84	False
CancellationSettingIntervalUnit	`DT_WSTR`	`nvarchar(16)`	16	False
CancellationSettingIntervalLength	`DT_I8`	`bigint`		False
Instructions	`DT_NTEXT`	`nvarchar(MAX)`		False
Expiry	`DT_WSTR`	`nvarchar(10)`	10	False
DeclineReason	`DT_WSTR`	`nvarchar(1000)`	1000	False
CardType	`DT_WSTR`	`nvarchar(100)`	100	False
CardEnding	`DT_WSTR`	`nvarchar(20)`	20	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.