Pipeline table reference
This article contains the table definitions used in the Pipeline solution. More information: Overview of pipelines in Power Platform
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
.
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: ActiveValue: 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 |
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 EnvironmentValue: 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: ActiveValue: 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: PendingValue: 200000001 Label: SuccessValue: 200000002 Label: Failed |
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: ActiveValue: 2 Label: Inactive |
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: ActiveValue: 2 Label: Inactive |
TargetDeploymentEnvironmentId Target Deployment Environment ID |
Lookup | Lookup to the target deployment environment associated with this deployment stage. |
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: NoneValue: 200000201 Label: ValidateValue: 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: NotStartedValue: 200000001 Label: StartedValue: 200000002 Label: SucceededValue: 200000003 Label: FailedValue: 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: NotStartedValue: 200000001 Label: StartedValue: 200000002 Label: SucceededValue: 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: ActiveValue: 2 Label: Inactive |
SubOperation SubOperation |
Picklist | Represents the sub operation of the current deployment operation. This is managed internally. Value: 200000100 Label: NoneValue: 200000101 Label: Executing Pre-stepValue: 200000102 Label: Retrieving Artifact ConfigurationValue: 200000103 Label: Validating Artifact ConfigurationValue: 200000104 Label: Retrieving ArtifactValue: 200000105 Label: Deploying ArtifactValue: 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. |
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: NoneValue: 200000201 Label: ValidateValue: 200000202 Label: Deploy |
OperationStatus Operation Status |
Picklist | Stores the status of the deployment sub operation. Value: 200000000 Label: NotStartedValue: 200000001 Label: StartedValue: 200000002 Label: SucceededValue: 200000003 Label: FailedValue: 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: ActiveValue: 2 Label: Inactive |
SubOperation Suboperation |
Picklist | Stores additional information about the background operation. Value: 200000100 Label: NoneValue: 200000101 Label: Executing Pre-stepValue: 200000102 Label: Retrieving Artifact ConfigurationValue: 200000103 Label: Validating Artifact ConfigurationValue: 200000104 Label: Retrieving ArtifactValue: 200000105 Label: Deploying ArtifactValue: 200000106 Label: Executing Post-step |