accounts

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

Overview

Name	accounts
Type	Resource
Id	azure.graph_services.accounts

Fields

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	Property bag from billing account
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, subscriptionId	Returns account resource for a given name.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Returns list of accounts apps.
list_by_subscription	SELECT	subscriptionId	Returns list of accounts belonging to a subscription.
create_and_update	INSERT	resourceGroupName, resourceName, subscriptionId, data__properties	Create or update account resource.
delete	DELETE	resourceGroupName, resourceName, subscriptionId	Deletes a account resource.
update	UPDATE	resourceGroupName, resourceName, subscriptionId	Update account details.

SELECT examples

Returns list of accounts belonging to a subscription.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.graph_services.accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.graph_services.accounts (
resourceGroupName,
resourceName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: systemData
      value:
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: appId
          value: string
        - name: billingPlanId
          value: string

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure.graph_services.accounts
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified accounts resource.

/*+ delete */
DELETE FROM azure.graph_services.accounts
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';