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

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