business_processes

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

Overview

Name	business_processes
Type	Resource
Id	azure.integration_environment.business_processes

Fields

vw_business_processes

Name	Datatype	Description
description	text	field from the properties object
applicationName	text	field from the properties object
businessProcessName	text	field from the properties object
business_process_mapping	text	field from the properties object
business_process_stages	text	field from the properties object
identifier	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
spaceName	text	field from the properties object
subscriptionId	text	field from the properties object
table_name	text	field from the properties object
tracking_data_store_reference_name	text	field from the properties object
version	text	field from the properties object

business_processes

Name	Datatype	Description
properties	object	The properties of business process.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	applicationName, businessProcessName, resourceGroupName, spaceName, subscriptionId	Get a BusinessProcess
list_by_application	SELECT	applicationName, resourceGroupName, spaceName, subscriptionId	List BusinessProcess resources by Application
create_or_update	INSERT	applicationName, businessProcessName, resourceGroupName, spaceName, subscriptionId	Create a BusinessProcess
delete	DELETE	applicationName, businessProcessName, resourceGroupName, spaceName, subscriptionId	Delete a BusinessProcess
patch	UPDATE	applicationName, businessProcessName, resourceGroupName, spaceName, subscriptionId	Update a BusinessProcess

SELECT examples

List BusinessProcess resources by Application

vw_business_processes

SELECT
description,
applicationName,
businessProcessName,
business_process_mapping,
business_process_stages,
identifier,
provisioning_state,
resourceGroupName,
spaceName,
subscriptionId,
table_name,
tracking_data_store_reference_name,
version
FROM azure.integration_environment.vw_business_processes
WHERE applicationName = '{{ applicationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';

business_processes

SELECT
properties
FROM azure.integration_environment.business_processes
WHERE applicationName = '{{ applicationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.integration_environment.business_processes (
applicationName,
businessProcessName,
resourceGroupName,
spaceName,
subscriptionId,
properties
)
SELECT 
'{{ applicationName }}',
'{{ businessProcessName }}',
'{{ resourceGroupName }}',
'{{ spaceName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: version
          value: string
        - name: description
          value: string
        - name: tableName
          value: string
        - name: trackingDataStoreReferenceName
          value: string
        - name: identifier
          value:
            - name: propertyName
              value: string
            - name: propertyType
              value: string
        - name: businessProcessStages
          value: object
        - name: businessProcessMapping
          value: object

UPDATE example

Updates a business_processes resource.

/*+ update */
UPDATE azure.integration_environment.business_processes
SET 
properties = '{{ properties }}'
WHERE 
applicationName = '{{ applicationName }}'
AND businessProcessName = '{{ businessProcessName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified business_processes resource.

/*+ delete */
DELETE FROM azure.integration_environment.business_processes
WHERE applicationName = '{{ applicationName }}'
AND businessProcessName = '{{ businessProcessName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND spaceName = '{{ spaceName }}'
AND subscriptionId = '{{ subscriptionId }}';