Lists information about the users of the logged in user's organizations' teams or the teams of the specified organization.

View-Specific Information

Select

The driver uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The driver processes other filters client-side within the driver.

• OrganizationLogin supports the '=' comparison operator.
• OrganizationTeamSlug supports the '=' comparison operator.
• Role supports the '=' comparison operator.
• Membership supports the '=' comparison operator.

The driver uses the GitHub API to process ORDER BY clause conditions built with the following column when OrganizationLogin and OrganizationTeamSlug is specified in the criteria both with the '=' comparison operator, or when OwnerLogin is set to an organization's login and OrganizationTeamSlug is specified in the criteria with the '=' comparison operator. The driver processes ordering by other columns client-side within the driver.

• Login
• CreatedAt

For example, the following queries are processed server side:

SELECT * FROM [Information].[OrganizationTeamMembers] WHERE [Information].[OrganizationTeamMembers].[OrganizationLogin] = 'EXAMPLE' AND [Information].[OrganizationTeamMembers].[OrganizationTeamSlug] = 'EXAMPLE_TEAM'

SELECT * FROM [Information].[OrganizationTeamMembers] WHERE [Information].[OrganizationTeamMembers].[OrganizationLogin] = 'EXAMPLE'

SELECT * FROM [Information].[OrganizationTeamMembers] WHERE [Information].[OrganizationTeamMembers].[OrganizationTeamSlug] = 'EXAMPLE_TEAM'

SELECT * FROM [Information].[OrganizationTeamMembers] WHERE [Information].[OrganizationTeamMembers].[Role] = 'MAINTAINER'

SELECT * FROM [Information].[OrganizationTeamMembers] WHERE [Information].[OrganizationTeamMembers].[Membership] = 'IMMEDIATE'

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.
Email	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.
MemberAccessResourcePath	String			The HTTP path to the organization's member access page.
MemberAccessUrl	String			The HTTP URL to the organization's member access page.
Role	String			The role the member has on the team.
OrganizationTeamSlug [KEY]	String	OrganizationTeams.Slug		The slug corresponding to the team.
OrganizationLogin [KEY]	String	Organizations.Login		The organization's login name.
Membership	String			Filter by membership type.