service_voice_consumptions

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

Overview

Name	service_voice_consumptions
Type	Resource
Id	ovh.telephony.service_voice_consumptions

Fields

The following fields are returned by SELECT queries:

get

successful operation

Name	Datatype	Description
consumption_id	integer	(wire: consumptionId)
called	string (phone-number)	Phone number
calling	string (phone-number)	Phone number
country_suffix	string	Country suffix destination (wire: countrySuffix)
creation_datetime	string (date-time)	(wire: creationDatetime)
designation	string	Description of the destination
destination_type	string	Consumption destination type (landline, mobile, special) (wire: destinationType)
dialed	string (phone-number)	Phone number
duration	integer
hangup_nature	string	Information about hangup cause (wire: hangupNature)
plan_type	string	Consumption plan type (outplan, priceplan) (wire: planType)
price_without_tax	object	Price with it's currency and textual representation (wire: priceWithoutTax)
way_type	string	Consumption way type (incoming, outgoing, transfer) (wire: wayType)

list

Call delivery record

Name	Datatype	Description
consumption_id	integer	(wire: consumptionId)
called	string (phone-number)	Phone number
calling	string (phone-number)	Phone number
country_suffix	string	Country suffix destination (wire: countrySuffix)
creation_datetime	string (date-time)	(wire: creationDatetime)
designation	string	Description of the destination
destination_type	string	Consumption destination type (landline, mobile, special) (wire: destinationType)
dialed	string (phone-number)	Phone number
duration	integer
hangup_nature	string	Information about hangup cause (wire: hangupNature)
plan_type	string	Consumption plan type (outplan, priceplan) (wire: planType)
price_without_tax	object	Price with it's currency and textual representation (wire: priceWithoutTax)
way_type	string	Consumption way type (incoming, outgoing, transfer) (wire: wayType)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	billing_account, consumption_id, service_name		Get a call record
list	select	billing_account, service_name	creation_datetime.from, creation_datetime.to, destination_type, plan_type, way_type, x_pagination_mode	List call records

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)
consumption_id	integer	(wire: consumptionId)
service_name	string	(wire: serviceName)
creation_datetime.from	string (date-time)	Filter the value of creationDatetime property (>=) (wire: creationDatetime.from)
creation_datetime.to	string (date-time)	Filter the value of creationDatetime property (<=) (wire: creationDatetime.to)
destination_type	string	Filter the value of destinationType property (=) (wire: destinationType)
plan_type	string	Filter the value of planType property (=) (wire: planType)
way_type	string	Filter the value of wayType property (=) (wire: wayType)
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

Get a call record

SELECT
consumption_id,
called,
calling,
country_suffix,
creation_datetime,
designation,
destination_type,
dialed,
duration,
hangup_nature,
plan_type,
price_without_tax,
way_type
FROM ovh.telephony.service_voice_consumptions
WHERE billing_account = '{{ billing_account }}' -- required
AND consumption_id = '{{ consumption_id }}' -- required
AND service_name = '{{ service_name }}' -- required
;

list

List call records

SELECT
consumption_id,
called,
calling,
country_suffix,
creation_datetime,
designation,
destination_type,
dialed,
duration,
hangup_nature,
plan_type,
price_without_tax,
way_type
FROM ovh.telephony.service_voice_consumptions
WHERE billing_account = '{{ billing_account }}' -- required
AND service_name = '{{ service_name }}' -- required
AND creation_datetime.from = '{{ creation_datetime.from }}'
AND creation_datetime.to = '{{ creation_datetime.to }}'
AND destination_type = '{{ destination_type }}'
AND plan_type = '{{ plan_type }}'
AND way_type = '{{ way_type }}'
AND x_pagination_mode = '{{ x_pagination_mode }}'
;