Skip to main content

subscriptions_saas_subscription_details

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

Overview

Namesubscriptions_saas_subscription_details
TypeResource
Idazure_isv.oracle.subscriptions_saas_subscription_details

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
idstringPurchased SaaS subscription ID
isAutoRenewbooleanAutoRenew flag
isFreeTrialbooleanFreeTrial flag
offerIdstringPurchased offer ID
planIdstringPurchased offer's plan ID
publisherIdstringPublisher ID
purchaserEmailIdstringPurchaser Email ID
purchaserTenantIdstringPurchaser Tenant ID
saasSubscriptionStatusstringIndicates the status of the Subscription.
subscriptionNamestringSaaS subscription name
termUnitstringPurchase Term Unit
timeCreatedstring (date-time)Creation Date and Time

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectsubscriptionIdList Saas Subscription Details

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
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

List Saas Subscription Details

SELECT
id,
isAutoRenew,
isFreeTrial,
offerId,
planId,
publisherId,
purchaserEmailId,
purchaserTenantId,
saasSubscriptionStatus,
subscriptionName,
termUnit,
timeCreated
FROM azure_isv.oracle.subscriptions_saas_subscription_details
WHERE subscriptionId = '{{ subscriptionId }}' -- required
;