Create a Product
Name
create_product
Description
Creates a new product. [API reference]
Related Tables
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 |
Examples
SSIS
Use Stripe Connector in API Source component to read data or in API Destination component to read/write data:
Insert into 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:

ODBC application
Use these SQL queries in your ODBC application data source:
Create a product
SELECT * FROM create_product
WITH
(
"name" = 'abcd-1234-name',
"type" = 'abcd-1234-type'
)
Inserts a Product
Inserts a product
INSERT INTO Products
( [Name]
, [Caption]
, [Description]
, [Type]
--, [UnitLabel] --only when product type=service
, [Active]
, [PackageDimensionsHeight]
, [PackageDimensionsWidth]
, [PackageDimensionsLength]
, [PackageDimensionsWeight]
, [URL]
, [Image1]
, [Image2]
, [Image3]
)
VALUES('SSIS PowerPack 3'
, 'SSIS Caption 3'
, 'SSIS PowerPack description long ....'
, 'good' --or service
--, 'Unit label' --only when product type=service
, 'True' --active ?
, '12'
, '13'
, '14'
, '1000'
, 'https://zappysys.com/products/ssis-powerpack/'
, 'https://zappysys.com/images/tech/web-api-logo.png'
, 'https://zappysys.com/images/tech/xml-logo.png'
, 'https://zappysys.com/images/tech/salesforce-logo.png'
)
create_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:
Create a product
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM create_product
WITH
(
"name" = ''abcd-1234-name'',
"type" = ''abcd-1234-type''
)';
EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];
Inserts a Product
Inserts a product
DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Products
( [Name]
, [Caption]
, [Description]
, [Type]
--, [UnitLabel] --only when product type=service
, [Active]
, [PackageDimensionsHeight]
, [PackageDimensionsWidth]
, [PackageDimensionsLength]
, [PackageDimensionsWeight]
, [URL]
, [Image1]
, [Image2]
, [Image3]
)
VALUES(''SSIS PowerPack 3''
, ''SSIS Caption 3''
, ''SSIS PowerPack description long ....''
, ''good'' --or service
--, ''Unit label'' --only when product type=service
, ''True'' --active ?
, ''12''
, ''13''
, ''14''
, ''1000''
, ''https://zappysys.com/products/ssis-powerpack/''
, ''https://zappysys.com/images/tech/web-api-logo.png''
, ''https://zappysys.com/images/tech/xml-logo.png''
, ''https://zappysys.com/images/tech/salesforce-logo.png''
)';
EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];
create_product
endpoint belongs to
Products
table(s), and can therefore be used via those table(s).