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]

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`

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:

Retrieve a single Product using API Source

Stripe

Retrieve a single Product

SSIS API Source - Read from table or endpoint

Retrieve a single Product using API Destination

Stripe

Retrieve a single Product