SSIS Components for GitHub

Build 24.0.9062

Enterprises

A list of enterprises that the user belongs to.

View-Specific Information

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 本製品.

  • Slug supports the '=' comparison operator.
  • MembershipType supports the '=' comparison operator.
  • Login supports the '=' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Slug] = 'test-enterprise'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[MembershipType] = 'ADMIN'
SELECT * FROM [Information].[Enterprises] WHERE [Information].[Enterprises].[Login] = 'test'

Columns

Name Type References OrderBySupport Description
Id [KEY] String The ID of the Enterprise object.
UserId String The ID of the User object.
Location String The location of the enterprise.
Name String The name of the enterprise.
DatabaseId Int Identifies the primary key from the database.
Announcement String The text of the announcement.
AnnouncementExpiresAt Datetime The expiration date of the announcement, if any.
AnnouncementUserDismissible Bool Whether the announcement can be dismissed by the user.
BillingEmail String The enterprise's billing email.
BillingInfoAllLicensableUsersCount Int The number of licenseable users/emails across the enterprise.
BillingInfoAssetPacks Int The number of data packs used by all organizations owned by the enterprise.
BillingInfoBandwidthQuota Double The bandwidth quota in GB for all organizations owned by the enterprise.
BillingInfoBandwidthUsage Double The bandwidth usage in GB for all organizations owned by the enterprise.
BillingInfoBandwidthUsagePercentage Int The bandwidth usage as a percentage of the bandwidth quota.
BillingInfoStorageQuota Double The storage quota in GB for all organizations owned by the enterprise.
BillingInfoStorageUsage Double The storage usage in GB for all organizations owned by the enterprise.
BillingInfoStorageUsagePercentage Int The storage usage as a percentage of the storage quota.
BillingInfoTotalAvailableLicenses Int The number of available licenses across all owned organizations based on the unique number of billable users.
BillingInfoTotalLicenses Int The total number of licenses allocated.
CreatedAt Datetime Identifies the date and time when the object was created.
Description String The description of the enterprise.
DescriptionHTML String The description of the enterprise as HTML.
OwnerInfoOidcProviderId String The ID of the OIDCProvider object
OwnerInfoOidcProviderTenantId String The ID of the tenant this provider is attached to.
OwnerInfoSamlIdentityProviderId String The ID of the EnterpriseIdentityProvider object.
ResourcePath String The HTTP path for this enterprise.
Slug String The URL-friendly identifier for the enterprise.
Url String The HTTP URL for this enterprise.
ViewerIsAdmin Bool Is the current viewer an admin of this enterprise?
WebsiteUrl String The URL of the enterprise website.
MembershipType String Filter enterprises returned based on the user's membership type.
Login String The user's login.

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