balances

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

Overview

Name	balances
Type	Resource
Id	azure.consumption.balances

Fields

vw_balances

Name	Datatype	Description
id	text	The full qualified ARM ID of an event.
name	text	The ID that uniquely identifies an event.
adjustment_details	text	field from the properties object
adjustments	text	field from the properties object
azure_marketplace_service_charges	text	field from the properties object
beginning_balance	text	field from the properties object
billingAccountId	text	field from the properties object
billing_frequency	text	field from the properties object
charges_billed_separately	text	field from the properties object
currency	text	field from the properties object
ending_balance	text	field from the properties object
etag	text	The etag for the resource.
new_purchases	text	field from the properties object
new_purchases_details	text	field from the properties object
overage_refund	text	field from the properties object
price_hidden	text	field from the properties object
service_overage	text	field from the properties object
tags	text	Resource tags.
total_overage	text	field from the properties object
total_usage	text	field from the properties object
type	text	Resource type.
utilized	text	field from the properties object

balances

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	The properties of the balance.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get_by_billing_account	SELECT	billingAccountId	Gets the balances for a scope by billingAccountId. Balances are available via this API only for May 1, 2014 or later.

SELECT examples

Gets the balances for a scope by billingAccountId. Balances are available via this API only for May 1, 2014 or later.

vw_balances

SELECT
id,
name,
adjustment_details,
adjustments,
azure_marketplace_service_charges,
beginning_balance,
billingAccountId,
billing_frequency,
charges_billed_separately,
currency,
ending_balance,
etag,
new_purchases,
new_purchases_details,
overage_refund,
price_hidden,
service_overage,
tags,
total_overage,
total_usage,
type,
utilized
FROM azure.consumption.vw_balances
WHERE billingAccountId = '{{ billingAccountId }}';

balances

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