Skip to main content

telephony_number_nogeographics

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

Overview​

Nametelephony_number_nogeographics
TypeResource
Idovh.order.telephony_number_nogeographics

Fields​

The following fields are returned by SELECT queries:

successful operation

NameDatatypeDescription
order_idintegerIdentifier of the order (wire: orderId)
contractsarrayList of contracts related to the order
detailsarrayDetails of the order
pricesobjectPrices of the order including with and without taxes
urlstringURL to download the order

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectbilling_account, country, display_universal_directory, legalform, offer, retractationape, city, email, firstname, name, organisation, phone, pool, siret, social_nomination, specific_number, street_name, street_number, zipGet prices and contracts information
createinsertbilling_account, country, display_universal_directory, legalform, offer, retractationCreate order

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.

NameDatatypeDescription
api_hoststringThe 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_accountstringThe name of your billingAccount (wire: billingAccount)
countrystringNumber country
display_universal_directorybooleanPublish contact informations on universal directories (wire: displayUniversalDirectory)
legalformstringLegal form
offerstringNumber offer
retractationbooleanRetractation rights if set
apestringCompany ape
citystringContact city
emailstring
firstnamestringContact firstname
namestringContact name
organisationstringContact organisation
phonestringContact phone
poolintegerNumber of alias in case of pool
siretstringCompany siret
social_nominationstringCompany social nomination (wire: socialNomination)
specific_numberstring (phone-number)Preselected standard number (wire: specificNumber)
street_namestringStreet name (wire: streetName)
street_numberstringStreet number (wire: streetNumber)
zipstringContact zip

SELECT examples​

Get prices and contracts information

SELECT
order_id,
contracts,
details,
prices,
url
FROM ovh.order.telephony_number_nogeographics
WHERE billing_account = '{{ billing_account }}' -- required
AND country = '{{ country }}' -- required
AND display_universal_directory = '{{ display_universal_directory }}' -- required
AND legalform = '{{ legalform }}' -- required
AND offer = '{{ offer }}' -- required
AND retractation = '{{ retractation }}' -- required
AND ape = '{{ ape }}'
AND city = '{{ city }}'
AND email = '{{ email }}'
AND firstname = '{{ firstname }}'
AND name = '{{ name }}'
AND organisation = '{{ organisation }}'
AND phone = '{{ phone }}'
AND pool = '{{ pool }}'
AND siret = '{{ siret }}'
AND social_nomination = '{{ social_nomination }}'
AND specific_number = '{{ specific_number }}'
AND street_name = '{{ street_name }}'
AND street_number = '{{ street_number }}'
AND zip = '{{ zip }}'
;

INSERT examples​

Create order

INSERT INTO ovh.order.telephony_number_nogeographics (
ape,
city,
country,
display_universal_directory,
email,
firstname,
legalform,
name,
offer,
organisation,
phone,
pool,
retractation,
siret,
social_nomination,
specific_number,
street_name,
street_number,
zip,
billing_account
)
SELECT
'{{ ape }}',
'{{ city }}',
'{{ country }}' /* required */,
{{ display_universal_directory }} /* required */,
'{{ email }}',
'{{ firstname }}',
'{{ legalform }}' /* required */,
'{{ name }}',
'{{ offer }}' /* required */,
'{{ organisation }}',
'{{ phone }}',
{{ pool }},
{{ retractation }} /* required */,
'{{ siret }}',
'{{ social_nomination }}',
'{{ specific_number }}',
'{{ street_name }}',
'{{ street_number }}',
'{{ zip }}',
'{{ billing_account }}'
RETURNING
order_id,
contracts,
details,
prices,
url
;