EndPoint Create a Product
Name
create_product
Description
Creates a new product. [API reference]
Parameters
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(100)
|
100 | False | |
Name |
DT_WSTR
|
nvarchar(100)
|
100 | False | |
Caption |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Description |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Active |
DT_BOOL
|
bit
|
False | ||
Created |
DT_DBTIMESTAMP
|
datetime
|
False | ||
Updated |
DT_DBTIMESTAMP
|
datetime
|
False | ||
Type |
DT_WSTR
|
nvarchar(100)
|
100 | False | |
Object |
DT_WSTR
|
nvarchar(100)
|
100 | False | |
Attributes |
DT_WSTR
|
nvarchar(2000)
|
2000 | False | |
LiveMode |
DT_BOOL
|
bit
|
False | ||
StatementDescription |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
UnitLabel |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsHeight |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsLength |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsWidth |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsWeight |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
URL |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Images |
DT_WSTR
|
nvarchar(2000)
|
2000 | False | |
TaxCodeId |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
TaxCodeName |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PriceUnitAmount |
DT_I8
|
bigint
|
False | ||
PriceRecurringInterval |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PriceRecurringIntervalCount |
DT_I4
|
int
|
False | ||
PriceRecurringUsageType |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Shippable |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
DeactivatedOn |
DT_DBTIMESTAMP
|
datetime
|
False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Name |
DT_WSTR
|
nvarchar(100)
|
100 | False | |
Caption |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Description |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Type |
DT_WSTR
|
nvarchar(100)
|
100 | False | |
Active |
DT_BOOL
|
bit
|
False | ||
StatementDescription |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
UnitLabel |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsHeight |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsLength |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsWidth |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
PackageDimensionsWeight |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
URL |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Shippable |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image1 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image2 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image3 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image4 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image5 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image6 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image7 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False | |
Image8 |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
Required columns that you need to supply are bolded.