lots

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

Overview

Name	lots
Type	Resource
Id	azure.consumption.lots

Fields

The following fields are returned by SELECT queries:

list_by_billing_profile

OK. The request has succeeded.

Name	Datatype	Description
properties	object	The lot properties. (title: Lot summary properties)

list_by_customer

OK. The request has succeeded.

Name	Datatype	Description
properties	object	The lot properties. (title: Lot summary properties)

list_by_billing_account

OK. The request has succeeded.

Name	Datatype	Description
properties	object	The lot properties. (title: Lot summary properties)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_billing_profile	select	billingAccountId, billingProfileId		Lists all Azure credits for a billing account or a billing profile. The API is only supported for Microsoft Customer Agreements (MCA) billing accounts.
list_by_customer	select	billingAccountId, customerId	$filter	Lists all Azure credits for a customer. The API is only supported for Microsoft Partner Agreements (MPA) billing accounts.
list_by_billing_account	select	billingAccountId	$filter	Lists all Microsoft Azure consumption commitments for a billing account. The API is only supported for Microsoft Customer Agreements (MCA) and Direct Enterprise Agreement (EA) billing accounts.

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
billingAccountId	string	BillingAccount ID
billingProfileId	string	Azure Billing Profile ID.
customerId	string	Customer ID
$filter	string	May be used to filter the lots by Status, Source etc. The filter supports 'eq', 'lt', 'gt', 'le', 'ge', and 'and'. It does not currently support 'ne', 'or', or 'not'. Tag filter is a key value pair string where key and value is separated by a colon (:).

SELECT examples

list_by_billing_profile

Lists all Azure credits for a billing account or a billing profile. The API is only supported for Microsoft Customer Agreements (MCA) billing accounts.

SELECT
properties
FROM azure.consumption.lots
WHERE billingAccountId = '{{ billingAccountId }}' -- required
AND billingProfileId = '{{ billingProfileId }}' -- required
;

list_by_customer

Lists all Azure credits for a customer. The API is only supported for Microsoft Partner Agreements (MPA) billing accounts.

SELECT
properties
FROM azure.consumption.lots
WHERE billingAccountId = '{{ billingAccountId }}' -- required
AND customerId = '{{ customerId }}' -- required
AND $filter = '{{ $filter }}'
;

list_by_billing_account

Lists all Microsoft Azure consumption commitments for a billing account. The API is only supported for Microsoft Customer Agreements (MCA) and Direct Enterprise Agreement (EA) billing accounts.

SELECT
properties
FROM azure.consumption.lots
WHERE billingAccountId = '{{ billingAccountId }}' -- required
AND $filter = '{{ $filter }}'
;