Excel Add-In for GitHub

Build 24.0.9060

Organizations

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

Table-Specific Information

By default this table 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 add-in uses the GitHub API to process WHERE clause conditions built with the below columns and operators. The add-in processes other filters client-side within the add-in.

  • Login supports the '=' comparison operator.
  • MemberLogin supports the '=' comparison operator.
For example, the following queries are processed server side: 
SELECT * FROM [Information].[Organizations] WHERE [Information].[Organizations].[Login] = 'OrganizationLogin'
SELECT * FROM [Information].[Organizations] WHERE [Information].[Organizations].[MemberLogin] = 'UserLogin'

Update

The following inputs can be used to update an organization's fields:

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

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

Delete

You can specify the Login to delete an organization. 

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

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The id of the organization.

DatabaseId Int False

Identifies the primary key from the database.

Login String False

The organization's login name.

Name String False

The organization's public profile name.

TwitterUsername String False

The organization's Twitter username.

Description String False

The organization's public profile description.

DescriptionHTML String False

The organization's public profile description rendered to HTML.

Email String False

The organization's public email.

OrganizationBillingEmail String False

The billing email for the organization.

Location String False

The organization's public profile location.

AnyPinnableItems Bool False

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 False

Returns how many more items this profile owner can pin to their profile.

WebCommitSignoffRequired Bool False

Whether contributors are required to sign off on web-based commits for repositories in this organization.

MembersCanForkPrivateRepositories Bool False

Members can fork private repositories in this organization.

IpAllowListEnabledSetting String False

The setting value for whether the organization has an IP allow list enabled.

NotificationDeliveryRestrictionEnabledSetting String False

Indicates if email notification delivery for this organization is restricted to verified or approved domains.

IpAllowListForInstalledAppsEnabledSetting String False

The setting value for whether the organization has IP allow list configuration for installed GitHub Apps enabled.

Announcement String False

The text of the announcement.

AnnouncementUserDismissible Bool False

Whether the announcement can be dismissed by the user.

AnnouncementExpiresAt Datetime False

The expiration date of the announcement, if any.

CreatedAt Datetime False

Identifies the date and time when the object was created.

UpdatedAt Datetime False

Identifies the date and time when the object was last updated.

ArchivedAt Datetime False

Identifies the date and time when the object was archived.

ResourcePath String False

The HTTP path for this organization.

ProjectsResourcePath String False

The HTTP path listing organization's projects.

TeamsResourcePath String False

The HTTP path listing organization's teams.

NewTeamResourcePath String False

The HTTP path creating a new team.

Url String False

The HTTP URL for this organization.

AvatarUrl String False

A URL pointing to the organization's public avatar. Arguments size (Int) The size of the resulting square image.

ProjectsUrl String False

The HTTP URL listing organization's projects.

WebsiteUrl String False

The organization's public profile URL.

TeamsUrl String False

The HTTP URL listing organization's teams.

NewTeamUrl String False

The HTTP URL creating a new team.

IsVerified Bool False

Whether the organization has verified its profile email and website.

IsSponsoringViewer Bool False

True if the viewer is sponsored by this user/organization.

ViewerCanAdminister Bool False

Organization is adminable by the viewer.

ViewerCanSponsor Bool False

Whether or not the viewer is able to sponsor this user/organization.

ViewerIsFollowing Bool False

Whether or not this Organization is followed by the viewer.

ViewerIsSponsoring Bool False

True if the viewer is sponsoring this user/organization.

ViewerCanCreateProjects Bool False

Can the current viewer create new projects on this owner?

ViewerCanCreateRepositories Bool False

Viewer can create repositories on this organization.

ViewerCanCreateTeams Bool False

Viewer can create teams on this organization.

ViewerIsAMember Bool False

Viewer is an active member of this organization.

ViewerCanChangePinnedItems Bool False

Can the viewer pin repositories and gists to the profile?

InteractionAbilityLimit String False

The current limit that is enabled on this object.

InteractionAbilityOrigin String False

The origin of the currently active interaction limit.

InteractionAbilityExpiresAt Datetime False

The time the currently active limit expires.

ItemShowcaseHasPinnedItems Bool False

Whether or not the owner has pinned any repositories or gists.

RequiresTwoFactorAuthentication Bool False

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

SamlIdentityProviderId String False

The ID for the SAML Identity Provider.

SamlIdentityProviderIssuer String False

The Issuer Entity ID for the SAML Identity Provider.

SamlIdentityProviderDigestMethod String False

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

SamlIdentityProviderIdpCertificate String False

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

SamlIdentityProviderSignatureMethod String False

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

SamlIdentityProviderSsoUrl String False

The URL endpoint for the Identity Provider's SAML SSO.

HasSponsorsListing Bool False

True if this user/organization has a GitHub Sponsors listing.

SponsorsListingId String False

The listing's id.

SponsorsListingName String False

The listing's full name.

EstimatedNextSponsorsPayoutInCents Int False

The estimated next GitHub Sponsors payout for this user/organization in cents (USD).

MonthlyEstimatedSponsorsIncomeInCents Int False

The estimated monthly GitHub Sponsors income for this user/organization in cents (USD).

MemberLogin String False

Filter organizations based on having a specific member by that user's login.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060