pipelines

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

Overview

Name	pipelines
Type	Resource
Id	azure.devops.pipelines

Fields

vw_pipelines

Name	Datatype	Description
id	text	Resource Id
name	text	Resource Name
bootstrap_configuration	text	field from the properties object
location	text	Resource Location
organization	text	field from the properties object
pipelineName	text	field from the properties object
pipeline_id	text	field from the properties object
project	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource Tags
type	text	Resource Type

pipelines

Name	Datatype	Description
id	string	Resource Id
name	string	Resource Name
location	string	Resource Location
properties	object	Custom properties of a Pipeline.
tags	object	Resource Tags
type	string	Resource Type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	pipelineName, resourceGroupName, subscriptionId	Gets an existing Azure Pipeline.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all Azure Pipelines under the specified resource group.
list_by_subscription	SELECT	subscriptionId	Lists all Azure Pipelines under the specified subscription.
create_or_update	INSERT	pipelineName, resourceGroupName, subscriptionId, data__properties	Creates or updates an Azure Pipeline.
delete	DELETE	pipelineName, resourceGroupName, subscriptionId	Deletes an Azure Pipeline.
update	UPDATE	pipelineName, resourceGroupName, subscriptionId	Updates the properties of an Azure Pipeline. Currently, only tags can be updated.

SELECT examples

Lists all Azure Pipelines under the specified subscription.

vw_pipelines

SELECT
id,
name,
bootstrap_configuration,
location,
organization,
pipelineName,
pipeline_id,
project,
resourceGroupName,
subscriptionId,
tags,
type
FROM azure.devops.vw_pipelines
WHERE subscriptionId = '{{ subscriptionId }}';

pipelines

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.devops.pipelines
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.devops.pipelines (
pipelineName,
resourceGroupName,
subscriptionId,
data__properties,
properties,
tags,
location
)
SELECT 
'{{ pipelineName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: pipelineId
          value: integer
        - name: organization
          value:
            - name: id
              value: string
            - name: name
              value: string
        - name: project
          value:
            - name: id
              value: string
            - name: name
              value: string
        - name: bootstrapConfiguration
          value:
            - name: repository
              value:
                - name: repositoryType
                  value: string
                - name: id
                  value: string
                - name: defaultBranch
                  value: string
                - name: authorization
                  value:
                    - name: authorizationType
                      value: string
                    - name: parameters
                      value: object
                - name: properties
                  value: object
            - name: template
              value:
                - name: id
                  value: string
                - name: parameters
                  value: object
    - name: id
      value: string
    - name: type
      value: string
    - name: tags
      value: object
    - name: location
      value: string
    - name: name
      value: string

UPDATE example

Updates a pipelines resource.

/*+ update */
UPDATE azure.devops.pipelines
SET 
tags = '{{ tags }}'
WHERE 
pipelineName = '{{ pipelineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified pipelines resource.

/*+ delete */
DELETE FROM azure.devops.pipelines
WHERE pipelineName = '{{ pipelineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';