ODBC Driver for GitHub

Build 24.0.9175

Organizations

Contains comprehensive information about organizations linked either to the authenticated user or to a specified organization.

Table-Specific Information

Select

The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

  • Login supports the '=,IN' comparison operators.
  • MemberLogin supports the '=,IN' comparison operators.

For example, the following queries are processed server-side: 

SELECT * FROM [Organizations]
SELECT * FROM [Organizations] WHERE [Login] = 'Val1'
SELECT * FROM [Organizations] WHERE [MemberLogin] = 'Val1'

The 本製品 processes other filters client-side within the 本製品.

Update

You can use the following columns to update a record:

  • Name
  • TwitterUsername
  • Description
  • Email
  • OrganizationBillingEmail
  • Location
  • WebCommitSignoffRequired
  • MembersCanForkPrivateRepositories
  • WebsiteUrl

UPDATE [Organizations] SET [Name] = 'test', [WebCommitSignoffRequired] = false WHERE [Login] = 'test'

Delete

You can specify the following column to delete a record: Login 

DELETE FROM [Organizations] WHERE [Login] = 'test'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier (node ID) of the organization.

DatabaseId Int True

The primary key identifier for the organization in the database, used for internal reference.

Login String True

The login (username) of the organization, used for identification and API references.

Name String True

The publicly displayed name of the organization.

TwitterUsername String True

The Twitter username associated with the organization, if provided.

Description String True

A brief description of the organization’s public profile, summarizing its purpose or mission.

DescriptionHTML String True

The HTML-rendered version of the organization’s public profile description for display purposes.

Email String True

The publicly visible email address associated with the organization.

OrganizationBillingEmail String True

The email address used for billing purposes within the organization.

Location String True

The geographic location specified in the organization’s public profile.

AnyPinnableItems Bool True

Indicates whether the organization has items, such as repositories or gists, that can be pinned to its profile. Can filter by item type.

PinnedItemsRemaining Int True

The number of additional items the organization can pin to its profile.

WebCommitSignoffRequired Bool True

Indicates whether contributors are required to sign off on web-based commits for repositories within the organization.

MembersCanForkPrivateRepositories Bool True

Indicates whether organization members are allowed to fork private repositories.

IpAllowListEnabledSetting String True

Specifies whether the organization has enabled an IP allow list for controlling access.

NotificationDeliveryRestrictionEnabledSetting String True

Indicates whether email notifications for the organization are restricted to verified or approved domains.

IpAllowListForInstalledAppsEnabledSetting String True

Specifies whether the organization has enabled IP allow list configuration for installed GitHub Apps.

Announcement String True

The text of the current announcement made by the organization.

AnnouncementUserDismissible Bool True

Indicates whether the announcement can be dismissed by users.

AnnouncementCreatedAt Datetime True

The date and time when the announcement was created, in ISO 8601 format.

AnnouncementExpiresAt Datetime True

The expiration date and time of the announcement, if set.

CreatedAt Datetime True

The date and time when the organization object was created, in ISO 8601 format.

UpdatedAt Datetime True

The date and time when the organization object was last updated, in ISO 8601 format.

ArchivedAt Datetime True

The date and time when the organization object was archived, if applicable.

ResourcePath String True

The relative HTTP path to the organization’s profile on GitHub.

ProjectsResourcePath String True

The relative HTTP path to the list of the organization’s projects.

TeamsResourcePath String True

The relative HTTP path to the list of the organization’s teams.

NewTeamResourcePath String True

The relative HTTP path for creating a new team within the organization.

Url String True

The absolute HTTP URL to the organization’s profile on GitHub.

AvatarUrl String True

A URL pointing to the organization’s public avatar image. Accepts an optional 'size' argument to specify the dimensions of the square image in pixels.

ProjectsUrl String True

The HTTP URL listing the organization’s projects on GitHub.

WebsiteUrl String True

The public URL of the organization’s website, as specified in its profile.

TeamsUrl String True

The HTTP URL listing the organization’s teams on GitHub.

NewTeamUrl String True

The HTTP URL for creating a new team within the organization.

IsVerified Bool True

Indicates whether the organization has verified its profile email and website.

IsSponsoringViewer Bool True

Indicates whether the organization is sponsoring the current viewer through GitHub Sponsors.

ViewerCanAdminister Bool True

Indicates whether the current viewer has administrative permissions for the organization.

ViewerCanSponsor Bool True

Indicates whether the current viewer is able to sponsor the organization through GitHub Sponsors.

ViewerIsFollowing Bool True

Indicates whether the current viewer is following the organization.

ViewerIsSponsoring Bool True

Indicates whether the current viewer is sponsoring the organization through GitHub Sponsors.

ViewerCanCreateProjects Bool True

Indicates whether the current viewer can create new projects within the organization.

ViewerCanCreateRepositories Bool True

Indicates whether the current viewer can create repositories within the organization.

ViewerCanCreateTeams Bool True

Indicates whether the current viewer can create teams within the organization.

ViewerIsAMember Bool True

Indicates whether the current viewer is an active member of the organization.

ViewerCanChangePinnedItems Bool True

Indicates whether the current viewer can pin repositories and gists to the organization’s profile.

InteractionAbilityLimit String True

Specifies the current interaction restriction applied to the organization (for example, collaborators only).

InteractionAbilityOrigin String True

The source or reason for the currently active interaction restriction (for example, account settings or admin action).

InteractionAbilityExpiresAt Datetime True

The date and time when the currently active interaction restriction expires, if applicable.

ItemShowcaseHasPinnedItems Bool True

Indicates whether the organization has pinned any repositories or gists to its profile.

RequiresTwoFactorAuthentication Bool True

Indicates whether the organization requires all members, billing managers, and outside collaborators to enable two-factor authentication.

SamlIdentityProviderId String True

The unique identifier (node ID) for the SAML Identity Provider associated with the organization.

SamlIdentityProviderIssuer String True

The Issuer Entity ID for the SAML Identity Provider, used to identify the issuer of SAML assertions.

SamlIdentityProviderDigestMethod String True

The digest algorithm used to sign SAML requests for the Identity Provider.

SamlIdentityProviderIdpCertificate String True

The x509 certificate used by the Identity Provider to sign SAML assertions and responses.

SamlIdentityProviderSignatureMethod String True

The signature algorithm used to sign SAML requests for the Identity Provider.

SamlIdentityProviderSsoUrl String True

The Single Sign-On (SSO) URL endpoint for the Identity Provider’s SAML SSO.

HasSponsorsListing Bool True

Indicates whether the organization has an active GitHub Sponsors listing.

SponsorsListingId String True

The unique identifier (node ID) for the organization’s GitHub Sponsors listing.

SponsorsListingName String True

The full name of the organization’s GitHub Sponsors listing.

EstimatedNextSponsorsPayoutInCents Int True

The estimated amount of the next payout from GitHub Sponsors for this organization, in cents (USD).

MonthlyEstimatedSponsorsIncomeInCents Int True

The estimated monthly income from GitHub Sponsors for this organization, in cents (USD).

MemberLogin String True

Filters the list of organizations to include only those that have a specific member, identified by the user's login (username).

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175