history_consumptions
Creates, updates, deletes, gets or lists a history_consumptions resource.
Overview​
| Name | history_consumptions |
| Type | Resource |
| Id | ovh.telephony.history_consumptions |
Fields​
The following fields are returned by SELECT queries:
- get
- list
successful operation
| Name | Datatype | Description |
|---|---|---|
date | string (date) | |
price | object | Price with it's currency and textual representation |
price_outplan | object | Price with it's currency and textual representation (wire: priceOutplan) |
status | string | Billing progress status (doing, done, error, todo) |
Previous billed consumptions
| Name | Datatype | Description |
|---|---|---|
date | string (date) | |
price | object | Price with it's currency and textual representation |
price_outplan | object | Price with it's currency and textual representation (wire: priceOutplan) |
status | string | Billing progress status (doing, done, error, todo) |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | billing_account, date | Get a billed consumption | |
list | select | billing_account | x_pagination_mode | List billed consumptions |
Parameters​
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
api_host | string | The OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}}) |
billing_account | string | The name of your billingAccount (wire: billingAccount) |
date | string (date) | |
x_pagination_mode | string | Sent as CachedObjectList-Pages by default so the list returns the full objects rather than their identifiers. (wire: X-Pagination-Mode) |
SELECT examples​
- get
- list
Get a billed consumption
SELECT
date,
price,
price_outplan,
status
FROM ovh.telephony.history_consumptions
WHERE billing_account = '{{ billing_account }}' -- required
AND date = '{{ date }}' -- required
;
List billed consumptions
SELECT
date,
price,
price_outplan,
status
FROM ovh.telephony.history_consumptions
WHERE billing_account = '{{ billing_account }}' -- required
AND x_pagination_mode = '{{ x_pagination_mode }}'
;