Endpoint

Get Subscriptions Ids

Name

get_subscription_ids

Parameter

Label

Required

Options

Description

PageSize

AccountId

Account Id

Products

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

StartDate

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)

EndDate

End Date (yyyy-MM-dd)

filters results to include transactions before the specified end date

Event

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(100)`	100	`False`

If the column you are looking for is missing, consider customizing FastSpring Connector.

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.

Use FastSpring Connector in API Source component to read data or in API Destination component to read/write data:

FastSpring

Get Subscriptions Ids

FastSpring

Get Subscriptions Ids

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_subscription_ids

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

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

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];