EndPoint Get Subscription By Id
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
Id | Subscription Id | NO |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
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. |
Examples
SSIS
Use FastSpring Connector in API Source component to read data or in API Destination component to read/write data:
Get Subscription By Id using API Source
FastSpring
Get Subscription By Id

Get Subscription By Id using API Destination
FastSpring
Get Subscription By Id
