Skip to main content

variants

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

Overview

Namevariants
TypeResource
Idcloudflare.images.variants

Fields

The following fields are returned by SELECT queries:

Variant details response

NameDatatypeDescription
variantobject

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectvariant_id, account_idFetch details for a single variant.
listselectaccount_idLists existing variants.
createinsertaccount_id, id, optionsSpecify variants that allow you to resize images for different use cases.
editupdatevariant_id, account_id, optionsUpdating a variant purges the cache for all images associated with the variant.
deletedeletevariant_id, account_idDeleting a variant purges the cache for all images associated with the variant.

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
account_idstringThe Cloudflare account ID.
variant_idstring

SELECT examples

Fetch details for a single variant.

SELECT
variant
FROM cloudflare.images.variants
WHERE variant_id = '{{ variant_id }}' -- required
AND account_id = '{{ account_id }}' -- required
;

INSERT examples

Specify variants that allow you to resize images for different use cases.

INSERT INTO cloudflare.images.variants (
id,
neverRequireSignedURLs,
options,
account_id
)
SELECT
'{{ id }}' /* required */,
{{ neverRequireSignedURLs }},
'{{ options }}' /* required */,
'{{ account_id }}'
RETURNING
errors,
messages,
result,
success
;

UPDATE examples

Updating a variant purges the cache for all images associated with the variant.

UPDATE cloudflare.images.variants
SET
neverRequireSignedURLs = {{ neverRequireSignedURLs }},
options = '{{ options }}'
WHERE
variant_id = '{{ variant_id }}' --required
AND account_id = '{{ account_id }}' --required
AND options = '{{ options }}' --required
RETURNING
errors,
messages,
result,
success;

DELETE examples

Deleting a variant purges the cache for all images associated with the variant.

DELETE FROM cloudflare.images.variants
WHERE variant_id = '{{ variant_id }}' --required
AND account_id = '{{ account_id }}' --required
;