FastSpring Connector
Documentation
Version: 1
Documentation
Endpoint

Update Product


Name

put_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 Description
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 Description
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:

Update rows in 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
Update
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update Product

Update product attributes by its ID

UPDATE Products
SET 
  Display='Product ABCD'
, Sku='PRD-ABCD-01'
, Summary='Product Abcd **STD**'
, Description='This product can be used to call **API** supports markdown syntax'
, Action='**Action** supports markdown'
, TaxCode='DC010500'
, Image='https://zappysys.com/api/images/ZappySys-icon.png'
, FulfillmentInstructions='Thank you for shopping. **Activate** license by using our License App'
, Format='digital'
, PriceUSD='101.5'
, PriceEUR='102.5'
, PriceGBP='103.5'
, PriceCAD='104.5'
, PriceNZD='105.5'
, PriceCHF='106.5'
, PriceSEK='107.5'
, PriceCZK='108.5'
, PriceDKK='109.5'
, PricePLN='101.5'
, PriceSGD='102.5'
, PriceJPY='103.5'
, PriceCNY='104.5'
, PriceHKD='105.5'
, PriceINR='106.5'
, PriceBRL='107.5'
, PriceAUD='108.5'

, Badge='Badge-1'
, Rank=1
, Trial=14 --how many trial days
, TrialPriceUSD=10.5 

--, Renew=1 --not allowed for update : Only for create (enable subscription)
, Interval='year' --allowed values: adhoc, day, week, year, only needed if you are creating a subscription
, IntervalLength=1
, IntervalCount=0

, QuantityBehavior='allow' --allowed values: allow, lock, hide
, QuantityDefault=1
, Attributes = '{"mykey-1" : "some-value-1", "mykey-2" : "some-value-2"}'
--, Fulfillments='[ { fullfillment }, { fullfillment } ... ]' --JSON fragment 	
Where Id='abcd'

Update multiple Products (read from CSV file)

Update multiple products from CSV file or other external source (e.g. Microsoft SQL Server, MySQL, Postgresql, ODBC)

UPDATE Products
SOURCE('ODBC',

--File input example (use as to match Column name allowed in Products Table to write)
--'Driver={ZappySys CSV Driver};DataPath=c:\data\products.csv',
--'select P_ID as Id,P_TAXCODE as TaxCode From $'

--Direct input example
'Driver={ZappySys CSV Driver}',
'select ''abcd'' as Id, ''DC010500'' as TaxCode UNION
 select ''xyz'' as Id, ''DC010500'' as TaxCode UNION
 select ''zzz'' as Id, ''DC010500'' as TaxCode 
'
)

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

Update Product

Update product attributes by its ID

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Products
SET 
  Display=''Product ABCD''
, Sku=''PRD-ABCD-01''
, Summary=''Product Abcd **STD**''
, Description=''This product can be used to call **API** supports markdown syntax''
, Action=''**Action** supports markdown''
, TaxCode=''DC010500''
, Image=''https://zappysys.com/api/images/ZappySys-icon.png''
, FulfillmentInstructions=''Thank you for shopping. **Activate** license by using our License App''
, Format=''digital''
, PriceUSD=''101.5''
, PriceEUR=''102.5''
, PriceGBP=''103.5''
, PriceCAD=''104.5''
, PriceNZD=''105.5''
, PriceCHF=''106.5''
, PriceSEK=''107.5''
, PriceCZK=''108.5''
, PriceDKK=''109.5''
, PricePLN=''101.5''
, PriceSGD=''102.5''
, PriceJPY=''103.5''
, PriceCNY=''104.5''
, PriceHKD=''105.5''
, PriceINR=''106.5''
, PriceBRL=''107.5''
, PriceAUD=''108.5''

, Badge=''Badge-1''
, Rank=1
, Trial=14 --how many trial days
, TrialPriceUSD=10.5 

--, Renew=1 --not allowed for update : Only for create (enable subscription)
, Interval=''year'' --allowed values: adhoc, day, week, year, only needed if you are creating a subscription
, IntervalLength=1
, IntervalCount=0

, QuantityBehavior=''allow'' --allowed values: allow, lock, hide
, QuantityDefault=1
, Attributes = ''{"mykey-1" : "some-value-1", "mykey-2" : "some-value-2"}''
--, Fulfillments=''[ { fullfillment }, { fullfillment } ... ]'' --JSON fragment 	
Where Id=''abcd''';

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];

Update multiple Products (read from CSV file)

Update multiple products from CSV file or other external source (e.g. Microsoft SQL Server, MySQL, Postgresql, ODBC)

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Products
SOURCE(''ODBC'',

--File input example (use as to match Column name allowed in Products Table to write)
--''Driver={ZappySys CSV Driver};DataPath=c:\data\products.csv'',
--''select P_ID as Id,P_TAXCODE as TaxCode From $''

--Direct input example
''Driver={ZappySys CSV Driver}'',
''select ''''abcd'''' as Id, ''''DC010500'''' as TaxCode UNION
 select ''''xyz'''' as Id, ''''DC010500'''' as TaxCode UNION
 select ''''zzz'''' as Id, ''''DC010500'''' as TaxCode 
''
)';

EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];

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