extra_sql_perso_service_infos
Creates, updates, deletes, gets or lists an extra_sql_perso_service_infos resource.
Overview​
| Name | extra_sql_perso_service_infos |
| Type | Resource |
| Id | ovh.hosting_web.extra_sql_perso_service_infos |
Fields​
The following fields are returned by SELECT queries:
- get
successful operation
| Name | Datatype | Description |
|---|---|---|
service_id | integer | (wire: serviceId) |
can_delete_at_expiration | boolean | Indicates that the service can be set up to be deleted at expiration (wire: canDeleteAtExpiration) |
contact_admin | string | (wire: contactAdmin) |
contact_billing | string | (wire: contactBilling) |
contact_tech | string | (wire: contactTech) |
creation | string (date) | |
domain | string | |
engaged_up_to | string (date) | (wire: engagedUpTo) |
expiration | string (date) | |
possible_renew_period | array | All the possible renew period of your service in month (wire: possibleRenewPeriod) |
renew | object | Way of handling the renew |
renewal_type | string | Detailed renewal type of a service (automaticForcedProduct, automaticV2012, automaticV2014, automaticV2016, manual, oneShot, option) (wire: renewalType) |
status | string | service.StateEnum (autorenewInProgress, expired, inCreation, ok, pendingDebt, unPaid) |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | id, service_name | Get extra SQL option service information. Returns the billing information of the option: creation and expiration dates, renewal settings and contacts. |
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"}}) |
id | integer | Identifier of the (additional) SQL slot |
service_name | string | The internal name of your hosting (wire: serviceName) |
SELECT examples​
- get
Get extra SQL option service information. Returns the billing information of the option: creation and expiration dates, renewal settings and contacts.
SELECT
service_id,
can_delete_at_expiration,
contact_admin,
contact_billing,
contact_tech,
creation,
domain,
engaged_up_to,
expiration,
possible_renew_period,
renew,
renewal_type,
status
FROM ovh.hosting_web.extra_sql_perso_service_infos
WHERE id = '{{ id }}' -- required
AND service_name = '{{ service_name }}' -- required
;