Subscriptions
Query contract subscriptions for billing insights.
Select
The Subscriptions view does not push any filters to the Talkdesk API. The driver retrieves the full result set from the endpoint and applies any WHERE clause conditions client-side.
For example:
SELECT * FROM Subscriptions
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the subscription record. | |
| AccountId | String |
Account.Id | The Talkdesk account identifier. |
| ContractNumber | String | The number of the contract. | |
| Currency | String | The ISO-4217 currency code for the subscription. | |
| BillingPeriod | String | The billing period (ANNUAL, QUARTER, MONTH, SEMI_ANNUAL, OTHER). | |
| Status | String | The contract status (ACTIVATED, OTHER). | |
| Term | Integer | The duration of the contract in months. | |
| StartDate | Date | The start date of the contract. | |
| EndDate | Date | The end date of the contract. | |
| Edition | String | The Talkdesk CX Cloud Edition on the contract. | |
| AutoRenewal | Boolean | Whether the contract auto-renews. Can be null. | |
| RenewalUplift | Double | The percentage uplift upon renewal. Can be null. | |
| ProductId | String |
Products.Id | The Talkdesk product code. |
| Quantity | Double | The quantity of product in the subscription. | |
| UnitPrice | Double | The price per product unit. | |
| BillingFrequency | String | The billing frequency at line level (ANNUAL, QUARTER, MONTH, SEMI_ANNUAL, OTHER). | |
| PricingModel | String | The pricing model (FIXED_FEE, TIME_AND_MATERIALS, OTHER). | |
| Concurrent | Boolean | Whether billed by simultaneous users rather than licensed users. | |
| Seasonal | Boolean | Whether the subscription is seasonal. | |
| ContractLineStartDate | Date | The start date of the contract line. | |
| ContractLineEndDate | Date | The end date of the contract line. |