Endpoint List All Subscriptions Items
Name
get_subscription_items
Description
Returns a list of subscriptions items. [API reference]
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: Subscription Id Unique identifier for the Subscription |
YES |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(180)
|
180 | |
| SubscriptionId |
DT_WSTR
|
nvarchar(180)
|
180 | |
| ProductId |
DT_WSTR
|
nvarchar(100)
|
100 | |
| Quantity |
DT_I4
|
int
|
||
| Object |
DT_WSTR
|
nvarchar(120)
|
120 | |
| BillingThresholds |
DT_WSTR
|
nvarchar(1000)
|
1000 | |
| Created |
DT_DBTIMESTAMP
|
datetime
|
||
| PriceID |
DT_WSTR
|
nvarchar(255)
|
255 | |
| PriceObject |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceActive |
DT_BOOL
|
bit
|
||
| PriceBillingScheme |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceCreated |
DT_DBTIMESTAMP
|
datetime
|
||
| PriceCurrency |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceCustomUnitAmount |
DT_I8
|
bigint
|
||
| PriceLivemode |
DT_BOOL
|
bit
|
||
| PriceLookupKey |
DT_WSTR
|
nvarchar(1020)
|
1020 | |
| PriceNickname |
DT_WSTR
|
nvarchar(1020)
|
1020 | |
| PriceRecurringAggregateUsage |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceRecurringInterval |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceRecurringIntervalCount |
DT_I8
|
bigint
|
||
| PriceRecurringTrialPeriodDays |
DT_I8
|
bigint
|
||
| PriceRecurringUsageType |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceTaxBehaviour |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceTiersMode |
DT_WSTR
|
nvarchar(1020)
|
1020 | |
| PriceTransformQuantity |
DT_I4
|
int
|
||
| PriceType |
DT_WSTR
|
nvarchar(100)
|
100 | |
| PriceUnitAmount |
DT_I8
|
bigint
|
||
| PriceUnitAmountDecimal |
DT_WSTR
|
nvarchar(100)
|
100 | |
| TaxRates |
DT_WSTR
|
nvarchar(1000)
|
1000 |
If the column you are looking for is missing, consider customizing Stripe Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | 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 or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - Stripe
This connector support read/write operations for Stripe APIs
Stripe
List All Subscriptions Items
| Required Parameters | |
|---|---|
| Subscription Id | Fill-in the parameter... |
| Optional Parameters | |
| ContineOn404Error | True |
API Destination
API Destination - Stripe
This connector support read/write operations for Stripe APIs
Stripe
List All Subscriptions Items
| Required Parameters | |
|---|---|
| Subscription Id | Fill-in the parameter... |
| Optional Parameters | |
| ContineOn404Error | True |
ODBC application
Use these SQL queries in your ODBC application data source:
List all subscriptions items
SELECT * FROM get_subscription_items
WHERE SubscriptionId = 'abcd-1234-subscriptionid'SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
List all subscriptions items
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_subscription_items
WHERE SubscriptionId = ''abcd-1234-subscriptionid''';
EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];