connection_types

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

Overview

Name	connection_types
Type	Resource
Id	azure.automation.connection_types

Fields

vw_connection_types

Name	Datatype	Description
id	text	Gets the id of the resource.
name	text	Gets the name of the connection type.
description	text	field from the properties object
automationAccountName	text	field from the properties object
connectionTypeName	text	field from the properties object
creation_time	text	field from the properties object
field_definitions	text	field from the properties object
is_global	text	field from the properties object
last_modified_time	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Resource type

connection_types

Name	Datatype	Description
id	string	Gets the id of the resource.
name	string	Gets the name of the connection type.
properties	object	Properties of the connection type.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	automationAccountName, connectionTypeName, resourceGroupName, subscriptionId	Retrieve the connection type identified by connection type name.
list_by_automation_account	SELECT	automationAccountName, resourceGroupName, subscriptionId	Retrieve a list of connection types.
create_or_update	INSERT	automationAccountName, connectionTypeName, resourceGroupName, subscriptionId, data__name, data__properties	Create a connection type.
delete	DELETE	automationAccountName, connectionTypeName, resourceGroupName, subscriptionId	Delete the connection type.

SELECT examples

Retrieve a list of connection types.

vw_connection_types

SELECT
id,
name,
description,
automationAccountName,
connectionTypeName,
creation_time,
field_definitions,
is_global,
last_modified_time,
resourceGroupName,
subscriptionId,
type
FROM azure.automation.vw_connection_types
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

connection_types

SELECT
id,
name,
properties,
type
FROM azure.automation.connection_types
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.automation.connection_types (
automationAccountName,
connectionTypeName,
resourceGroupName,
subscriptionId,
data__name,
data__properties,
name,
properties
)
SELECT 
'{{ automationAccountName }}',
'{{ connectionTypeName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__name }}',
'{{ data__properties }}',
'{{ name }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: name
      value: string
    - name: properties
      value:
        - name: isGlobal
          value: boolean
        - name: fieldDefinitions
          value: object

DELETE example

Deletes the specified connection_types resource.

/*+ delete */
DELETE FROM azure.automation.connection_types
WHERE automationAccountName = '{{ automationAccountName }}'
AND connectionTypeName = '{{ connectionTypeName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';