Skip to main content

infrastructure_resources

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

Overview

Nameinfrastructure_resources
TypeResource
Idazure.integration_environment.infrastructure_resources

Fields

The following fields are returned by SELECT queries:

ARM operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, spaceName, infrastructureResourceNameGet a InfrastructureResource
list_by_spaceselectsubscriptionId, resourceGroupName, spaceNametop, skip, maxpagesize, filter, select, expand, orderbyList InfrastructureResource resources by Space
create_or_updateinsertsubscriptionId, resourceGroupName, spaceName, infrastructureResourceNameCreate a InfrastructureResource
patchupdatesubscriptionId, resourceGroupName, spaceName, infrastructureResourceNameUpdate a InfrastructureResource
deletedeletesubscriptionId, resourceGroupName, spaceName, infrastructureResourceNameDelete a InfrastructureResource

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
infrastructureResourceNamestringThe name of the infrastructure resource in the space.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
spaceNamestringThe name of the space
subscriptionIdstringThe ID of the target subscription.
expandarrayExpand the indicated resources into the response.
filterstringFilter the result list using the given expression.
maxpagesizeinteger (int32)The maximum number of result items per page.
orderbyarrayExpressions that specify the order of returned results.
selectarraySelect the specified fields to be included in the response.
skipinteger (int32)The number of result items to skip.
topinteger (int32)The number of result items to return.

SELECT examples

Get a InfrastructureResource

SELECT
properties
FROM azure.integration_environment.infrastructure_resources
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND spaceName = '{{ spaceName }}' -- required
AND infrastructureResourceName = '{{ infrastructureResourceName }}' -- required
;

INSERT examples

Create a InfrastructureResource

INSERT INTO azure.integration_environment.infrastructure_resources (
data__properties,
subscriptionId,
resourceGroupName,
spaceName,
infrastructureResourceName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ spaceName }}',
'{{ infrastructureResourceName }}'
RETURNING
properties
;

UPDATE examples

Update a InfrastructureResource

UPDATE azure.integration_environment.infrastructure_resources
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND spaceName = '{{ spaceName }}' --required
AND infrastructureResourceName = '{{ infrastructureResourceName }}' --required
RETURNING
properties;

DELETE examples

Delete a InfrastructureResource

DELETE FROM azure.integration_environment.infrastructure_resources
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND spaceName = '{{ spaceName }}' --required
AND infrastructureResourceName = '{{ infrastructureResourceName }}' --required
;