Lists information about the organizations of the logged in user, the specified user, or the specified organization.

View-Specific Information

By default this view will only return information about the organizations of the logged in user.

Specific columns require the authenticated user to be an owner of the organization to retrieve data. These columns include WebCommitSignoffRequired, IpAllowListEnabledSetting, RequiresTwoFactorAuthentication, MembersCanForkPrivateRepositories, NotificationDeliveryRestrictionEnabledSetting and IpAllowListForInstalledAppsEnabledSetting.

Data access to third-parties is limited if an organization has enabled OAuth App access restrictions.

Select

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

• Login supports the '=' comparison operator.
• MemberLogin supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM [Information].[Organizations] WHERE [Information].[Organizations].[Login] = 'OrganizationLogin'
SELECT * FROM [Information].[Organizations] WHERE [Information].[Organizations].[MemberLogin] = 'UserLogin'

Columns

Name	Type	References	OrderBySupport	Description
Id [KEY]	String			The id of the organization.
DatabaseId	Int			Identifies the primary key from the database.
Login	String			The organization's login name.
Name	String			The organization's public profile name.
TwitterUsername	String			The organization's Twitter username.
Description	String			The organization's public profile description.
DescriptionHTML	String			The organization's public profile description rendered to HTML.
Email	String			The organization's public email.
OrganizationBillingEmail	String			The billing email for the organization.
Location	String			The organization'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.
WebCommitSignoffRequired	Bool			Whether contributors are required to sign off on web-based commits for repositories in this organization.
MembersCanForkPrivateRepositories	Bool			Members can fork private repositories in this organization.
IpAllowListEnabledSetting	String			The setting value for whether the organization has an IP allow list enabled.
NotificationDeliveryRestrictionEnabledSetting	String			Indicates if email notification delivery for this organization is restricted to verified or approved domains.
IpAllowListForInstalledAppsEnabledSetting	String			The setting value for whether the organization has IP allow list configuration for installed GitHub Apps enabled.
Announcement	String			The text of the announcement.
AnnouncementUserDismissible	Bool			Whether the announcement can be dismissed by the user.
AnnouncementExpiresAt	Datetime			The expiration date of the announcement, if any.
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.
ArchivedAt	Datetime			Identifies the date and time when the object was archived.
ResourcePath	String			The HTTP path for this organization.
ProjectsResourcePath	String			The HTTP path listing organization's projects.
TeamsResourcePath	String			The HTTP path listing organization's teams.
NewTeamResourcePath	String			The HTTP path creating a new team.
Url	String			The HTTP URL for this organization.
AvatarUrl	String			A URL pointing to the organization's public avatar. Arguments size (Int) The size of the resulting square image.
ProjectsUrl	String			The HTTP URL listing organization's projects.
WebsiteUrl	String			The organization's public profile URL.
TeamsUrl	String			The HTTP URL listing organization's teams.
NewTeamUrl	String			The HTTP URL creating a new team.
IsVerified	Bool			Whether the organization has verified its profile email and website.
IsSponsoringViewer	Bool			True if the viewer is sponsored by this user/organization.
ViewerCanAdminister	Bool			Organization is adminable by the viewer.
ViewerCanSponsor	Bool			Whether or not the viewer is able to sponsor this user/organization.
ViewerIsFollowing	Bool			Whether or not this Organization 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?
ViewerCanCreateRepositories	Bool			Viewer can create repositories on this organization.
ViewerCanCreateTeams	Bool			Viewer can create teams on this organization.
ViewerIsAMember	Bool			Viewer is an active member of this organization.
ViewerCanChangePinnedItems	Bool			Can the viewer pin repositories and gists to the profile?
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.
ItemShowcaseHasPinnedItems	Bool			Whether or not the owner has pinned any repositories or gists.
RequiresTwoFactorAuthentication	Bool			When true the organization requires all members, billing managers, and outside collaborators to enable two-factor authentication.
SamlIdentityProviderId	String			The ID for the SAML Identity Provider.
SamlIdentityProviderIssuer	String			The Issuer Entity ID for the SAML Identity Provider.
SamlIdentityProviderDigestMethod	String			The digest algorithm used to sign SAML requests for the Identity Provider.
SamlIdentityProviderIdpCertificate	String			The x509 certificate used by the Identity Provider to sign assertions and responses.
SamlIdentityProviderSignatureMethod	String			The signature algorithm used to sign SAML requests for the Identity Provider.
SamlIdentityProviderSsoUrl	String			The URL endpoint for the Identity Provider's SAML SSO.
HasSponsorsListing	Bool			True if this user/organization has a GitHub Sponsors listing.
SponsorsListingId	String			The listing's id.
SponsorsListingName	String			The listing's full name.
EstimatedNextSponsorsPayoutInCents	Int			The estimated next GitHub Sponsors payout for this user/organization in cents (USD).
MonthlyEstimatedSponsorsIncomeInCents	Int			The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).
MemberLogin	String			Filter organizations based on having a specific member by that user's login.