OrganizationTeamMembers
Tracks team memberships within organizations, detailing roles and associated permissions for each member.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:
- Role supports the '=,IN' comparison operators.
- OrganizationTeamSlug supports the '=,IN' comparison operators.
- OrganizationLogin supports the '=,IN' comparison operators.
- Membership supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [OrganizationTeamMembers]
SELECT * FROM [OrganizationTeamMembers] WHERE [Role] = 'MAINTAINER'
SELECT * FROM [OrganizationTeamMembers] WHERE [OrganizationTeamSlug] = 'Val1'
SELECT * FROM [OrganizationTeamMembers] WHERE [OrganizationLogin] = 'Val1'
SELECT * FROM [OrganizationTeamMembers] WHERE [Membership] = 'IMMEDIATE'
The add-in processes other filters client-side within the add-in.
The add-in uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:
- Login
- CreatedAt
SELECT * FROM [OrganizationTeamMembers] ORDER BY [Login]
SELECT * FROM [OrganizationTeamMembers] ORDER BY [CreatedAt]
The add-in uses client-side processing when ordering by any other columns. This impacts performance.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier (node ID) of the user who is a team member. | ||
| DatabaseId | Int | The primary key identifier for the user in the database, used for internal reference. | ||
| Login | String | The username used by the team member to log in and identify their GitHub account. | ||
| Name | String | The publicly visible name of the team member as displayed on their GitHub profile. | ||
| String | The publicly visible email address of the team member, if available. | |||
| TwitterUsername | String | The Twitter handle provided by the team member on their public profile, if available. | ||
| Pronouns | String | The pronouns specified by the team member on their profile (for example, they/them, she/her, he/him). | ||
| Bio | String | The public profile bio of the team member, providing a brief description of their background or interests. | ||
| BioHTML | String | The HTML-formatted version of the team member's bio for display purposes. | ||
| Company | String | The organization or company name listed on the team member’s public profile. | ||
| CompanyHTML | String | The HTML-formatted version of the team member’s company information for display purposes. | ||
| Location | String | The geographic location specified by the team member on their public profile. | ||
| AnyPinnableItems | Bool | Indicates whether the team member has any items, such as repositories or gists, that can be pinned to their profile. Can filter by item type. | ||
| PinnedItemsRemaining | Int | The number of additional items the team member can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether the team member has pinned any repositories or gists to their profile. | ||
| IsEmployee | Bool | Indicates whether the team member is a GitHub employee. | ||
| IsHireable | Bool | Indicates whether the team member has marked themselves as available for hire. | ||
| IsBountyHunter | Bool | Indicates whether the team member participates in the GitHub Security Bug Bounty program. | ||
| IsCampusExpert | Bool | Indicates whether the team member is a participant in the GitHub Campus Experts program. | ||
| IsFollowingViewer | Bool | Indicates whether the team member is following the current viewer of their profile. This is the inverse of ViewerIsFollowing. | ||
| IsSiteAdmin | Bool | Indicates whether the team member is a GitHub site administrator with elevated permissions. | ||
| IsDeveloperProgramMember | Bool | Indicates whether the team member is a participant in the GitHub Developer Program. | ||
| IsGitHubStar | Bool | Indicates whether the team member is a recognized member of the GitHub Stars program. | ||
| IsSponsoringViewer | Bool | Indicates whether the team member or their organization is financially sponsoring the current viewer. | ||
| IsViewer | Bool | Indicates whether the team member is the currently logged-in viewer of the profile. | ||
| ViewerCanFollow | Bool | Indicates whether the current viewer has the ability to follow this team member. | ||
| ViewerCanSponsor | Bool | Indicates whether the current viewer can sponsor this team member or their organization through GitHub Sponsors. | ||
| ViewerIsFollowing | Bool | Indicates whether the current viewer is following this team member. | ||
| ViewerIsSponsoring | Bool | Indicates whether the current viewer is sponsoring this team member or their organization through GitHub Sponsors. | ||
| ViewerCanCreateProjects | Bool | Indicates whether the current viewer can create new projects within this user’s or organization’s scope. | ||
| ViewerCanChangePinnedItems | Bool | Indicates whether the current viewer has permission to pin repositories and gists to this user’s profile. | ||
| StatusId | String | The unique identifier (node ID) for the emoji representing the user’s status. | ||
| StatusEmoji | String | An emoji that visually summarizes the user’s current status or activity. | ||
| StatusMessage | String | A brief, user-defined message describing the user’s current activity or availability. | ||
| StatusIndicatesLimitedAvailability | Bool | Indicates whether the user’s status signifies limited availability on GitHub. | ||
| StatusEmojiHTML | String | The HTML representation of the emoji used for the user’s status. | ||
| StatusCreatedAt | Datetime | The date and time when the user’s status was created, in ISO 8601 format. | ||
| StatusExpiresAt | Datetime | The expiration date and time of the user’s status. After this date, the status is no longer displayed. | ||
| StatusUpdatedAt | Datetime | The date and time when the user’s status was last updated, in ISO 8601 format. | ||
| StatusOrganizationId | String | The unique identifier (node ID) of the organization associated with the user’s status. | ||
| StatusOrganizationLogin | String | The login name of the organization associated with the user’s status. | ||
| InteractionAbilityLimit | String | Specifies the current interaction restriction applied to this user or their content (for example, 'collaborators only'). | ||
| InteractionAbilityOrigin | String | The source or reason for the currently active interaction restriction (for example, account settings, admin action). | ||
| InteractionAbilityExpiresAt | Datetime | The expiration date and time of the current interaction restriction, if applicable. | ||
| HasSponsorsListing | Bool | Indicates whether this user or organization has an active GitHub Sponsors listing. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly income from GitHub Sponsors for this user or organization, in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated amount of the next payout from GitHub Sponsors for this user or organization, in cents (USD). | ||
| SponsorsListingId | String | The unique identifier (node ID) for this user’s or organization’s GitHub Sponsors listing. | ||
| SponsorsListingName | String | The full display name of the GitHub Sponsors listing for this user or organization. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount in US cents that this user or organization has spent sponsoring others on GitHub. Visible only to the user or managers of the organization. | ||
| ResourcePath | String | The relative HTTP path to this user’s profile on GitHub. | ||
| ProjectsResourcePath | String | The relative HTTP path listing the projects associated with this user. | ||
| Url | String | The absolute HTTP URL to the user’s GitHub profile. | ||
| ProjectsUrl | String | The absolute HTTP URL listing the projects associated with this user. | ||
| WebsiteUrl | String | A URL pointing to the user’s personal website or blog, as listed on their profile. | ||
| AvatarUrl | String | The URL to the user’s public avatar image. Can accept an optional 'size' parameter to specify the dimensions of the square image in pixels. | ||
| CopilotEndpointsApi | String | The API endpoint for interacting with GitHub Copilot services. | ||
| CopilotEndpointsOriginTracker | String | The endpoint used by GitHub Copilot to track the origin of requests. | ||
| CopilotEndpointsProxy | String | The proxy endpoint used for routing GitHub Copilot requests. | ||
| CopilotEndpointsTelemetry | String | The telemetry endpoint for collecting data related to GitHub Copilot activities and usage. | ||
| CreatedAt | Datetime | The date and time when the object or team member was created, in ISO 8601 format. | ||
| UpdatedAt | Datetime | The date and time when the object or team member was last updated, in ISO 8601 format. | ||
| RepositoryCount | Int | The total number of repositories owned by the user within the team or organization. | ||
| FollowerCount | Int | The total number of followers the team member has on GitHub. | ||
| MemberAccessResourcePath | String | The relative HTTP path to the organization's member access page. | ||
| MemberAccessUrl | String | The absolute HTTP URL to the organization's member access page. | ||
| Role | String | The specific role assigned to the team member within the team (for example, 'member', 'maintainer').
The allowed values are MAINTAINER, MEMBER. | ||
| OrganizationTeamSlug [KEY] | String |
OrganizationTeams.Slug | The unique slug (URL-friendly identifier) corresponding to the team within the organization. | |
| OrganizationLogin [KEY] | String |
Organizations.Login | The login (username) of the organization associated with the team. | |
| Membership | String | Filters team members based on their membership type (for example, 'active', 'pending').
The allowed values are IMMEDIATE, CHILD_TEAM, ALL. |