Les på engelsk Rediger

Del via


Pipeline table reference

This article contains the table definitions used in the Pipeline solution. More information: Overview of pipelines in Power Platform

Diagram showing relationship between pipeline tables

Obs!

For brevity, common columns found on all tables are not included here. The schema name for these columns are: CreatedBy, CreatedOn, CreatedOnBehalfBy, ImportSequenceNumber, ModifiedBy, ModifiedOn, ModifiedOnBehalfBy, OverriddenCreatedOn, OwningBusinessUnit, OwningTeam, OwningUser, TimeZoneRuleVersionNumber, UTCConversionTimeZoneCode, VersionNumber, and statecode.

DeploymentArtifact (Deployment Artifact)

Stores solution artifacts that are exported when running pipelines.

SchemaName
Display Name
Type Description
ArtifactVersion
Artifact Version
String Stores the artifact version number.
DeploymentArtifactId
DeploymentArtifact
Uniqueidentifier Unique identifier for entity instances.
GeneratedOn
Generated On
DateTime Date and time when the artifact record was generated.
Name
Name
String The name of the artifact record.
OwnerId
Owner
Owner Owner ID
statuscode
Status Reason
Status Reason for the status of the Deployment Artifact.
Value:1 Label: Active
Value:2 Label: Inactive
ArtifactFile
Managed Artifact File
File Stores the managed version of the artifact.
Not valid for Create
ArtifactFileUnmanaged
Unmanaged Artifact File
File Unmanaged Artifact File.
Not valid for Create

DeploymentEnvironment (Deployment Environment)

Stores the environments that are participating in pipelines and configured in the deployment stages.

SchemaName
Display Name
Type Description
DeploymentEnvironmentId
Deployment Environment
Uniqueidentifier Unique identifier for deployment environment instances
EnvironmentId
Environment ID
String The Environment ID of the Power Platform environment.
EnvironmentType
Environment Type
Picklist Indicates if the environment is used for development or as a target environment that a pipeline will deploy to.
Value: 200000000 Label: Development Environment
Value: 200000001 Label: Target Environment
ErrorMessage
Error Message
String Stores the Power Platform environment validation failure error messages.
name
Name
String The name of the Deployment Environment.
OwnerId
Owner
Owner Owner ID
statuscode
Status Reason
Status Reason for the status of the Deployment Environment.
Value:1 Label: Active
Value:2 Label: Inactive
ValidationStatus
Validation Status
Picklist Indicates if the Environment ID of the Power Platform environment has been validated.
Not valid for Create
Value:200000000 Label: Pending
Value:200000001 Label: Success
Value:200000002 Label: Failed

DeploymentPipeline (Deployment Pipeline)

Stores the pipeline configurations.

SchemaName
Display Name
Type Description
DeploymentPipelineId
Deployment Pipeline
Uniqueidentifier Unique identifier for the pipeline instances
Description
Description
String Custom description of the pipeline.
Name
Name
String The name of the pipeline record.
OwnerId
Owner
Owner Owner ID
statuscode
Status Reason
Status Reason for the status of the deployment pipeline.
Value:1 Label: Active
Value:2 Label: Inactive

DeploymentStage (Deployment Stage)

Stores the deployment stage configuration such as target environment and prerequisite deployment stages.

SchemaName
Display Name
Type Description
DeploymentPipelineId
Deployment Pipeline
Lookup Lookup to the pipeline that this stage belongs to.
DeploymentStageId
Deployment Stage ID
Uniqueidentifier Unique identifier for the Deployment Stage instance.
Description
Description
String Custom description of the deployment stage instance.
Name
Name
String The name of the deployment stage instance.
OwnerId
Owner
Owner Owner ID
PreviousDeploymentStageId
Previous Deployment Stage
Lookup Lookup to the previous deployment stage configured in the pipeline. Previous deployment stages must be run successfully before deployments can be run for the current stage.
statuscode
Status Reason
Status Reason for the status of the Deployment Stage.
Value:1 Label: Active
Value:2 Label: Inactive
TargetDeploymentEnvironmentId
Target Deployment Environment ID
Lookup Lookup to the target deployment environment associated with this deployment stage.

DeploymentStageRun (Deployment Stage Run)

Stores information about a deployment stage execution.

SchemaName
Display Name
Type Description
ArtifactDevCurrentVersion
Solution Artifact Current Version
String Stores the current version of the solution artifact within a development environment.
ArtifactId
Artifact ID
Lookup Internal use only.
ArtifactName
Artifact Name
String The name of the Deployment Artifact being deployed by a Stage Run instance.
ArtifactVersion
Solution Artifact Version
String The version number of the Deployment Artifact being deployed by a Stage Run instance.
DeploymentSettingsJson
Deployment Settings JSON
String Validated JSON payload storing the Connection Reference and Environment Variable information collected when a Deployment Stage is run.
DeploymentStageId
Deployment Stage
Lookup Lookup to the Deployment Stage associated with a Deployment Stage Run instance.
DeploymentStageRunId
Deployment Stage Run
Uniqueidentifier Unique identifier for Deployment Stage Run instances.
DevDeploymentEnvironment
Development Deployment Environment ID
Lookup Lookup to the development Deployment Environment associated with a Deployment Stage Run.
DevEnvironmentId
Dev Environment Id
String For internal use only.
EndTime
End Time
DateTime Date and time when the deployment succeeded or failed.
ErrorMessage
Error Message
String Stores the deployment failure messages for a stage run instance.
Name
Name
String The name of a Deployment Stage Run. This is auto-generated based on the stage name, the artifact name, and the artifact version number.
Operation
Operation
Picklist Indicates the current operation the deployment.
Value: 200000200 Label: None
Value: 200000201 Label: Validate
Value: 200000202 Label: Deploy
OperationDetails
Operation Details
String Stores the details of the current deployment operation.
OperationStatus
Operation Status
Picklist Stores the status of the current deployment operation.
Value: 200000000 Label: NotStarted
Value: 200000001 Label: Started
Value: 200000002 Label: Succeeded
Value: 200000003 Label: Failed
Value: 200000004 Label: Pending
OwnerId
Owner
Owner Owner ID
RetryCount
Retry Count
Integer For internal use only.
StageRunStatus
Stage Run Status
Picklist Indicates the overall status of a Deployment Stage Run.
Value: 200000000 Label: NotStarted
Value: 200000001 Label: Started
Value: 200000002 Label: Succeeded
Value: 200000003 Label: Failed
StartTime
Start Time
DateTime Date and time when the deployment started.
statuscode
Status Reason
Status Reason for the status of the Deployment Stage Run.
Value:1 Label: Active
Value:2 Label: Inactive
SubOperation
SubOperation
Picklist Represents the sub operation of the current deployment operation. This is managed internally.
Value: 200000100 Label: None
Value: 200000101 Label: Executing Pre-step
Value: 200000102 Label: Retrieving Artifact Configuration
Value: 200000103 Label: Validating Artifact Configuration
Value: 200000104 Label: Retrieving Artifact
Value: 200000105 Label: Deploying Artifact
Value: 200000106 Label: Executing Post-step
TargetDeploymentEnvironment
Target Deployment Environment ID
Lookup Lookup to the target Deployment Environment associated with a Deployment Stage Run.
TargetEnvironmentId
Target Environment Id
String For internal use only.
ValidationResults
Validation Results
String Stores the artifact validation response.

DeploymentStageRunStatus (Deployment Stage Run Suboperations)

Stores background operation information for a Deployment Stage Run.

SchemaName
Display Name
Type Description
DeploymentStageRunId
Deployment Stage Run
Lookup Lookup to the owning Deployment Stage Run instance.
DeploymentStageRunStatusId
Deployment Stage Run Suboperation ID
Uniqueidentifier Unique identifier for Deployment Stage Run Suboperation instances.
Details
Details
String Stores information about the Deployment Stage Run Suboperation.
EndTime
End Time
DateTime Date and Time when the deployment operation succeeded or failed.
ErrorMessage
Error Message
String Stores any error message associated with the Deployment Stage Run Suboperation.
Name
Name
String The name of the Deployment Stage Run Suboperation. This is managed internally.
Operation
Operation
Picklist Stores information about the deployment operation being run.
Value: 200000200 Label: None
Value: 200000201 Label: Validate
Value: 200000202 Label: Deploy
OperationStatus
Operation Status
Picklist Stores the status of the deployment sub operation.
Value: 200000000 Label: NotStarted
Value: 200000001 Label: Started
Value: 200000002 Label: Succeeded
Value: 200000003 Label: Failed
Value: 200000004 Label: Pending
OwnerId
Owner
Owner Owner ID
RetryCount
Retry Count
Integer For internal use only.
StartTime
Start Time
DateTime Date and time when the deployment operation started.
statuscode
Status Reason
Status Reason for the status of the Deployment Stage Run Status.
Value:1 Label: Active
Value:2 Label: Inactive
SubOperation
Suboperation
Picklist Stores additional information about the background operation.
Value: 200000100 Label: None
Value: 200000101 Label: Executing Pre-step
Value: 200000102 Label: Retrieving Artifact Configuration
Value: 200000103 Label: Validating Artifact Configuration
Value: 200000104 Label: Retrieving Artifact
Value: 200000105 Label: Deploying Artifact
Value: 200000106 Label: Executing Post-step

See Also

Overview of pipelines in Power Platform