Azure DevOps Tables

Tables

AzureDevOpsPipeLineApprovals

Name	Type	Description
ID	string	Unique identifier for the approval instance
Status	string	Current state of the approval (e.g., pending, approved, rejected)
CreatedOn	datetime	Date and time when the approval was created or requested
LastModifiedOn	datetime	Date and time of the most recent update to the approval
Instructions	string	Custom instructions or comments provided to the approver
ExecutionOrder	string	Defines the sequence in which approvals or stages are executed
MinRequiredApprovers	integer	Minimum number of approvers required to proceed
Pipeline	string	Name or object representing the pipeline where the approval occurs
PipeLineId	string	Unique identifier for the associated pipeline
ConfigID	integer	ID of the configuration entity (e.g., environment or resource)
BatchDate	datetime	Custom value to represent batch execution or scheduling time

AzureDevOpsPipelineCheckConfigurations

Name	Type	Description
ID	integer	Unique identifier for the check configuration
CreatedBy	string	Name or identity of the user who created the check configuration
CreatedById	string	Unique ID of the user who created the check configuration
CreatedOn	datetime	Timestamp when the check configuration was created
ModifiedBy	string	Name or identity of the user who last modified the check configuration
ModifiedById	string	Unique ID of the user who last modified the check configuration
ModifiedOn	datetime	Timestamp of the last modification to the check configuration
Timeout	integer	Duration before the check times out if no action is taken
TypeId	string	Unique identifier for the type of check (e.g., business rule, external, etc.)
TypeName	string	Descriptive name for the type of check
Url	string	URL associated with the check configuration or external service
ConfigID	integer	Configuration-specific ID, often referencing the associated resource or policy
BatchDate	datetime	Custom field to represent batch execution or scheduling time

AzureDevOpsPipeLines

Name	Type	Description
ID	integer	Unique identifier for the pipeline
Url	string	URL reference to the pipeline resource in Azure DevOps
Revision	integer	The revision number of the pipeline, indicating how many times it has changed
Name	string	The display name of the pipeline
Folder	string	Folder path where the pipeline is stored (for organization)
ConfigID	integer	ID referencing a related configuration (e.g., environment, variable group)
BatchDate	datetime	Custom field to represent batch run date or scheduling time

AzureDevOpsProjects

Name	Type	Description
ID	string	Unique identifier for the Azure DevOps project
Name	string	Name of the project
Url	string	URL reference to the project in Azure DevOps
Description	string	Text description of the project’s purpose or contents
BatchDate	datetime	Custom field to represent batch load or synchronization date
ConfigID	integer	Custom configuration ID associated with the project (e.g., for mapping/setup)

AzureDevOpsPullRequests

Name	Type	Description
ID	integer	Unique identifier for the pull request
Repository	string	Name of the repository where the pull request was created
RepositoryId	string	Unique ID of the associated repository
CodeReviewId	integer	Internal ID for the code review process
Status	string	Current status of the pull request (e.g., active, completed, abandoned)
CreatedBy	string	Display name or identity of the user who created the pull request
CreatedByID	string	Unique ID of the user who created the pull request
CreationDate	datetime	Date and time the pull request was created
ClosedDate	datetime	Date and time the pull request was completed or abandoned
Title	string	Title of the pull request
Description	string	Description or summary of the pull request changes
SourceRefName	string	The source branch of the pull request
TargetRefName	string	The target branch the changes are being merged into
MergeStatus	string	Indicates if the pull request can be merged automatically
MergeId	string	ID representing the merge operation
LastMergeSourceCommitId	string	Commit ID of the source branch at the time of the last merge attempt
LastMergeSourceCommitUrl	string	URL to view the source commit from the last merge attempt
LastMergeTargetCommitId	string	Commit ID of the target branch at the time of the last merge attempt
LastMergeTargetCommitUrl	string	URL to view the target commit from the last merge attempt
LastMergeCommitId	string	Commit ID resulting from the last successful merge
LastMergeCommitUrl	string	URL to view the final merge commit
Reviewers	string	List of reviewers assigned to the pull request
Url	string	URL reference to the pull request resource
SupportsIterations	bit	Indicates whether the pull request supports iteration tracking
CompletionQueueTime	datetime	Time the pull request was queued for auto-completion (if applicable)
ConfigID	integer	Custom configuration ID (e.g., used in tracking or integration systems)
BatchDate	datetime	Custom field representing batch processing or sync date

AzureDevOpsRepositories

Name	Type	Description
ID	string	Unique identifier for the repository
Name	string	Name of the repository
Url	string	URL reference to the repository in Azure DevOps
ProjectId	string	Unique identifier of the project the repository belongs to
ProjectName	string	Name of the project that owns the repository
DefaultBranch	string	The default branch for the repository (e.g., `refs`, `heads`, `main`)
Size	integer	Total size of the repository (in bytes)
RemoteUrl	string	URL used for remote access via HTTPS
SshUrl	string	URL used for remote access via SSH
WebUrl	string	URL used to view the repository in the web interface
IsDisabled	bit	Indicates whether the repository is currently disabled
IsInMaintenance	bit	Indicates whether the repository is in maintenance mode
ConfigID	integer	Custom configuration ID for integrations or mapping
BatchDate	datetime	Custom field representing batch load or sync date

AzureDevOpsTeamMembers

Name	Type	Description
DisplayName	string	Full name of the team member as shown in the UI
UniqueName	string	Unique login or username (typically email or alias)
Url	string	URL reference to the team member’s identity in Azure DevOps
ImageUrl	string	URL to the profile image of the team member
IsTeamAdmin	bit	Indicates whether the member is an admin of the team
ConfigID	integer	Custom configuration ID (e.g., for integration or tracking purposes)
BatchDate	datetime	Custom field representing batch load or sync date
TeamId	string	Unique identifier of the team the member belongs to
TeamName	string	Name of the Azure DevOps team
IdentityID	string	Unique identity ID of the user in the Azure DevOps identity system

AzureDevOpsTeams

Name	Type	Description
ID	string	Unique identifier for the team
Name	string	Name of the Azure DevOps team
Url	string	URL reference to the team in Azure DevOps
Description	string	Text description of the team's purpose or responsibilities
IdentityUrl	string	URL to the team’s identity information or management page
ProjectName	string	Name of the project to which the team belongs
ProjectId	string	Unique identifier for the project to which the team belongs
ConfigID	integer	Custom configuration ID associated with the team (e.g., for tracking or setup)
BatchDate	datetime	Custom field representing batch load or sync date

Tables

AzureDevOpsPipeLineApprovals

AzureDevOpsPipelineCheckConfigurations

AzureDevOpsPipeLines

AzureDevOpsProjects

AzureDevOpsPullRequests

AzureDevOpsRepositories

AzureDevOpsTeamMembers

AzureDevOpsTeams

Learn more...