EndPoint List All Products

Name

get_products

Description

Returns a list of your products. The products are returned sorted by creation date, with the most recently created products appearing first. [API reference]

Parameters

Parameter

Label

Required

Options

Description

active

Active

Option	Value
True	True
False	False

Only return products that are active or inactive (e.g., pass false to list all inactive products).

created_gt

Created later than (yyyy-MM-dd)

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
2022-01-31	2022-01-31
2022-01-31 23:59:59	2022-01-31 23:59:59

Return results where the created field is greater than this value.

created_gte

Created on or later than (yyyy-MM-dd)

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
2022-01-31	2022-01-31
2022-01-31 23:59:59	2022-01-31 23:59:59

Return results where the created field is greater than or equal to this value.

created_lt

Created earlier than (yyyy-MM-dd)

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
2022-01-31	2022-01-31
2022-01-31 23:59:59	2022-01-31 23:59:59

Return results where the created field is less than this value.

created_lte

Created on or earlier than (yyyy-MM-dd)

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
2022-01-31	2022-01-31
2022-01-31 23:59:59	2022-01-31 23:59:59

Return results where the created field is less than or equal to this value.

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
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

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

List All Products using API Source

Stripe

List All Products

SSIS API Source - Read from table or endpoint

List All Products using API Destination

Stripe

List All Products