Branches
Contains detailed information about branches in a repository, including branch names and their relationships with other branches for version control.
Table-Specific Information
Select
The connector uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- Name supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [Branches]
SELECT * FROM [Branches] WHERE [Name] = 'Val1'
The connector processes other filters client-side within the connector.
Insert
You can use the following columns to create (insert) a new record:
- Name
- TargetOid
You can use the following pseudo-column to create a new record: Force
INSERT INTO [Branches] ([Name], [TargetOid]) VALUES ('TestBranch', '6330b82300aa01f5f92cf7ac22e79ef261a5457a')
Update
You can use the following column to update a record: TargetOid
You can use the following pseudo-column to update a record: Force
UPDATE [Branches] SET [TargetOid] = '2fa01729273842c19b4ee9594f4f32007e4aea31', [Force] = 'true' WHERE [Id] = 'REF_kwDOOq2woLVyZWZzL2hlYWRzL1Rlc3RCcmFuY2g'
Delete
You can specify the following column to delete a record: Id
DELETE FROM [Branches] WHERE [Id] = 'REF_kwDOOq2woLRyZWZzL2hlYWRzL0RldkJyYW5jaA'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier for the branch within the repository. | |
| Name | String | False |
The name of the branch, typically representing a feature, fix, or release. | |
| Prefix | String | True |
The standard prefix used for branch refs. | |
| TargetId | String | True |
The ID of the object the ref points to. | |
| TargetOid | String | False |
The Git object ID of the object the ref points to. |
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 |
| Force | Bool |
Permit updates of branch refs that are not fast-forwards. |