available_balances

Creates, updates, deletes, gets or lists an available_balances resource.

Overview

Name	available_balances
Type	Resource
Id	azure.billing.available_balances

Fields

The following fields are returned by SELECT queries:

get_by_billing_profile

The Available Credit or Payment on Account Balance. The credit balance can be used to settle due or past due invoices.

Name	Datatype	Description
properties	object	The Available Credit or Payment on Account Balance. The credit balance can be used to settle due or past due invoices.
tags	object	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /

get_by_billing_account

The Available Credit or Payment on Account Balance. The credit balance can be used to settle due or past due invoices.

Name	Datatype	Description
properties	object	The Available Credit or Payment on Account Balance. The credit balance can be used to settle due or past due invoices.
tags	object	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_by_billing_profile	select	billingAccountName, billingProfileName		The Available Credit or Payment on Account Balance for a billing profile. The credit balance can be used to settle due or past due invoices and is supported for billing accounts with agreement type Microsoft Customer Agreement. The payment on account balance is supported for billing accounts with agreement type Microsoft Customer Agreement.
get_by_billing_account	select	billingAccountName		The Available Credit or Payment on Account Balance for a billing account. The credit balance can be used to settle due or past due invoices and is supported for billing accounts with agreement type Microsoft Customer Agreement. The payment on account balance is supported for billing accounts with agreement type Microsoft Customer Agreement or Microsoft Online Services Program.

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.

Name	Datatype	Description
billingAccountName	string	The ID that uniquely identifies a billing account.
billingProfileName	string	The ID that uniquely identifies a billing profile.

SELECT examples

get_by_billing_profile

The Available Credit or Payment on Account Balance for a billing profile. The credit balance can be used to settle due or past due invoices and is supported for billing accounts with agreement type Microsoft Customer Agreement. The payment on account balance is supported for billing accounts with agreement type Microsoft Customer Agreement.

SELECT
properties,
tags
FROM azure.billing.available_balances
WHERE billingAccountName = '{{ billingAccountName }}' -- required
AND billingProfileName = '{{ billingProfileName }}' -- required
;

get_by_billing_account

The Available Credit or Payment on Account Balance for a billing account. The credit balance can be used to settle due or past due invoices and is supported for billing accounts with agreement type Microsoft Customer Agreement. The payment on account balance is supported for billing accounts with agreement type Microsoft Customer Agreement or Microsoft Online Services Program.

SELECT
properties,
tags
FROM azure.billing.available_balances
WHERE billingAccountName = '{{ billingAccountName }}' -- required
;