Reference

Endpoint Get Subscriptions Ids

Name

get_subscription_ids

Description

Parameters

Parameter Required Options
Name: PageSize

Label: PageSize
Name: AccountId

Label: AccountId

Account Id
Name: Products

Label: Products

filters results to include only transactions involving the specified product ID(s) / product path(s)
Name: StartDate

Label: Start Date (yyyy-MM-dd)

filters results to include transactions after the specified begin date (must be at least one day before the specified end date)
Option Value
2023-12-31 2023-12-31
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Name: EndDate

Label: End Date (yyyy-MM-dd)

filters results to include transactions before the specified end date
Option Value
2023-12-31 2023-12-31
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Name: Event

Label: Event

Event

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(100) 100
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

API Source - FastSpring
Read / write FastSpring data related to Orders, Subscriptions, Quotes, Products, Accounts and more without coding.
FastSpring
Get Subscriptions Ids
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

API Destination - FastSpring
Read / write FastSpring data related to Orders, Subscriptions, Quotes, Products, Accounts and more without coding.
FastSpring
Get Subscriptions Ids
There are no parameters to configure.
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get subscriptions ids 

SELECT * FROM get_subscription_ids

SQL Server

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

Get subscriptions ids 

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

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];