Reference

Endpoint Get Subscription By Id

Name

get_subscription

Description

Related Tables

Subscriptions

Parameters

Parameter Required Options
Name: Id

Label: Subscription Id

Output Columns

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

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Subscriptions table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - FastSpring
Read / write FastSpring data related to Orders, Subscriptions, Quotes, Products, Accounts and more without coding.
FastSpring
Subscriptions
Optional Parameters
Subscription Id
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Subscriptions table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get subscription by id:

API Destination - FastSpring
Read / write FastSpring data related to Orders, Subscriptions, Quotes, Products, Accounts and more without coding.
FastSpring
Subscriptions
Lookup
Optional Parameters
Subscription Id
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get subscription by id 

SELECT * FROM Subscriptions

get_subscription endpoint belongs to Subscriptions table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get subscription by id 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Subscriptions';

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];

get_subscription endpoint belongs to Subscriptions table(s), and can therefore be used via those table(s).