Skip to main content

rate_card

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

Overview

Namerate_card
TypeResource
Idazure_extras.commerce.rate_card

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
CurrencystringThe currency in which the rates are provided.
IsTaxIncludedbooleanAll rates are pretax, so this will always be returned as 'false'.
LocalestringThe culture in which the resource information is localized.
MetersarrayA list of meters.
OfferTermsarrayA list of offer terms.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscription_id, $filterEnables you to query for the resource/meter metadata and related prices used in a given subscription by Offer ID, Currency, Locale and Region. The metadata associated with the billing meters, including but not limited to service names, types, resources, units of measure, and regions, is subject to change at any time and without notice. If you intend to use this billing data in an automated fashion, please use the billing meter GUID to uniquely identify each billable item. If the billing meter GUID is scheduled to change due to a new billing model, you will be notified in advance of the change. .. seealso:: - https://docs.microsoft.com/rest/api/commerce/ratecard

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
$filterstringThe filter to apply on the operation. It ONLY supports the 'eq' and 'and' logical operators at this time. All the 4 query parameters 'OfferDurableId', 'Currency', 'Locale', 'Region' are required to be a part of the $filter. Required.
subscription_idstring

SELECT examples

Enables you to query for the resource/meter metadata and related prices used in a given subscription by Offer ID, Currency, Locale and Region. The metadata associated with the billing meters, including but not limited to service names, types, resources, units of measure, and regions, is subject to change at any time and without notice. If you intend to use this billing data in an automated fashion, please use the billing meter GUID to uniquely identify each billable item. If the billing meter GUID is scheduled to change due to a new billing model, you will be notified in advance of the change. .. seealso:: - https://docs.microsoft.com/rest/api/commerce/ratecard

SELECT
Currency,
IsTaxIncluded,
Locale,
Meters,
OfferTerms
FROM azure_extras.commerce.rate_card
WHERE subscription_id = '{{ subscription_id }}' -- required
AND $filter = '{{ $filter }}' -- required
;