contacts

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

Overview

Name	contacts
Type	Resource
Id	ovh.domain.contacts

Fields

The following fields are returned by SELECT queries:

get

successful operation

Name	Datatype	Description
id	integer	Unique identifier
accreditation_id	string	Lawyer accreditation number (wire: accreditationId)
enterprise_id	string	Enterprise identifier (wire: enterpriseId)
trademark_id	string	Trademark related to the contact (wire: trademarkId)
first_name	string	First name (wire: firstName)
last_name	string	Last name (wire: lastName)
organisation_name	string	Name of organisation (wire: organisationName)
accreditation_country	string	Country of lawyer accreditation (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: accreditationCountry)
accreditation_organism	string	Organism of lawyer accreditation (wire: accreditationOrganism)
accreditation_year	integer	Year of lawyer accreditation (wire: accreditationYear)
address	object	The address of the contact
birth_city	string	City of birth (wire: birthCity)
birth_country	string	Birth 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) (wire: birthCountry)
birth_day	string (date)	Birth date (wire: birthDay)
birth_zip	string	Birth Zipcode (wire: birthZip)
cell_phone	string (phone-number)	Cellphone number (wire: cellPhone)
company_national_identification_number	string	Company National Identification Number (wire: companyNationalIdentificationNumber)
email	string	Email address
fax	string	Fax number
gender	string	Gender (female, male)
insee	string	INSEE identifier
language	string	Language (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)
legal_form	string	Legal forms a nichandle can be registered as (administration, association, corporation, individual, other, personalcorporation) (wire: legalForm)
legal_form_category	string	category of legalForm (wire: legalFormCategory)
national_identification_number	string	National Identification Number (wire: nationalIdentificationNumber)
nationality	string	Nationality (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)
organisation_accountable	string	To whom is the organisation accountable (wire: organisationAccountable)
organisation_funding	string	What is the source of funding (wire: organisationFunding)
organisation_funding_other	string	Explain the source of funding if organisationFunding is other (wire: organisationFundingOther)
organisation_role	string	Role of your organisation (wire: organisationRole)
organisation_role_other	string	Explain the role of your organisation if organisationRole is other (wire: organisationRoleOther)
organisation_staff_status	string	Status of the staff (wire: organisationStaffStatus)
organisation_staff_status_other	string	Explain the status of the staff if organisationStaffStatus is other (wire: organisationStaffStatusOther)
organisation_type	string	type of organisation (wire: organisationType)
organisation_type_other	string	Explain the type of organisation if organisationType is other (wire: organisationTypeOther)
phone	string (phone-number)	Phone number
registrant_document_type	string	Type of registrant document (wire: registrantDocumentType)
registrant_document_type_other	string	Explain the type of registrant document if registrantDocumentType is other (wire: registrantDocumentTypeOther)
role_in_organisation	string	The role in the organisation (wire: roleInOrganisation)
vat	string	VAT number
website	string	Website

list

A contact contains the personal data of a user

Name	Datatype	Description
id	integer	Unique identifier
accreditation_id	string	Lawyer accreditation number (wire: accreditationId)
enterprise_id	string	Enterprise identifier (wire: enterpriseId)
trademark_id	string	Trademark related to the contact (wire: trademarkId)
first_name	string	First name (wire: firstName)
last_name	string	Last name (wire: lastName)
organisation_name	string	Name of organisation (wire: organisationName)
accreditation_country	string	Country of lawyer accreditation (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: accreditationCountry)
accreditation_organism	string	Organism of lawyer accreditation (wire: accreditationOrganism)
accreditation_year	integer	Year of lawyer accreditation (wire: accreditationYear)
address	object	The address of the contact
birth_city	string	City of birth (wire: birthCity)
birth_country	string	Birth 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) (wire: birthCountry)
birth_day	string (date)	Birth date (wire: birthDay)
birth_zip	string	Birth Zipcode (wire: birthZip)
cell_phone	string (phone-number)	Cellphone number (wire: cellPhone)
company_national_identification_number	string	Company National Identification Number (wire: companyNationalIdentificationNumber)
email	string	Email address
fax	string	Fax number
gender	string	Gender (female, male)
insee	string	INSEE identifier
language	string	Language (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)
legal_form	string	Legal forms a nichandle can be registered as (administration, association, corporation, individual, other, personalcorporation) (wire: legalForm)
legal_form_category	string	category of legalForm (wire: legalFormCategory)
national_identification_number	string	National Identification Number (wire: nationalIdentificationNumber)
nationality	string	Nationality (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)
organisation_accountable	string	To whom is the organisation accountable (wire: organisationAccountable)
organisation_funding	string	What is the source of funding (wire: organisationFunding)
organisation_funding_other	string	Explain the source of funding if organisationFunding is other (wire: organisationFundingOther)
organisation_role	string	Role of your organisation (wire: organisationRole)
organisation_role_other	string	Explain the role of your organisation if organisationRole is other (wire: organisationRoleOther)
organisation_staff_status	string	Status of the staff (wire: organisationStaffStatus)
organisation_staff_status_other	string	Explain the status of the staff if organisationStaffStatus is other (wire: organisationStaffStatusOther)
organisation_type	string	type of organisation (wire: organisationType)
organisation_type_other	string	Explain the type of organisation if organisationType is other (wire: organisationTypeOther)
phone	string (phone-number)	Phone number
registrant_document_type	string	Type of registrant document (wire: registrantDocumentType)
registrant_document_type_other	string	Explain the type of registrant document if registrantDocumentType is other (wire: registrantDocumentTypeOther)
role_in_organisation	string	The role in the organisation (wire: roleInOrganisation)
vat	string	VAT number
website	string	Website

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	contact_id		Get details about a contact
list	select			List all contacts
create	insert			Create a contact
update	update	contact_id		Update a contact

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"}})
contact_id	integer	Contact ID (wire: contactId)

SELECT examples

get

Get details about a contact

SELECT
id,
accreditation_id,
enterprise_id,
trademark_id,
first_name,
last_name,
organisation_name,
accreditation_country,
accreditation_organism,
accreditation_year,
address,
birth_city,
birth_country,
birth_day,
birth_zip,
cell_phone,
company_national_identification_number,
email,
fax,
gender,
insee,
language,
legal_form,
legal_form_category,
national_identification_number,
nationality,
organisation_accountable,
organisation_funding,
organisation_funding_other,
organisation_role,
organisation_role_other,
organisation_staff_status,
organisation_staff_status_other,
organisation_type,
organisation_type_other,
phone,
registrant_document_type,
registrant_document_type_other,
role_in_organisation,
vat,
website
FROM ovh.domain.contacts
WHERE contact_id = '{{ contact_id }}' -- required
;

list

List all contacts

SELECT
id,
accreditation_id,
enterprise_id,
trademark_id,
first_name,
last_name,
organisation_name,
accreditation_country,
accreditation_organism,
accreditation_year,
address,
birth_city,
birth_country,
birth_day,
birth_zip,
cell_phone,
company_national_identification_number,
email,
fax,
gender,
insee,
language,
legal_form,
legal_form_category,
national_identification_number,
nationality,
organisation_accountable,
organisation_funding,
organisation_funding_other,
organisation_role,
organisation_role_other,
organisation_staff_status,
organisation_staff_status_other,
organisation_type,
organisation_type_other,
phone,
registrant_document_type,
registrant_document_type_other,
role_in_organisation,
vat,
website
FROM ovh.domain.contacts
;

INSERT examples

create

Create a contact

INSERT INTO ovh.domain.contacts (
accreditation_country,
accreditation_id,
accreditation_organism,
accreditation_year,
address,
birth_city,
birth_country,
birth_day,
birth_zip,
cell_phone,
company_national_identification_number,
email,
enterprise_id,
fax,
first_name,
gender,
insee,
language,
last_name,
legal_form,
legal_form_category,
national_identification_number,
nationality,
organisation_accountable,
organisation_funding,
organisation_funding_other,
organisation_name,
organisation_role,
organisation_role_other,
organisation_staff_status,
organisation_staff_status_other,
organisation_type,
organisation_type_other,
phone,
registrant_document_type,
registrant_document_type_other,
role_in_organisation,
trademark_id,
vat,
website
)
SELECT 
'{{ accreditation_country }}',
'{{ accreditation_id }}',
'{{ accreditation_organism }}',
{{ accreditation_year }},
'{{ address }}',
'{{ birth_city }}',
'{{ birth_country }}',
'{{ birth_day }}',
'{{ birth_zip }}',
'{{ cell_phone }}',
'{{ company_national_identification_number }}',
'{{ email }}',
'{{ enterprise_id }}',
'{{ fax }}',
'{{ first_name }}',
'{{ gender }}',
'{{ insee }}',
'{{ language }}',
'{{ last_name }}',
'{{ legal_form }}',
'{{ legal_form_category }}',
'{{ national_identification_number }}',
'{{ nationality }}',
'{{ organisation_accountable }}',
'{{ organisation_funding }}',
'{{ organisation_funding_other }}',
'{{ organisation_name }}',
'{{ organisation_role }}',
'{{ organisation_role_other }}',
'{{ organisation_staff_status }}',
'{{ organisation_staff_status_other }}',
'{{ organisation_type }}',
'{{ organisation_type_other }}',
'{{ phone }}',
'{{ registrant_document_type }}',
'{{ registrant_document_type_other }}',
'{{ role_in_organisation }}',
'{{ trademark_id }}',
'{{ vat }}',
'{{ website }}'
RETURNING
id,
accreditation_id,
enterprise_id,
trademark_id,
first_name,
last_name,
organisation_name,
accreditation_country,
accreditation_organism,
accreditation_year,
address,
birth_city,
birth_country,
birth_day,
birth_zip,
cell_phone,
company_national_identification_number,
email,
fax,
gender,
insee,
language,
legal_form,
legal_form_category,
national_identification_number,
nationality,
organisation_accountable,
organisation_funding,
organisation_funding_other,
organisation_role,
organisation_role_other,
organisation_staff_status,
organisation_staff_status_other,
organisation_type,
organisation_type_other,
phone,
registrant_document_type,
registrant_document_type_other,
role_in_organisation,
vat,
website
;

Manifest

# Description fields are for documentation purposes
- name: contacts
props:
  - name: accreditation_country
    value: "{{ accreditation_country }}"
    description: |
      Country of lawyer accreditation
    valid_values: ['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']
  - name: accreditation_id
    value: "{{ accreditation_id }}"
    description: |
      Lawyer accreditation number
  - name: accreditation_organism
    value: "{{ accreditation_organism }}"
    description: |
      Organism of lawyer accreditation
  - name: accreditation_year
    value: {{ accreditation_year }}
    description: |
      Year of lawyer accreditation
  - name: address
    description: |
      The address of the contact
    value:
      city: "{{ city }}"
      country: "{{ country }}"
      line1: "{{ line1 }}"
      line2: "{{ line2 }}"
      line3: "{{ line3 }}"
      otherDetails: "{{ otherDetails }}"
      province: "{{ province }}"
      zip: "{{ zip }}"
  - name: birth_city
    value: "{{ birth_city }}"
    description: |
      City of birth
  - name: birth_country
    value: "{{ birth_country }}"
    description: |
      Birth Country
    valid_values: ['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']
  - name: birth_day
    value: "{{ birth_day }}"
    description: |
      Birth date
  - name: birth_zip
    value: "{{ birth_zip }}"
    description: |
      Birth Zipcode
  - name: cell_phone
    value: "{{ cell_phone }}"
    description: |
      Cellphone number
  - name: company_national_identification_number
    value: "{{ company_national_identification_number }}"
    description: |
      Company National Identification Number
  - name: email
    value: "{{ email }}"
    description: |
      Email address
  - name: enterprise_id
    value: "{{ enterprise_id }}"
    description: |
      Enterprise identifier
  - name: fax
    value: "{{ fax }}"
    description: |
      Fax number
  - name: first_name
    value: "{{ first_name }}"
    description: |
      First name
  - name: gender
    value: "{{ gender }}"
    description: |
      Gender
    valid_values: ['female', 'male']
  - name: insee
    value: "{{ insee }}"
    description: |
      INSEE identifier
  - name: language
    value: "{{ language }}"
    description: |
      Language
    valid_values: ['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']
  - name: last_name
    value: "{{ last_name }}"
    description: |
      Last name
  - name: legal_form
    value: "{{ legal_form }}"
    description: |
      Legal forms a nichandle can be registered as
    valid_values: ['administration', 'association', 'corporation', 'individual', 'other', 'personalcorporation']
  - name: legal_form_category
    value: "{{ legal_form_category }}"
    description: |
      category of legalForm
  - name: national_identification_number
    value: "{{ national_identification_number }}"
    description: |
      National Identification Number
  - name: nationality
    value: "{{ nationality }}"
    description: |
      Nationality
    valid_values: ['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']
  - name: organisation_accountable
    value: "{{ organisation_accountable }}"
    description: |
      To whom is the organisation accountable
  - name: organisation_funding
    value: "{{ organisation_funding }}"
    description: |
      What is the source of funding
  - name: organisation_funding_other
    value: "{{ organisation_funding_other }}"
    description: |
      Explain the source of funding if organisationFunding is other
  - name: organisation_name
    value: "{{ organisation_name }}"
    description: |
      Name of organisation
  - name: organisation_role
    value: "{{ organisation_role }}"
    description: |
      Role of your organisation
  - name: organisation_role_other
    value: "{{ organisation_role_other }}"
    description: |
      Explain the role of your organisation if organisationRole is other
  - name: organisation_staff_status
    value: "{{ organisation_staff_status }}"
    description: |
      Status of the staff
  - name: organisation_staff_status_other
    value: "{{ organisation_staff_status_other }}"
    description: |
      Explain the status of the staff if organisationStaffStatus is other
  - name: organisation_type
    value: "{{ organisation_type }}"
    description: |
      type of organisation
  - name: organisation_type_other
    value: "{{ organisation_type_other }}"
    description: |
      Explain the type of organisation if organisationType is other
  - name: phone
    value: "{{ phone }}"
    description: |
      Phone number
  - name: registrant_document_type
    value: "{{ registrant_document_type }}"
    description: |
      Type of registrant document
  - name: registrant_document_type_other
    value: "{{ registrant_document_type_other }}"
    description: |
      Explain the type of registrant document if registrantDocumentType is other
  - name: role_in_organisation
    value: "{{ role_in_organisation }}"
    description: |
      The role in the organisation
  - name: trademark_id
    value: "{{ trademark_id }}"
    description: |
      Trademark related to the contact
  - name: vat
    value: "{{ vat }}"
    description: |
      VAT number
  - name: website
    value: "{{ website }}"
    description: |
      Website

UPDATE examples

update

Update a contact

UPDATE ovh.domain.contacts
SET 
accreditation_country = '{{ accreditation_country }}',
accreditation_id = '{{ accreditation_id }}',
accreditation_organism = '{{ accreditation_organism }}',
accreditation_year = {{ accreditation_year }},
address = '{{ address }}',
birth_city = '{{ birth_city }}',
birth_country = '{{ birth_country }}',
birth_day = '{{ birth_day }}',
birth_zip = '{{ birth_zip }}',
cell_phone = '{{ cell_phone }}',
company_national_identification_number = '{{ company_national_identification_number }}',
email = '{{ email }}',
enterprise_id = '{{ enterprise_id }}',
fax = '{{ fax }}',
first_name = '{{ first_name }}',
gender = '{{ gender }}',
insee = '{{ insee }}',
language = '{{ language }}',
last_name = '{{ last_name }}',
legal_form = '{{ legal_form }}',
legal_form_category = '{{ legal_form_category }}',
national_identification_number = '{{ national_identification_number }}',
nationality = '{{ nationality }}',
organisation_accountable = '{{ organisation_accountable }}',
organisation_funding = '{{ organisation_funding }}',
organisation_funding_other = '{{ organisation_funding_other }}',
organisation_name = '{{ organisation_name }}',
organisation_role = '{{ organisation_role }}',
organisation_role_other = '{{ organisation_role_other }}',
organisation_staff_status = '{{ organisation_staff_status }}',
organisation_staff_status_other = '{{ organisation_staff_status_other }}',
organisation_type = '{{ organisation_type }}',
organisation_type_other = '{{ organisation_type_other }}',
phone = '{{ phone }}',
registrant_document_type = '{{ registrant_document_type }}',
registrant_document_type_other = '{{ registrant_document_type_other }}',
role_in_organisation = '{{ role_in_organisation }}',
trademark_id = '{{ trademark_id }}',
vat = '{{ vat }}',
website = '{{ website }}'
WHERE 
contact_id = '{{ contact_id }}' --required
RETURNING
id,
accreditation_id,
enterprise_id,
trademark_id,
first_name,
last_name,
organisation_name,
accreditation_country,
accreditation_organism,
accreditation_year,
address,
birth_city,
birth_country,
birth_day,
birth_zip,
cell_phone,
company_national_identification_number,
email,
fax,
gender,
insee,
language,
legal_form,
legal_form_category,
national_identification_number,
nationality,
organisation_accountable,
organisation_funding,
organisation_funding_other,
organisation_role,
organisation_role_other,
organisation_staff_status,
organisation_staff_status_other,
organisation_type,
organisation_type_other,
phone,
registrant_document_type,
registrant_document_type_other,
role_in_organisation,
vat,
website;