SubscriptionSchedules
Retrieves the list of your subscription schedules.
Table Specific Information
Select
Server-Side Query Support
The connector 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 connector.
- 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'
Columns
| 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. |