Skip to main content

service_directories

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

Overview​

Nameservice_directories
TypeResource
Idovh.telephony.service_directories

Fields​

The following fields are returned by SELECT queries:

successful operation

NameDatatypeDescription
namestring
display_first_nameboolean (wire: displayFirstName)
first_namestring (wire: firstName)
way_namestring (wire: wayName)
addressstring
address_extrastring (wire: addressExtra)
apestring
area_codeinteger (wire: areaCode)
birth_datestring (date) (wire: birthDate)
cedexstring
citystring
countrystring
directory_service_codestring (wire: directoryServiceCode)
display_marketing_directoryboolean (wire: displayMarketingDirectory)
display_only_cityboolean (wire: displayOnlyCity)
display_search_reverseboolean (wire: displaySearchReverse)
display_universal_directoryboolean (wire: displayUniversalDirectory)
emailstring
genderstringAll genders a person can choose (female, male)
insee_codeinteger (wire: inseeCode)
legal_formstring (wire: legalForm)
line_descriptionstring (wire: lineDescription)
modification_datestring (wire: modificationDate)
modification_typestring (wire: modificationType)
numberstring
occupationstring
post_boxstring (wire: postBox)
post_codestring (wire: postCode)
siretstring
social_nominationstring (wire: socialNomination)
social_nomination_extrastring (wire: socialNominationExtra)
statusstring
urban_districtstring (wire: urbanDistrict)
way_numberstring (wire: wayNumber)
way_number_extrastring (wire: wayNumberExtra)
way_typestring (wire: wayType)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectbilling_account, service_nameGet the directory listing
updateupdatebilling_account, service_nameUpdate the directory listing
fetch_entreprise_informationsexecbillingAccount, serviceName, entrepriseNumberFetch company information

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"}})
billingAccountstringThe name of your billingAccount
billing_accountstringThe name of your billingAccount (wire: billingAccount)
serviceNamestring
service_namestring (wire: serviceName)

SELECT examples​

Get the directory listing

SELECT
name,
display_first_name,
first_name,
way_name,
address,
address_extra,
ape,
area_code,
birth_date,
cedex,
city,
country,
directory_service_code,
display_marketing_directory,
display_only_city,
display_search_reverse,
display_universal_directory,
email,
gender,
insee_code,
legal_form,
line_description,
modification_date,
modification_type,
number,
occupation,
post_box,
post_code,
siret,
social_nomination,
social_nomination_extra,
status,
urban_district,
way_number,
way_number_extra,
way_type
FROM ovh.telephony.service_directories
WHERE billing_account = '{{ billing_account }}' -- required
AND service_name = '{{ service_name }}' -- required
;

UPDATE examples​

Update the directory listing

UPDATE ovh.telephony.service_directories
SET
address = '{{ address }}',
address_extra = '{{ address_extra }}',
ape = '{{ ape }}',
birth_date = '{{ birth_date }}',
cedex = '{{ cedex }}',
city = '{{ city }}',
country = '{{ country }}',
directory_service_code = '{{ directory_service_code }}',
display_first_name = {{ display_first_name }},
display_marketing_directory = {{ display_marketing_directory }},
display_only_city = {{ display_only_city }},
display_search_reverse = {{ display_search_reverse }},
display_universal_directory = {{ display_universal_directory }},
email = '{{ email }}',
first_name = '{{ first_name }}',
gender = '{{ gender }}',
legal_form = '{{ legal_form }}',
line_description = '{{ line_description }}',
name = '{{ name }}',
occupation = '{{ occupation }}',
post_box = '{{ post_box }}',
post_code = '{{ post_code }}',
siret = '{{ siret }}',
social_nomination = '{{ social_nomination }}',
social_nomination_extra = '{{ social_nomination_extra }}',
urban_district = '{{ urban_district }}',
way_name = '{{ way_name }}',
way_number = '{{ way_number }}',
way_number_extra = '{{ way_number_extra }}',
way_type = '{{ way_type }}'
WHERE
billing_account = '{{ billing_account }}' --required
AND service_name = '{{ service_name }}' --required;

Lifecycle Methods​

EXEC variables use wire (API) names.

Fetch company information

EXEC ovh.telephony.service_directories.fetch_entreprise_informations
@billingAccount='{{ billingAccount }}' --required,
@serviceName='{{ serviceName }}' --required
@@json=
'{
"entrepriseNumber": "{{ entrepriseNumber }}"
}'
;