vps_upgrades

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

Overview

Name	vps_upgrades
Type	Resource
Id	ovh.order.vps_upgrades

Fields

The following fields are returned by SELECT queries:

get

successful operation

Name	Datatype	Description
order_id	integer	Identifier of the order (wire: orderId)
contracts	array	List of contracts related to the order
details	array	Details of the order
prices	object	Prices of the order including with and without taxes
url	string	URL to download the order

list

An order

Name	Datatype	Description
order_id	integer	Identifier of the order (wire: orderId)
contracts	array	List of contracts related to the order
details	array	Details of the order
prices	object	Prices of the order including with and without taxes
url	string	URL to download the order

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	duration, model, service_name		Get prices and contracts information
list	select	model, service_name	x_pagination_mode	Get allowed durations for 'upgrade' option
create	insert	duration, service_name, model		Create order

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"}})
duration	string	Duration
model	string	Model
service_name	string	The internal name of your VPS offer (wire: serviceName)
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 prices and contracts information

SELECT
order_id,
contracts,
details,
prices,
url
FROM ovh.order.vps_upgrades
WHERE duration = '{{ duration }}' -- required
AND model = '{{ model }}' -- required
AND service_name = '{{ service_name }}' -- required
;

list

Get allowed durations for 'upgrade' option

SELECT
order_id,
contracts,
details,
prices,
url
FROM ovh.order.vps_upgrades
WHERE model = '{{ model }}' -- required
AND service_name = '{{ service_name }}' -- required
AND x_pagination_mode = '{{ x_pagination_mode }}'
;

INSERT examples

create

Create order

INSERT INTO ovh.order.vps_upgrades (
model,
duration,
service_name
)
SELECT 
'{{ model }}' /* required */,
'{{ duration }}',
'{{ service_name }}'
RETURNING
order_id,
contracts,
details,
prices,
url
;

Manifest

# Description fields are for documentation purposes
- name: vps_upgrades
props:
  - name: duration
    value: "{{ duration }}"
    description: Required parameter for the vps_upgrades resource.
  - name: service_name
    value: "{{ service_name }}"
    description: Required parameter for the vps_upgrades resource.
  - name: model
    value: "{{ model }}"
    description: |
      Model