Endpoint

Retrieve a single Product

Name

get_single_product

Description

Retrieves the details of an existing product. Supply the unique product Id from either a product creation request or the product list, and Stripe will return the corresponding product information. [API reference]

Related Tables

Products

Parameters

Parameter	Label	Required	Options	Description
Id	Product Id	YES		Unique identifier for the Product

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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`

If the column you are looking for is missing, consider customizing Stripe Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

Required columns that you need to supply are bolded.

Examples

SSIS

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

Lookup a row in 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:

Stripe

Products

Lookup

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Retrieve a single product

SELECT * FROM get_single_product
WHERE Id = 'abcd-1234-id'

Get a Product

Read a product

SELECT * FROM Products
WHERE Id = 'abc'

get_single_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:

Retrieve a single product

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_single_product
WHERE Id = ''abcd-1234-id''';

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

Get a Product

Read a product

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

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];

get_single_product endpoint belongs to Products table(s), and can therefore be used via those table(s).