Skip to main content

cdn_domain_options

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

Overview​

Namecdn_domain_options
TypeResource
Idovh.hosting_web.cdn_domain_options

Fields​

The following fields are returned by SELECT queries:

successful operation

NameDatatypeDescription
namestringOption name
configobjectOption configuration
enabledbooleanEnable / Disable the option
extraobjectAdditional information about option
patternstringUrl pattern
typestringOption type (brotli, cache_rule, cors, devmode, geo_headers, hsts, https_redirect, mixed_content, mobile_redirect, prefetch, prewarm, querystring, waf)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdomain_name, option_name, service_nameGet details for an option on a domain
listselectdomain_name, service_nameList all options for a domain
createinsertdomain_name, service_name, enabled, name, typeAdd an option on a domain
updateupdatedomain_name, option_name, service_name, enabled, typeUpdate an option on a domain
deletedeletedomain_name, option_name, service_nameRemove or Reset an option to his default value

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"}})
domain_namestringDomain name (wire: domainName)
option_namestringOption name (wire: optionName)
service_namestringService name (wire: serviceName)

SELECT examples​

Get details for an option on a domain

SELECT
name,
config,
enabled,
extra,
pattern,
type
FROM ovh.hosting_web.cdn_domain_options
WHERE domain_name = '{{ domain_name }}' -- required
AND option_name = '{{ option_name }}' -- required
AND service_name = '{{ service_name }}' -- required
;

INSERT examples​

Add an option on a domain

INSERT INTO ovh.hosting_web.cdn_domain_options (
config,
enabled,
name,
pattern,
type,
domain_name,
service_name
)
SELECT
'{{ config }}',
{{ enabled }} /* required */,
'{{ name }}' /* required */,
'{{ pattern }}',
'{{ type }}' /* required */,
'{{ domain_name }}',
'{{ service_name }}'
RETURNING
name,
config,
enabled,
extra,
pattern,
type
;

UPDATE examples​

Update an option on a domain

UPDATE ovh.hosting_web.cdn_domain_options
SET
config = '{{ config }}',
enabled = {{ enabled }},
extra = '{{ extra }}',
pattern = '{{ pattern }}',
type = '{{ type }}'
WHERE
domain_name = '{{ domain_name }}' --required
AND option_name = '{{ option_name }}' --required
AND service_name = '{{ service_name }}' --required
AND enabled = {{ enabled }} --required
AND type = '{{ type }}' --required
RETURNING
name,
config,
enabled,
extra,
pattern,
type;

DELETE examples​

Remove or Reset an option to his default value

DELETE FROM ovh.hosting_web.cdn_domain_options
WHERE domain_name = '{{ domain_name }}' --required
AND option_name = '{{ option_name }}' --required
AND service_name = '{{ service_name }}' --required
;