Reference

Endpoint Get Product

Name

get_product

Description

Related Tables

Products

Parameters

Parameter Required Options
Name: Id

Label: Product Id

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(255) 255
Display DT_WSTR nvarchar(1000) 1000
Summary DT_WSTR nvarchar(1000) 1000
Description DT_WSTR nvarchar(4000) 4000
Action DT_WSTR nvarchar(4000) 4000
Image DT_WSTR nvarchar(500) 500
Format DT_WSTR nvarchar(50) 50
Sku DT_WSTR nvarchar(255) 255
Renew DT_WSTR nvarchar(10) 10
Interval DT_WSTR nvarchar(10) 10
IntervalLength DT_I8 bigint
IntervalCount DT_I4 int
QuantityBehavior DT_WSTR nvarchar(10) 10
QuantityDefault DT_I8 bigint
PriceUSD DT_R8 float
PriceEUR DT_R8 float
PriceGBP DT_R8 float
PriceCAD DT_R8 float
PriceNZD DT_R8 float
PriceCHF DT_R8 float
PriceSEK DT_R8 float
PriceCZK DT_R8 float
PriceDKK DT_R8 float
PricePLN DT_R8 float
PriceSGD DT_R8 float
PriceJPY DT_R8 float
PriceCNY DT_R8 float
PriceHKD DT_R8 float
PriceINR DT_R8 float
PriceBRL DT_R8 float
PriceAUD DT_R8 float
Trial DT_I4 int
PaymentCollected DT_BOOL bit
PaidTrial DT_BOOL bit
FulfillmentInstructions DT_WSTR nvarchar(4000) 4000
Badge DT_WSTR nvarchar(50) 50
Rank DT_I4 int
DateLimitsEnabled DT_BOOL bit
CancellationInterval DT_WSTR nvarchar(4) 4
CancellationIntervalLength DT_I8 bigint
TaxCode DT_WSTR nvarchar(50) 50
TaxCodeDescription DT_WSTR nvarchar(500) 500
Visibility DT_WSTR nvarchar(255) 255
ProductAppReference DT_WSTR nvarchar(255) 255
Parent DT_WSTR nvarchar(255) 255
MigratedProductId DT_WSTR nvarchar(50) 50
ClassicProduct DT_WSTR nvarchar(4000) 4000
SetupFeeTitle DT_WSTR nvarchar(500) 500
SetupFeePriceUSD DT_R8 float
SetupFeePriceEUR DT_R8 float
SetupFeePriceGBP DT_R8 float
TrialPriceUSD DT_R8 float
TrialPriceEUR DT_R8 float
TrialPriceGBP DT_R8 float
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 Products 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
Products
Optional Parameters
Product Id
SSIS API Source - Read from table or endpoint

API Destination

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

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

ODBC application

Use these SQL queries in your ODBC application data source:

Read a single product by id

Read a single product by id 

SELECT * FROM Products Where Id='some-product-id'

get_product endpoint belongs to Products 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:

Read a single product by id

Read a single product by id 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Products Where Id=''some-product-id''';

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];

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