consumption_usage_histories

Creates, updates, deletes, gets or lists a consumption_usage_histories resource.

Overview

Name	consumption_usage_histories
Type	Resource
Id	ovh.me.consumption_usage_histories

Fields

The following fields are returned by SELECT queries:

list

List of consumptions recorded in a range

Name	Datatype	Description
id	integer	Transaction ID
service_id	integer	Service ID (wire: serviceId)
begin_date	string (date-time)	Begin date (wire: beginDate)
creation_date	string (date-time)	Creation date (wire: creationDate)
elements	array	List of product plan code consumption
end_date	string (date-time)	End date (wire: endDate)
last_update	string (date-time)	Last update (wire: lastUpdate)
price	object	Consumption amount price

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	begin_date, end_date		Get list of transactions between two dates

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"}})
begin_date	string (date-time)	Begin date (wire: beginDate)
end_date	string (date-time)	End date (wire: endDate)

SELECT examples

list

Get list of transactions between two dates

SELECT
id,
service_id,
begin_date,
creation_date,
elements,
end_date,
last_update,
price
FROM ovh.me.consumption_usage_histories
WHERE begin_date = '{{ begin_date }}' -- required
AND end_date = '{{ end_date }}' -- required
;