Items
Contains all details related to project items, including metadata and any associated fields.
View-Specific Information
Select
The add-in processes all filters client-side within the add-in. The following query is the only one processed server-side:
SELECT * FROM [Items]
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | A unique identifier for the item. | ||
| FullDatabaseId | Long | The primary key of the item in the database, stored as a BigInt. | ||
| UpdatedAt | Datetime | The date and time when the item or its details were last updated. | ||
| CreatedAt | Datetime | The date and time when the item was created. | ||
| IsArchived | Bool | Indicates whether the item is archived and no longer active. | ||
| Type | String | The type or category of the item, such as 'Issue' or 'Pull Request'. | ||
| DraftIssueId | String | The unique identifier for the draft issue associated with this item. | ||
| DraftIssueTitle | String | The title of the draft issue. | ||
| DraftIssueBody | String | The full content of the draft issue's body written in Markdown. | ||
| DraftIssueBodyText | String | The content of the draft issue's body rendered as plain text. | ||
| DraftIssueBodyHTML | String | The content of the draft issue's body rendered as HTML for display purposes. | ||
| DraftIssueUpdatedAt | Datetime | The date and time when the draft issue was last updated. | ||
| DraftIssueCreatedAt | Datetime | The date and time when the draft issue was created. | ||
| IssueId | String | A unique identifier for the issue associated with this item. | ||
| IssueFullDatabaseId | Long | The primary key of the issue in the database, stored as a BigInt. | ||
| IssueTitle | String | The title of the issue, summarizing its purpose or content. | ||
| IssueTitleHTML | String | The title of the issue rendered in HTML for display purposes. | ||
| IssueAuthor | String | The username of the user who authored the issue. | ||
| IssueAuthorAssociation | String | The author's relationship with the repository, such as 'CONTRIBUTOR' or 'OWNER'. | ||
| IssueEditor | String | The username of the user who last edited the issue. | ||
| IssueBody | String | The full content of the issue's body written in Markdown. | ||
| IssueBodyText | String | The content of the issue's body rendered as plain text. | ||
| IssueBodyHTML | String | The content of the issue's body rendered as HTML for display purposes. | ||
| IssueBodyResourcePath | String | The relative HTTP path to access the body of the issue. | ||
| IssueBodyUrl | String | The full HTTP URL to access the body of the issue. | ||
| IssueNumber | Int | The unique number assigned to the issue within its repository. | ||
| IssueState | String | The current state of the issue, such as 'OPEN' or 'CLOSED'.
The allowed values are open, closed. | ||
| IssueStateReason | String | The reason provided for the current state of the issue, such as 'COMPLETED' or 'NOT_PLANNED'. | ||
| IssueLocked | Bool | Indicates whether the issue is locked to prevent further changes or comments. | ||
| IssueActiveLockReason | String | The reason why the issue was locked, such as 'OFF_TOPIC' or 'RESOLVED'. | ||
| IssueClosed | Bool | Indicates whether the issue is closed. The definition of 'closed' may depend on the type of the issue. | ||
| IssueIsPinned | Bool | Indicates whether the issue is currently pinned to the top of the repository's issues list. | ||
| IssueIncludesCreatedEdit | Bool | Indicates whether the comment was edited and includes the original creation data. | ||
| IssueCreatedViaEmail | Bool | Indicates whether the comment was created via an email reply. | ||
| IssueResourcePath | String | The relative HTTP path to access this issue on GitHub. | ||
| IssueUrl | String | The full HTTP URL to access this issue on GitHub. | ||
| IssueLastEditedAt | Datetime | The date and time when the issue was last edited by an editor. | ||
| IssuePublishedAt | Datetime | The date and time when the issue or its associated comment was published. | ||
| IssueClosedAt | Datetime | The date and time when the issue was closed. | ||
| IssueUpdatedAt | Datetime | The date and time when the issue or its details were last updated. | ||
| IssueCreatedAt | Datetime | The date and time when the issue was created. | ||
| IssueMilestoneId | String | The unique identifier for the milestone associated with this issue. | ||
| IssueMilestoneTitle | String | The title of the milestone associated with this issue. | ||
| IssueMilestoneNumber | Int | The number assigned to the milestone associated with this issue. | ||
| IssueIsReadByViewer | Bool | Indicates whether the issue has been marked as read by the viewer. | ||
| IssueViewerDidAuthor | Bool | Indicates whether the viewer is the author of this comment or issue. | ||
| IssueViewerSubscription | String | The viewer's subscription status for this issue, such as 'WATCHING', 'NOT_WATCHING', or 'IGNORING'. | ||
| IssueViewerCanLabel | Bool | Indicates whether the viewer has permission to edit or add labels to this issue. | ||
| IssueViewerCanClose | Bool | Indicates whether the viewer can close this issue. | ||
| IssueViewerCanReopen | Bool | Indicates whether the viewer can reopen this issue after it has been closed. | ||
| IssueViewerCanDelete | Bool | Indicates whether the viewer can delete this issue or its associated content. | ||
| IssueViewerCanReact | Bool | Indicates whether the viewer can react to this issue or its comments using emojis. | ||
| IssueViewerCanSubscribe | Bool | Indicates whether the viewer can change their subscription status for this issue. | ||
| IssueViewerThreadSubscriptionStatus | String | The viewer's current thread subscription status for the issue. | ||
| IssueViewerThreadSubscriptionFormAction | String | The form action URL for updating the viewer's thread subscription status for the issue. | ||
| IssueViewerCanUpdate | Bool | Indicates whether the viewer can update this issue or its associated content. | ||
| IssueViewerCannotUpdateReasons | String | The reasons why the viewer is unable to update this issue or its content. | ||
| IssueCommentCount | Int | The total number of comments on this issue. | ||
| IssueReactionCount | Int | The total number of emoji reactions on this issue. | ||
| PullRequestId | String | The unique identifier for the pull request associated with this item. | ||
| PullRequestFullDatabaseId | Long | The primary key of the pull request in the database, stored as a BigInt. | ||
| PullRequestAuthor | String | The login name of the user who authored the pull request. | ||
| PullRequestAuthorAssociation | String | The author's relationship with the repository, such as 'CONTRIBUTOR' or 'MEMBER'. | ||
| PullRequestEditor | String | The login name of the user who last edited the body of the pull request. | ||
| PullRequestHeadRepositoryId | String | The unique identifier of the repository associated with the head branch of this pull request. | ||
| PullRequestHeadRepositoryOwner | String | The login name of the owner of the repository associated with the head branch of this pull request. | ||
| PullRequestMergedBy | String | The login name of the user who merged this pull request. | ||
| PullRequestBaseRefId | String | The unique identifier of the base branch associated with this pull request, even if the branch has been deleted. | ||
| PullRequestBaseRefOid | String | The Git Object ID (OID) of the base branch associated with this pull request, even if the branch has been deleted. | ||
| PullRequestBaseRefPrefix | String | The prefix of the base branch's reference path (for example, 'refs/heads/'). | ||
| PullRequestBaseRefName | String | The name of the base branch associated with this pull request, even if the branch has been deleted. | ||
| PullRequestHeadRefId | String | The unique identifier of the head branch associated with this pull request, even if the branch has been deleted. | ||
| PullRequestHeadRefOid | String | The Git Object ID (OID) of the head branch associated with this pull request, even if the branch has been deleted. | ||
| PullRequestHeadRefPrefix | String | The prefix of the head branch's reference path (for example, 'refs/heads/'). | ||
| PullRequestHeadRefName | String | The name of the head branch associated with this pull request, even if the branch has been deleted. | ||
| PullRequestTitle | String | The title of the pull request, summarizing its purpose or changes. | ||
| PullRequestTitleHTML | String | The title of the pull request rendered as HTML for web display. | ||
| PullRequestBody | String | The body content of the pull request, written in Markdown. | ||
| PullRequestBodyText | String | The body content of the pull request rendered as plain text. | ||
| PullRequestBodyHTML | String | The body content of the pull request rendered as HTML for web display. | ||
| PullRequestState | String | The current state of the pull request, such as 'OPEN', 'CLOSED', or 'MERGED'.
The allowed values are OPEN, CLOSED, MERGED. | ||
| PullRequestNumber | Int | The unique number assigned to this pull request within its repository. | ||
| PullRequestMergeable | String | Indicates whether the pull request is mergeable, considering the presence or absence of merge conflicts. | ||
| PullRequestMerged | Bool | Indicates whether the pull request has been successfully merged. | ||
| PullRequestClosed | Bool | Indicates whether the pull request is closed without being merged. | ||
| PullRequestChangedFiles | Int | The total number of files changed in this pull request. | ||
| PullRequestAdditions | Int | The total number of lines added in this pull request. | ||
| PullRequestDeletions | Int | The total number of lines removed in this pull request. | ||
| PullRequestTotalCommentsCount | Int | The total number of comments, including review comments, made on this pull request. | ||
| PullRequestReviewDecision | String | The current review decision on the pull request, such as 'APPROVED', 'CHANGES_REQUESTED', or 'REVIEW_REQUIRED'. | ||
| PullRequestLocked | Bool | Indicates whether the pull request is locked to prevent further activity. | ||
| PullRequestActiveLockReason | String | The reason provided for locking the pull request conversation, such as 'RESOLVED' or 'OFF_TOPIC'. | ||
| PullRequestIsDraft | Bool | Indicates whether the pull request is a draft and not yet ready for review or merging. | ||
| PullRequestIsCrossRepository | Bool | Indicates whether the pull request's head and base branches are in different repositories. | ||
| PullRequestMaintainerCanModify | Bool | Indicates whether repository maintainers are allowed to make changes to the pull request's branch. | ||
| PullRequestCreatedViaEmail | Bool | Indicates whether this comment on the pull request was created via an email reply. | ||
| PullRequestIncludesCreatedEdit | Bool | Indicates whether this comment on the pull request was edited and includes data from the original creation. | ||
| PullRequestMergeCommitId | String | The unique commit ID generated when this pull request was successfully merged. | ||
| PullRequestPotentialMergeCommitId | String | The unique commit ID automatically generated by GitHub to test the mergeability of this pull request. This value is unavailable if the pull request is already merged or the test merge commit is still being generated. | ||
| PullRequestPermalink | String | The permanent URL that links directly to this pull request. | ||
| PullRequestResourcePath | String | The relative HTTP path for accessing this pull request on GitHub. | ||
| PullRequestChecksResourcePath | String | The relative HTTP path for accessing the checks and statuses associated with this pull request. | ||
| PullRequestRevertResourcePath | String | The relative HTTP path for initiating a revert of this pull request. | ||
| PullRequestUrl | String | The full HTTP URL for accessing this pull request on GitHub. | ||
| PullRequestChecksUrl | String | The full HTTP URL for accessing the checks and statuses associated with this pull request. | ||
| PullRequestRevertUrl | String | The full HTTP URL for initiating a revert of this pull request. | ||
| PullRequestLastEditedAt | Datetime | The date and time when this pull request was last edited by an editor. | ||
| PullRequestMergedAt | Datetime | The date and time when this pull request was successfully merged. | ||
| PullRequestClosedAt | Datetime | The date and time when this pull request was closed. | ||
| PullRequestPublishedAt | Datetime | The date and time when this pull request or its associated comment was published. | ||
| PullRequestUpdatedAt | Datetime | The date and time when this pull request or its details were last updated. | ||
| PullRequestCreatedAt | Datetime | The date and time when this pull request was created. | ||
| PullRequestMilestoneId | String | The unique identifier for the milestone associated with this pull request. | ||
| PullRequestMilestoneTitle | String | The title of the milestone associated with this pull request. | ||
| PullRequestMilestoneNumber | Int | The number assigned to the milestone associated with this pull request. | ||
| PullRequestAutoMergeRequestCommitHeadline | String | The title of the commit created as part of the auto-merge request. This value is set by the merge queue if required by the base branch. | ||
| PullRequestAutoMergeRequestAuthorEmail | String | The email address of the author who initiated the auto-merge request. | ||
| PullRequestAutoMergeRequestCommitBody | String | The commit message created as part of the auto-merge request. This value is set by the merge queue if required by the base branch. | ||
| PullRequestAutoMergeRequestEnabledAt | Datetime | The date and time when the auto-merge request for this pull request was enabled. | ||
| PullRequestAutoMergeRequestMergeMethod | String | The merge method (for example, 'MERGE', 'SQUASH', 'REBASE') used for the auto-merge request. This value is set by the merge queue if required by the base branch. | ||
| PullRequestViewerDidAuthor | Bool | Indicates whether the viewer authored this comment or pull request. | ||
| PullRequestIsReadByViewer | Bool | Indicates whether this pull request has been marked as read by the viewer. | ||
| PullRequestViewerSubscription | String | Indicates the viewer's subscription status for this pull request, such as 'WATCHING', 'NOT_WATCHING', or 'IGNORING'. | ||
| PullRequestViewerCanLabel | Bool | Indicates whether the viewer has permission to edit or add labels to this pull request. | ||
| PullRequestViewerCanClose | Bool | Indicates whether the viewer has permission to close this pull request. | ||
| PullRequestViewerCanReact | Bool | Indicates whether the viewer can react to this pull request or its comments using emojis. | ||
| PullRequestViewerCanReopen | Bool | Indicates whether the viewer has permission to reopen this pull request after it has been closed. | ||
| PullRequestViewerCanSubscribe | Bool | Indicates whether the viewer can change their subscription status for the repository associated with this pull request. | ||
| PullRequestViewerCanApplySuggestion | Bool | Indicates whether the viewer can apply suggested changes to this pull request. | ||
| PullRequestViewerCanEditFiles | Bool | Indicates whether the viewer has permission to edit files within this pull request. | ||
| PullRequestViewerCanDeleteHeadRef | Bool | Indicates whether the viewer can restore a deleted head reference associated with this pull request. | ||
| PullRequestViewerCanDisableAutoMerge | Bool | Indicates whether the viewer can disable the auto-merge feature for this pull request. | ||
| PullRequestViewerCanEnableAutoMerge | Bool | Indicates whether the viewer can enable the auto-merge feature for this pull request. | ||
| PullRequestViewerCanMergeAsAdmin | Bool | Indicates whether the viewer, as an administrator, can bypass branch protection rules and merge the pull request immediately. | ||
| PullRequestViewerCanUpdate | Bool | Indicates whether the viewer has permission to update this pull request or its associated data. | ||
| PullRequestViewerCanUpdateBranch | Bool | Indicates whether the viewer can update the head branch of this pull request by merging or rebasing the base branch. Returns false if the head branch is up to date or the viewer lacks permissions. | ||
| PullRequestViewerCannotUpdateReasons | String | Lists the reasons why the viewer cannot update this pull request or its associated data. | ||
| PullRequestViewerLatestReviewRequestId | String | The unique identifier of the viewer's most recent review request for this pull request. | ||
| PullRequestViewerLatestReviewId | String | The unique identifier of the viewer's most recent review on this pull request. | ||
| PullRequestIsMergeQueueEnabled | Bool | Indicates whether the base branch of this pull request has a merge queue enabled to manage merge operations. | ||
| PullRequestIsInMergeQueue | Bool | Indicates whether this pull request is currently in a merge queue awaiting processing. | ||
| PullRequestMergeQueueEntryId | String | A unique identifier for this pull request's entry in the merge queue. | ||
| PullRequestMergeQueueEntryJump | Bool | Indicates whether this pull request has been prioritized to jump ahead in the merge queue. | ||
| PullRequestMergeQueueEntryPosition | Int | The position of this pull request's entry in the merge queue. | ||
| PullRequestMergeQueueEntrySolo | Bool | Indicates whether this pull request needs to be deployed or merged independently, without batching with others. | ||
| PullRequestMergeQueueEntryState | String | The current state of this pull request's entry in the merge queue, such as 'ENQUEUED', 'MERGING', or 'FAILED'. | ||
| PullRequestMergeQueueEntryEnqueuedAt | Datetime | The date and time when this pull request was added to the merge queue. | ||
| PullRequestMergeQueueEntryEstimatedTimeToMerge | Int | The estimated time in seconds until this pull request is expected to be merged from the queue. | ||
| PullRequestMergeQueueEntryBaseCommitId | String | The unique identifier of the base commit associated with this merge queue entry. | ||
| PullRequestMergeQueueEntryHeadCommitId | String | The unique identifier of the head commit associated with this merge queue entry. | ||
| PullRequestMergeQueueEntryMergeQueueId | String | The unique identifier of the merge queue containing this pull request entry. | ||
| PullRequestMergeQueueEntryMergeQueueUrl | String | The full HTTP URL for accessing the merge queue containing this pull request. | ||
| PullRequestMergeQueueEntryMergeQueueResourcePath | String | The relative HTTP path for accessing the merge queue containing this pull request. | ||
| PullRequestMergeQueueEntryMergeQueueNextEntryEstimatedTimeToMerge | Int | The estimated time in seconds until a newly added entry in the merge queue is expected to be merged. | ||
| PullRequestStatusCheckRollupId | String | The node ID of the StatusCheckRollup object aggregating status checks and runs for this pull request. | ||
| PullRequestStatusCheckRollupCommitId | String | The unique identifier of the commit to which the status checks and runs are attached. | ||
| PullRequestStatusCheckRollupState | String | The combined status of all checks and runs for the associated commit, such as 'SUCCESS', 'PENDING', or 'FAILURE'. | ||
| TitleId | String | A unique identifier for the title value associated with the item. | ||
| TitleDatabaseId | Int | The primary key of the title value in the database, used for internal reference. | ||
| TitleCreatorLogin | String | The username of the actor who created the item or title value. | ||
| TitleCreatedAt | Datetime | The date and time when the title value or item was created. | ||
| TitleUpdatedAt | Datetime | The date and time when the title value or item was last updated. | ||
| TitleText | String | The text value of the field representing the title. | ||
| StatusId | String | A unique identifier for the status value associated with the item. | ||
| StatusDatabaseId | Int | The primary key of the status value in the database, used for internal reference. | ||
| StatusCreatorLogin | String | The username of the actor who created the status value. | ||
| StatusCreatedAt | Datetime | The date and time when the status value was created. | ||
| StatusUpdatedAt | Datetime | The date and time when the status value was last updated. | ||
| StatusName | String | The name of the selected single-select option for the status. | ||
| StatusNameHTML | String | The HTML-formatted name of the selected single-select option for the status. | ||
| StatusDescription | String | A plain-text description explaining the meaning of the selected single-select option for the status. | ||
| StatusDescriptionHTML | String | The HTML-formatted description of the selected single-select option for the status. | ||
| StatusColor | String | The color code associated with the selected single-select option for the status. | ||
| StatusOptionId | String | The unique identifier for the selected single-select option for the status. | ||
| MilestoneId | String | A unique identifier for the milestone associated with the item. | ||
| MilestoneTitle | String | The title of the milestone, summarizing its purpose or scope. | ||
| MilestoneClosed | Bool | Indicates whether the milestone is closed. The definition of 'closed' may depend on the context. | ||
| MilestoneProgressPercentage | Double | The progress percentage for this milestone, typically based on completed tasks or issues. | ||
| MilestoneDescription | String | The description of the milestone, providing additional context or details. | ||
| MilestoneNumber | Int | The unique number assigned to the milestone. | ||
| MilestoneState | String | The current state of the milestone, such as 'OPEN' or 'CLOSED'.
The allowed values are OPEN, CLOSED. | ||
| MilestoneResourcePath | String | The relative HTTP path for accessing the milestone on GitHub. | ||
| MilestoneUrl | String | The full HTTP URL for accessing the milestone on GitHub. | ||
| MilestoneViewerCanClose | Bool | Indicates whether the viewer has permission to close this milestone. | ||
| MilestoneViewerCanReopen | Bool | Indicates whether the viewer has permission to reopen this milestone after it has been closed. | ||
| MilestoneDueOn | Datetime | The due date of the milestone, if one is set. | ||
| MilestoneClosedAt | Datetime | The date and time when the milestone was closed. | ||
| MilestoneUpdatedAt | Datetime | The date and time when the milestone or its details were last updated. | ||
| MilestoneCreatedAt | Datetime | The date and time when the milestone was created. | ||
| RepositoryId | String | A unique identifier for the repository. | ||
| RepositoryDatabaseId | Int | The primary key of the repository in the database, used for internal reference. | ||
| RepositoryName | String | The name of the repository. | ||
| RepositoryNameWithOwner | String | The full name of the repository, including the owner's login (for example, 'owner/repository-name'). | ||
| RepositoryOwnerId | String | The unique identifier for the owner of the repository. | ||
| RepositoryOwnerLogin | String | The login name of the repository's owner, which could be a user or an organization. | ||
| RepositoryVisibility | String | The visibility level of the repository, such as 'PUBLIC', 'PRIVATE', or 'INTERNAL'. | ||
| RepositoryDiskUsage | Int | The size of the repository on disk, in kilobytes. | ||
| RepositoryForkCount | Int | The total number of forks of this repository in the entire network. | ||
| RepositoryStargazerCount | Int | The total number of users who have starred this repository. | ||
| RepositoryWatcherCount | Int | The total number of users watching this repository for updates. | ||
| RepositoryTopicCount | Int | The number of topics applied to the repository for categorization. | ||
| RepositoryTempCloneToken | String | A temporary authentication token that allows cloning this repository. | ||
| RepositoryWebCommitSignoffRequired | Bool | Indicates whether contributors are required to sign off on commits made via the web interface. | ||
| RepositoryUsesCustomOpenGraphImage | Bool | Indicates whether the repository uses a custom image for Open Graph representation instead of the owner's avatar. | ||
| RepositoryDescription | String | The textual description of the repository provided by the owner. | ||
| RepositoryDescriptionHTML | String | The HTML-rendered version of the repository's description. | ||
| RepositoryShortDescriptionHTML | String | A short, HTML-rendered description of the repository without any links. | ||
| RepositoryResourcePath | String | The relative HTTP path for accessing this repository on GitHub. | ||
| RepositoryProjectsResourcePath | String | The relative HTTP path for accessing the projects associated with this repository. | ||
| RepositoryUrl | String | The full HTTP URL for accessing this repository on GitHub. | ||
| RepositoryHomepageUrl | String | The URL for the repository's homepage, if provided. | ||
| RepositoryMirrorUrl | String | The original URL of the repository if it is a mirror. | ||
| RepositoryProjectsUrl | String | The full HTTP URL for accessing the projects associated with this repository. | ||
| RepositorySecurityPolicyUrl | String | The URL of the repository's security policy, if available. | ||
| RepositorySSHUrl | String | The SSH URL for cloning this repository. | ||
| RepositoryOpenGraphImageUrl | String | The URL of the image used to represent this repository in Open Graph data. | ||
| RepositoryMergeCommitTitle | String | Specifies how the default commit title is generated when merging a pull request. | ||
| RepositoryMergeCommitMessage | String | Specifies how the default commit message is generated when merging a pull request. | ||
| RepositorySquashMergeCommitTitle | String | Specifies how the default commit title is generated when squash-merging a pull request. | ||
| RepositorySquashMergeCommitMessage | String | Specifies how the default commit message is generated when squash-merging a pull request. | ||
| RepositoryDeleteBranchOnMerge | Bool | Indicates whether branches are automatically deleted after being merged in this repository. | ||
| RepositoryHasDiscussionsEnabled | Bool | Indicates whether the Discussions feature is enabled for this repository. | ||
| RepositoryHasIssuesEnabled | Bool | Indicates whether the Issues feature is enabled for this repository. | ||
| RepositoryHasProjectsEnabled | Bool | Indicates whether the Projects feature is enabled for this repository. | ||
| RepositoryHasWikiEnabled | Bool | Indicates whether the Wiki feature is enabled for this repository. | ||
| RepositoryHasVulnerabilityAlertsEnabled | Bool | Indicates whether vulnerability alerts are enabled for this repository. | ||
| RepositoryHasSponsorshipsEnabled | Bool | Indicates whether the repository displays a 'Sponsor' button for financial contributions. | ||
| RepositoryIsInOrganization | Bool | Indicates whether the repository is owned by an organization or is a private fork of an organization repository. | ||
| RepositoryIsBlankIssuesEnabled | Bool | Indicates whether creating blank issues is allowed in this repository. | ||
| RepositoryIsSecurityPolicyEnabled | Bool | Indicates whether this repository has a security policy configured. | ||
| RepositoryIsUserConfigurationRepository | Bool | Indicates whether this repository is designated as a user configuration repository. | ||
| RepositoryIsArchived | Bool | Indicates whether the repository is archived and unmaintained. | ||
| RepositoryIsDisabled | Bool | Indicates whether the repository is disabled. | ||
| RepositoryIsEmpty | Bool | Indicates whether the repository is empty and has no content. | ||
| RepositoryIsFork | Bool | Indicates whether the repository is a fork of another repository. | ||
| RepositoryIsLocked | Bool | Indicates whether the repository is locked, preventing modifications. | ||
| RepositoryIsMirror | Bool | Indicates whether the repository is a mirror of another repository. | ||
| RepositoryIsPrivate | Bool | Indicates whether the repository is private and not publicly accessible. | ||
| RepositoryIsTemplate | Bool | Indicates whether the repository is a template that can be used to generate new repositories. | ||
| RepositoryLockReason | String | The reason why the repository has been locked, such as 'MIGRATING' or 'BILLING'.
The allowed values are BILLING, MIGRATING, MOVING, RENAME. | ||
| RepositoryTemplateRepositoryId | String | The unique identifier of the template repository from which this repository was generated, if applicable. | ||
| RepositoryParentId | String | The unique identifier of the parent repository if this repository is a fork. | ||
| RepositoryForkingAllowed | Bool | Indicates whether forking is allowed for this repository. | ||
| RepositoryAutoMergeAllowed | Bool | Indicates whether Auto-merge can be enabled for pull requests in this repository. | ||
| RepositorySquashMergeAllowed | Bool | Indicates whether squash-merging is enabled for pull requests in this repository. | ||
| RepositoryRebaseMergeAllowed | Bool | Indicates whether rebase-merging is enabled for pull requests in this repository. | ||
| RepositoryMergeCommitAllowed | Bool | Indicates whether pull requests can be merged with a merge commit in this repository. | ||
| RepositoryAllowUpdateBranch | Bool | Indicates whether pull request head branches that are behind their base branches can be updated, even if not required to be up-to-date before merging. | ||
| RepositoryViewerPermission | String | The permission level of the authenticated user on the repository. Returns null if authenticated as a GitHub App.
The allowed values are ADMIN, MAINTAIN, READ, TRIAGE, WRITE. | ||
| RepositoryViewerSubscription | String | Indicates whether the viewer is watching, not watching, or ignoring updates from this repository.
The allowed values are IGNORED, SUBSCRIBED, UNSUBSCRIBED. | ||
| RepositoryViewerHasStarred | Bool | Indicates whether the currently authenticated viewer has starred this repository. | ||
| RepositoryViewerDefaultCommitEmail | String | The email address the viewer used for their last commit in this repository. | ||
| RepositoryViewerDefaultMergeMethod | String | The last merge method used by the viewer or the default merge method for the repository (for example, 'MERGE', 'SQUASH', 'REBASE'). | ||
| RepositoryViewerPossibleCommitEmails | String | A list of email addresses the viewer can use for commits in this repository. | ||
| RepositoryViewerCanAdminister | Bool | Indicates whether the viewer has administrative permissions on this repository. | ||
| RepositoryViewerCanSubscribe | Bool | Indicates whether the viewer can change their subscription status for this repository. | ||
| RepositoryViewerCanCreateProjects | Bool | Indicates whether the viewer has permission to create new projects for this repository. | ||
| RepositoryViewerCanUpdateTopics | Bool | Indicates whether the viewer can update the topics associated with this repository. | ||
| RepositoryCodeOfConductId | String | The unique identifier for the repository's Code of Conduct. | ||
| RepositoryCodeOfConductName | String | The formal name of the Code of Conduct associated with this repository. | ||
| RepositoryCodeOfConductBody | String | The full text of the repository's Code of Conduct. | ||
| RepositoryCodeOfConductKey | String | The unique key representing the repository's Code of Conduct. | ||
| RepositoryCodeOfConductUrl | String | The full HTTP URL for accessing the repository's Code of Conduct. | ||
| RepositoryCodeOfConductResourcePath | String | The relative HTTP path for accessing the repository's Code of Conduct. | ||
| RepositoryDefaultBranchRefId | String | The unique identifier for the default branch reference of the repository. | ||
| RepositoryDefaultBranchRefName | String | The name of the default branch of the repository (for example, 'main', 'master'). | ||
| RepositoryInteractionAbilityLimit | String | The current interaction restrictions enabled on this repository, such as limiting interactions to collaborators only. | ||
| RepositoryInteractionAbilityOrigin | String | The origin or reason for the currently active interaction restrictions on this repository. | ||
| RepositoryInteractionAbilityExpiresAt | Datetime | The expiration date and time for the currently active interaction restrictions on this repository. | ||
| RepositoryLatestReleaseId | String | The unique identifier for the latest release in this repository. | ||
| RepositoryLatestReleaseName | String | The title of the latest release in this repository. | ||
| RepositoryLicenseId | String | The unique identifier for the license associated with this repository. | ||
| RepositoryLicenseKey | String | The key representing the license associated with this repository (for example, 'MIT', 'GPL-3.0'). | ||
| RepositoryLanguageId | String | The unique identifier for the repository's primary programming language. | ||
| RepositoryLanguageName | String | The name of the repository's primary programming language. | ||
| RepositoryLanguageColor | String | The color associated with the repository's primary programming language, often used for visualizations. | ||
| RepositoryPushedAt | Datetime | The date and time when the repository was last pushed to. | ||
| RepositoryArchivedAt | Datetime | The date and time when the repository was archived. | ||
| RepositoryCreatedAt | Datetime | The date and time when the repository was created. | ||
| RepositoryUpdatedAt | Datetime | The date and time when the repository's details were last updated. | ||
| RepositoryPlanFeaturesCodeOwners | Bool | Indicates whether reviews can be automatically requested and enforced using a CODEOWNERS file in this repository. | ||
| RepositoryPlanFeaturesDraftPullRequests | Bool | Indicates whether pull requests can be created as drafts or converted to draft status. | ||
| RepositoryPlanFeaturesMaximumAssignees | Int | The maximum number of users that can be assigned to a single issue or pull request. | ||
| RepositoryPlanFeaturesMaximumManualReviewRequests | Int | The maximum number of manually requested reviews allowed on a pull request. | ||
| RepositoryPlanFeaturesTeamReviewRequests | Bool | Indicates whether teams can be requested to review pull requests. | ||
| CustomTextId | String | A unique identifier for the custom text field. | ||
| CustomTextDatabaseId | Int | The primary key of the custom text field in the database, used for internal reference. | ||
| CustomTextCreatorLogin | String | The username of the actor who created the custom text field. | ||
| CustomTextCreatedAt | Datetime | The date and time when the custom text field was created. | ||
| CustomTextUpdatedAt | Datetime | The date and time when the custom text field was last updated. | ||
| CustomTextText | String | The text value of the custom field. | ||
| CustomNumberId | String | A unique identifier for the custom number field. | ||
| CustomNumberDatabaseId | Int | The primary key of the custom number field in the database, used for internal reference. | ||
| CustomNumberCreatorLogin | String | The username of the actor who created the custom number field. | ||
| CustomNumberCreatedAt | Datetime | The date and time when the custom number field was created. | ||
| CustomNumberUpdatedAt | Datetime | The date and time when the custom number field was last updated. | ||
| CustomNumberNumber | Double | A numeric value represented as a floating-point number in the custom field. | ||
| CustomDateId | String | A unique identifier for the custom date field. | ||
| CustomDateDatabaseId | Int | The primary key of the custom date field in the database, used for internal reference. | ||
| CustomDateCreatorLogin | String | The username of the actor who created the custom date field. | ||
| CustomDateCreatedAt | Datetime | The date and time when the custom date field was created. | ||
| CustomDateUpdatedAt | Datetime | The date and time when the custom date field was last updated. | ||
| CustomDateDate | Date | The date value stored in the custom date field. | ||
| CustomSingleSelectId | String | A unique identifier for the custom single-select field. | ||
| CustomSingleSelectDatabaseId | Int | The primary key of the custom single-select field in the database, used for internal reference. | ||
| CustomSingleSelectCreatorLogin | String | The username of the actor who created the custom single-select field. | ||
| CustomSingleSelectCreatedAt | Datetime | The date and time when the custom single-select field was created. | ||
| CustomSingleSelectUpdatedAt | Datetime | The date and time when the custom single-select field was last updated. | ||
| CustomSingleSelectName | String | The name of the selected option in the custom single-select field. | ||
| CustomSingleSelectNameHTML | String | The HTML-rendered name of the selected option in the custom single-select field. | ||
| CustomSingleSelectDescription | String | A plain-text description explaining the meaning of the selected option in the custom single-select field. | ||
| CustomSingleSelectDescriptionHTML | String | The HTML-rendered description of the selected option in the custom single-select field. | ||
| CustomSingleSelectColor | String | The color associated with the selected option in the custom single-select field. | ||
| CustomSingleSelectOptionId | String | The unique identifier for the selected option in the custom single-select field. | ||
| CustomIterationId | String | A unique identifier for the custom iteration field. | ||
| CustomIterationDatabaseId | Int | The primary key of the custom iteration field in the database, used for internal reference. | ||
| CustomIterationCreatorLogin | String | The username of the actor who created the custom iteration field. | ||
| CustomIterationCreatedAt | Datetime | The date and time when the custom iteration field was created. | ||
| CustomIterationUpdatedAt | Datetime | The date and time when the custom iteration field was last updated. | ||
| CustomIterationTitle | String | The title of the custom iteration. | ||
| CustomIterationTitleHTML | String | The title of the custom iteration, rendered in HTML. | ||
| CustomIterationStartDate | Date | The start date for the custom iteration. | ||
| CustomIterationDuration | Int | The duration of the custom iteration, measured in days. | ||
| CustomIterationIterationId | String | The unique identifier for the iteration associated with the custom iteration field. |