Skip to main content

integration_service_environments

Creates, updates, deletes, gets or lists an integration_service_environments resource.

Overview

Nameintegration_service_environments
TypeResource
Idazure.logic_apps.integration_service_environments

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe resource id.
namestringGets the resource name.
identityobjectManaged service identity properties.
locationstringThe resource location.
propertiesobjectThe integration service environment properties.
skuobjectThe sku.
tagsobjectThe resource tags.
typestringGets the resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroup, integrationServiceEnvironmentNameapi-versionGets an integration service environment.
list_by_resource_groupselectsubscriptionId, resourceGroupapi-version, $topGets a list of integration service environments by resource group.
list_by_subscriptionselectsubscriptionIdapi-version, $topGets a list of integration service environments by subscription.
create_or_updateinsertsubscriptionId, resourceGroup, integrationServiceEnvironmentNameapi-versionCreates or updates an integration service environment.
updateupdatesubscriptionId, resourceGroup, integrationServiceEnvironmentNameapi-versionUpdates an integration service environment.
deletedeletesubscriptionId, resourceGroup, integrationServiceEnvironmentNameapi-versionDeletes an integration service environment.
restartexecsubscriptionId, resourceGroup, integrationServiceEnvironmentNameapi-versionRestarts an integration service environment.

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
integrationServiceEnvironmentNamestringThe integration service environment name.
resourceGroupstringThe resource group.
subscriptionIdstringThe subscription id.
$topinteger (int32)The number of items to be included in the result.
api-versionstringThe API version.

SELECT examples

Gets an integration service environment.

SELECT
id,
name,
identity,
location,
properties,
sku,
tags,
type
FROM azure.logic_apps.integration_service_environments
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroup = '{{ resourceGroup }}' -- required
AND integrationServiceEnvironmentName = '{{ integrationServiceEnvironmentName }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Creates or updates an integration service environment.

INSERT INTO azure.logic_apps.integration_service_environments (
data__properties,
data__sku,
data__identity,
data__location,
data__tags,
subscriptionId,
resourceGroup,
integrationServiceEnvironmentName,
api-version
)
SELECT
'{{ properties }}',
'{{ sku }}',
'{{ identity }}',
'{{ location }}',
'{{ tags }}',
'{{ subscriptionId }}',
'{{ resourceGroup }}',
'{{ integrationServiceEnvironmentName }}',
'{{ api-version }}'
RETURNING
id,
name,
identity,
location,
properties,
sku,
tags,
type
;

UPDATE examples

Updates an integration service environment.

UPDATE azure.logic_apps.integration_service_environments
SET
data__properties = '{{ properties }}',
data__sku = '{{ sku }}',
data__identity = '{{ identity }}',
data__location = '{{ location }}',
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroup = '{{ resourceGroup }}' --required
AND integrationServiceEnvironmentName = '{{ integrationServiceEnvironmentName }}' --required
AND api-version = '{{ api-version}}'
RETURNING
id,
name,
identity,
location,
properties,
sku,
tags,
type;

DELETE examples

Deletes an integration service environment.

DELETE FROM azure.logic_apps.integration_service_environments
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroup = '{{ resourceGroup }}' --required
AND integrationServiceEnvironmentName = '{{ integrationServiceEnvironmentName }}' --required
AND api-version = '{{ api-version }}'
;

Lifecycle Methods

Restarts an integration service environment.

EXEC azure.logic_apps.integration_service_environments.restart 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroup='{{ resourceGroup }}' --required,
@integrationServiceEnvironmentName='{{ integrationServiceEnvironmentName }}' --required,
@api-version='{{ api-version }}'
;