UsageRecords
Query Usage Records in Twilio.
View-Specific Information
SELECT
The driver uses the Twilio API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.
| Column | Supported Operators |
| Category | = |
| StartDate | =, >, >=, <, <= |
| EndDate | =, >, >=, <, <= |
| Interval | = |
Note: Interval should be used as an escaped string, i.e [Interval].
For example, the following queries are processed server-side:
SELECT * FROM UsageRecords WHERE [Interval] = 'Today'
Columns
| Name | Type | References | Description |
| AccountSid | String | The account Id of the usage record. | |
| Category | String | The category of the usage record. For example, calls, sms, phonenumbers, recordings, transcriptions, and totalprice. | |
| Description | String | The description of the usage record. | |
| StartDate | Date | The start date of the usage record. You can also specify an offset, such as -30days. | |
| EndDate | Date | The end date of the usage record. You can also specify an offset, such as -1year. | |
| Count | Integer | The number of usage events. For example: the number of calls. | |
| CountUnit | String | The type of the usage events counted. For example: calls and messages. | |
| Usage | Double | The amount of usage. | |
| UsageUnit | String | The usage unit. For example: minutes and messages. | |
| Price | Decimal | The total price of the usage. | |
| PriceUnit | String | The currency of the price. | |
| ApiVersion | String | The API version of the usage record. | |
| Uri | String | The URI of the usage record. | |
| AsOf | Datetime | Usage records up to date as of this timestamp, formatted as YYYY-MM-DDTHH:MM:SS+00:00 | |
| SubresourceUris | String | A list of related resources identified by their URIs. For more information, see List Subresources. |
Pseudocolumns
Pseudocolumn fields can be used in SELECT, INSERT, and UPDATE statements to provide additional control over data retrieval and modification in the data source.
| Name | Type | Description | |
| Interval | String | The interval of records. Should be used as an escaped string in Where clause, i.e [Interval]. The allowed values are Daily, Monthly, Yearly, AllTime, Today, Yesterday, LastMonth, and ThisMonth
The allowed values are Daily, Monthly, Yearly, AllTime, Today, Yesterday, LastMonth, ThisMonth. |