OrganizationMembers
Lists information about the users of the logged in user's organizations or of the specified organization.
View-Specific Information
Select
The connector uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The connector processes other filters client-side within the connector.
- OrganizationLogin supports the '=' comparison operator.
SELECT * FROM [Information].[OrganizationMembers] WHERE [Information].[OrganizationMembers].[OrganizationLogin] = 'EXAMPLE'
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | The ID of the user. | ||
| DatabaseId | Int | Identifies the primary key from the database. | ||
| Login | String | The username used to login. | ||
| Name | String | The user's public profile name. | ||
| String | The user's publicly visible profile email. | |||
| TwitterUsername | String | The user's Twitter username. | ||
| Pronouns | String | The user's profile pronouns. | ||
| Bio | String | The user's public profile bio. | ||
| BioHTML | String | The user's public profile bio as HTML. | ||
| Company | String | The user's public profile company. | ||
| CompanyHTML | String | The user's public profile company as HTML. | ||
| Location | String | The user's public profile location. | ||
| AnyPinnableItems | Bool | Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item. | ||
| PinnedItemsRemaining | Int | Returns how many more items this profile owner can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Whether or not the owner has pinned any repositories or gists. | ||
| IsEmployee | Bool | Whether or not this user is a GitHub employee. | ||
| IsHireable | Bool | Whether or not the user has marked themselves as for hire. | ||
| IsBountyHunter | Bool | Whether or not this user is a participant in the GitHub Security Bug Bounty. | ||
| IsCampusExpert | Bool | Whether or not this user is a participant in the GitHub Campus Experts Program. | ||
| IsFollowingViewer | Bool | Whether or not this user is following the viewer. Inverse of viewerIsFollowing. | ||
| IsSiteAdmin | Bool | Whether or not this user is a site administrator. | ||
| IsDeveloperProgramMember | Bool | Whether or not this user is a GitHub Developer Program member. | ||
| IsGitHubStar | Bool | Whether or not this user is a member of the GitHub Stars Program. | ||
| IsSponsoringViewer | Bool | True if the viewer is sponsored by this user/organization. | ||
| IsViewer | Bool | Whether or not this user is the viewing user. | ||
| ViewerCanFollow | Bool | Whether or not the viewer is able to follow the user. | ||
| ViewerCanSponsor | Bool | Whether or not the viewer is able to sponsor this user/organization. | ||
| ViewerIsFollowing | Bool | Whether or not this user is followed by the viewer. | ||
| ViewerIsSponsoring | Bool | True if the viewer is sponsoring this user/organization. | ||
| ViewerCanCreateProjects | Bool | Can the current viewer create new projects on this owner. | ||
| ViewerCanChangePinnedItems | Bool | Can the viewer pin repositories and gists to the profile?. | ||
| StatusId | String | The emoji's id. | ||
| StatusEmoji | String | An emoji summarizing the user's status. | ||
| StatusMessage | String | A brief message describing what the user is doing. | ||
| StatusIndicatesLimitedAvailability | Bool | Whether this status indicates the user is not fully available on GitHub. | ||
| StatusEmojiHTML | String | The status emoji as HTML. | ||
| StatusCreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| StatusExpiresAt | Datetime | If set, the status will not be shown after this date. | ||
| StatusUpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| StatusOrganizationId | String | The organization's id. | ||
| StatusOrganizationLogin | String | The organization's login name. | ||
| InteractionAbilityLimit | String | The current limit that is enabled on this object. | ||
| InteractionAbilityOrigin | String | The origin of the currently active interaction limit. | ||
| InteractionAbilityExpiresAt | Datetime | The time the currently active limit expires. | ||
| HasSponsorsListing | Bool | True if this user/organization has a GitHub Sponsors listing. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly GitHub Sponsors income for this user/organization in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated next GitHub Sponsors payout for this user/organization in cents (USD). | ||
| SponsorsListingId | String | The listing's id. | ||
| SponsorsListingName | String | The listing's full name. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The amount in US cents that this entity has spent on GitHub to fund sponsorships. Only returns a value when viewed by the user themselves or by a user who can manage sponsorships for the requested organization. | ||
| ResourcePath | String | The HTTP path for this user. | ||
| ProjectsResourcePath | String | The HTTP path listing user's projects. | ||
| Url | String | The HTTP URL for this user. | ||
| ProjectsUrl | String | The HTTP URL listing user's projects. | ||
| WebsiteUrl | String | A URL pointing to the user's public website/blog. | ||
| AvatarUrl | String | A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image. | ||
| CreatedAt | Datetime | Identifies the date and time when the object was created. | ||
| UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | ||
| RepositoryCount | Int | The number of repositories that a user owns. | ||
| FollowerCount | Int | The number of followers that a user has. | ||
| Role | String | The role of this user has in the organization. | ||
| HasTwoFactorEnabled | Bool | Whether the organization member has two factor enabled or not. Returns null if information is not available to viewer. | ||
| OrganizationLogin [KEY] | String |
Organizations.Login | The organization's login name. |