Skip to main content

accounts

Creates, updates, deletes, gets or lists an accounts resource.

Overview​

Nameaccounts
TypeResource
Idovh.me.accounts

Fields​

The following fields are returned by SELECT queries:

successful operation

NameDatatypeDescription
namestringCustomer name
display_namestringDisplay name shown instead of the organisation name. (wire: displayName)
addressstringAddress of nichandle
areastringArea of nichandle
birth_citystringCity of birth (wire: birthCity)
birth_daystringBirth date (wire: birthDay)
citystringCity of nichandle
company_national_identification_numberstringCompany National Identification Number (wire: companyNationalIdentificationNumber)
complementary_addressstringComplementary Address (wire: complementaryAddress)
corporation_typestringCorporation type (wire: corporationType)
countrystringCustomer country (AC, AD, AE, AF, AG, AI, AL, AM, AO, AQ, AR, AS, AT, AU, AW, AX, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BL, BM, BN, BO, BQ, BR, BS, BT, BW, BY, BZ, CA, CC, CD, CF, CG, CH, CI, CK, CL, CM, CN, CO, CR, CU, CV, CW, CX, CY, CZ, DE, DG, DJ, DK, DM, DO, DZ, EA, EC, EE, EG, EH, ER, ES, ET, FI, FJ, FK, FM, FO, FR, GA, GB, GD, GE, GF, GG, GH, GI, GL, GM, GN, GP, GQ, GR, GS, GT, GU, GW, GY, HK, HN, HR, HT, HU, IC, ID, IE, IL, IM, IN, IO, IQ, IR, IS, IT, JE, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KY, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MF, MG, MH, MK, ML, MM, MN, MO, MP, MQ, MR, MS, MT, MU, MV, MW, MX, MY, MZ, NA, NC, NE, NF, NG, NI, NL, NO, NP, NR, NU, NZ, OM, PA, PE, PF, PG, PH, PK, PL, PM, PN, PR, PS, PT, PW, PY, QA, RE, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SH, SI, SJ, SK, SL, SM, SN, SO, SR, SS, ST, SV, SX, SY, SZ, TA, TC, TD, TF, TG, TH, TJ, TK, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, UM, UNKNOWN, US, UY, UZ, VA, VC, VE, VG, VI, VN, VU, WF, WS, XK, YE, YT, ZA, ZM, ZW)
currencyobjectCustomer currency
customer_codestringYour customer code (a numerical value used for identification when contacting support via phone call) (wire: customerCode)
einvoicing_billing_addressstringDefault e-invoicing billing address (wire: einvoicingBillingAddress)
emailstringEmail address
faxstringFax number
firstnamestringFirst name
italian_sdistringItalian SDI (wire: italianSDI)
kyc_validatedbooleanKYC validation state (wire: kycValidated)
languagestringLanguage (cs_CZ, de_DE, en_AU, en_CA, en_GB, en_IE, en_US, es_ES, fi_FI, fr_CA, fr_FR, fr_MA, fr_SN, fr_TN, it_IT, lt_LT, nl_NL, pl_PL, pt_PT)
legalformstringCustomer legal form (administration, association, corporation, individual, other, personalcorporation)
national_identification_numberstringNational Identification Number (wire: nationalIdentificationNumber)
nichandlestringCustomer identifier
organisationstringName of organisation
ovh_companystringOVH company (kimsufi, ovh, soyoustart) (wire: ovhCompany)
ovh_subsidiarystringOVH subsidiary (CZ, DE, ES, EU, FI, FR, GB, IE, IT, LT, MA, NL, PL, PT, SN, TN) (wire: ovhSubsidiary)
phonestringPhone number
phone_countrystringCountries a nichandle can choose (AC, AD, AE, AF, AG, AI, AL, AM, AO, AQ, AR, AS, AT, AU, AW, AX, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BL, BM, BN, BO, BQ, BR, BS, BT, BW, BY, BZ, CA, CC, CD, CF, CG, CH, CI, CK, CL, CM, CN, CO, CR, CU, CV, CW, CX, CY, CZ, DE, DG, DJ, DK, DM, DO, DZ, EA, EC, EE, EG, EH, ER, ES, ET, FI, FJ, FK, FM, FO, FR, GA, GB, GD, GE, GF, GG, GH, GI, GL, GM, GN, GP, GQ, GR, GS, GT, GU, GW, GY, HK, HN, HR, HT, HU, IC, ID, IE, IL, IM, IN, IO, IQ, IR, IS, IT, JE, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KY, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MF, MG, MH, MK, ML, MM, MN, MO, MP, MQ, MR, MS, MT, MU, MV, MW, MX, MY, MZ, NA, NC, NE, NF, NG, NI, NL, NO, NP, NR, NU, NZ, OM, PA, PE, PF, PG, PH, PK, PL, PM, PN, PR, PS, PT, PW, PY, QA, RE, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SH, SI, SJ, SK, SL, SM, SN, SO, SR, SS, ST, SV, SX, SY, SZ, TA, TC, TD, TF, TG, TH, TJ, TK, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, UM, UNKNOWN, US, UY, UZ, VA, VC, VE, VG, VI, VN, VU, WF, WS, XK, YE, YT, ZA, ZM, ZW) (wire: phoneCountry)
phone_typestringType of phone(mobile, landline) (landline, mobile) (wire: phoneType)
purpose_of_purchasestringCustomer purpose of purchase (wire: purposeOfPurchase)
sexstringGender (female, male)
spare_emailstringSpare email (wire: spareEmail)
statestringNichandle state (complete, incomplete)
vatstringVAT number
zipstringZipcode

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectGet details about your nichandle
updateupdateUpdate details of your nichandle
accountexecCreate a new account whose billing will be linked to your current account's billing (Alpha version)
api_log_urlexeckindGenerate a temporary URL to retrieve logs
carbon_calculator_csvexecendMonth, startMonthCreate a carbon footprint csv generation task
carbon_calculator_pdfexecmonthCreate a carbon footprint pdf generation task
change_emailexecnewEmailInitiate an email change procedure
change_passwordexecInitiate a password change procedure
credit_codeexecinputCodeValidate a code to generate associated credit movement
geolocationexecFetch visitor country & region
mailing_list_subscribeexecemail, mailingListSubscribe an email to a restricted mailing list
password_recoverexecovhCompany, ovhIdRequest a password recover
voucher_check_validityexecvoucherVerify existing voucher

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"}})

SELECT examples​

Get details about your nichandle

SELECT
name,
display_name,
address,
area,
birth_city,
birth_day,
city,
company_national_identification_number,
complementary_address,
corporation_type,
country,
currency,
customer_code,
einvoicing_billing_address,
email,
fax,
firstname,
italian_sdi,
kyc_validated,
language,
legalform,
national_identification_number,
nichandle,
organisation,
ovh_company,
ovh_subsidiary,
phone,
phone_country,
phone_type,
purpose_of_purchase,
sex,
spare_email,
state,
vat,
zip
FROM ovh.me.accounts
;

UPDATE examples​

Update details of your nichandle

UPDATE ovh.me.accounts
SET
address = '{{ address }}',
area = '{{ area }}',
birth_city = '{{ birth_city }}',
birth_day = '{{ birth_day }}',
city = '{{ city }}',
company_national_identification_number = '{{ company_national_identification_number }}',
complementary_address = '{{ complementary_address }}',
corporation_type = '{{ corporation_type }}',
country = '{{ country }}',
display_name = '{{ display_name }}',
einvoicing_billing_address = '{{ einvoicing_billing_address }}',
fax = '{{ fax }}',
firstname = '{{ firstname }}',
italian_sdi = '{{ italian_sdi }}',
language = '{{ language }}',
legalform = '{{ legalform }}',
name = '{{ name }}',
national_identification_number = '{{ national_identification_number }}',
organisation = '{{ organisation }}',
phone = '{{ phone }}',
phone_country = '{{ phone_country }}',
phone_type = '{{ phone_type }}',
purpose_of_purchase = '{{ purpose_of_purchase }}',
sex = '{{ sex }}',
spare_email = '{{ spare_email }}',
vat = '{{ vat }}',
zip = '{{ zip }}';

Lifecycle Methods​

EXEC variables use wire (API) names.

Create a new account whose billing will be linked to your current account's billing (Alpha version)

EXEC ovh.me.accounts.account
@@json=
'{
"address": "{{ address }}",
"area": "{{ area }}",
"billingAccount": "{{ billingAccount }}",
"birthCity": "{{ birthCity }}",
"birthDay": "{{ birthDay }}",
"city": "{{ city }}",
"companyNationalIdentificationNumber": "{{ companyNationalIdentificationNumber }}",
"complementaryAddress": "{{ complementaryAddress }}",
"corporationType": "{{ corporationType }}",
"country": "{{ country }}",
"einvoicingBillingAddress": "{{ einvoicingBillingAddress }}",
"email": "{{ email }}",
"fax": "{{ fax }}",
"firstname": "{{ firstname }}",
"italianSDI": "{{ italianSDI }}",
"language": "{{ language }}",
"legalform": "{{ legalform }}",
"name": "{{ name }}",
"nationalIdentificationNumber": "{{ nationalIdentificationNumber }}",
"organisation": "{{ organisation }}",
"phone": "{{ phone }}",
"phoneCountry": "{{ phoneCountry }}",
"phoneType": "{{ phoneType }}",
"purposeOfPurchase": "{{ purposeOfPurchase }}",
"sex": "{{ sex }}",
"spareEmail": "{{ spareEmail }}",
"vat": "{{ vat }}",
"zip": "{{ zip }}"
}'
;