workflows

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

Overview

Name	workflows
Type	Resource
Id	azure.logic_apps.workflows

Fields

vw_workflows

Name	Datatype	Description
id	text	The resource id.
name	text	Gets the resource name.
access_control	text	field from the properties object
access_endpoint	text	field from the properties object
changed_time	text	field from the properties object
created_time	text	field from the properties object
definition	text	field from the properties object
endpoints_configuration	text	field from the properties object
identity	text	Managed service identity properties.
integration_account	text	field from the properties object
integration_service_environment	text	field from the properties object
location	text	The resource location.
parameters	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	field from the properties object
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.
version	text	field from the properties object
workflowName	text	field from the properties object

workflows

Name	Datatype	Description
id	string	The resource id.
name	string	Gets the resource name.
identity	object	Managed service identity properties.
location	string	The resource location.
properties	object	The workflow properties.
tags	object	The resource tags.
type	string	Gets the resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, subscriptionId, workflowName	Gets a workflow.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets a list of workflows by resource group.
list_by_subscription	SELECT	subscriptionId	Gets a list of workflows by subscription.
create_or_update	INSERT	resourceGroupName, subscriptionId, workflowName	Creates or updates a workflow.
delete	DELETE	resourceGroupName, subscriptionId, workflowName	Deletes a workflow.
update	UPDATE	resourceGroupName, subscriptionId, workflowName	Updates a workflow.
disable	EXEC	resourceGroupName, subscriptionId, workflowName	Disables a workflow.
enable	EXEC	resourceGroupName, subscriptionId, workflowName	Enables a workflow.
generate_upgraded_definition	EXEC	resourceGroupName, subscriptionId, workflowName	Generates the upgraded definition for a workflow.
move	EXEC	resourceGroupName, subscriptionId, workflowName	Moves an existing workflow.
regenerate_access_key	EXEC	resourceGroupName, subscriptionId, workflowName	Regenerates the callback URL access key for request triggers.
validate_by_location	EXEC	location, resourceGroupName, subscriptionId, workflowName	Validates the workflow definition.
validate_by_resource_group	EXEC	resourceGroupName, subscriptionId, workflowName	Validates the workflow.

SELECT examples

Gets a list of workflows by subscription.

vw_workflows

SELECT
id,
name,
access_control,
access_endpoint,
changed_time,
created_time,
definition,
endpoints_configuration,
identity,
integration_account,
integration_service_environment,
location,
parameters,
provisioning_state,
resourceGroupName,
sku,
state,
subscriptionId,
tags,
type,
version,
workflowName
FROM azure.logic_apps.vw_workflows
WHERE subscriptionId = '{{ subscriptionId }}';

workflows

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.logic_apps.workflows (
resourceGroupName,
subscriptionId,
workflowName,
properties,
identity,
location,
tags
)
SELECT 
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ workflowName }}',
'{{ properties }}',
'{{ identity }}',
'{{ location }}',
'{{ tags }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: createdTime
          value: string
        - name: changedTime
          value: string
        - name: state
          value: []
        - name: version
          value: string
        - name: accessEndpoint
          value: string
        - name: endpointsConfiguration
          value:
            - name: workflow
              value:
                - name: outgoingIpAddresses
                  value:
                    - - name: address
                        value: string
                - name: accessEndpointIpAddresses
                  value:
                    - - name: address
                        value: string
        - name: accessControl
          value:
            - name: triggers
              value:
                - name: allowedCallerIpAddresses
                  value:
                    - - name: addressRange
                        value: string
                - name: openAuthenticationPolicies
                  value:
                    - name: policies
                      value: object
        - name: sku
          value:
            - name: name
              value: []
            - name: plan
              value:
                - name: id
                  value: string
                - name: name
                  value: string
                - name: type
                  value: string
        - name: definition
          value: []
        - name: parameters
          value: object
    - name: identity
      value:
        - name: type
          value: string
        - name: tenantId
          value: string
        - name: principalId
          value: string
        - name: userAssignedIdentities
          value: object
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

UPDATE example

Updates a workflows resource.

/*+ update */
UPDATE azure.logic_apps.workflows
SET 

WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workflowName = '{{ workflowName }}';

DELETE example

Deletes the specified workflows resource.

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