price_sheets

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

Overview

Name	price_sheets
Type	Resource
Id	azure.consumption.price_sheets

Fields

vw_price_sheets

Name	Datatype	Description
id	text	The full qualified ARM ID of an event.
name	text	The ID that uniquely identifies an event.
billingPeriodName	text	field from the properties object
download	text	field from the properties object
etag	text	The etag for the resource.
next_link	text	field from the properties object
pricesheets	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
type	text	Resource type.

price_sheets

Name	Datatype	Description
id	string	The full qualified ARM ID of an event.
name	string	The ID that uniquely identifies an event.
etag	string	The etag for the resource.
properties	object	price sheet result. It contains the pricesheet associated with billing period
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	subscriptionId	Gets the price sheet for a subscription. Price sheet is available via this API only for May 1, 2014 or later.
get_by_billing_period	SELECT	billingPeriodName, subscriptionId	Get the price sheet for a scope by subscriptionId and billing period. Price sheet is available via this API only for May 1, 2014 or later.
download_by_billing_account_period	EXEC	billingAccountId, billingPeriodName	Generates the pricesheet for the provided billing period asynchronously based on the enrollment id

SELECT examples

Gets the price sheet for a subscription. Price sheet is available via this API only for May 1, 2014 or later.

vw_price_sheets

SELECT
id,
name,
billingPeriodName,
download,
etag,
next_link,
pricesheets,
subscriptionId,
tags,
type
FROM azure.consumption.vw_price_sheets
WHERE subscriptionId = '{{ subscriptionId }}';

price_sheets

SELECT
id,
name,
etag,
properties,
tags,
type
FROM azure.consumption.price_sheets
WHERE subscriptionId = '{{ subscriptionId }}';