OrganizationMembers
Details all members and collaborators associated with the user's organizations or a specific organization.
View-Specific Information
Select
The add-in uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- OrganizationLogin supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [OrganizationMembers]
SELECT * FROM [OrganizationMembers] WHERE [OrganizationLogin] = 'Val1'
The add-in processes other filters client-side within the add-in.
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The unique identifier (node ID) of the user within the organization. | ||
| DatabaseId | Int | The primary key identifier for the user in the database, used for internal reference. | ||
| Login | String | The username used by the user to log in and identify their GitHub account. | ||
| Name | String | The publicly visible name of the user as displayed on their GitHub profile. | ||
| String | The email address publicly associated with the user’s profile, if available. | |||
| TwitterUsername | String | The Twitter handle provided by the user on their public profile, if available. | ||
| Pronouns | String | The pronouns specified by the user on their profile (for example, they/them, she/her, he/him). | ||
| Bio | String | The user’s public profile bio, which provides a brief description of their background or interests. | ||
| BioHTML | String | The HTML-formatted version of the user's bio for display purposes. | ||
| Company | String | The organization or company name listed on the user’s public profile. | ||
| CompanyHTML | String | The HTML-formatted version of the user’s company information for display purposes. | ||
| Location | String | The geographic location provided by the user on their public profile. | ||
| AnyPinnableItems | Bool | Indicates whether the user has any items, such as repositories or gists, that can be pinned to their profile. Can be filtered by item type. | ||
| PinnedItemsRemaining | Int | The number of additional items 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 a GitHub employee. | ||
| IsHireable | Bool | Indicates whether the user has marked themselves as available for hire on GitHub. | ||
| 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 the user is following the current viewer of their profile. This is the inverse of ViewerIsFollowing. | ||
| IsSiteAdmin | Bool | Indicates whether the user is a GitHub site administrator with elevated permissions. | ||
| IsDeveloperProgramMember | Bool | Indicates whether the user is a participant in the GitHub Developer Program. | ||
| IsGitHubStar | Bool | Indicates whether the user is a recognized member of the GitHub Stars program. | ||
| IsSponsoringViewer | Bool | Indicates whether the user or organization is financially sponsoring the current viewer. | ||
| IsViewer | Bool | Indicates whether the user is the currently logged-in viewer of the profile. | ||
| ViewerCanFollow | Bool | Indicates whether the current viewer has the ability to follow this user. | ||
| ViewerCanSponsor | Bool | Indicates whether the current viewer can sponsor this user or organization through GitHub Sponsors. | ||
| ViewerIsFollowing | Bool | Indicates whether the current viewer is following this user. | ||
| ViewerIsSponsoring | Bool | Indicates whether the current viewer is sponsoring this user or organization through GitHub Sponsors. | ||
| ViewerCanCreateProjects | Bool | Indicates whether the current viewer can create new projects for this user or organization. | ||
| ViewerCanChangePinnedItems | Bool | Indicates whether the current viewer has permission to pin repositories and gists to the user's profile. | ||
| StatusId | String | The unique identifier (ID) of the emoji representing the user’s status. | ||
| StatusEmoji | String | An emoji that visually represents the user’s current status. | ||
| StatusMessage | String | A brief, user-defined message describing the user’s current activity or availability. | ||
| StatusIndicatesLimitedAvailability | Bool | Indicates whether the user’s status suggests 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 for the user’s status. After this time, the status is no longer be visible. | ||
| 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’s account or content (for example, collaborators only). | ||
| InteractionAbilityOrigin | String | The source or reason for the currently active interaction restriction (for example, account settings or an admin action). | ||
| InteractionAbilityExpiresAt | Datetime | The date and time when the currently active interaction restriction expires, 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) of the GitHub Sponsors listing for this user or organization. | ||
| SponsorsListingName | String | The full name of the GitHub Sponsors listing for this user or organization. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount (in cents, USD) that this user or organization has spent to sponsor others on GitHub. Only visible 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 to the list of projects associated with this user. | ||
| Url | String | The absolute HTTP URL to the user’s profile on GitHub. | ||
| ProjectsUrl | String | The absolute HTTP URL to the list of 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 pointing to the user’s public avatar image. Optionally accepts a 'size' argument to specify the dimensions of the square image in pixels. | ||
| CopilotEndpointsApi | String | The API endpoint used to interact with GitHub Copilot services. | ||
| CopilotEndpointsOriginTracker | String | The endpoint used by GitHub Copilot for tracking the origin of requests. | ||
| CopilotEndpointsProxy | String | The proxy endpoint used for routing GitHub Copilot requests. | ||
| CopilotEndpointsTelemetry | String | The telemetry endpoint used for collecting data related to GitHub Copilot activities and usage. | ||
| CreatedAt | Datetime | The date and time when the object or user was created, in ISO 8601 format. | ||
| UpdatedAt | Datetime | The date and time when the object or user was last updated, in ISO 8601 format. | ||
| RepositoryCount | Int | The total number of repositories owned by the user within the organization. | ||
| FollowerCount | Int | The total number of followers the user has on GitHub. | ||
| Role | String | The specific role assigned to the user within the organization (for example, 'member', 'admin'). | ||
| HasTwoFactorEnabled | Bool | Indicates whether the organization member has two-factor authentication enabled. Returns null if the information is not visible to the current viewer. | ||
| OrganizationLogin [KEY] | String |
Organizations.Login | The login (username) of the organization associated with the member. |