OrganizationTeams

Maintains a list of all teams within the user's organizations, supporting team management and collaboration.

Table-Specific Information

Select

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

OrganizationLogin supports the '=,IN' comparison operators.
Privacy supports the '=' comparison operator.
Slug supports the '=,IN' comparison operators.
NotificationSetting supports the '=' comparison operator.
LdapMapped supports the '=' comparison operator.
Role supports the '=,IN' comparison operators.
RootTeamsOnly supports the '=' comparison operator.
UserLogins supports the '=,IN' comparison operators.

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

SELECT * FROM [OrganizationTeams]
SELECT * FROM [OrganizationTeams] WHERE [OrganizationLogin] = 'Val1'
SELECT * FROM [OrganizationTeams] WHERE [Privacy] = 'SECRET'
SELECT * FROM [OrganizationTeams] WHERE [Slug] = 'Val1'
SELECT * FROM [OrganizationTeams] WHERE [NotificationSetting] = 'NOTIFICATIONS_ENABLED'
SELECT * FROM [OrganizationTeams] WHERE [LdapMapped] = true
SELECT * FROM [OrganizationTeams] WHERE [Role] = 'ADMIN'
SELECT * FROM [OrganizationTeams] WHERE [RootTeamsOnly] = true
SELECT * FROM [OrganizationTeams] WHERE [UserLogins] = 'Val1'

The component processes other filters client-side within the component.

The component uses the GitHub API to process ORDER BY clause conditions that are built with the following column:

Name ASC

SELECT * FROM [OrganizationTeams] ORDER BY [Name] ASC

The component uses client-side processing when ordering by any other columns. This impacts performance.

Insert

You can use the following columns to create (insert) a new record:

OrganizationLogin
OrganizationDatabaseId
ParentTeamDatabaseId
Name
Description
Privacy
NotificationSetting
UserLogins

You can use the following pseudo-column to create a new record: RepositoryNamesWithOwner

INSERT INTO [OrganizationTeams] ([Name], [Description], [Privacy], [NotificationSetting], [OrganizationLogin], [UserLogins], [RepositoryNamesWithOwner]) VALUES ('TestTeam', 'A test team.', 'SECRET', 'NOTIFICATIONS_ENABLED', 'myorg', 'User1,User2', 'myorg/test2,myorg/test')

Update

You can use the following columns to update a record:

ParentTeamDatabaseId
Name
Description
Privacy
NotificationSetting

UPDATE [OrganizationTeams] SET [Name] = '123456', [Description] = 'newDescription', [Privacy] = 'VISIBLE', [NotificationSetting] = 'NOTIFICATIONS_DISABLED' WHERE [OrganizationLogin] = 'myorg' AND [Slug] = 'team'

Delete

You can specify either of the following sets of WHERE conditions to delete a record:

OrganizationLogin and Slug

DELETE FROM [OrganizationTeams] WHERE ([OrganizationLogin] = 'myorg') AND ([Slug] = 'team')

OrganizationDatabaseId and DatabaseId

DELETE FROM [OrganizationTeams] WHERE ([OrganizationDatabaseId] = '178278991') AND ([DatabaseId] = '11017906')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier (node ID) of the team.
DatabaseId	Int	True		The primary key identifier for the team in the database, used for internal reference.
OrganizationId	String	True	Organizations.Id	The unique identifier (node ID) of the organization associated with the team.
OrganizationDatabaseId	Int	False	Organizations.DatabaseId	The primary key identifier for the organization in the database, used for internal reference.
OrganizationLogin	String	False	Organizations.Login	The login (username) of the organization associated with the team.
ParentTeamId	String	True		The unique identifier (node ID) of the parent team, if this team is part of a parent-child team hierarchy.
ParentTeamDatabaseId	Int	False		The primary key identifier for the parent team in the database, used for internal reference.
ParentTeamName	String	True		The name of the parent team, if applicable.
Name	String	False		The name of the team, as displayed within the organization.
Description	String	False		A brief description of the team, summarizing its purpose or activities.
Privacy	String	False		The privacy level of the team, which can be 'secret' or 'closed'. The allowed values are SECRET, VISIBLE.
Slug	String	True		The URL-friendly identifier (slug) corresponding to the team.
Url	String	True		The absolute HTTP URL to access the team on GitHub.
AvatarUrl	String	True		A URL pointing to the team’s avatar image, if available.
CombinedSlug	String	True		The combined slug of the organization and team (for example, 'org-name/team-name').
DiscussionsUrl	String	True		The absolute HTTP URL to access the team's discussions on GitHub.
MembersUrl	String	True		The absolute HTTP URL to view the team’s members on GitHub.
NotificationSetting	String	False		The current notification setting for the team (for example, 'all', 'mentions'). The allowed values are NOTIFICATIONS_ENABLED, NOTIFICATIONS_DISABLED.
RepositoriesUrl	String	True		The absolute HTTP URL to view the repositories associated with the team.
ResourcePath	String	True		The relative HTTP path to access the team on GitHub.
TeamsUrl	String	True		The absolute HTTP URL to view the sub-teams under this team, if any.
ViewerSubscription	String	True		Indicates whether the viewer is 'watching', 'not watching', or 'ignoring' the team’s updates.
DiscussionsResourcePath	String	True		The relative HTTP path to the team's discussions on GitHub.
EditTeamUrl	String	True		The absolute HTTP URL to access the editing page for this team.
MembersResourcePath	String	True		The relative HTTP path to the team’s members on GitHub.
NewTeamUrl	String	True		The absolute HTTP URL to create a new team within the organization.
RepositoriesResourcePath	String	True		The relative HTTP path to the team’s associated repositories.
TeamsResourcePath	String	True		The relative HTTP path to the sub-teams under this team, if any.
ViewerCanAdminister	Bool	True		Indicates whether the current viewer has administrative permissions for this team.
ViewerCanSubscribe	Bool	True		Indicates whether the viewer can change their subscription status for the team.
EditTeamResourcePath	String	True		The relative HTTP path to the page for editing this team on GitHub.
NewTeamResourcePath	String	True		The relative HTTP path to the page for creating a new team within the organization.
CreatedAt	Datetime	True		The date and time when the team object was created, in ISO 8601 format.
UpdatedAt	Datetime	True		The date and time when the team object was last updated, in ISO 8601 format.
ReviewRequestDelegationAlgorithm	String	True		Specifies the algorithm used for assigning code reviews to team members (for example, round-robin).
ReviewRequestDelegationEnabled	Bool	True		Indicates whether automatic review assignment is enabled for this team.
ReviewRequestDelegationMemberCount	Int	True		The number of team members required to be assigned for review requests when delegation is enabled.
ReviewRequestDelegationNotifyTeam	Bool	True		Indicates whether the entire team should be notified when review requests are assigned via delegation.
LdapMapped	Bool	True		Indicates whether the team is mapped to an LDAP Group (Enterprise feature only).
Role	String	True		Filters teams based on whether the viewer is an 'admin' or a 'member' of the team, if applicable. The allowed values are ADMIN, MEMBER.
RootTeamsOnly	Bool	True		Restricts results to only root-level teams if set to true, excluding sub-teams.
UserLogins	String	False	OrganizationMembers.Login	A comma-separated list of user logins to filter by when querying team data or assigning users as team maintainers during team creation.

Pseudo-Columns

Pseudo-columns are fields that can be used in WHERE clauses to filter data, but do not contain data themselves.


Name	Type	Description
RepositoryNamesWithOwner	String	A comma-separated list of fully qualified repository names (for example, 'organization-name/repository-name') to add the team to.

SSIS Components for GitHub