ip_organisations

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

Overview

Name	ip_organisations
Type	Resource
Id	ovh.me.ip_organisations

Fields

The following fields are returned by SELECT queries:

get

successful operation

Name	Datatype	Description
organisation_id	string	(wire: organisationId)
abuse_mailbox	string
address	string
city	string
country	string	Countries 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)
firstname	string
lastname	string
phone	string (phone-number)	Phone number
registry	string	Ip registries (ARIN, RIPE)
state	string
zip	string

list

Details about an IP block organisation

Name	Datatype	Description
organisation_id	string	(wire: organisationId)
abuse_mailbox	string
address	string
city	string
country	string	Countries 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)
firstname	string
lastname	string
phone	string (phone-number)	Phone number
registry	string	Ip registries (ARIN, RIPE)
state	string
zip	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	organisation_id		Get this object properties
list	select		x_pagination_mode	List of organisations
create	insert	abuse_mailbox, address, city, country, firstname, lastname, phone, registry		Add an organisation
update	update	organisation_id		Alter this object properties
delete	delete	organisation_id		Delete this organisation

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"}})
organisation_id	string	(wire: organisationId)
x_pagination_mode	string	Sent as CachedObjectList-Pages by default so the list returns the full objects rather than their identifiers. (wire: X-Pagination-Mode)

SELECT examples

get

Get this object properties

SELECT
organisation_id,
abuse_mailbox,
address,
city,
country,
firstname,
lastname,
phone,
registry,
state,
zip
FROM ovh.me.ip_organisations
WHERE organisation_id = '{{ organisation_id }}' -- required
;

list

List of organisations

SELECT
organisation_id,
abuse_mailbox,
address,
city,
country,
firstname,
lastname,
phone,
registry,
state,
zip
FROM ovh.me.ip_organisations
WHERE x_pagination_mode = '{{ x_pagination_mode }}'
;

INSERT examples

create

Add an organisation

INSERT INTO ovh.me.ip_organisations (
abuse_mailbox,
address,
city,
country,
firstname,
lastname,
phone,
registry,
state,
zip
)
SELECT 
'{{ abuse_mailbox }}' /* required */,
'{{ address }}' /* required */,
'{{ city }}' /* required */,
'{{ country }}' /* required */,
'{{ firstname }}' /* required */,
'{{ lastname }}' /* required */,
'{{ phone }}' /* required */,
'{{ registry }}' /* required */,
'{{ state }}',
'{{ zip }}'
;

Manifest

# Description fields are for documentation purposes
- name: ip_organisations
props:
  - name: abuse_mailbox
    value: "{{ abuse_mailbox }}"
  - name: address
    value: "{{ address }}"
  - name: city
    value: "{{ city }}"
  - name: country
    value: "{{ country }}"
    description: |
      Countries a nichandle can choose
    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: firstname
    value: "{{ firstname }}"
  - name: lastname
    value: "{{ lastname }}"
  - name: phone
    value: "{{ phone }}"
    description: |
      Phone number
  - name: registry
    value: "{{ registry }}"
    description: |
      Ip registries
    valid_values: ['ARIN', 'RIPE']
  - name: state
    value: "{{ state }}"
  - name: zip
    value: "{{ zip }}"

UPDATE examples

update

Alter this object properties

UPDATE ovh.me.ip_organisations
SET 
abuse_mailbox = '{{ abuse_mailbox }}',
address = '{{ address }}',
city = '{{ city }}',
country = '{{ country }}',
firstname = '{{ firstname }}',
lastname = '{{ lastname }}',
phone = '{{ phone }}',
state = '{{ state }}',
zip = '{{ zip }}'
WHERE 
organisation_id = '{{ organisation_id }}' --required;

DELETE examples

delete

Delete this organisation

DELETE FROM ovh.me.ip_organisations
WHERE organisation_id = '{{ organisation_id }}' --required
;