Endpoint

Create Product

Name

post_product

Description

Related Tables

Products

Parameters

Parameter	Label	Required	Options	Description
There are no parameters

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(255)`	255	`False`
Display	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
Summary	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
Description	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Action	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Image	`DT_WSTR`	`nvarchar(500)`	500	`False`
Format	`DT_WSTR`	`nvarchar(50)`	50	`False`
Sku	`DT_WSTR`	`nvarchar(255)`	255	`False`
Renew	`DT_WSTR`	`nvarchar(10)`	10	`False`
Interval	`DT_WSTR`	`nvarchar(10)`	10	`False`
IntervalLength	`DT_I8`	`bigint`		`False`
IntervalCount	`DT_I4`	`int`		`False`
QuantityBehavior	`DT_WSTR`	`nvarchar(10)`	10	`False`
QuantityDefault	`DT_I8`	`bigint`		`False`
PriceUSD	`DT_R8`	`float`		`False`
PriceEUR	`DT_R8`	`float`		`False`
PriceGBP	`DT_R8`	`float`		`False`
PriceCAD	`DT_R8`	`float`		`False`
PriceNZD	`DT_R8`	`float`		`False`
PriceCHF	`DT_R8`	`float`		`False`
PriceSEK	`DT_R8`	`float`		`False`
PriceCZK	`DT_R8`	`float`		`False`
PriceDKK	`DT_R8`	`float`		`False`
PricePLN	`DT_R8`	`float`		`False`
PriceSGD	`DT_R8`	`float`		`False`
PriceJPY	`DT_R8`	`float`		`False`
PriceCNY	`DT_R8`	`float`		`False`
PriceHKD	`DT_R8`	`float`		`False`
PriceINR	`DT_R8`	`float`		`False`
PriceBRL	`DT_R8`	`float`		`False`
PriceAUD	`DT_R8`	`float`		`False`
Trial	`DT_I4`	`int`		`False`
PaymentCollected	`DT_BOOL`	`bit`		`False`
PaidTrial	`DT_BOOL`	`bit`		`False`
FulfillmentInstructions	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Badge	`DT_WSTR`	`nvarchar(50)`	50	`False`
Rank	`DT_I4`	`int`		`False`
DateLimitsEnabled	`DT_BOOL`	`bit`		`False`
CancellationInterval	`DT_WSTR`	`nvarchar(4)`	4	`False`
CancellationIntervalLength	`DT_I8`	`bigint`		`False`
TaxCode	`DT_WSTR`	`nvarchar(50)`	50	`False`
TaxCodeDescription	`DT_WSTR`	`nvarchar(500)`	500	`False`
Visibility	`DT_WSTR`	`nvarchar(255)`	255	`False`
ProductAppReference	`DT_WSTR`	`nvarchar(255)`	255	`False`
Parent	`DT_WSTR`	`nvarchar(255)`	255	`False`
MigratedProductId	`DT_WSTR`	`nvarchar(50)`	50	`False`
ClassicProduct	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
SetupFeeTitle	`DT_WSTR`	`nvarchar(500)`	500	`False`
SetupFeePriceUSD	`DT_R8`	`float`		`False`
SetupFeePriceEUR	`DT_R8`	`float`		`False`
SetupFeePriceGBP	`DT_R8`	`float`		`False`
TrialPriceUSD	`DT_R8`	`float`		`False`
TrialPriceEUR	`DT_R8`	`float`		`False`
TrialPriceGBP	`DT_R8`	`float`		`False`
Result	`DT_WSTR`	`nvarchar(100)`	100	`False`
ResultAction	`DT_WSTR`	`nvarchar(100)`	100	`False`
ResultErrors	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
ResultMessage	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

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

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(255)`	255	`False`
Display	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Summary	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Description	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Action	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
Format	`DT_WSTR`	`nvarchar(50)`	50	`False`
Sku	`DT_WSTR`	`nvarchar(255)`	255	`False`
TaxCode	`DT_WSTR`	`nvarchar(50)`	50	`False`
Image	`DT_WSTR`	`nvarchar(500)`	500	`False`
Renew	`DT_WSTR`	`nvarchar(10)`	10	`False`
Interval	`DT_WSTR`	`nvarchar(10)`	10	`False`
IntervalLength	`DT_I8`	`bigint`		`False`
IntervalCount	`DT_I4`	`int`		`False`
QuantityBehavior	`DT_WSTR`	`nvarchar(10)`	10	`False`
QuantityDefault	`DT_I8`	`bigint`		`False`
PriceUSD	`DT_R8`	`float`		`False`
PriceEUR	`DT_R8`	`float`		`False`
PriceGBP	`DT_R8`	`float`		`False`
PriceCAD	`DT_R8`	`float`		`False`
PriceNZD	`DT_R8`	`float`		`False`
PriceCHF	`DT_R8`	`float`		`False`
PriceSEK	`DT_R8`	`float`		`False`
PriceCZK	`DT_R8`	`float`		`False`
PriceDKK	`DT_R8`	`float`		`False`
PricePLN	`DT_R8`	`float`		`False`
PriceSGD	`DT_R8`	`float`		`False`
PriceJPY	`DT_R8`	`float`		`False`
PriceCNY	`DT_R8`	`float`		`False`
PriceHKD	`DT_R8`	`float`		`False`
PriceINR	`DT_R8`	`float`		`False`
PriceBRL	`DT_R8`	`float`		`False`
PriceAUD	`DT_R8`	`float`		`False`
Trial	`DT_I4`	`int`		`False`
PaymentCollected	`DT_BOOL`	`bit`		`False`
PaidTrial	`DT_BOOL`	`bit`		`False`
FulfillmentInstructions	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
DateLimitsEnabled	`DT_BOOL`	`bit`		`False`
CancellationInterval	`DT_WSTR`	`nvarchar(4)`	4	`False`
CancellationIntervalLength	`DT_I8`	`bigint`		`False`
SetupFeeTitle	`DT_WSTR`	`nvarchar(500)`	500	`False`
SetupFeePriceUSD	`DT_R8`	`float`		`False`
SetupFeePriceEUR	`DT_R8`	`float`		`False`
SetupFeePriceGBP	`DT_R8`	`float`		`False`
TrialPriceUSD	`DT_R8`	`float`		`False`
TrialPriceEUR	`DT_R8`	`float`		`False`
TrialPriceGBP	`DT_R8`	`float`		`False`
Badge	`DT_WSTR`	`nvarchar(50)`	50	`False`
Rank	`DT_I4`	`int`		`False`
Parent	`DT_WSTR`	`nvarchar(255)`	255	`False`
Attributes	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
Fulfillments	`DT_WSTR`	`nvarchar(4000)`	4000	`True`

Required columns that you need to supply are bolded.

Examples

SSIS

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

Read from Products table using API Destination

This Endpoint belongs to Products table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

FastSpring

Products

Insert, Upsert

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).