Skip to main content

logic_apps

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

Overview

Namelogic_apps
TypeResource
Idazure.app_containers.logic_apps

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
filesobjectGets or sets the files.
flowStatestringGets or sets the state of the workflow. Known values are: "NotSpecified", "Completed", "Enabled", "Disabled", "Deleted", and "Suspended". (NotSpecified, Completed, Enabled, Disabled, Deleted, Suspended)
healthobjectGets or sets workflow health.
kindstringGets the logic app hybrid workflow kind. Known values are: "Stateful", "Stateless", and "Agentic". (Stateful, Stateless, Agentic)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_workflowselectresource_group_name, container_app_name, logic_app_name, workflow_name, subscription_idGet workflow information by its name. Get workflow information by its name.
getselectresource_group_name, container_app_name, logic_app_name, subscription_idGets a logic app extension resource. Gets a logic app extension resource.
create_or_updateinsertresource_group_name, container_app_name, logic_app_name, subscription_idCreate or update a Logic App extension resource.
create_or_updatereplaceresource_group_name, container_app_name, logic_app_name, subscription_idCreate or update a Logic App extension resource.
deletedeleteresource_group_name, container_app_name, logic_app_name, subscription_idDeletes a Logic App extension resource.
list_workflows_connectionsexecresource_group_name, container_app_name, logic_app_name, subscription_idGets logic app's connections. Gets logic app's connections.
list_workflowsexecresource_group_name, container_app_name, logic_app_name, subscription_idList the workflows for a logic app. List the workflows for a logic app.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
container_app_namestringName of the Container App. Required.
logic_app_namestringName of the Logic App, the extension resource. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
workflow_namestringWorkflow name. Required.

SELECT examples

Get workflow information by its name. Get workflow information by its name.

SELECT
id,
name,
files,
flowState,
health,
kind,
systemData,
type
FROM azure.app_containers.logic_apps
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND container_app_name = '{{ container_app_name }}' -- required
AND logic_app_name = '{{ logic_app_name }}' -- required
AND workflow_name = '{{ workflow_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update a Logic App extension resource.

INSERT INTO azure.app_containers.logic_apps (
id,
name,
type,
systemData,
resource_group_name,
container_app_name,
logic_app_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ name }}',
'{{ type }}',
'{{ systemData }}',
'{{ resource_group_name }}',
'{{ container_app_name }}',
'{{ logic_app_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
systemData,
type
;

REPLACE examples

Create or update a Logic App extension resource.

REPLACE azure.app_containers.logic_apps
SET
id = '{{ id }}',
name = '{{ name }}',
type = '{{ type }}',
systemData = '{{ systemData }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND container_app_name = '{{ container_app_name }}' --required
AND logic_app_name = '{{ logic_app_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
systemData,
type;

DELETE examples

Deletes a Logic App extension resource.

DELETE FROM azure.app_containers.logic_apps
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND container_app_name = '{{ container_app_name }}' --required
AND logic_app_name = '{{ logic_app_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Gets logic app's connections. Gets logic app's connections.

EXEC azure.app_containers.logic_apps.list_workflows_connections 
@resource_group_name='{{ resource_group_name }}' --required,
@container_app_name='{{ container_app_name }}' --required,
@logic_app_name='{{ logic_app_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;