Connecting to GitLab

To authenticate to GitLab, you can use either OAuth 2.0 or Personal Access Tokens (APIKey).

Using OAuth Authentication

First you need to register an OAuth application with GitLab. This can be done in your GitLab user settings under Applications or for GitLab groups under Group Settings > Applications. For self-hosted GitLab instances, you may also need to configure the BaseURL property to point to your GitLab installation.

After setting the following connection properties, you are ready to connect:

AuthScheme: Set this to OAuth.
InitiateOAuth: Set this to GETANDREFRESH. The CData API Profile for GitLab will automatically walk through the OAuth process in order to obtained the access token.
OAuthClientID: Set this to the Application ID that is specified in your app settings.
OAuthClientSecret: Set this to the Secret that is specified in your app settings.
CallbackURL: Set this to the Redirect URI you specified in your app settings.
BaseURL: (Optional) Set this to your GitLab instance URL if using a self-hosted GitLab (e.g., https://gitlab.example.com). Defaults to https://gitlab.com.

Example OAuth connection string

Profile=C:\profiles\GitLab.apip;AuthScheme=OAuth;InitiateOAuth=GETANDREFRESH;OAuthClientId=your_application_id;OAuthClientSecret=your_secret;CallbackUrl=your_callback_url;

Using APIKey Authentication

You can also authenticate using a GitLab Personal Access Token. Create a Personal Access Token in your GitLab user settings under Access Tokens. Make sure to grant appropriate scopes such as read_user, read_api, read_repository, and api based on the data you need to access.

After creating your Personal Access Token, set the following connection properties:

AuthScheme: Set this to APIKey.
APIKey: Set this to your GitLab Personal Access Token.
BaseURL: (Optional) Set this to your GitLab instance URL if using a self-hosted GitLab (e.g., https://gitlab.example.com). Defaults to https://gitlab.com.

Example APIKey connection string

Profile=C:\profiles\GitLab.apip;AuthScheme=APIKey;ProfileSettings='APIKey=your_personal_access_token';

Usage Examples

AccessRequests:

SELECT * FROM AccessRequests WHERE GroupId = '123'

AlertManagementAlertMetricImages:

SELECT * FROM AlertManagementAlertMetricImages WHERE AlertIid = '123' AND ProjectId = '12345'

AllGroupMembers:

SELECT * FROM AllGroupMembers WHERE GroupId = '789'

AllProjectMembers:

SELECT * FROM AllProjectMembers WHERE ProjectId = '12345'

AllRunners:

SELECT * FROM AllRunners WHERE Status = 'active'

AllSnippets:

SELECT * FROM AllSnippets WHERE Visibility = 'public'

Appearance:

SELECT * FROM Appearance

Applications:

SELECT * FROM Applications

ApplicationSettings:

SELECT * FROM ApplicationSettings

AuditEvents:

SELECT * FROM AuditEvents

BillableMemberIndirectMemberships:

SELECT * FROM BillableMemberIndirectMemberships WHERE GroupId = '789' AND UserId = '456'

BillableMemberMemberships:

SELECT * FROM BillableMemberMemberships WHERE GroupId = '789' AND UserId = '456'

Branches:

SELECT * FROM Branches WHERE ProjectId = '12345'

BroadcastMessages:

SELECT * FROM BroadcastMessages

BulkImportEntities:

SELECT * FROM BulkImportEntities WHERE BulkImportId = '123'

BulkImportEntityFailures:

SELECT * FROM BulkImportEntityFailures WHERE BulkImportId = '123' AND EntityId = '456'

BulkImports:

SELECT * FROM BulkImports

ClusterAgents:

SELECT * FROM ClusterAgents WHERE ProjectId = '12345'

ClusterAgentTokens:

SELECT * FROM ClusterAgentTokens WHERE ProjectId = '12345' AND AgentId = '123'

ClusterAgentUrlConfigurations:

SELECT * FROM ClusterAgentUrlConfigurations WHERE ProjectId = '12345' AND AgentId = '123'

CommitComments:

SELECT * FROM CommitComments WHERE ProjectId = '12345' AND Sha = 'abc123def456'

CommitDiff:

SELECT * FROM CommitDiff WHERE ProjectId = '12345' AND Sha = 'abc123def456'

CommitDiscussions:

SELECT * FROM CommitDiscussions WHERE ProjectId = '12345' AND CommitId = 'abc123def456'

CommitMergeRequests:

SELECT * FROM CommitMergeRequests WHERE ProjectId = '12345' AND Sha = 'abc123def456'

CommitRefs:

SELECT * FROM CommitRefs WHERE ProjectId = '12345' AND Sha = 'abc123def456'

Commits:

SELECT * FROM Commits WHERE ProjectId = '12345'

CommitSignature:

SELECT * FROM CommitSignature WHERE ProjectId = '12345' AND Sha = 'abc123def456'

CommitStatuses:

SELECT * FROM CommitStatuses WHERE ProjectId = '12345' AND Sha = 'abc123def456'

ContainerRegistry:

SELECT * FROM ContainerRegistry WHERE ProjectId = '12345' AND GroupId = '789'

ContainerRegistryTags:

SELECT * FROM ContainerRegistryTags WHERE ProjectId = '12345' AND RepositoryId = '123'

DastProfiles:

SELECT * FROM DastProfiles WHERE ProjectId = '12345'

Dependencies:

SELECT * FROM Dependencies WHERE ProjectId = '12345'

DeployKeys:

SELECT * FROM DeployKeys

DeploymentMergeRequests:

SELECT * FROM DeploymentMergeRequests WHERE ProjectId = '12345' AND DeploymentId = '123'

Deployments:

SELECT * FROM Deployments WHERE ProjectId = '12345'

DeployTokens:

SELECT * FROM DeployTokens WHERE ProjectId = '12345'

DockerfileKeyTemplates:

SELECT * FROM DockerfileKeyTemplates WHERE Key = 'dockerfile'

DockerfileTemplates:

SELECT * FROM DockerfileTemplates

DraftNotes:

SELECT * FROM DraftNotes WHERE ProjectId = '12345' AND MergeRequestIid = '1'

Environments:

SELECT * FROM Environments WHERE ProjectId = '12345'

EpicIssues:

SELECT * FROM EpicIssues WHERE GroupId = '789' AND EpicIid = '1'

EpicResourceLabelEvents:

SELECT * FROM EpicResourceLabelEvents WHERE GroupId = '789' AND EpicId = '123'

EpicResourceStateEvents:

SELECT * FROM EpicResourceStateEvents WHERE GroupId = '789' AND EpicId = '123'

Epics:

SELECT * FROM Epics WHERE GroupId = '789'

ErrorTrackingClientKeys:

SELECT * FROM ErrorTrackingClientKeys WHERE ProjectId = '12345'

ErrorTrackingSettings:

SELECT * FROM ErrorTrackingSettings WHERE ProjectId = '12345'

Events:

SELECT * FROM Events WHERE Action = 'pushed'

FeatureFlags:

SELECT * FROM FeatureFlags WHERE ProjectId = '12345'

Features:

SELECT * FROM Features

FreezePeriods:

SELECT * FROM FreezePeriods WHERE ProjectId = '12345'

GeoSites:

SELECT * FROM GeoSites

GitignoreKeyTemplates:

SELECT * FROM GitignoreKeyTemplates WHERE Key = 'python'

GitignoreTemplates:

SELECT * FROM GitignoreTemplates

GitlabCiKeyTemplates:

SELECT * FROM GitlabCiKeyTemplates WHERE Key = 'nodejs'

GitlabCiTemplates:

SELECT * FROM GitlabCiTemplates

GlobalNotificationSettings:

SELECT * FROM GlobalNotificationSettings

GlobalProjectRepositoryStorageMoves:

SELECT * FROM GlobalProjectRepositoryStorageMoves

GroupAccessTokens:

SELECT * FROM GroupAccessTokens WHERE GroupId = '789'

GroupAuditEvents:

SELECT * FROM GroupAuditEvents WHERE GroupId = '789'

GroupBadges:

SELECT * FROM GroupBadges WHERE GroupId = '789'

GroupBadgesRender:

SELECT * FROM GroupBadgesRender WHERE GroupId = '789' AND ImageUrl = 'https://img.shields.io/badge/build-passing-brightgreen' AND LinkUrl = 'https://gitlab.example.com'

GroupBillableMembers:

SELECT * FROM GroupBillableMembers WHERE GroupId = '789'

GroupBoards:

SELECT * FROM GroupBoards WHERE GroupId = '789'

GroupCustomAttributes:

SELECT * FROM GroupCustomAttributes WHERE GroupId = '789'

GroupDeployTokens:

SELECT * FROM GroupDeployTokens WHERE GroupId = '789'

GroupDescendantGroups:

SELECT * FROM GroupDescendantGroups WHERE GroupId = '789'

GroupDoraMetrics:

SELECT * FROM GroupDoraMetrics WHERE GroupId = '789'

GroupHooks:

SELECT * FROM GroupHooks WHERE GroupId = '789'

GroupIssueBoardLists:

SELECT * FROM GroupIssueBoardLists WHERE GroupId = '789' AND BoardId = '123'

GroupIssues:

SELECT * FROM GroupIssues WHERE GroupId = '789'

GroupIterations:

SELECT * FROM GroupIterations WHERE GroupId = '789'

GroupLabels:

SELECT * FROM GroupLabels WHERE GroupId = '789'

GroupMembers:

SELECT * FROM GroupMembers WHERE GroupId = '789'

GroupMergeRequests:

SELECT * FROM GroupMergeRequests WHERE GroupId = '789'

GroupMilestoneBurndownEvents:

SELECT * FROM GroupMilestoneBurndownEvents WHERE GroupId = '789' AND MilestoneId = '123'

GroupMilestones:

SELECT * FROM GroupMilestones WHERE GroupId = '789'

GroupPackages:

SELECT * FROM GroupPackages WHERE GroupId = '789'

GroupProjects:

SELECT * FROM GroupProjects WHERE GroupId = '789'

GroupReleases:

SELECT * FROM GroupReleases WHERE GroupId = '789'

GroupRunners:

SELECT * FROM GroupRunners WHERE GroupId = '789'

Groups:

SELECT * FROM Groups WHERE Visibility = 'public'

GroupSamlIdentities:

SELECT * FROM GroupSamlIdentities WHERE GroupId = '789'

GroupScimIdentities:

SELECT * FROM GroupScimIdentities WHERE GroupId = '789'

GroupServiceAccounts:

SELECT * FROM GroupServiceAccounts WHERE GroupId = '789'

GroupSubgroups:

SELECT * FROM GroupSubgroups WHERE GroupId = '789'

GroupVariables:

SELECT * FROM GroupVariables WHERE GroupId = '789'

GroupWikis:

SELECT * FROM GroupWikis WHERE GroupId = '789'

InstanceVariables:

SELECT * FROM InstanceVariables

IssueClosedBy:

SELECT * FROM IssueClosedBy WHERE ProjectId = '12345' AND IssueIid = '1'

IssueDiscussions:

SELECT * FROM IssueDiscussions WHERE ProjectId = '12345' AND IssueIid = '1'

IssueLinks:

SELECT * FROM IssueLinks WHERE ProjectId = '12345' AND IssueIid = '1'

IssueNotes:

SELECT * FROM IssueNotes WHERE ProjectId = '12345' AND IssueIid = '1'

IssueParticipants:

SELECT * FROM IssueParticipants WHERE ProjectId = '12345' AND IssueIid = '1'

IssueRelatedMergeRequests:

SELECT * FROM IssueRelatedMergeRequests WHERE ProjectId = '12345' AND IssueIid = '1'

IssueResourceIterationEvents:

SELECT * FROM IssueResourceIterationEvents WHERE ProjectId = '12345' AND IssueIid = '1'

IssueResourceLabelEvents:

SELECT * FROM IssueResourceLabelEvents WHERE ProjectId = '12345' AND IssueIid = '1'

IssueResourceMilestoneEvents:

SELECT * FROM IssueResourceMilestoneEvents WHERE ProjectId = '12345' AND IssueIid = '1'

IssueResourceStateEvents:

SELECT * FROM IssueResourceStateEvents WHERE ProjectId = '12345' AND IssueIid = '1'

IssueResourceWeightEvents:

SELECT * FROM IssueResourceWeightEvents WHERE ProjectId = '12345' AND IssueIid = '1'

Issues:

SELECT * FROM Issues WHERE State = 'opened'

IssueTimeStats:

SELECT * FROM IssueTimeStats WHERE ProjectId = '12345' AND IssueIid = '1'

Jobs:

SELECT * FROM Jobs WHERE ProjectId = '12345'

Keys:

SELECT * FROM Keys WHERE Id = '123' AND Fingerprint = 'SHA256:abc123def456'

Licenses:

SELECT * FROM Licenses WHERE ProjectId = '12345'

LicenseTemplates:

SELECT * FROM LicenseTemplates

MembershipInvitations:

SELECT * FROM MembershipInvitations WHERE GroupId = '789' AND ProjectId = '12345'

MergeRequestApprovalRules:

SELECT * FROM MergeRequestApprovalRules WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestApprovals:

SELECT * FROM MergeRequestApprovals WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestApprovalState:

SELECT * FROM MergeRequestApprovalState WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestCommits:

SELECT * FROM MergeRequestCommits WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestContextCommits:

SELECT * FROM MergeRequestContextCommits WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestDiscussions:

SELECT * FROM MergeRequestDiscussions WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestNotes:

SELECT * FROM MergeRequestNotes WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestParticipants:

SELECT * FROM MergeRequestParticipants WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestResourceLabelEvents:

SELECT * FROM MergeRequestResourceLabelEvents WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestResourceMilestoneEvents:

SELECT * FROM MergeRequestResourceMilestoneEvents WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestResourceStateEvents:

SELECT * FROM MergeRequestResourceStateEvents WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequestReviewers:

SELECT * FROM MergeRequestReviewers WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeRequests:

SELECT * FROM MergeRequests WHERE State = 'opened'

MergeRequestVersions:

SELECT * FROM MergeRequestVersions WHERE ProjectId = '12345' AND MergeRequestIid = '1'

MergeTrains:

SELECT * FROM MergeTrains WHERE ProjectId = '12345'

Metadata:

SELECT * FROM Metadata

MilestoneIssues:

SELECT * FROM MilestoneIssues WHERE ProjectId = '12345' AND GroupId = '789' AND MilestoneId = '123'

MilestoneMergeRequests:

SELECT * FROM MilestoneMergeRequests WHERE ProjectId = '12345' AND GroupId = '789' AND MilestoneId = '123'

NamespaceExists:

SELECT * FROM NamespaceExists WHERE Namespace = 'my-namespace'

Namespaces:

SELECT * FROM Namespaces WHERE Kind = 'group'

NotificationSettings:

SELECT * FROM NotificationSettings WHERE GroupId = '789' AND ProjectId = '12345'

PackageFiles:

SELECT * FROM PackageFiles WHERE ProjectId = '12345' AND PackageId = '123'

PackagePipelines:

SELECT * FROM PackagePipelines WHERE ProjectId = '12345' AND PackageId = '123'

PagesDomains:

SELECT * FROM PagesDomains

PendingMembers:

SELECT * FROM PendingMembers WHERE GroupId = '789'

PersonalAccessTokens:

SELECT * FROM PersonalAccessTokens WHERE UserId = '456'

PersonalAccessTokensSelfAssociations:

SELECT * FROM PersonalAccessTokensSelfAssociations WHERE UserId = '456'

Pipeline:

SELECT * FROM Pipeline WHERE ProjectId = '12345'

Pipelines:

SELECT * FROM Pipelines WHERE ProjectId = '12345'

PipelineJobs:

SELECT * FROM PipelineJobs WHERE ProjectId = '12345' AND PipelineId = '123'

PipelineLatest:

SELECT * FROM PipelineLatest WHERE ProjectId = '12345'

PipelineSchedulePipelines:

SELECT * FROM PipelineSchedulePipelines WHERE ProjectId = '12345' AND PipelineScheduleId = '123'

PipelineSchedules:

SELECT * FROM PipelineSchedules WHERE ProjectId = '12345'

PipelineTestReport:

SELECT * FROM PipelineTestReport WHERE ProjectId = '12345' AND PipelineId = '123'

PipelineTestReportSummary:

SELECT * FROM PipelineTestReportSummary WHERE ProjectId = '12345' AND PipelineId = '123'

PipelineTriggers:

SELECT * FROM PipelineTriggers WHERE ProjectId = '12345'

PipelineVariables:

SELECT * FROM PipelineVariables WHERE ProjectId = '12345' AND PipelineId = '123'

PlanLimits:

SELECT * FROM PlanLimits

ProjectAccessTokens:

SELECT * FROM ProjectAccessTokens WHERE ProjectId = '12345'

ProjectAliases:

SELECT * FROM ProjectAliases WHERE ProjectId = '12345'

ProjectApprovalRules:

SELECT * FROM ProjectApprovalRules WHERE ProjectId = '12345'

ProjectApprovals:

SELECT * FROM ProjectApprovals WHERE ProjectId = '12345'

ProjectAuditEvents:

SELECT * FROM ProjectAuditEvents WHERE ProjectId = '12345'

ProjectBadges:

SELECT * FROM ProjectBadges WHERE ProjectId = '12345'

ProjectBadgesRender:

SELECT * FROM ProjectBadgesRender WHERE ProjectId = '12345' AND ImageUrl = 'https://img.shields.io/badge/build-passing-brightgreen' AND LinkUrl = 'https://gitlab.example.com'

ProjectBoards:

SELECT * FROM ProjectBoards WHERE ProjectId = '12345'

ProjectCustomAttributes:

SELECT * FROM ProjectCustomAttributes WHERE ProjectId = '12345'

ProjectDeployKeys:

SELECT * FROM ProjectDeployKeys WHERE ProjectId = '12345'

ProjectDeployTokens:

SELECT * FROM ProjectDeployTokens WHERE ProjectId = '12345'

ProjectDoraMetrics:

SELECT * FROM ProjectDoraMetrics WHERE ProjectId = '12345'

ProjectEvents:

SELECT * FROM ProjectEvents WHERE ProjectId = '12345'

ProjectExportStatus:

SELECT * FROM ProjectExportStatus WHERE ProjectId = '12345'

ProjectHooks:

SELECT * FROM ProjectHooks WHERE ProjectId = '12345'

ProjectImportStatus:

SELECT * FROM ProjectImportStatus WHERE ProjectId = '12345'

ProjectIntegrations:

SELECT * FROM ProjectIntegrations WHERE ProjectId = '12345'

ProjectIssueBoardLists:

SELECT * FROM ProjectIssueBoardLists WHERE ProjectId = '12345' AND BoardId = '123'

ProjectIssues:

SELECT * FROM ProjectIssues WHERE ProjectId = '12345'

ProjectIterations:

SELECT * FROM ProjectIterations WHERE ProjectId = '12345'

ProjectKeyTemplates:

SELECT * FROM ProjectKeyTemplates WHERE ProjectId = '12345'

ProjectLabels:

SELECT * FROM ProjectLabels WHERE ProjectId = '12345'

ProjectMembers:

SELECT * FROM ProjectMembers WHERE ProjectId = '12345'

ProjectMergeRequests:

SELECT * FROM ProjectMergeRequests WHERE ProjectId = '12345'

ProjectMilestones:

SELECT * FROM ProjectMilestones WHERE ProjectId = '12345'

ProjectMirrors:

SELECT * FROM ProjectMirrors WHERE ProjectId = '12345'

ProjectPackages:

SELECT * FROM ProjectPackages WHERE ProjectId = '12345'

ProjectPagesDomains:

SELECT * FROM ProjectPagesDomains WHERE ProjectId = '12345'

ProjectRelationImports:

SELECT * FROM ProjectRelationImports WHERE ProjectId = '12345'

ProjectReleases:

SELECT * FROM ProjectReleases WHERE ProjectId = '12345'

ProjectRepositoryStorageMoves:

SELECT * FROM ProjectRepositoryStorageMoves WHERE ProjectId = '12345'

ProjectRunners:

SELECT * FROM ProjectRunners WHERE ProjectId = '12345'

Projects:

SELECT * FROM Projects WHERE Visibility = 'public'

ProjectSecuritySettings:

SELECT * FROM ProjectSecuritySettings WHERE ProjectId = '12345'

ProjectSnippets:

SELECT * FROM ProjectSnippets WHERE ProjectId = '12345'

ProjectStatistics:

SELECT * FROM ProjectStatistics WHERE ProjectId = '12345'

ProjectTemplates:

SELECT * FROM ProjectTemplates WHERE ProjectId = '12345' AND Type = 'dockerfile'

ProjectUsers:

SELECT * FROM ProjectUsers WHERE ProjectId = '12345'

ProjectVariables:

SELECT * FROM ProjectVariables WHERE ProjectId = '12345'

ProjectWikis:

SELECT * FROM ProjectWikis WHERE ProjectId = '12345'

ProtectedBranches:

SELECT * FROM ProtectedBranches WHERE ProjectId = '12345'

ProtectedEnvironments:

SELECT * FROM ProtectedEnvironments WHERE ProjectId = '12345'

ProtectedTags:

SELECT * FROM ProtectedTags WHERE ProjectId = '12345'

PublicSnippets:

SELECT * FROM PublicSnippets WHERE Visibility = 'public'

RegistryRepositories:

SELECT * FROM RegistryRepositories WHERE ProjectId = '12345'

ReleaseLinks:

SELECT * FROM ReleaseLinks WHERE ProjectId = '12345' AND TagName = 'v1.0.0'

RepositoryBlobs:

SELECT * FROM RepositoryBlobs WHERE ProjectId = '12345' AND Sha = 'abc123def456'

RepositoryContributors:

SELECT * FROM RepositoryContributors WHERE ProjectId = '12345'

RepositoryFileBlame:

SELECT * FROM RepositoryFileBlame WHERE ProjectId = '12345' AND FilePath = 'README.md' AND Ref = 'main'

RepositoryFiles:

SELECT * FROM RepositoryFiles WHERE ProjectId = '12345' AND FilePath = 'README.md' AND Ref = 'main'

RepositoryMergeBase:

SELECT * FROM RepositoryMergeBase WHERE ProjectId = '12345'

RepositoryTree:

SELECT * FROM RepositoryTree WHERE ProjectId = '12345'

ResourceGroups:

SELECT * FROM ResourceGroups WHERE ProjectId = '12345'

RunnerJobs:

SELECT * FROM RunnerJobs WHERE RunnerId = '123'

RunnerManagers:

SELECT * FROM RunnerManagers WHERE RunnerId = '123'

Runners:

SELECT * FROM Runners WHERE Status = 'active'

Search:

SELECT * FROM Search WHERE Query = 'test' AND ProjectId = '12345'

SecureFiles:

SELECT * FROM SecureFiles WHERE ProjectId = '12345'

SelfUser:

SELECT * FROM SelfUser

SelfUserEmails:

SELECT * FROM SelfUserEmails

SelfUserGpgKeys:

SELECT * FROM SelfUserGpgKeys

SelfUserKeys:

SELECT * FROM SelfUserKeys

SelfUserStatus:

SELECT * FROM SelfUserStatus WHERE UserId = '456'

SidekiqCompoundMetrics:

SELECT * FROM SidekiqCompoundMetrics

SidekiqJobStats:

SELECT * FROM SidekiqJobStats

SidekiqProcessMetrics:

SELECT * FROM SidekiqProcessMetrics

SidekiqQueueMetrics:

SELECT * FROM SidekiqQueueMetrics

SnippetDiscussions:

SELECT * FROM SnippetDiscussions WHERE ProjectId = '12345' AND SnippetId = '123'

SnippetNotes:

SELECT * FROM SnippetNotes WHERE ProjectId = '12345' AND SnippetId = '123'

Snippets:

SELECT * FROM Snippets WHERE Visibility = 'public'

Statistics:

SELECT * FROM Statistics

SystemHooks:

SELECT * FROM SystemHooks

Tags:

SELECT * FROM Tags WHERE ProjectId = '12345'

TagSignature:

SELECT * FROM TagSignature WHERE ProjectId = '12345' AND TagName = 'v1.0.0'

TodoItems:

SELECT * FROM TodoItems WHERE State = 'pending'

Topics:

SELECT * FROM Topics WHERE Name = 'javascript'

UserAssociationsCount:

SELECT * FROM UserAssociationsCount WHERE UserId = '456'

UserContributedProjects:

SELECT * FROM UserContributedProjects WHERE UserId = '456'

UserCounts:

SELECT * FROM UserCounts WHERE UserId = '456'

UserCustomAttributes:

SELECT * FROM UserCustomAttributes WHERE UserId = '456'

UserEmails:

SELECT * FROM UserEmails WHERE UserId = '456'

UserEvents:

SELECT * FROM UserEvents WHERE UserId = '456'

UserGpgKeys:

SELECT * FROM UserGpgKeys WHERE UserId = '456'

UserKeys:

SELECT * FROM UserKeys WHERE UserId = '456'

UserMemberships:

SELECT * FROM UserMemberships WHERE UserId = '456'

UserPreferences:

SELECT * FROM UserPreferences WHERE UserId = '456'

UserProjectDeployKeys:

SELECT * FROM UserProjectDeployKeys WHERE UserId = '456'

UserProjects:

SELECT * FROM UserProjects WHERE UserId = '456'

Users:

SELECT * FROM Users WHERE Username = 'johndoe'

UserStarredProjects:

SELECT * FROM UserStarredProjects WHERE UserId = '456'

UserStatus:

SELECT * FROM UserStatus WHERE UserId = '456'

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

Property	Description
APIKey	The Personal Access Token for your GitLab account.
AuthScheme	The scheme used for authentication. Accepted entries are OAuth or APIKey. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT
BaseURL	The URL of the GitLab instance.
CallbackURL	Identifies the URL users return to after authenticating to API via OAuth (Custom OAuth applications only).
InitiateOAuth	Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. Allowed values are: OFF, GETANDREFRESH, REFRESH
OAuthClientId	Specifies the client ID (also known as the consumer key) assigned to your custom OAuth application. This ID is required to identify the application to the OAuth authorization server during authentication.
OAuthClientSecret	Specifies the client secret assigned to your custom OAuth application. This confidential value is used to authenticate the application to the OAuth authorization server. (Custom OAuth applications only.).