Subscriptions
Returns subscriptions belonging to the account.
Table-Specific Information
Select
Returns all subscriptions associated with your account.
The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
| Column | Supported Operators |
| Id | =, IN |
| ProductId | = |
| ProductType | = |
| Status | = |
| ScopeId | = |
| ScopeType | = |
| UpdatedAt | = |
SELECT * FROM Subscriptions WHERE Status = 'ACTIVE';
SELECT * FROM Subscriptions WHERE Id IN ('bc/account/subscription/123456','bc/account/subscription/789012');
SELECT * FROM Subscriptions WHERE ProductType = 'APPLICATION';
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID of the subscription. |
| AccountId | String | The ID of the account. |
| ActivationDate | Datetime | The date when the Subscription becomes active, ending any trial period, and billing the Merchant for the first time. |
| BillingInterval | String | The frequency of charges for the Merchant. |
| CreatedAt | Datetime | The date the subscription was created. |
| CurrentPeriodEnd | Datetime | The end of the current billing interval for the Merchant. |
| PricePerIntervalCurrencyCode | String | The currency code for the pricing amount. |
| PricePerIntervalValue | Double | The pricing amount. |
| ProductId | String | The unique ID of the product. |
| ProductType | String | The type of product (for example, APPLICATION).
The allowed values are APPLICATION, NONE. |
| ProductProductLevel | String | A description of the product level, if applicable (for example, application tier for an application). |
| Status | String | The status of this subscription.
The allowed values are ACTIVE, CANCELLED, SUSPENDED. |
| ScopeId | String | The unique ID of the scope. |
| ScopeType | String | The type of scope (for example, STORE).
The allowed values are STORE. |
| UpdatedAt | Datetime | The date the subscription was last updated. |