Excel Add-In for GitHub

Build 24.0.9175

Repositories

Provides comprehensive details about user-owned or managed repositories, including configuration and metadata.

Table-Specific Information

Select

The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

  • Name supports the '=,!=' comparison operators.
  • OwnerLogin supports the '=,IN' comparison operators.
  • ForkCount supports the '=,>,>=,<,<=' comparison operators.
  • StargazerCount supports the '=,>,>=,<,<=' comparison operators.
  • TopicCount supports the '=,>,>=,<,<=' comparison operators.
  • IsArchived supports the '=' comparison operator.
  • IsFork supports the '=' comparison operator.
  • IsMirror supports the '=' comparison operator.
  • IsPrivate supports the '=' comparison operator.
  • LicenseKey supports the '=,!=' comparison operators.
  • LanguageName supports the '=,!=' comparison operators.
  • PushedAt supports the '=,>,>=,<,<=' comparison operators.
  • CreatedAt supports the '=,>,>=,<,<=' comparison operators.

For example, the following queries are processed server-side: 

SELECT * FROM [Repositories]
SELECT * FROM [Repositories] WHERE [Name] = 'Val1'
SELECT * FROM [Repositories] WHERE [OwnerLogin] = 'Val1'
SELECT * FROM [Repositories] WHERE [ForkCount] = 123
SELECT * FROM [Repositories] WHERE [StargazerCount] = 123
SELECT * FROM [Repositories] WHERE [TopicCount] = 123
SELECT * FROM [Repositories] WHERE [IsArchived] = true
SELECT * FROM [Repositories] WHERE [IsFork] = true
SELECT * FROM [Repositories] WHERE [IsMirror] = true
SELECT * FROM [Repositories] WHERE [IsPrivate] = true
SELECT * FROM [Repositories] WHERE [LicenseKey] = 'Val1'
SELECT * FROM [Repositories] WHERE [LanguageName] = 'Val1'
SELECT * FROM [Repositories] WHERE [PushedAt] = '2023-01-01 11:10:00'
SELECT * FROM [Repositories] WHERE [CreatedAt] = '2023-01-01 11:10:00'

The add-in processes other filters client-side within the add-in.

Insert

You can use the following columns to create (insert) a new record:

  • Name
  • OwnerId
  • Visibility
  • Description
  • HomepageUrl
  • HasIssuesEnabled
  • HasWikiEnabled
  • IsTemplate

You can use the following pseudo-column to create a new record: TeamId 

INSERT INTO [Repositories] ([Name], [OwnerId], [Visibility], [HasWikiEnabled]) VALUES ('APIRepo', 'MDQ6VXNlcjg3ODExMTEx', 'PRIVATE', true)
INSERT INTO [Repositories] ([Name], [OwnerId], [Visibility], [HomepageUrl], [TeamId]) VALUES ('OrgRepo', 'O_kgDOCfyf0Q', 'PRIVATE', 'www.test.com', 'T_kwDOCfyf0c4AmRiX')

Update

You can use the following columns to update a record:

  • Name
  • Description
  • HomepageUrl
  • HasDiscussionsEnabled
  • HasIssuesEnabled
  • HasProjectsEnabled
  • HasWikiEnabled
  • HasSponsorshipsEnabled

You can use the following column to archive a record: IsArchived

You can use the following column to unarchive a record: IsArchived 

UPDATE [Repositories] SET [Name] = 'NewRepoNameTest', [Description] = 'Test description.', [HasProjectsEnabled] = true WHERE [Id] = 'R_kgDOML7svg'
UPDATE [Repositories] SET [IsArchived] = false WHERE [Id] = 'R_kgDOML7svg'
UPDATE [Repositories] SET [IsArchived] = true WHERE [Id] = 'R_kgDOML7svg'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier (node ID) of the repository.

DatabaseId Int True

The primary key identifier for the repository in the database, used for internal reference.

Name String False

The name of the repository, as set by its owner.

NameWithOwner String True

The repository's name, prefixed with the owner's username or organization (for example, 'owner/repository-name').

OwnerId String True

The unique identifier (node ID) of the owner of the repository, which could be a user or organization.

OwnerLogin String True

The login (username) of the repository's owner, which could be a user or organization.

Visibility String True

The visibility level of the repository ('public', 'private', or 'internal').

DiskUsage Int True

The amount of disk space (in kilobytes) occupied by the repository.

ForkCount Int True

The total number of forks created from this repository across the network.

StargazerCount Int True

The total number of users who have starred this repository.

WatcherCount Int True

The total number of users watching this repository for updates.

TopicCount Int True

The number of topics assigned to the repository to improve discoverability.

TempCloneToken String True

A temporary authentication token for cloning the repository.

WebCommitSignoffRequired Bool True

Indicates whether contributors must sign off on web-based commits to this repository.

UsesCustomOpenGraphImage Bool True

Indicates whether the repository uses a custom image for Open Graph instead of the owner's avatar.

Description String False

A brief text description of the repository, as provided by the owner.

DescriptionHTML String True

The HTML-rendered version of the repository's description for display purposes.

ShortDescriptionHTML String True

A simplified version of the repository's description, rendered in HTML without links.

ResourcePath String True

The relative HTTP path to access the repository on GitHub.

ProjectsResourcePath String True

The relative HTTP path listing the projects associated with this repository.

Url String True

The absolute HTTP URL to the repository's main page on GitHub.

HomepageUrl String False

The URL of the repository's homepage, if specified.

MirrorUrl String True

The URL of the repository's original mirror, if applicable.

ProjectsUrl String True

The absolute HTTP URL listing the projects associated with this repository.

SecurityPolicyUrl String True

The URL pointing to the repository's security policy, if available.

SSHUrl String True

The SSH URL used for cloning the repository.

OpenGraphImageUrl String True

The image used to represent this repository in Open Graph metadata.

MergeCommitTitle String True

Specifies how the default commit title is generated when merging a pull request (for example, 'pull request title').

MergeCommitMessage String True

Specifies how the default commit message is generated when merging a pull request (for example, 'pull request description').

SquashMergeCommitTitle String True

Specifies how the default commit title is generated when squash-merging a pull request (for example, 'pull request title').

SquashMergeCommitMessage String True

Specifies how the default commit message is generated when squash-merging a pull request (for example, 'pull request description').

DeleteBranchOnMerge Bool True

Indicates whether branches are automatically deleted after being merged in this repository.

HasDiscussionsEnabled Bool False

Indicates whether the Discussions feature is enabled for this repository.

HasIssuesEnabled Bool False

Indicates whether the Issues feature is enabled for this repository.

HasProjectsEnabled Bool False

Indicates whether the Projects feature is enabled for this repository.

HasWikiEnabled Bool False

Indicates whether the Wiki feature is enabled for this repository.

HasVulnerabilityAlertsEnabled Bool True

Indicates whether vulnerability alerts are enabled for this repository.

HasSponsorshipsEnabled Bool False

Indicates whether the repository displays a Sponsor button for financial contributions.

IsInOrganization Bool True

Indicates whether the repository is owned by an organization or is a private fork of an organization repository.

IsBlankIssuesEnabled Bool True

Indicates whether blank issue creation is allowed for this repository.

IsSecurityPolicyEnabled Bool True

Indicates whether the repository has a security policy in place.

IsUserConfigurationRepository Bool True

Indicates whether the repository is a user configuration repository.

IsArchived Bool True

Indicates whether the repository is archived and unmaintained.

IsDisabled Bool True

Indicates whether the repository is disabled.

IsEmpty Bool True

Indicates whether the repository is empty.

IsFork Bool True

Indicates whether the repository is a fork of another repository.

IsLocked Bool True

Indicates whether the repository has been locked.

IsMirror Bool True

Indicates whether the repository is a mirror of another repository.

IsPrivate Bool True

Indicates whether the repository is private and not publicly accessible.

IsTemplate Bool False

Indicates whether the repository is a template that can be used to generate new repositories.

LockReason String True

Specifies the reason why the repository has been locked, if applicable.

The allowed values are BILLING, MIGRATING, MOVING, RENAME.

TemplateRepositoryId String True

The unique identifier (node ID) of the template repository from which this repository was generated, if any.

ParentId String True

The unique identifier (node ID) of the parent repository, if this repository is a fork.

ForkingAllowed Bool True

Indicates whether forking is allowed for this repository.

AutoMergeAllowed Bool True

Indicates whether Auto-merge can be enabled on pull requests for this repository.

SquashMergeAllowed Bool True

Indicates whether squash-merging is enabled for pull requests in this repository.

RebaseMergeAllowed Bool True

Indicates whether rebase-merging is enabled for pull requests in this repository.

MergeCommitAllowed Bool True

Indicates whether pull requests can be merged with a merge commit in this repository.

AllowUpdateBranch Bool True

Indicates whether pull request head branches that are behind their base branches can always be updated even if not required for merging.

ViewerPermission String True

Specifies the permission level of the viewer on the repository (for example, 'read', 'write', 'admin'). Returns null if authenticated as a GitHub App.

The allowed values are ADMIN, MAINTAIN, READ, TRIAGE, WRITE.

ViewerSubscription String True

Indicates whether the viewer is watching, not watching, or ignoring the repository.

The allowed values are IGNORED, SUBSCRIBED, UNSUBSCRIBED.

ViewerHasStarred Bool True

Indicates whether the viewing user has starred this repository.

ViewerDefaultCommitEmail String True

The email address used by the viewer for their most recent commit in this repository.

ViewerDefaultMergeMethod String True

The last merge method used by the viewer (for example, 'merge', 'squash', 'rebase') or the repository's default merge method.

ViewerPossibleCommitEmails String True

A list of email addresses available for the viewer to use for committing in this repository.

ViewerCanAdminister Bool True

Indicates whether the viewer has administrative permissions on this repository.

ViewerCanSubscribe Bool True

Indicates whether the viewer can change their subscription status for the repository.

ViewerCanCreateProjects Bool True

Indicates whether the viewer can create new projects associated with this repository.

ViewerCanUpdateTopics Bool True

Indicates whether the viewer can update the topics (tags) of this repository.

CodeOfConductId String True

The unique identifier (node ID) of the Code of Conduct associated with this repository.

CodeOfConductName String True

The formal name of the Code of Conduct applied to this repository.

CodeOfConductBody String True

The full text of the Code of Conduct describing its rules and guidelines.

CodeOfConductKey String True

The unique key identifier for the Code of Conduct.

CodeOfConductUrl String True

The absolute HTTP URL to access the Code of Conduct for this repository.

CodeOfConductResourcePath String True

The relative HTTP path to access the Code of Conduct for this repository.

DefaultBranchRefId String True

The unique identifier (node ID) of the default branch in this repository.

DefaultBranchRefName String True

The name of the default branch in this repository (for example, 'main', 'master').

InteractionAbilityLimit String True

The current interaction restriction applied to this repository (for example, 'collaborators only').

InteractionAbilityOrigin String True

The source or reason for the currently active interaction restriction (for example, account settings, admin action).

InteractionAbilityExpiresAt Datetime True

The expiration date and time of the current interaction restriction, if applicable.

LatestReleaseId String True

The unique identifier (node ID) of the latest release in this repository.

LatestReleaseName String True

The title of the latest release in this repository.

LicenseId String True

The unique identifier (node ID) of the license associated with the repository.

LicenseKey String True

Licenses.Key

The SPDX key of the license associated with the repository (for example, 'mit', 'apache-2.0').

LanguageId String True

The unique identifier (node ID) of the primary programming language used in this repository.

LanguageName String True

The name of the primary programming language used in this repository (for example, 'JavaScript', 'Python').

LanguageColor String True

The hexadecimal color code associated with the primary programming language used in the repository.

PushedAt Datetime True

The date and time when the repository was last pushed to, in ISO 8601 format.

ArchivedAt Datetime True

The date and time when the repository was archived, in ISO 8601 format.

CreatedAt Datetime True

The date and time when the repository was created, in ISO 8601 format.

UpdatedAt Datetime True

The date and time when the repository was last updated, in ISO 8601 format.

PlanFeaturesCodeOwners Bool True

Indicates whether reviews can be automatically requested and enforced using a CODEOWNERS file.

PlanFeaturesDraftPullRequests Bool True

Indicates whether pull requests can be created as drafts or converted to drafts.

PlanFeaturesMaximumAssignees Int True

The maximum number of users that can be assigned to an issue or pull request in this repository.

PlanFeaturesMaximumManualReviewRequests Int True

The maximum number of manually requested reviews allowed on a pull request in this repository.

PlanFeaturesTeamReviewRequests Bool True

Indicates whether teams can be requested to review pull requests in this repository.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.

Name Type Description
TeamId String

Specifies the team ID to be granted access to the repository when an organization is set as the owner.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175