Subscriptions
Query contract subscriptions for billing insights.
Select
The Subscriptions view does not push any filters to the Talkdesk API. The add-in 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. |