customers

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

Overview

Name	customers
Type	Resource
Id	azure.billing.customers

Fields

vw_customers

Name	Datatype	Description
billingAccountName	text	field from the properties object
billingProfileName	text	field from the properties object
billing_profile_display_name	text	field from the properties object
billing_profile_id	text	field from the properties object
customerName	text	field from the properties object
display_name	text	field from the properties object
enabled_azure_plans	text	field from the properties object
resellers	text	field from the properties object
status	text	field from the properties object
system_id	text	field from the properties object
tags	text	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 < > % & \ ? /

customers

Name	Datatype	Description
properties	object	A partner's customer.
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

Name	Accessible by	Required Params	Description
get	SELECT	billingAccountName, billingProfileName, customerName	Gets a customer by its ID. The operation is supported only for billing accounts with agreement type Microsoft Partner Agreement.
get_by_billing_account	SELECT	billingAccountName, customerName	Gets a customer by its ID at billing account level. The operation is supported only for billing accounts with agreement type Microsoft Partner Agreement.
list_by_billing_account	SELECT	billingAccountName	Lists the customers that are billed to a billing account. The operation is supported only for billing accounts with agreement type Microsoft Partner Agreement.
list_by_billing_profile	SELECT	billingAccountName, billingProfileName	Lists the customers that are billed to a billing profile. The operation is supported only for billing accounts with agreement type Microsoft Partner Agreement.

SELECT examples

Lists the customers that are billed to a billing account. The operation is supported only for billing accounts with agreement type Microsoft Partner Agreement.

vw_customers

SELECT
billingAccountName,
billingProfileName,
billing_profile_display_name,
billing_profile_id,
customerName,
display_name,
enabled_azure_plans,
resellers,
status,
system_id,
tags
FROM azure.billing.vw_customers
WHERE billingAccountName = '{{ billingAccountName }}';

customers

SELECT
properties,
tags
FROM azure.billing.customers
WHERE billingAccountName = '{{ billingAccountName }}';