Skip to main content

telephony_portabilities

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

Overview​

Nametelephony_portabilities
TypeResource
Idovh.order.telephony_portabilities

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, call_number, city, country, display_universal_directory, name, offer, social_reason, street_name, street_number, zipbuilding, contact_name, contact_number, desire_date, door, execute_as_soon_as_possible, fiabilisation, first_name, floor, line_to_redirect_alias_to, list_numbers, mobile_phone, rio, siret, special_number_category, stair, street_number_extra, street_type, typeGet prices and contracts information
createinsertbilling_account, call_number, city, country, display_universal_directory, name, offer, social_reason, street_name, street_number, zipCreate 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)
call_numberstringThe number you want to port (wire: callNumber)
citystringAddress city
countrystringCountry of number
display_universal_directorybooleanPublish informations on directory ? (Yellow Pages...) (wire: displayUniversalDirectory)
namestringYour name
offerstringThe offer : individual or company
social_reasonstringYour social reason (wire: socialReason)
street_namestringAddress street name (wire: streetName)
street_numbernumberAddress street number (wire: streetNumber)
zipstringAddress zip code
buildingstringAddress building
contact_namestringYour contact name (wire: contactName)
contact_numberstringYour contact phone number (wire: contactNumber)
desire_datestring (date)The date you want for portability execution. Overridden if flag executeAsSoonAsPossible is set (wire: desireDate)
doorstringAddress door
execute_as_soon_as_possiblebooleanAsk to port the number as soon as possible (wire: executeAsSoonAsPossible)
fiabilisationbooleanAsk for a fiabilisation or not (FR only)
first_namestringYour firstname (wire: firstName)
floornumberAddress floor
line_to_redirect_alias_tostring (phone-number)Redirect ported numbers to the specific line (wire: lineToRedirectAliasTo)
list_numbersstringExtra numbers to be ported, a comma separated list of numbers (wire: listNumbers)
mobile_phonestring (phone-number)Mobile phone to use to text portability status (wire: mobilePhone)
riostringRIO of the number for individual offer
siretstringIf you port under your society, the SIRET number
special_number_categorystringThe special number category (needed if type is special) (wire: specialNumberCategory)
stairnumberAddress stair
street_number_extrastringAddress street number extra : bis, ter, ... (wire: streetNumberExtra)
street_typestringAddress street type (wire: streetType)
typestringThe type of number : landline or special

SELECT examples​

Get prices and contracts information

SELECT
order_id,
contracts,
details,
prices,
url
FROM ovh.order.telephony_portabilities
WHERE billing_account = '{{ billing_account }}' -- required
AND call_number = '{{ call_number }}' -- required
AND city = '{{ city }}' -- required
AND country = '{{ country }}' -- required
AND display_universal_directory = '{{ display_universal_directory }}' -- required
AND name = '{{ name }}' -- required
AND offer = '{{ offer }}' -- required
AND social_reason = '{{ social_reason }}' -- required
AND street_name = '{{ street_name }}' -- required
AND street_number = '{{ street_number }}' -- required
AND zip = '{{ zip }}' -- required
AND building = '{{ building }}'
AND contact_name = '{{ contact_name }}'
AND contact_number = '{{ contact_number }}'
AND desire_date = '{{ desire_date }}'
AND door = '{{ door }}'
AND execute_as_soon_as_possible = '{{ execute_as_soon_as_possible }}'
AND fiabilisation = '{{ fiabilisation }}'
AND first_name = '{{ first_name }}'
AND floor = '{{ floor }}'
AND line_to_redirect_alias_to = '{{ line_to_redirect_alias_to }}'
AND list_numbers = '{{ list_numbers }}'
AND mobile_phone = '{{ mobile_phone }}'
AND rio = '{{ rio }}'
AND siret = '{{ siret }}'
AND special_number_category = '{{ special_number_category }}'
AND stair = '{{ stair }}'
AND street_number_extra = '{{ street_number_extra }}'
AND street_type = '{{ street_type }}'
AND type = '{{ type }}'
;

INSERT examples​

Create order

INSERT INTO ovh.order.telephony_portabilities (
building,
call_number,
city,
contact_name,
contact_number,
country,
desire_date,
display_universal_directory,
door,
execute_as_soon_as_possible,
fiabilisation,
first_name,
floor,
line_to_redirect_alias_to,
list_numbers,
mobile_phone,
name,
offer,
rio,
siret,
social_reason,
special_number_category,
stair,
street_name,
street_number,
street_number_extra,
street_type,
type,
zip,
billing_account
)
SELECT
'{{ building }}',
'{{ call_number }}' /* required */,
'{{ city }}' /* required */,
'{{ contact_name }}',
'{{ contact_number }}',
'{{ country }}' /* required */,
'{{ desire_date }}',
{{ display_universal_directory }} /* required */,
'{{ door }}',
{{ execute_as_soon_as_possible }},
{{ fiabilisation }},
'{{ first_name }}',
{{ floor }},
'{{ line_to_redirect_alias_to }}',
'{{ list_numbers }}',
'{{ mobile_phone }}',
'{{ name }}' /* required */,
'{{ offer }}' /* required */,
'{{ rio }}',
'{{ siret }}',
'{{ social_reason }}' /* required */,
'{{ special_number_category }}',
{{ stair }},
'{{ street_name }}' /* required */,
{{ street_number }} /* required */,
'{{ street_number_extra }}',
'{{ street_type }}',
'{{ type }}',
'{{ zip }}' /* required */,
'{{ billing_account }}'
RETURNING
order_id,
contracts,
details,
prices,
url
;