Table Products

Description

No description available

Parameters

Parameter	Label	Required	Options	Description	Help
There are no parameters

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.

Method	Supported	Reference EndPoint
SELECT		get_products
INSERT		create_product
UPDATE		update_product
UPSERT
DELETE		delete_product
LOOKUP		get_single_product

Examples

SSIS

Use Stripe Connector in API Source component to read data or in API Destination component to read/write data:

Read from Products table using API Source

Stripe

Products

SSIS API Source - Read from table or endpoint

Read/write to Products table using API Destination

Stripe

Products

Select

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get all Products

Read all products

SELECT * FROM Products

Get a Product

Read a product

SELECT * FROM Products
WHERE Id = 'abc'

Update a Product

Read a product

UPDATE Products
SET [name] = 'new name'
WHERE Id = 'abc'

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

Update a Product

Product Update example. When supply Image1,Image2... it will reset previous images.

UPDATE Products
SET   [Name]='SSIS PowerPack 3 - Updated'
	, [Caption]='Caption-updated'
	, [Description]='Desc-updated'
	--, [UnitLabel] --only when product type=service
	, [Active]='true'
	, [PackageDimensionsHeight]=12
	, [PackageDimensionsWidth]=13
	, [PackageDimensionsLength]=14
	, [PackageDimensionsWeight]=1122
	, [URL]='https://zappysys.com/products/ssis-powerpack/?updated=1'
	, [Image1]='https://zappysys.com/images/tech/web-api-logo.png?updated=1'
	, [Image2]='https://zappysys.com/images/tech/xml-logo.png?updated=1'
WHERE Id='prod_MiSJzGZ8PDM9uh'

Delete a Product

Delete a product

DELETE FROM Products
WHERE Id = 'abc'

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get all Products

Read all products

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Products';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];

Get a Product

Read a product

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Products
WHERE Id = ''abc''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];

Update a Product

Read a product

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Products
SET [name] = ''new name''
WHERE Id = ''abc''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_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 [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];

Update a Product

Product Update example. When supply Image1,Image2... it will reset previous images.

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Products
SET   [Name]=''SSIS PowerPack 3 - Updated''
	, [Caption]=''Caption-updated''
	, [Description]=''Desc-updated''
	--, [UnitLabel] --only when product type=service
	, [Active]=''true''
	, [PackageDimensionsHeight]=12
	, [PackageDimensionsWidth]=13
	, [PackageDimensionsLength]=14
	, [PackageDimensionsWeight]=1122
	, [URL]=''https://zappysys.com/products/ssis-powerpack/?updated=1''
	, [Image1]=''https://zappysys.com/images/tech/web-api-logo.png?updated=1''
	, [Image2]=''https://zappysys.com/images/tech/xml-logo.png?updated=1''
WHERE Id=''prod_MiSJzGZ8PDM9uh''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];

Delete a Product

Delete a product

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Products
WHERE Id = ''abc''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_STRIPE_IN_DATA_GATEWAY];