SSIS Components for GitHub

Build 24.0.9062

OrganizationTeamRepositories

Lists information about the repositories that the logged in user's organizations' teams or the teams of the specified organization have access 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 本製品.

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

The 本製品 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 本製品 processes ordering by other columns client-side within the 本製品.

  • Name
  • StargazerCount
  • PushedAt
  • CreatedAt
  • Permission
For example, the following queries are processed server side:
SELECT * FROM [Information].[OrganizationTeamRepositories] WHERE [Information].[OrganizationTeamRepositories].[OrganizationLogin] = 'EXAMPLE' AND [Information].[OrganizationTeamRepositories].[OrganizationTeamSlug] = 'EXAMPLE_TEAM'

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

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

Columns

Name Type References OrderBySupport Description
Id [KEY] String The ID of the repository.
DatabaseId Int Identifies the primary key from the database.
Name String The name of the repository.
NameWithOwner String The repository's name with owner.
Visibility String Indicates the repository's visibility level.
DiskUsage Int The number of kilobytes this repository occupies on disk.
ForkCount Int Returns how many forks there are of this repository in the whole network.
StargazerCount Int Returns a count of how many stargazers there are on this object.
WatcherCount Int The number of watchers in a repository.
TopicCount Int The number of topics that have been applied to the repository.
TempCloneToken String Temporary authentication token for cloning this repository.
WebCommitSignoffRequired Bool Whether contributors are required to sign off on web-based commits in this repository.
UsesCustomOpenGraphImage Bool Whether this repository has a custom image to use with Open Graph as opposed to being represented by the owner's avatar.
Description String The description of the repository.
DescriptionHTML String The description of the repository rendered to HTML.
ShortDescriptionHTML String A description of the repository, rendered to HTML without any links in it.
ResourcePath String The HTTP path for this repository.
ProjectsResourcePath String The HTTP path listing the repository's projects.
Url String The HTTP URL for this repository.
HomepageUrl String The repository's URL.
MirrorUrl String The repository's original mirror URL.
ProjectsUrl String The HTTP URL listing the repository's projects.
SecurityPolicyUrl String The security policy URL.
SSHUrl String The SSH URL to clone this repository.
OpenGraphImageUrl String The image used to represent this repository in Open Graph data.
MergeCommitTitle String How the default commit title will be generated when merging a pull request.
MergeCommitMessage String How the default commit message will be generated when merging a pull request.
SquashMergeCommitTitle String How the default commit title will be generated when squash merging a pull request.
SquashMergeCommitMessage String How the default commit message will be generated when squash merging a pull request.
DeleteBranchOnMerge Bool Whether or not branches are automatically deleted when merged in this repository.
HasDiscussionsEnabled Bool Indicates if the repository has the Discussions feature enabled.
HasIssuesEnabled Bool Indicates if the repository has issues feature enabled.
HasProjectsEnabled Bool Indicates if the repository has the Projects feature enabled.
HasWikiEnabled Bool Indicates if the repository has wiki feature enabled.
HasVulnerabilityAlertsEnabled Bool Whether vulnerability alerts are enabled for the repository.
HasSponsorshipsEnabled Bool Indicates if the repository displays a Sponsor button for financial contributions.
IsInOrganization Bool Indicates if a repository is either owned by an organization, or is a private fork of an organization repository.
IsBlankIssuesEnabled Bool Returns true if blank issue creation is allowed.
IsSecurityPolicyEnabled Bool Returns true if this repository has a security policy.
IsUserConfigurationRepository Bool Is this repository a user configuration repository?
IsArchived Bool Indicates if the repository is unmaintained.
IsDisabled Bool Returns whether or not this repository disabled.
IsEmpty Bool Returns whether or not this repository is empty.
IsFork Bool Identifies if the repository is a fork.
IsLocked Bool Indicates if the repository has been locked or not.
IsMirror Bool Identifies if the repository is a mirror.
IsPrivate Bool Identifies if the repository is private.
IsTemplate Bool Identifies if the repository is a template that can be used to generate new repositories.
LockReason String The reason the repository has been locked.
TemplateRepositoryId String The ID of the repository from which this repository was generated, if any.
ParentId String The repository parent ID, if this is a fork.
ForkingAllowed Bool Whether this repository allows forks.
AutoMergeAllowed Bool Whether or not Auto-merge can be enabled on pull requests in this repository.
SquashMergeAllowed Bool Whether or not squash-merging is enabled on this repository.
RebaseMergeAllowed Bool Whether or not rebase-merging is enabled on this repository.
MergeCommitAllowed Bool Whether or not PRs are merged with a merge commit on this repository.
AllowUpdateBranch Bool Whether or not a pull request head branch that is behind its base branch can always be updated even if it is not required to be up to date before merging.
ViewerPermission String The users permission level on the repository. Will return null if authenticated as an GitHub App.
ViewerSubscription String Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
ViewerHasStarred Bool Returns a boolean indicating whether the viewing user has starred this starrable.
ViewerDefaultCommitEmail String The last commit email for the viewer.
ViewerDefaultMergeMethod String The last used merge method by the viewer or the default for the repository.
ViewerPossibleCommitEmails String A list of emails this viewer can commit with.
ViewerCanAdminister Bool Indicates whether the viewer has admin permissions on this repository.
ViewerCanSubscribe Bool Check if the viewer is able to change their subscription status for the repository.
ViewerCanCreateProjects Bool Can the current viewer create new projects on this owner.
ViewerCanUpdateTopics Bool Indicates whether the viewer can update the topics of this repository.
CodeOfConductId String The ID of the Code of Conduct.
CodeOfConductName String The formal name of the Code of Conduct.
CodeOfConductBody String The body of the Code of Conduct.
CodeOfConductKey String The key for the Code of Conduct.
CodeOfConductUrl String The HTTP URL for this Code of Conduct.
CodeOfConductResourcePath String The HTTP path for this Code of Conduct.
DefaultBranchRefId String The ref id.
DefaultBranchRefName String The ref 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.
LatestReleaseId String The ID of the release.
LatestReleaseName String The title of the release.
LicenseId String The ID of the license associated with the repository.
LicenseKey String

Licenses.Key

The key of the license associated with the repository.
LanguageId String The ID of the current primary language.
LanguageName String The name defined for the current language.
LanguageColor String The color defined for the current language.
PushedAt Datetime Identifies when the repository was last pushed to.
ArchivedAt Datetime Identifies the date and time when the repository was archived.
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.
Permission String The permission level the team has on the repository.
OrganizationTeamSlug [KEY] String

OrganizationTeams.Slug

The slug corresponding to the team.
OrganizationLogin [KEY] String

Organizations.Login

The organization's login name.

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