EndPoint Update Product

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

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.