ADO.NET Provider for Stripe

Build 23.0.8839


Create, update, delete, and query the available subscription items in Stripe.

Table Specific Information


Server-Side Query Support

The 本製品 uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the 本製品.

  • Id, SubscriptionId and AccountId support the following operator: =.

To query SubscriptionItems table, the Id of the subscription (SubscriptionId) whose items are retrieved is required:

SELECT * FROM SubscriptionItems WHERE SubscriptionId = 'sub_A9WZGVTbvgBJ4t'

In addition to SubscriptionId, provider supports all columns to be used as criteria in the WHERE clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve a SubscriptionItem by specifying its Id:

SELECT * FROM SubscriptionItems WHERE Id = 'sit_A9WZGVTbvgBJ4t'


SubscriptionId and PlanId columns are required to create a new subscription item.

INSERT INTO SubscriptionItems (SubscriptionId, PlanId, ProrationDate, Quantity) VALUES ('sub_1OMqdl2eZvKYlo2CIci8bOT8', 'price_1OPjac2eZvKYlo2Cm8XeR5YQ', '2014-12-12', 10)


To update a subscription item, specify the Id column.

UPDATE SubscriptionItems SET PlanId = 'price_1OPjac2eZvKYlo2Cm8XeR5YQ', ProrationDate = '2014-12-12', Quantity = 12 WHERE Id = 'si_PDakKMQHunYX0k'


To delete a subscription item specify the Id of the item.

DELETE FROM SubscriptionItems WHERE Id = 'sit_A9WZGVTbvgBJ4t'


Name Type ReadOnly References Description
Id [KEY] String True

The Id of the subscription item.

SubscriptionId String False


The Id of the subscription.

PlanId String False


The Id of the plan.

Quantity Double False

The quantity of the plan to which the customer should be subscribed.

Created Datetime True

Creation date.

MetadataAggregate String False

Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format.

PriceId String False


Unique identifier for the price.

Object String True

String representing the object's type. Objects of the same type share the same value.

BillingThresholdsUsageGte Integer False

Usage threshold that triggers the subscription to create an invoice

TaxRatesAggregate String False

The tax rates which apply to this subscription_item. When set, the default_tax_rates on the subscription do not apply to this subscription_item.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
IsProrate Boolean

Flag indicating whether to prorate switching plans during a billing cycle.

ProrationDate Date

If set, the proration will be calculated as though the subscription was updated at the given time.

PaymentBehavior String

Payment Behavior. Valid for INSERT, DELETE and UPDATE.

使用できる値は次のとおりです。allow_incomplete, default_incomplete, error_if_incomplete, pending_if_incomplete

ProrationBehavior String

Determines how to handle prorations when the billing cycle changes. Valid for INSERT, DELETE and UPDATE.

使用できる値は次のとおりです。always_invoice, create_prorations, none

AccountId String

The Id of the connected account to get subscription items for

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839