integration_accounts

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

Overview

Name	integration_accounts
Type	Resource
Id	azure.logic_apps.integration_accounts

Fields

vw_integration_accounts

Name	Datatype	Description
id	text	The resource id.
name	text	Gets the resource name.
integrationAccountName	text	field from the properties object
integration_service_environment	text	field from the properties object
location	text	The resource location.
resourceGroupName	text	field from the properties object
sku	text	The integration account sku.
state	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	The resource tags.
type	text	Gets the resource type.

integration_accounts

Name	Datatype	Description
id	string	The resource id.
name	string	Gets the resource name.
location	string	The resource location.
properties	object	The integration account properties.
sku	object	The integration account sku.
tags	object	The resource tags.
type	string	Gets the resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	integrationAccountName, resourceGroupName, subscriptionId	Gets an integration account.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets a list of integration accounts by resource group.
list_by_subscription	SELECT	subscriptionId	Gets a list of integration accounts by subscription.
create_or_update	INSERT	integrationAccountName, resourceGroupName, subscriptionId	Creates or updates an integration account.
delete	DELETE	integrationAccountName, resourceGroupName, subscriptionId	Deletes an integration account.
update	UPDATE	integrationAccountName, resourceGroupName, subscriptionId	Updates an integration account.
log_tracking_events	EXEC	integrationAccountName, resourceGroupName, subscriptionId, data__events, data__sourceType	Logs the integration account's tracking events.
regenerate_access_key	EXEC	integrationAccountName, resourceGroupName, subscriptionId	Regenerates the integration account access key.

SELECT examples

Gets a list of integration accounts by subscription.

vw_integration_accounts

SELECT
id,
name,
integrationAccountName,
integration_service_environment,
location,
resourceGroupName,
sku,
state,
subscriptionId,
tags,
type
FROM azure.logic_apps.vw_integration_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

integration_accounts

SELECT
id,
name,
location,
properties,
sku,
tags,
type
FROM azure.logic_apps.integration_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.logic_apps.integration_accounts (
integrationAccountName,
resourceGroupName,
subscriptionId,
properties,
sku,
location,
tags
)
SELECT 
'{{ integrationAccountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ sku }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: integrationServiceEnvironment
          value:
            - name: id
              value: string
            - name: name
              value: string
            - name: type
              value: string
        - name: state
          value: []
    - name: sku
      value:
        - name: name
          value: []
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

UPDATE example

Updates a integration_accounts resource.

/*+ update */
UPDATE azure.logic_apps.integration_accounts
SET 
properties = '{{ properties }}',
sku = '{{ sku }}',
location = '{{ location }}',
tags = '{{ tags }}'
WHERE 
integrationAccountName = '{{ integrationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified integration_accounts resource.

/*+ delete */
DELETE FROM azure.logic_apps.integration_accounts
WHERE integrationAccountName = '{{ integrationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';