Collaborators
Lists collaborators in a repository, including their roles, permissions, and contributions to the project.
View-Specific Information
Select
The add-in processes all filters client-side within the add-in. The following query is the only one processed server-side:
SELECT * FROM [Collaborators]
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | A unique identifier for the user. | ||
| DatabaseId | Int | The primary key identifying the user in the database. | ||
| Login | String | The username associated with the user's GitHub account. | ||
| Name | String | The user's publicly displayed name on their GitHub profile. | ||
| String | The publicly visible email address listed on the user's profile, if available. | |||
| TwitterUsername | String | The user's Twitter handle, if linked to their GitHub profile. | ||
| Pronouns | String | The pronouns specified by the user on their profile. | ||
| Bio | String | A short biography provided by the user to describe themselves. | ||
| BioHTML | String | The user's bio formatted in HTML for display on web pages. | ||
| Company | String | The company or organization the user is affiliated with, as listed on their profile. | ||
| CompanyHTML | String | The user's company information formatted as HTML. | ||
| Location | String | The geographic location specified by the user on their profile. | ||
| AnyPinnableItems | Bool | Indicates whether the user has repositories or gists that can be pinned to their profile. Accepts a filter argument for specific item types. | ||
| PinnedItemsRemaining | Int | The number of additional repositories or gists the user can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether the user has pinned any repositories or gists to their profile. | ||
| IsEmployee | Bool | Indicates whether the user is an employee of GitHub. | ||
| IsHireable | Bool | Indicates whether the user has marked themselves as available for hiring. | ||
| IsBountyHunter | Bool | Indicates whether the user participates in the GitHub Security Bug Bounty program. | ||
| IsCampusExpert | Bool | Indicates whether the user is a member of the GitHub Campus Experts Program. | ||
| IsFollowingViewer | Bool | Indicates whether this user is following the currently authenticated viewer. | ||
| IsSiteAdmin | Bool | Indicates whether the user has GitHub site administrator privileges. | ||
| IsDeveloperProgramMember | Bool | Indicates whether the user is a member of the GitHub Developer Program. | ||
| IsGitHubStar | Bool | Indicates whether the user is recognized as a GitHub Star for their contributions to the community. | ||
| IsSponsoringViewer | Bool | True if this user or organization is sponsoring the currently authenticated viewer. | ||
| IsViewer | Bool | Indicates whether this user is the currently authenticated viewer. | ||
| ViewerCanFollow | Bool | Indicates whether the currently authenticated viewer is able to follow this user. | ||
| ViewerCanSponsor | Bool | Indicates whether the currently authenticated viewer is able to sponsor this user or organization through GitHub Sponsors. | ||
| ViewerIsFollowing | Bool | Indicates whether the currently authenticated viewer is following this user. | ||
| ViewerIsSponsoring | Bool | True if the currently authenticated viewer is sponsoring this user or organization. | ||
| ViewerCanCreateProjects | Bool | Indicates whether the currently authenticated viewer has permission to create new projects for this user or organization. | ||
| ViewerCanChangePinnedItems | Bool | Indicates whether the viewer has permission to pin repositories and gists to the user's GitHub profile. | ||
| StatusId | String | A unique identifier for the emoji representing the user's current status. | ||
| StatusEmoji | String | The emoji used to summarize the user's current status, such as availability or activity. | ||
| StatusMessage | String | A short custom message set by the user to describe what they are currently doing. | ||
| StatusIndicatesLimitedAvailability | Bool | True if the user's status indicates limited availability on GitHub, such as being away or unavailable. | ||
| StatusEmojiHTML | String | The status emoji formatted as HTML for rendering on web pages. | ||
| StatusCreatedAt | Datetime | The timestamp when the user's status was first created. | ||
| StatusExpiresAt | Datetime | The expiration timestamp for the user's status, after which it is no longer be visible. | ||
| StatusUpdatedAt | Datetime | The timestamp of the last update made to the user's status. | ||
| StatusOrganizationId | String | The unique identifier of the organization associated with the user's status. | ||
| StatusOrganizationLogin | String | The login name of the organization to which the user belongs, if applicable. | ||
| InteractionAbilityLimit | String | The type of limit currently imposed on interactions with the user's profile (for example, comment restrictions). | ||
| InteractionAbilityOrigin | String | The source or origin of the interaction limit, such as user settings or a GitHub policy. | ||
| InteractionAbilityExpiresAt | Datetime | The expiration timestamp of the active interaction limit, indicating when the restriction will be lifted. | ||
| HasSponsorsListing | Bool | Indicates whether the user or organization has a public listing on GitHub Sponsors to receive financial support. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly income (in cents USD) that the user or organization receives through GitHub Sponsors. | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated payout (in cents USD) the user or organization will receive from GitHub Sponsors during the next disbursement. | ||
| SponsorsListingId | String | The unique identifier of the GitHub Sponsors listing associated with the user or organization. | ||
| SponsorsListingName | String | The full name of the GitHub Sponsors listing for the user or organization. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount (in cents USD) the user or organization has spent sponsoring other GitHub users or projects. | ||
| ResourcePath | String | The relative HTTP path that leads to this user's profile resource in the GitHub API. | ||
| ProjectsResourcePath | String | The relative HTTP path listing the user's projects available through the GitHub API. | ||
| Url | String | The full HTTP URL pointing to the user's public GitHub profile. | ||
| ProjectsUrl | String | The full HTTP URL listing the user's GitHub projects. | ||
| WebsiteUrl | String | A URL pointing to the user's personal or professional website or blog, if available. | ||
| AvatarUrl | String | A URL pointing to the user's avatar image on GitHub. The 'size' parameter can be specified to adjust the image resolution. | ||
| CopilotEndpointsApi | String | The API endpoint used for GitHub Copilot services, providing access to Copilot features. | ||
| CopilotEndpointsOriginTracker | String | The endpoint for tracking the origin of requests made to GitHub Copilot services. | ||
| CopilotEndpointsProxy | String | The proxy endpoint used for routing requests made to GitHub Copilot services. | ||
| CopilotEndpointsTelemetry | String | The endpoint used for sending telemetry data related to GitHub Copilot usage. | ||
| CreatedAt | Datetime | The timestamp when this user's GitHub profile or object was created. | ||
| UpdatedAt | Datetime | The timestamp when the user's GitHub profile or object was last updated. | ||
| RepositoryCount | Int | The total number of repositories that the user owns on GitHub. | ||
| FollowerCount | Int | The total number of users who are following this user on GitHub. | ||
| Permission | String | The level of permission granted to the user for the repository, such as 'read', 'write', or 'admin'. | ||
| RepositoryId | String | The unique identifier for the repository that the user has access to. |