instances

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

Overview

Name	instances
Type	Resource
Id	azure.device_update.instances

Fields

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Device Update instance properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, instanceName, resourceGroupName, subscriptionId	Returns instance details for the given instance and account name.
list_by_account	SELECT	accountName, resourceGroupName, subscriptionId	Returns instances for the given account name.
create	INSERT	accountName, instanceName, resourceGroupName, subscriptionId, data__properties	Creates or updates instance.
delete	DELETE	accountName, instanceName, resourceGroupName, subscriptionId	Deletes instance.
update	UPDATE	accountName, instanceName, resourceGroupName, subscriptionId	Updates instance's tags.

SELECT examples

Returns instances for the given account name.

SELECT
location,
properties,
tags
FROM azure.device_update.instances
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.device_update.instances (
accountName,
instanceName,
resourceGroupName,
subscriptionId,
data__properties,
tags,
location,
properties
)
SELECT 
'{{ accountName }}',
'{{ instanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: accountName
          value: string
        - name: iotHubs
          value:
            - - name: resourceId
                value: string
        - name: enableDiagnostics
          value: boolean
        - name: diagnosticStorageProperties
          value:
            - name: authenticationType
              value: string
            - name: connectionString
              value: string
            - name: resourceId
              value: string

UPDATE example

Updates a instances resource.

/*+ update */
UPDATE azure.device_update.instances
SET 
tags = '{{ tags }}'
WHERE 
accountName = '{{ accountName }}'
AND instanceName = '{{ instanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified instances resource.

/*+ delete */
DELETE FROM azure.device_update.instances
WHERE accountName = '{{ accountName }}'
AND instanceName = '{{ instanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';