instances

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

Overview

Name	instances
Type	Resource
Id	azure_extras.dyn365_fraud_protection.instances

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
location	string	Location of the DFP resource.
properties	object	Properties of DFP resource.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Key-value pairs of additional resource provisioning properties.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
list	SELECT	subscriptionId	Lists all the Dedicated instances for the given subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all the Dedicated instance for the given resource group.
create	INSERT	instanceName, resourceGroupName, subscriptionId, data__location	Provisions the specified DFP instance based on the configuration specified in the request.
delete	DELETE	instanceName, resourceGroupName, subscriptionId	Deletes the specified DFP instance.
update	UPDATE	instanceName, resourceGroupName, subscriptionId	Updates the current state of the specified DFP instance.
check_name_availability	EXEC	location, subscriptionId	Check the name availability in the target location.

SELECT examples

Lists all the Dedicated instances for the given subscription.

SELECT
id,
name,
location,
properties,
systemData,
tags,
type
FROM azure_extras.dyn365_fraud_protection.instances
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.dyn365_fraud_protection.instances (
instanceName,
resourceGroupName,
subscriptionId,
data__location,
properties,
location,
tags
)
SELECT 
'{{ instanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__location }}',
'{{ properties }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: administration
          value:
            - name: members
              value:
                - string
    - name: location
      value: string
    - name: tags
      value: object
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

UPDATE example

Updates a instances resource.

/*+ update */
UPDATE azure_extras.dyn365_fraud_protection.instances
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
instanceName = '{{ instanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified instances resource.

/*+ delete */
DELETE FROM azure_extras.dyn365_fraud_protection.instances
WHERE instanceName = '{{ instanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';