CData Python Connector for Stripe

Build 23.0.8839


Retrieves the list of your subscription schedules.

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 本製品.

  • Customer support the following operator: =.
  • CanceledAt support the following operator: =.
  • CompletedAt support the following operator: =.
  • Created support the following operator: =.
  • ReleasedAt support the following operator: =.

The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

To query the SubscriptionSchedules we can try the below queries.

SELECT * from SubscriptionSchedules

SELECT * from SubscriptionSchedules where Created = '2024-01-18 02:16:47.0'


Name Type References Description
Id [KEY] String Unique identifier for the object.
Application String ID of the Connect Application that created the schedule.
CanceledAt Datetime Time at which the subscription schedule was canceled. Measured in seconds since the Unix epoch.
CompletedAt Datetime Time at which the subscription schedule was completed. Measured in seconds since the Unix epoch.
Created Datetime Time at which the object was created. Measured in seconds since the Unix epoch.
CurrentPhaseEndDate Datetime The end of this phase of the subscription schedule.
CurrentPhaseStartDate Datetime The start of this phase of the subscription schedule.
Customer String ID of the customer who owns the subscription schedule.
MetadataAggregate String The set of key/value pairs that you can attach to a an object.
Phases String Configuration for the subscription schedules phases.
Status String The present status of the subscription schedule.
Subscription String ID of the subscription managed by the subscription schedule.
Object String String representing the objects type. Objects of the same type share the same value.
DefaultSettingsApplicationFeePercent Decimal A non-negative decimal between 0 and 100, with at most two decimal places.
DefaultSettingsAutomaticTaxEnabled Boolean Whether Stripe automatically computes tax on invoices created during this phase.
DefaultSettingsAutomaticTaxLiability String The account thats liable for tax.
DefaultSettingsBillingCycleAnchor String Possible values are phase_start or automatic.
DefaultSettingsBillingThresholds String Define thresholds at which an invoice will be sent, and the subscription advanced to a new billing period
DefaultSettingsCollectionMethod String Either charge_automatically, or send_invoice.
DefaultSettingsDefaultPaymentMethod String ID of the default payment method for the subscription schedule.
DefaultSettingsDescription String Subscription description, meant to be displayable to the customer.
DefaultSettingsInvoiceSettings String The subscription schedules default invoice settings.
DefaultSettingsOnBehalfOf String The account (if any) the charge was made on behalf of for charges associated with the schedules subscription.
DefaultSettingsTransferData String The account (if any) the associated subscriptions payments will be attributed to for tax reporting, and where funds from each payment will be transferred to for each of the subscriptions invoices.
EndBehavior String Behavior of the subscription schedule and underlying subscription when it ends.
Livemode Boolean Has the value true if the object exists in live mode or the value false if the object exists in test mode.
ReleasedAt Datetime Time at which the subscription schedule was released. Measured in seconds since the Unix epoch.
ReleasedSubscription String ID of the subscription once managed by the subscription schedule (if it is released).
TestClock String ID of the test clock this subscription schedule belongs to.

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