Reference

Table Products

Description

No description available

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

API Source - Stripe
Read and write Stripe data effortlessly. Manage customers, products, subscriptions, and invoices — almost no coding required.
Stripe
Products
Optional Parameters
Active
Created later than (yyyy-MM-dd)
Created on or later than (yyyy-MM-dd)
Created earlier than (yyyy-MM-dd)
Created on or earlier than (yyyy-MM-dd)
SSIS API Source - Read from table or endpoint

Read/write to Products table using API Destination

API Destination - Stripe
Read and write Stripe data effortlessly. Manage customers, products, subscriptions, and invoices — almost no coding required.
Stripe
Products
Select
Optional Parameters
Active
Created later than (yyyy-MM-dd)
Created on or later than (yyyy-MM-dd)
Created earlier than (yyyy-MM-dd)
Created on or earlier than (yyyy-MM-dd)
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read products

<p>Reads all records from the <code>Products</code> table. This example demonstrates a basic SELECT query to retrieve a complete list of products from the Stripe account.</p> 

SELECT * FROM Products

Read a product

<p>Reads a single product record from the <code>Products</code> table by specifying the <code>Id</code>. This example demonstrates how to filter results to a specific product using the WHERE clause.</p> 

SELECT * FROM Products
WHERE Id = 'abc'

Update a product name

<p>Updates the name of a product in the <code>Products</code> table. This example shows a simple update operation targeting a single column for a specific product identified by its <code>Id</code>.</p> 

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

Create a product

<p>Creates a new product record in the <code>Products</code> table. This example demonstrates how to use the <code>INSERT INTO</code> statement to specify product details such as name, description, dimensions, and images.</p> 

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

<p>Updates an existing product record in the <code>Products</code> table. This example demonstrates updating multiple fields, including images and dimensions. Note that supplying image fields will reset any previously existing images for the product.</p> 

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

<p>Deletes a product record from the <code>Products</code> table. This example demonstrates how to remove a product using the <code>DELETE FROM</code> statement with a specific <code>Id</code> in the WHERE clause.</p> 

DELETE FROM Products
WHERE Id = 'abc'

SQL Server

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

Read products

<p>Reads all records from the <code>Products</code> table. This example demonstrates a basic SELECT query to retrieve a complete list of products from the Stripe account.</p> 

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Read a product

<p>Reads a single product record from the <code>Products</code> table by specifying the <code>Id</code>. This example demonstrates how to filter results to a specific product using the WHERE clause.</p> 

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Update a product name

<p>Updates the name of a product in the <code>Products</code> table. This example shows a simple update operation targeting a single column for a specific product identified by its <code>Id</code>.</p> 

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Create a product

<p>Creates a new product record in the <code>Products</code> table. This example demonstrates how to use the <code>INSERT INTO</code> statement to specify product details such as name, description, dimensions, and images.</p> 

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];

Update a product

<p>Updates an existing product record in the <code>Products</code> table. This example demonstrates updating multiple fields, including images and dimensions. Note that supplying image fields will reset any previously existing images for the product.</p> 

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 [LS_TO_STRIPE_IN_GATEWAY];

Delete a product

<p>Deletes a product record from the <code>Products</code> table. This example demonstrates how to remove a product using the <code>DELETE FROM</code> statement with a specific <code>Id</code> in the WHERE clause.</p> 

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];