Skip to main content

identity_user_tokens

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

Overview​

Nameidentity_user_tokens
TypeResource
Idovh.me.identity_user_tokens

Fields​

The following fields are returned by SELECT queries:

successful operation

NameDatatypeDescription
namestringName of this token
creationstring (date-time)Creation date of this token
descriptionstringPersonal access token's description
expires_atstring (date-time)Personal access token's expiration date (wire: expiresAt)
last_usedstring (date-time)Personal access token's last used date (wire: lastUsed)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectname, userGet a personal access token's information
listselectuserx_pagination_modeRetrieve all personal access tokens from this user
createinsertuser, description, nameCreate a new personal access token
updateupdatename, userAlter a user personal acces token
deletedeletename, userDelete a personal access token

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

SELECT examples​

Get a personal access token's information

SELECT
name,
creation,
description,
expires_at,
last_used
FROM ovh.me.identity_user_tokens
WHERE name = '{{ name }}' -- required
AND user = '{{ user }}' -- required
;

INSERT examples​

Create a new personal access token

INSERT INTO ovh.me.identity_user_tokens (
description,
expires_at,
expires_in,
name,
user
)
SELECT
'{{ description }}' /* required */,
'{{ expires_at }}',
{{ expires_in }},
'{{ name }}' /* required */,
'{{ user }}'
RETURNING
name,
creation,
description,
expires_at,
last_used,
token
;

UPDATE examples​

Alter a user personal acces token

UPDATE ovh.me.identity_user_tokens
SET
description = '{{ description }}',
expires_at = '{{ expires_at }}',
expires_in = {{ expires_in }}
WHERE
name = '{{ name }}' --required
AND user = '{{ user }}' --required
RETURNING
name,
creation,
description,
expires_at,
last_used;

DELETE examples​

Delete a personal access token

DELETE FROM ovh.me.identity_user_tokens
WHERE name = '{{ name }}' --required
AND user = '{{ user }}' --required
;