requests

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

Overview

Name	requests
Type	Resource
Id	azure.billing.requests

Fields

Name	Datatype	Description
properties	object	A request submitted by a user to manage billing. Users with an owner role on the scope can approve or decline these requests.
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	billingRequestName	Gets a billing request by its ID.
list_by_billing_account	SELECT	billingAccountName	The list of billing requests submitted for the billing account.
list_by_billing_profile	SELECT	billingAccountName, billingProfileName	The list of billing requests submitted for the billing profile.
list_by_customer	SELECT	billingAccountName, billingProfileName, customerName	The list of billing requests submitted for the customer.
list_by_user	SELECT		The list of billing requests submitted by a user.
create_or_update	INSERT	billingRequestName	Create or update a billing request.

SELECT examples

The list of billing requests submitted by a user.

SELECT
properties,
tags
FROM azure.billing.requests
;

INSERT example

Use the following StackQL query and manifest file to create a new requests resource.

All Properties

/*+ create */
INSERT INTO azure.billing.requests (
billingRequestName,
tags,
properties
)
SELECT 
'{{ billingRequestName }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: additionalInformation
          value: object
        - name: reviewedBy
          value: string
        - name: reviewalDate
          value: string
        - name: billingAccountId
          value: string
        - name: billingAccountName
          value: string
        - name: billingAccountDisplayName
          value: string
        - name: billingAccountPrimaryBillingTenantId
          value: string
        - name: billingProfileId
          value: string
        - name: billingProfileName
          value: string
        - name: billingProfileDisplayName
          value: string
        - name: createdBy
          value: string
        - name: creationDate
          value: string
        - name: expirationDate
          value: string
        - name: decisionReason
          value: string
        - name: invoiceSectionId
          value: string
        - name: invoiceSectionName
          value: string
        - name: invoiceSectionDisplayName
          value: string
        - name: customerId
          value: string
        - name: customerName
          value: string
        - name: customerDisplayName
          value: string
        - name: subscriptionId
          value: string
        - name: subscriptionName
          value: string
        - name: subscriptionDisplayName
          value: string
        - name: justification
          value: string
        - name: recipients
          value:
            - - name: tenantId
                value: string
              - name: objectId
                value: string
              - name: upn
                value: string
        - name: requestScope
          value: string
        - name: billingScope
          value: string
        - name: status
          value: string
        - name: type
          value: string
        - name: lastUpdatedBy
          value: string
        - name: lastUpdatedDate
          value: string