EndPoint Update Product

Name

put_product

Description

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`

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