Reference

Endpoint Create Product

Name

post_product

Description

Related Tables

Products

Parameters

Parameter Required Options
There are no parameters

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
Result DT_WSTR nvarchar(100) 100
ResultAction DT_WSTR nvarchar(100) 100
ResultErrors DT_WSTR nvarchar(4000) 4000
ResultMessage DT_WSTR nvarchar(4000) 4000
If the column you are looking for is missing, consider customizing FastSpring Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(255) 255
Display DT_WSTR nvarchar(4000) 4000
Summary DT_WSTR nvarchar(4000) 4000
Description DT_WSTR nvarchar(4000) 4000
Action DT_WSTR nvarchar(1000) 1000
Format DT_WSTR nvarchar(50) 50
Sku DT_WSTR nvarchar(255) 255
TaxCode DT_WSTR nvarchar(50) 50
Image DT_WSTR nvarchar(500) 500
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
DateLimitsEnabled DT_BOOL bit
CancellationInterval DT_WSTR nvarchar(4) 4
CancellationIntervalLength DT_I8 bigint
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
Badge DT_WSTR nvarchar(50) 50
Rank DT_I4 int
Parent DT_WSTR nvarchar(255) 255
Attributes DT_WSTR nvarchar(4000) 4000
Fulfillments DT_WSTR nvarchar(4000) 4000
Required columns that you need to supply are bolded.

Examples

SSIS

Use FastSpring Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

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 create product:

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

ODBC application

Use these SQL queries in your ODBC application data source:

Create or Update Product (Upsert)

Create or Update product (Upsert) 

--Insert or Update
--UPSERT INTO Products 

--Insert or Update
UPSERT INTO Products
(     [Id]	, [Display]	, [Summary]
	, [Description]	, [Action]	, [Format]
	, [Sku]	, [TaxCode]	, [Image]
	, [Renew]	, [Interval]	, [IntervalLength]
	, [IntervalCount]	, [QuantityBehavior]	, [QuantityDefault]
	, [PriceUSD]	, [PriceEUR]	, [PriceGBP]
	, [PriceCAD]	, [PriceNZD]	, [PriceCHF]
	, [PriceSEK]	, [PriceCZK]	, [PriceDKK]
	, [PricePLN]	, [PriceSGD]	, [PriceJPY]
	, [PriceCNY]	, [PriceHKD]	, [PriceINR]	, [PriceBRL]	, [PriceAUD]
	, [Trial]	
	, [TrialPriceUSD]	, [TrialPriceEUR]	, [TrialPriceGBP]
	, [PaymentCollected]	, [PaidTrial]
	, [FulfillmentInstructions]
	, [DateLimitsEnabled]	, [CancellationInterval]	, [CancellationIntervalLength]	
	, [SetupFeeTitle]	
	, [SetupFeePriceUSD]	, [SetupFeePriceEUR]	, [SetupFeePriceGBP]	
	, [Badge]	, [Rank]	
	, [Attributes]		
	)
VALUES('test-std-id'
	, '3Year **standard** subscription edition'
	, 'summary **standard edition** _some italic_ ' -- markdown syntax allowed
	
	, 'long description **test STD** and many more lines' --markdown syntax allowed
	, 'action text with **markdown** '
	, 'digital' -- e.g. digital OR physical OR digital-and-physical
	
	, 'TEST-STD-001'
	, 'DC010500'
	, 'https://zappysys.com/api/images/ZappySys-icon.png'
	
	, true	, 'year'	, 1
	, 1 	, 'allow' -- e.g. allow Or lock Or hide
	, 3	--stop renewal after 3 periods
	, 10.12	, 11.12	, 12.12	
	, 13.12	, 14.12	, 15.12	
	, 16.12	, 17.12	, 18.12	
	, 19.12	, 20.12	, 21.12	
	, 22.12	, 23.12	, 24.12	, 25.12	, 26.12	
    , 14 --how many days trial allowed
    , 10.12	, 11.12	, 12.12	
    , 'true', true
	, 'Thank you for shopping, **here are** license instructions' --markdown supported
	, false, 'day', 5
	, 'Setup title'	
	--setup fees in common currencies
	, 10.50	, 11.50	, 12.50	
	, 'badge-1'	, 1
	, '{"mykey-1" : "some-value-1", "mykey-2" : "some-value-2"}' --JSON fragment 
	--, '[... fullfillments.. ]' --JSON fragment 	
)

post_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:

Create or Update Product (Upsert)

Create or Update product (Upsert) 

DECLARE @MyQuery NVARCHAR(MAX) = '--Insert or Update
--UPSERT INTO Products 

--Insert or Update
UPSERT INTO Products
(     [Id]	, [Display]	, [Summary]
	, [Description]	, [Action]	, [Format]
	, [Sku]	, [TaxCode]	, [Image]
	, [Renew]	, [Interval]	, [IntervalLength]
	, [IntervalCount]	, [QuantityBehavior]	, [QuantityDefault]
	, [PriceUSD]	, [PriceEUR]	, [PriceGBP]
	, [PriceCAD]	, [PriceNZD]	, [PriceCHF]
	, [PriceSEK]	, [PriceCZK]	, [PriceDKK]
	, [PricePLN]	, [PriceSGD]	, [PriceJPY]
	, [PriceCNY]	, [PriceHKD]	, [PriceINR]	, [PriceBRL]	, [PriceAUD]
	, [Trial]	
	, [TrialPriceUSD]	, [TrialPriceEUR]	, [TrialPriceGBP]
	, [PaymentCollected]	, [PaidTrial]
	, [FulfillmentInstructions]
	, [DateLimitsEnabled]	, [CancellationInterval]	, [CancellationIntervalLength]	
	, [SetupFeeTitle]	
	, [SetupFeePriceUSD]	, [SetupFeePriceEUR]	, [SetupFeePriceGBP]	
	, [Badge]	, [Rank]	
	, [Attributes]		
	)
VALUES(''test-std-id''
	, ''3Year **standard** subscription edition''
	, ''summary **standard edition** _some italic_ '' -- markdown syntax allowed
	
	, ''long description **test STD** and many more lines'' --markdown syntax allowed
	, ''action text with **markdown** ''
	, ''digital'' -- e.g. digital OR physical OR digital-and-physical
	
	, ''TEST-STD-001''
	, ''DC010500''
	, ''https://zappysys.com/api/images/ZappySys-icon.png''
	
	, true	, ''year''	, 1
	, 1 	, ''allow'' -- e.g. allow Or lock Or hide
	, 3	--stop renewal after 3 periods
	, 10.12	, 11.12	, 12.12	
	, 13.12	, 14.12	, 15.12	
	, 16.12	, 17.12	, 18.12	
	, 19.12	, 20.12	, 21.12	
	, 22.12	, 23.12	, 24.12	, 25.12	, 26.12	
    , 14 --how many days trial allowed
    , 10.12	, 11.12	, 12.12	
    , ''true'', true
	, ''Thank you for shopping, **here are** license instructions'' --markdown supported
	, false, ''day'', 5
	, ''Setup title''	
	--setup fees in common currencies
	, 10.50	, 11.50	, 12.50	
	, ''badge-1''	, 1
	, ''{"mykey-1" : "some-value-1", "mykey-2" : "some-value-2"}'' --JSON fragment 
	--, ''[... fullfillments.. ]'' --JSON fragment 	
)';

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];

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