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.integration_service_environments

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe resource id.
namestringGets the resource name.
encryptionConfigurationobjectThe encryption configuration.
endpointsConfigurationobjectThe endpoints configuration.
identityobjectManaged service identity properties.
integrationServiceEnvironmentIdstringGets the tracking id.
locationstringThe resource location.
networkConfigurationobjectThe network configuration.
provisioningStatestringThe provisioning state. Known values are: "NotSpecified", "Accepted", "Running", "Ready", "Creating", "Created", "Deleting", "Deleted", "Canceled", "Failed", "Succeeded", "Moving", "Updating", "Registering", "Registered", "Unregistering", "Unregistered", "Completed", "Renewing", "Pending", "Waiting", and "InProgress".
skuobjectThe sku.
statestringThe integration service environment state. Known values are: "NotSpecified", "Completed", "Enabled", "Disabled", "Deleted", and "Suspended".
tagsobjectThe resource tags.
typestringGets the resource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group, integration_service_environment_name, subscription_idGets an integration service environment.
list_by_resource_groupselectresource_group, subscription_id$topGets a list of integration service environments by resource group.
list_by_subscriptionselectsubscription_id$topGets a list of integration service environments by subscription.
create_or_updateinsertresource_group, integration_service_environment_name, subscription_idCreates or updates an integration service environment.
updateupdateresource_group, integration_service_environment_name, subscription_idUpdates an integration service environment.
create_or_updatereplaceresource_group, integration_service_environment_name, subscription_idCreates or updates an integration service environment.
deletedeleteresource_group, integration_service_environment_name, subscription_idDeletes an integration service environment.
restartexecresource_group, integration_service_environment_name, subscription_idRestarts 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
integration_service_environment_namestringThe integration service environment name. Required.
resource_groupstringThe resource group. Required.
subscription_idstring
$topintegerThe number of items to be included in the result. Default value is None.

SELECT examples

Gets an integration service environment.

SELECT
id,
name,
encryptionConfiguration,
endpointsConfiguration,
identity,
integrationServiceEnvironmentId,
location,
networkConfiguration,
provisioningState,
sku,
state,
tags,
type
FROM azure.logic.integration_service_environments
WHERE resource_group = '{{ resource_group }}' -- required
AND integration_service_environment_name = '{{ integration_service_environment_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates or updates an integration service environment.

INSERT INTO azure.logic.integration_service_environments (
location,
tags,
properties,
sku,
identity,
resource_group,
integration_service_environment_name,
subscription_id
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ sku }}',
'{{ identity }}',
'{{ resource_group }}',
'{{ integration_service_environment_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
identity,
location,
properties,
sku,
tags,
type
;

UPDATE examples

Updates an integration service environment.

UPDATE azure.logic.integration_service_environments
SET
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}',
sku = '{{ sku }}',
identity = '{{ identity }}'
WHERE
resource_group = '{{ resource_group }}' --required
AND integration_service_environment_name = '{{ integration_service_environment_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
identity,
location,
properties,
sku,
tags,
type;

REPLACE examples

Creates or updates an integration service environment.

REPLACE azure.logic.integration_service_environments
SET
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}',
sku = '{{ sku }}',
identity = '{{ identity }}'
WHERE
resource_group = '{{ resource_group }}' --required
AND integration_service_environment_name = '{{ integration_service_environment_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
identity,
location,
properties,
sku,
tags,
type;

DELETE examples

Deletes an integration service environment.

DELETE FROM azure.logic.integration_service_environments
WHERE resource_group = '{{ resource_group }}' --required
AND integration_service_environment_name = '{{ integration_service_environment_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Restarts an integration service environment.

EXEC azure.logic.integration_service_environments.restart 
@resource_group='{{ resource_group }}' --required,
@integration_service_environment_name='{{ integration_service_environment_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;