Skip to main content

subscriptions

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

Overview

Namesubscriptions
TypeResource
Idcloudflare.accounts.subscriptions

Fields

The following fields are returned by SELECT queries:

List Subscriptions response

NameDatatypeDescription
errorsarray
messagesarray
resultarray
result_infoobject
successbooleanWhether the API call was successful (true)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectaccount_idLists all of an account's subscriptions.
createinsertaccount_idCreates an account subscription.
updatereplacesubscription_identifier, account_idUpdates an account subscription.
deletedeletesubscription_identifier, account_idDeletes an account's subscription.

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.
subscription_identifierstring

SELECT examples

Lists all of an account's subscriptions.

SELECT
errors,
messages,
result,
result_info,
success
FROM cloudflare.accounts.subscriptions
WHERE account_id = '{{ account_id }}' -- required
;

INSERT examples

Creates an account subscription.

INSERT INTO cloudflare.accounts.subscriptions (
frequency,
rate_plan,
account_id
)
SELECT
'{{ frequency }}',
'{{ rate_plan }}',
'{{ account_id }}'
RETURNING
errors,
messages,
result,
success
;

REPLACE examples

Updates an account subscription.

REPLACE cloudflare.accounts.subscriptions
SET
frequency = '{{ frequency }}',
rate_plan = '{{ rate_plan }}'
WHERE
subscription_identifier = '{{ subscription_identifier }}' --required
AND account_id = '{{ account_id }}' --required
RETURNING
errors,
messages,
result,
success;

DELETE examples

Deletes an account's subscription.

DELETE FROM cloudflare.accounts.subscriptions
WHERE subscription_identifier = '{{ subscription_identifier }}' --required
AND account_id = '{{ account_id }}' --required
;