payment_methods

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

Overview

Name	payment_methods
Type	Resource
Id	azure.billing.payment_methods

Fields

vw_payment_methods

Name	Datatype	Description
account_holder_name	text	field from the properties object
billingAccountName	text	field from the properties object
billingProfileName	text	field from the properties object
display_name	text	field from the properties object
expiration	text	field from the properties object
family	text	field from the properties object
last_four_digits	text	field from the properties object
logos	text	field from the properties object
paymentMethodName	text	field from the properties object
payment_method	text	field from the properties object
payment_method_id	text	field from the properties object
payment_method_type	text	field from the properties object
status	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 < > % & \ ? /

payment_methods

Name	Datatype	Description
properties	object	The properties of a payment method link.
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_by_billing_account	SELECT	billingAccountName, paymentMethodName	Gets a payment method available for a billing account. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
get_by_billing_profile	SELECT	billingAccountName, billingProfileName, paymentMethodName	Gets a payment method linked with a billing profile. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
get_by_user	SELECT	paymentMethodName	Gets a payment method owned by the caller.
list_by_billing_account	SELECT	billingAccountName	Lists the payment methods available for a billing account. Along with the payment methods owned by the caller, these payment methods can be attached to a billing profile to make payments. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
list_by_billing_profile	SELECT	billingAccountName, billingProfileName	Lists payment methods attached to a billing profile. The operation is supported only for billing accounts with agreement type Microsoft Customer Agreement.
list_by_user	SELECT		Lists the payment methods owned by the caller.
delete_by_user	DELETE	paymentMethodName	Deletes a payment method owned by the caller.

SELECT examples

Lists the payment methods owned by the caller.

vw_payment_methods

SELECT
account_holder_name,
billingAccountName,
billingProfileName,
display_name,
expiration,
family,
last_four_digits,
logos,
paymentMethodName,
payment_method,
payment_method_id,
payment_method_type,
status,
tags
FROM azure.billing.vw_payment_methods
;

payment_methods

SELECT
properties,
tags
FROM azure.billing.payment_methods
;

DELETE example

Deletes the specified payment_methods resource.

/*+ delete */
DELETE FROM azure.billing.payment_methods
WHERE paymentMethodName = '{{ paymentMethodName }}';