Reference

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	Required	Options
Name: Id Label: Product Id Unique identifier for the Product	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
Id	`DT_WSTR`	`nvarchar(100)`	100
Name	`DT_WSTR`	`nvarchar(100)`	100
Caption	`DT_WSTR`	`nvarchar(4000)`	4000
Description	`DT_WSTR`	`nvarchar(4000)`	4000
Active	`DT_BOOL`	`bit`
Created	`DT_DBTIMESTAMP`	`datetime`
Updated	`DT_DBTIMESTAMP`	`datetime`
Type	`DT_WSTR`	`nvarchar(100)`	100
Object	`DT_WSTR`	`nvarchar(100)`	100
Attributes	`DT_WSTR`	`nvarchar(2000)`	2000
LiveMode	`DT_BOOL`	`bit`
StatementDescription	`DT_WSTR`	`nvarchar(4000)`	4000
UnitLabel	`DT_WSTR`	`nvarchar(4000)`	4000
PackageDimensionsHeight	`DT_WSTR`	`nvarchar(4000)`	4000
PackageDimensionsLength	`DT_WSTR`	`nvarchar(4000)`	4000
PackageDimensionsWidth	`DT_WSTR`	`nvarchar(4000)`	4000
PackageDimensionsWeight	`DT_WSTR`	`nvarchar(4000)`	4000
URL	`DT_WSTR`	`nvarchar(4000)`	4000
Images	`DT_WSTR`	`nvarchar(2000)`	2000
TaxCodeId	`DT_WSTR`	`nvarchar(4000)`	4000
TaxCodeName	`DT_WSTR`	`nvarchar(4000)`	4000
PriceUnitAmount	`DT_I8`	`bigint`
PriceRecurringInterval	`DT_WSTR`	`nvarchar(4000)`	4000
PriceRecurringIntervalCount	`DT_I4`	`int`
PriceRecurringUsageType	`DT_WSTR`	`nvarchar(4000)`	4000
Shippable	`DT_WSTR`	`nvarchar(4000)`	4000
DeactivatedOn	`DT_DBTIMESTAMP`	`datetime`

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

Input Columns

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

Required columns that you need to supply are bolded.

Examples

SSIS

Use Stripe Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Products table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Stripe

This connector support read/write operations for Stripe APIs

Stripe

Products

Required Parameters
Product Id	Fill-in the parameter...
Optional Parameters
ContineOn404Error	True

SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Products table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to retrieve a single product:

API Destination - Stripe

This connector support read/write operations for Stripe APIs

Stripe

Products

Lookup

Required Parameters
Product Id	Fill-in the parameter...
Optional Parameters
ContineOn404Error	True

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

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:

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