Stripe Connector
Documentation
Version: 2
Documentation
Home » API Integration Hub » Stripe Connector » EndPoints > List All Products

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