Skip to main content

subscriptions

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

Overview

Namesubscriptions
TypeResource
Idgoogle.apigee.subscriptions

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringOutput only. Name of the API product subscription.
apiproductstringName of the API product for which the developer is purchasing a subscription.
createdAtstring (int64)Output only. Time when the API product subscription was created in milliseconds since epoch.
endTimestring (int64)Time when the API product subscription ends in milliseconds since epoch.
lastModifiedAtstring (int64)Output only. Time when the API product subscription was last modified in milliseconds since epoch.
startTimestring (int64)Time when the API product subscription starts in milliseconds since epoch.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
organizations_developers_subscriptions_getselectorganizationsId, developersId, subscriptionsIdGets details for an API product subscription.
organizations_developers_subscriptions_listselectorganizationsId, developersIdstartKey, countLists all API product subscriptions for a developer.
organizations_developers_subscriptions_createinsertorganizationsId, developersIdCreates a subscription to an API product.
organizations_developers_subscriptions_expireexecorganizationsId, developersId, subscriptionsIdExpires an API product subscription immediately.

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
developersIdstring
organizationsIdstring
subscriptionsIdstring
countinteger (int32)
startKeystring

SELECT examples

Gets details for an API product subscription.

SELECT
name,
apiproduct,
createdAt,
endTime,
lastModifiedAt,
startTime
FROM google.apigee.subscriptions
WHERE organizationsId = '{{ organizationsId }}' -- required
AND developersId = '{{ developersId }}' -- required
AND subscriptionsId = '{{ subscriptionsId }}' -- required;

INSERT examples

Creates a subscription to an API product.

INSERT INTO google.apigee.subscriptions (
data__apiproduct,
data__startTime,
data__endTime,
organizationsId,
developersId
)
SELECT
'{{ apiproduct }}',
'{{ startTime }}',
'{{ endTime }}',
'{{ organizationsId }}',
'{{ developersId }}'
RETURNING
name,
apiproduct,
createdAt,
endTime,
lastModifiedAt,
startTime
;

Lifecycle Methods

Expires an API product subscription immediately.

EXEC google.apigee.subscriptions.organizations_developers_subscriptions_expire 
@organizationsId='{{ organizationsId }}' --required,
@developersId='{{ developersId }}' --required,
@subscriptionsId='{{ subscriptionsId }}' --required;