Objects Supported
| Name | Description |
|---|---|
| AdvancedSettings | Query the application properties that are accessible on the Advanced Settings page. |
| ApplicationRoles | Query all application roles. In Jira, application roles are managed using the Application access configuration page. |
| Attachments | Query, insert and delete the available Attachments in Jira. |
| Audit | Query the audit log of your Jira account. |
| BoardConfiguration | Query the agile Board Configuration in Jira. |
| BoardIssues | Query the agile Board Issues in Jira. |
| Boards | Query, insert and delete the agile Boards in Jira. |
| BoardSprints | Query the agile Sprints related to a Jira Board. |
| Comments | Create, modify, delete and query the available Comment types in Jira. |
| Configuration | Query the available Configurations in Jira. |
| Dashboards | Query the available Dashboards in Jira. |
| Epics | Query all the Epics. |
| FavouriteFilters | Query the favourite Filters in Jira. |
| Fields | Query the available System and Custom Fields in Jira. |
| Filters | Query the set up Filters in Jira. This table is not available in Jira Server. |
| FiltersUsers | Query the users that filters are shared with. |
| Groups | Query the available Groups in Jira. |
| GroupsUsers | Query the users available in Jira and their associated groups. |
| IssueAffectedVersions | Query the Affected Versions of an issue in Jira. |
| IssueChangelogs | Query the available IssueChangelogs in Jira. |
| IssueComponents | Query the available IssueComponents in Jira. |
| IssueCustomFieldOptions | Query Issue Custom Field Options in Jira. This resource is not available in Jira Server or when using OAuth authentication. Specifying at least CUSTOMFIELDID, or ID is required. |
| IssueCustomFields | Query the available Custom Fields in Jira. |
| IssueFixVersions | Query the available IssueFixVersions in Jira. |
| IssueLinks | Query the available IssueLinks in Jira. |
| IssueLinkTypes | Lists all the issue link types. |
| IssueNavigatorDefaultColumns | Query the default issue navigator columns. |
| IssuePriorities | Query the list of all issue priorities. |
| IssueResolutions | Query the list of all issue resolution values. |
| Issues | Create, modify, delete and query Issues in Jira. |
| IssueSecurityLevelMembers | Query the members of issue security level entities. |
| IssueSubtasks | Query the available IssueSubtasks in Jira. |
| IssueTransitions | Query the available IssueTransitions in Jira. |
| IssueTypes | Query the available Issue Types in Jira. |
| MyPermissions | Query the available Permissions of the current user in Jira. |
| PermissionGrants | Query the available permission grants for a permission scheme in Jira. |
| Permissions | Query the available Permissions in Jira. |
| PermissionSchemes | Query the available permission schemes in Jira. |
| ProjectCategories | Query all the project categories. |
| ProjectComponents | Query, create, modify, and delete the available Components of a project in Jira. |
| ProjectRoleActors | Query the actors who act in a role for specific projects in Jira. |
| ProjectRoles | Query roles for all projects in Jira. |
| Projects | Query, update, insert and delete the available Projects in Jira. |
| ProjectsIssueTypes | Query the available Issue Types of projects. |
| ProjectsPermissionScheme | Query the available permissions schemes for a project in Jira. |
| ProjectTypes | Query the list of all issue priorities. |
| ProjectVersions | Query,create, modify and delete the available Versions of a project in Jira. |
| RoleActors | Query the default actors for project roles in Jira. |
| Roles | Query the available roles in Jira. |
| SecurityLevels | Query all the created security levels. |
| SecuritySchemes | Query all the created security schemes. |
| SprintIssues | Query the agile Sprint Issues in Jira. |
| Sprints | Query,create, modify and delete the agile Sprints in Jira. |
| Statuses | Query the possible Statuses in Jira. |
| TimeTrackingProviders | Query the list of all time tracking providers. |
| Users | Query the available Users in Jira. |
| Votes | Query the available Votes in Jira. |
| Watchers | Query the available Watchers in Jira. |
| Workflows | Query the available Workflows in Jira. |
| WorkflowSchemes | Create, modify, delete and query the available workflow schemes in Jira. |
| WorkflowStatusCategories | Query the list of all status categories. |
| WorkflowStatuses | Query the list of all statuses associated with workflows. |
| WorklogDeleted | Queries the deleted worklogs in your Jira account. |
| Worklogs | Create, modify, delete and query the available Worklogs in Jira. |
AdvancedSettings
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The ID of the application property. | |
| Name | String | False | No | The name of the application property. | |
| Description | String | False | No | The description of the application property. | |
| Type | String | False | No | The data type of the application property. | |
| Value | String | False | No | The new value. | |
| DefaultValue | String | False | No | The default value of the application property. | |
| AllowedValues | String | False | No | The allowed values, if applicable. |
ApplicationRoles
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Key [KEY] | String | False | No | The key of the application role. | |
| Name | String | False | No | The display name of the application role. | |
| Groups | String | False | No | The groups associated with the application role. | |
| DefaultGroups | String | False | No | The groups that are granted default access for this application role. | |
| SelectedByDefault | Boolean | False | No | Determines whether this application role should be selected by default on user creation. | |
| NumberOfSeats | Integer | False | No | The maximum count of users on your license. | |
| RemainingSeats | Integer | False | No | The count of users remaining on your license. | |
| UserCount | Integer | False | No | The number of users counting against your license. | |
| UserCountDescription | String | False | No | The type of users being counted against your license. | |
| HasUnlimitedSeats | Boolean | False | No | Determines whether this application role has unlimited seats. | |
| Platform | Boolean | False | No | Indicates if the application role belongs to Jira platform (jira-core). |
Attachments
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The Id of the attachment. | |
| IssueId [KEY] | Integer | False | Issues.Id | No | The Id of the issue. |
| IssueKey | String | False | Issues.Key | No | The key of the issue. |
| ProjectId | Integer | True | Projects.Id | No | The project Id of the attachment's issue. |
| ProjectName | String | True | No | The project name of the attachment's issue. | |
| IssueCreatedDate | Datetime | False | No | The date the attachment's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the attachment's issue was last updated. | |
| Filename | String | False | No | The filename of the attachment. | |
| AuthorName | String | False | No | The name of the author of the attachment. | |
| AuthorDisplayName | String | False | Users.DisplayName | No | The display name of the author of the attachment. |
| Created | Datetime | False | No | The creation date of the attachment. | |
| Size | Integer | False | No | The size of the attachment. | |
| MimeType | String | False | No | The MIME type of the attachment. | |
| Content | String | False | No | The URI of the actual attached file. | |
| Thumbnail | String | False | No | The thumbnail of the attachment. | |
| AuthorAccountId | String | False | Users.AccountId | No | The account Id of the author of the attachment. |
| AuthorKey | String | False | No | The author key of the attachment. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. | |
| FilePath | String | False | Yes | The path of the file to insert. | |
| ContentEncoded | String | False | Yes | BASE64 encoded content of the file to insert. | |
| Name | String | False | Yes | The name of the file to upload. Also the file extension should be specified. |
Audit
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| RecordId | Integer | False | No | The Id of the audit record. | |
| Summary | String | False | No | Summary of the change. | |
| RemoteAddress | String | False | No | The remote address of the record. | |
| AuthorKey | String | False | No | Key of the author that made the change. | |
| Created | Datetime | False | No | Date on when the change was made. | |
| Category | String | False | No | Category of the change. | |
| EventSource | String | False | No | What triggered the event. | |
| Description | String | False | No | Description of the change. | |
| ItemId | String | False | No | Unique identifier of the object item. | |
| ItemName | String | False | No | Name of the object item. | |
| ItemTypeName | String | False | No | Typename of the object item. | |
| ItemParentId | String | False | No | Identifier of the parent of the object item. | |
| ItemParentName | String | False | No | Parent name of the object item. | |
| FieldName | String | False | No | The name of the changed field. | |
| ChangedFrom | String | False | No | The updated value. | |
| ChangedTo | String | False | No | The previous value. | |
| Filter | String | False | Yes | Containing a string in at least one field. For example, providing up will return all audit records where one or more fields contains words such as update. |
BoardConfiguration
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| BoardId [KEY] | Integer | False | Boards.Id | No | The Id of the board. |
| ColumnConfig | String | False | No | The column configuration lists the columns for the board, in the order defined in the column configuration. For each column, it shows the issue status mapping as well as the constraint type (Valid values: none, issueCount, issueCountExclSubs) for the min/max number of issues. | |
| Filter | String | False | No | Reference to the filter used by the given board. | |
| Name | String | False | No | The Name of the board. | |
| CustomFieldIdRank | Integer | False | No | The CustomFieldId ranking. | |
| Self | String | False | No | The self/url column. | |
| SubQuery | String | False | No | JQL subquery used by the given board. | |
| Type | String | False | No | The type of the board. | |
| EstimationDisplayName | String | False | No | Display name of the field used for estimation. | |
| EstimationFieldId | String | False | No | The Id of the field used for estimation. | |
| EstimationType | String | False | No | Contains information about type of estimation used for the board. Valid values: none, issueCount, field. If the estimation type is |
BoardIssues
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | Issues.Id | No | The Id of the issue. |
| Key | String | False | Issues.Key | No | The key of the issue. |
| BoardId [KEY] | Integer | False | Boards.Id | No | The board the issue is included in. |
| IssueTypeId | String | False | Issuetypes.Id | No | The issue type Id. |
| IssueTypeName | String | False | No | The issue type name. | |
| StatusId | Integer | False | Statuses.Id | No | The issue status Id. |
| StatusName | String | False | No | The issue status name. | |
| ProjectId | Integer | False | Projects.Id | No | The project Id of the issue. |
| ProjectKey | String | False | Projects.Key | No | The project key of the issue. |
| ProjectName | String | False | No | The project name of the issue. | |
| ClosedSprintsAggregate | String | False | No | The issue's previous sprints that have been closed. | |
| Created | Datetime | False | No | The creation date of the issue. | |
| Updated | Datetime | False | No | The updated date of the issue. |
Boards
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | True | No | The Id of the board. | |
| Name | String | False | No | The name of the board. | |
| Type | String | False | No | The type of the board. | |
| ProjectKeyOrId | String | False | Yes | Filter the agile boards based on the project they are located in. | |
| FilterId | String | False | Yes | ID of a filter that the user has permissions to view. Not supported for next-gen boards. |
BoardSprints
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The Id of the sprint. | |
| BoardId [KEY] | Integer | False | Boards.Id | No | The board Id the sprint is in. |
| Name | String | False | No | The name of the sprint. | |
| State | String | False | No | The state of the sprint. The sprint state can only transition from 'future' to 'active', and from 'active' to 'close' | |
| Goal | String | False | No | The goal assigned for the sprint. | |
| OriginBoardId | Integer | False | Boards.Id | No | The board Id the sprint originated from. This field cannot be updated |
| StartDate | Datetime | False | No | The date when the sprint was started. | |
| EndDate | Datetime | False | No | The date when the sprint has ended. | |
| CompleteDate | Datetime | True | No | The date when the sprint was completed. |
Comments
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | True | No | The Id of the comment. | |
| IssueId [KEY] | Integer | False | Issues.Id | No | The Id of the issue. |
| IssueKey | String | False | Issues.Key | No | The key of the issue. |
| ProjectId | Integer | True | Projects.Id | No | The project Id of the comment's issue. |
| ProjectName | String | True | No | The project name of the comment's issue. | |
| IssueCreatedDate | Datetime | True | No | The date the comment's issue was created. | |
| IssueUpdatedDate | Datetime | True | No | The date the comment's issue was last updated. | |
| AuthorDisplayName | String | True | Users.DisplayName | No | The display name of the author who made the comment. |
| AuthorEmail | String | True | Users.EmailAddress | No | The email address of the author who made the comment. |
| UpdateDisplayName | String | True | Users.DisplayName | No | The display name of the author who changed the comment. |
| UpdateAuthorEmail | String | True | Users.EmailAddress | No | The email address of the author who edited the comment. |
| Body | String | False | No | The body of the comment. | |
| RenderedBody | String | True | No | The rendered body of the comment. | |
| Created | Datetime | True | No | The date the comment was created. | |
| Updated | Datetime | True | No | The date the comment was updated. | |
| VisibilityType | String | False | No | The visibility type of the comment. | |
| VisibilityValue | String | False | No | The visibility value of the comment. | |
| AuthorAccountName | String | True | No | The name of the author who made the comment. | |
| AuthorAccountKey | String | True | No | The key of the author who made the comment. | |
| UpdateAuthorAccountKey | String | True | No | The Id of the author who edited the comment. | |
| UpdateAuthorAccountName | String | True | No | The name of the author who edited the comment. | |
| AuthorAccountId | String | True | Users.AccountId | No | The name of the author who made the comment. |
| UpdateAuthorAccountId | String | True | Users.AccountId | No | The Id of the author who edited the comment. |
| ItemURL | String | True | No | A browsable link of the comment. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
Configuration
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| VotingEnabled | Boolean | False | No | Configuration for voting. | |
| WatchingEnabled | Boolean | False | No | Configuration for watching. | |
| UnassignedIssuesAllowed | Boolean | False | No | Configuration to allow unassigned issues. | |
| SubTasksEnabled | Boolean | False | No | Configuration to enable subtasks. | |
| IssueLinkingEnabled | Boolean | False | No | Configuration to enable issue linking. | |
| TimeTrackingEnabled | Boolean | False | No | Configuration to enable time tracking. | |
| AttachmentsEnabled | Boolean | False | No | Configuration to enable attachments. | |
| WorkingHoursPerDay | Double | False | No | Configuration of the working hours per day. | |
| WorkingDaysPerWeek | Double | False | No | Configuration of the working days per week. | |
| TimeFormat | String | False | No | Configuration of the time format. | |
| DefaultUnit | String | False | No | Configuration of the default unit. |
Dashboards
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the dashboard. | |
| Name | String | False | No | The name of the dashboard | |
| View | String | False | No | The view URL of the dashboard. | |
| Filter | String | False | Yes | This is used to filter data. Valid values include favourite and my. |
Epics
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The Id of the Epic. | |
| Key [KEY] | String | False | No | The key of the Epic. | |
| BoardId [KEY] | Integer | False | Boards.Id | No | The board Id the Epic is in. |
| Name | String | False | No | The name of the Epic. | |
| Done | Boolean | False | No | Whether or not the Epic is done. | |
| ColorKey | String | False | No | The key of the Epic's color. | |
| Summary | String | False | No | A brief summary for the Epic. |
FavouriteFilters
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The Id of the favourite filter. | |
| Name | String | False | No | The name assigned to the favourite filter. | |
| JQLExpression | String | False | No | The JQL by which the favourite filter will search issues by. | |
| Description | String | False | No | The description given to the favourite filter. | |
| OwnerDisplayName | String | False | No | The display name of the user who owns the favourite filter. | |
| OwnerAccountId | String | False | No | The account ID of the user who owns the favourite filter. | |
| Count | Integer | False | No | How many users have this filter as a favourite. | |
| OwnerKey | String | False | No | The key of the user who owns the favourite filter. |
Fields
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the field. | |
| Key | String | False | No | The key of the field. | |
| Name | String | False | No | The name of the field. | |
| Custom | Boolean | False | No | A boolean indicating if the field is custom. | |
| Orderable | Boolean | False | No | A boolean indicating if the field is orderable. | |
| Navigable | Boolean | False | No | A boolean indicating if the field is navigable. | |
| Searchable | Boolean | False | No | A boolean indicating if the field is searchable. |
Filters
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The Id of the filter. | |
| Name | String | False | No | The name assigned to the filter. | |
| JQLExpression | String | False | No | The JQL by which the filter will search issues by. | |
| Description | String | False | No | The description given to the filter. | |
| OwnerDisplayName | String | False | No | The board Id the sprint originated from. | |
| Favourite | Boolean | False | No | Whether you have set this filter as a favourite. | |
| FavouritedCount | Integer | False | No | How many users have this filter as a favourite. | |
| SubscriptionsAggregate | String | False | No | Collection of user subscriptions to the filter . | |
| SharePermissionsAggregate | String | False | No | Aggregate of share permissions to the filter. |
FiltersUsers
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AccountId [KEY] | String | False | No | The accountId of the user, which uniquely identifies the user across all Atlassian products. | |
| FilterId [KEY] | String | False | Filters.Id | No | The key of the project. |
| DisplayName | String | False | No | The display name of the user. | |
| EmailAddress | String | False | No | The email address of the user. | |
| Active | Bool | False | No | Indicates whether the user is active. | |
| TimeZone | String | False | No | The time zone specified in the user's profile. | |
| Locale | String | False | No | The locale of the user. | |
| AccountType | String | False | No | The accountType of the user. |
Groups
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the group. | |
| Name | String | False | No | The name of the group. | |
| Html | String | False | No | The HTML of the group. | |
| LabelsAggregate | String | False | No | The labels of the group. |
GroupsUsers
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AccountId [KEY] | String | False | No | The accountId of the user, which uniquely identifies the user across all Atlassian products. | |
| Key [KEY] | String | False | No | The key of the user. | |
| GroupId [KEY] | String | False | No | The group Id the user is part of. | |
| GroupName [KEY] | String | False | No | The group name the user is part of. | |
| Name | String | False | No | The name of the user. | |
| DisplayName | String | False | No | The display name of the user. | |
| EmailAddress | String | False | No | The email address of the user. | |
| Active | Bool | False | No | Indicates whether the user is active. | |
| TimeZone | String | False | No | The time zone specified in the user's profile. | |
| Locale | String | False | No | The locale of the user. | |
| AccountType | String | False | No | The accountType of the user. | |
| Products | String | False | No | A delimited string of jira products to which the user has access to, ex: jira-core,jira-servicedesk,jira-product-discovery,jira-software |
IssueAffectedVersions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| VersionId [KEY] | String | False | No | The Id of the affected version. | |
| IssueId [KEY] | Integer | False | Issues.Id | No | The issue Id of the affected version. |
| IssueKey | String | False | Issues.Key | No | The issue key of the affected version. |
| IssueCreatedDate | Datetime | False | No | The date the affected version's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the affected version's issue was last updated. | |
| Name | String | False | No | The name of the affected version. | |
| Archived | Boolean | False | No | A boolean indicating if the affected is archived. | |
| Released | Boolean | False | No | A boolean indicating if the affected is released. | |
| ReleaseDate | Date | False | No | The release date. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
IssueChangelogs
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| HistoryId | Integer | False | No | The Id of the change. | |
| IssueId | Integer | False | Issues.Id | No | The Id of the issue. |
| IssueKey | String | False | Issues.Key | No | The key of the issue. |
| Created | Datetime | False | No | The creation date of the change. | |
| IssueCreatedDate | Datetime | False | No | The date the change's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the change's issue was last updated. | |
| ItemField | String | False | No | The item field of the change. | |
| ItemFieldType | String | False | No | The item field type of the change. | |
| ItemFrom | String | False | No | The item the issue changed from. | |
| ItemFromString | String | False | No | The description of the item the issue changed from. | |
| ItemTo | String | False | No | The item the issue changed to. | |
| ItemToString | String | False | No | The description of the item the issue changed to. | |
| AuthorDisplayName | String | False | No | The display name of the author who has updated the change. | |
| AuthorAccountId | String | False | No | The author name of the change. | |
| AuthorName | String | False | No | The author name of the change. | |
| AuthorAccountKey | String | False | No | The key of the author of the change. | |
| AuthorAccountName | String | False | No | The name of the author who has updated the change. | |
| ProjectId | Integer | False | Projects.Id | No | The project Id of the issue. |
| ProjectKey | String | False | Projects.Key | No | The project key of the issue. |
| ProjectName | String | False | No | The project name of the issue. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
IssueComponents
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the component. | |
| Name | String | False | No | The name of the component. | |
| IssueId [KEY] | Integer | False | Issues.Id | No | The issue Id of the component. |
| IssueKey | String | False | Issues.Key | No | The issue key of the component. |
| IssueCreatedDate | Datetime | False | No | The date the component's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the component's issue was last updated. | |
| Description | String | False | No | The description of the component. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
IssueCustomFieldOptions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Long | False | No | The ID of the custom field option. | |
| CustomFieldId | Long | False | IssueCustomFields.CustomId | No | The ID of the custom field. |
| Name | String | False | No | The name of the custom field option. |
IssueCustomFields
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the custom field. | |
| Key | String | False | No | The key of the custom field. | |
| CustomId | Long | False | No | The custom ID of the field. | |
| Name | String | False | No | The name of the custom field. | |
| CDataName | String | False | No | The name of the custom field on the Issues table provided by CData, when IncludeCustomFields=true | |
| Orderable | Boolean | False | No | A boolean indicating if the field is orderable. | |
| Navigable | Boolean | False | No | A boolean indicating if the field is navigable. | |
| Searchable | Boolean | False | No | A boolean indicating if the field is searchable. |
IssueFixVersions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| VersionId [KEY] | String | False | No | The Id of the fix version. | |
| IssueId [KEY] | Integer | False | Issues.Id | No | The issue Id of the fix version. |
| IssueKey | String | False | Issues.Key | No | The issue key of the fix version. |
| IssueCreatedDate | Datetime | False | No | The date the fix version's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the fix version's issue was last updated. | |
| Name | String | False | No | The name of the fix version. | |
| Archived | Boolean | False | No | A boolean indicating if the fix is archived. | |
| Released | Boolean | False | No | A boolean indicating if the fix is released. | |
| ReleaseDate | Datetime | False | No | The release date. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
IssueLinks
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the link. | |
| InwardIssueId | Integer | False | Issues.Id | No | The Id of the issue targeting this issue in the link. |
| InwardIssueKey | String | False | Issues.Key | No | The Key of the issue targeting this issue in the link. |
| OutWardIssueId | Integer | False | Issues.Id | No | The Id of the issue this link is targeting. |
| OutwardIssueKey | String | False | Issues.Key | No | The Key of the issue this link is targeting. |
| IssueId [KEY] | Integer | False | Issues.Id | No | The link's original issue Id. |
| IssueKey | String | False | Issues.Key | No | The link's original issue Key. |
| IssueCreatedDate | Datetime | False | No | The date the link's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the links's issue was last updated. | |
| TypeId | Id | False | No | The Id of the link type. | |
| TypeName | String | False | No | The Name of the link type. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
IssueLinkTypes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | Unique identifier of the issue link type. | |
| Name | String | False | No | The name of the issue link type. | |
| Inward | String | False | No | The description of the issue link type inward link. | |
| Outward | String | False | No | The description of the issue link type outward link. |
IssueNavigatorDefaultColumns
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Label | String | False | No | The issue navigator column label. | |
| Value | String | False | No | The issue navigator column value. |
IssuePriorities
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The ID of the issue priority. | |
| Name | String | False | No | The name of the issue priority. | |
| Description | String | False | No | The description of the issue priority. | |
| URL | String | False | No | The URL of the issue priority. | |
| StatusColor | String | False | No | The color used to indicate the issue priority. | |
| IconUrl | String | False | No | The URL of the icon for the issue priority. |
IssueResolutions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The ID of the issue resolution. | |
| Name | String | False | No | The name of the issue resolution. | |
| Description | String | False | No | The description of the issue resolution. | |
| URL | String | False | No | The URL of the issue resolution. |
Issues
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | True | No | The Id of the issue. | |
| Key | String | True | No | The key of the issue. | |
| IssueTypeId | String | False | No | The issue type Id. | |
| IssueTypeName | String | True | No | The issue type name. | |
| ProjectId | String | False | No | The project Id of the issue. | |
| ProjectName | String | True | No | The project name of the issue. | |
| ProjectKey | String | False | No | The project key of the issue. | |
| ParentId | Int | False | No | The Id of the issue's parent if the issue is a subtask. | |
| ParentKey | String | True | No | The key of the issue's parent if the issue is a subtask. | |
| ParentIssueTypeId | String | True | No | The issue type id of the issue's parent. | |
| ParentIssueTypeName | String | True | No | The issue type name of the issue's parent. | |
| ParentStatusId | String | True | No | The status id of the issue's parent. | |
| ParentStatusName | String | True | No | The status name of the issue's parent. | |
| ResolutionId | String | True | No | The resolution Id of the issue. | |
| ResolutionName | String | True | No | The resolution name of the issue. | |
| ResolutionDescription | String | True | No | The resolution description of the issue. | |
| ResolutionDate | Datetime | True | No | The resolution date of the issue. | |
| Workratio | Long | True | No | The work ratio of the issue. | |
| LastViewed | Datetime | True | No | The last time that the issue was viewed. | |
| WatchCount | Int | True | No | The number of watches of the issue. | |
| IsWatching | Bool | True | No | Whether the currently authenticated user is watching the issue. | |
| Created | Datetime | True | No | The creation date of the issue. | |
| PriorityId | String | False | No | The priority Id of the issue. | |
| PriorityName | String | True | No | The priority name of the issue. | |
| TimeSpentSeconds | Long | True | No | The time spent in seconds on the issue. | |
| TimeSpent | String | True | No | The time spent on the issue. | |
| RemainingEstimateSeconds | Long | True | No | The time estimate in seconds of the issue. | |
| RemainingEstimate | String | False | No | The time estimate of the issue. | |
| OriginalEstimateSeconds | Long | True | No | The original time estimate in seconds of the issue. | |
| OriginalEstimate | String | False | No | The original time estimate of the issue. | |
| AggregateTimeSpent | Long | True | No | The aggregate time spent of the issue. | |
| AggregateTimeOriginalEstimate | Long | True | No | The original aggregate time estimate of the issue. | |
| AggregateTimeEstimate | Long | True | No | The aggregate time estimate of the issue. | |
| AssigneeDisplayName | String | True | No | Assignee display name. | |
| AssigneeKey | String | True | No | [DEPRECATED] The assignee key of the issue. | |
| AssigneeAccountId | String | False | No | The assignee account id. | |
| AssigneeName | String | False | No | The assignee name of the issue. | |
| AssigneeEmail | String | True | No | The assignee email of the issue. | |
| Updated | Datetime | True | No | The updated date of the issue. | |
| StatusId | String | True | No | The status Id of the issue. | |
| StatusName | String | True | No | The status name of the issue. | |
| StatusCategoryId | String | True | No | The status category id of the issue. | |
| StatusCategoryKey | String | True | No | The status category key of the issue. | |
| StatusCategoryName | String | True | No | The status category name of the issue. | |
| Description | String | False | No | The description of the issue. | |
| Summary | String | False | No | The summary of the issue. | |
| CreatorDisplayName | String | True | No | Issue creator display name. | |
| CreatorName | String | True | No | The creator name of the issue. | |
| CreatorAccountId | String | True | No | The creator account id. | |
| CreatorKey | String | True | No | [DEPRECATED] The creator key of the issue. | |
| CreatorEmail | String | True | No | The creator email of the issue. | |
| ReporterDisplayName | String | True | No | Issue reporter display name. | |
| ReporterName | String | False | No | The reporter name of the issue. | |
| ReporterKey | String | True | No | [DEPRECATED]The reporter key of the issue. | |
| ReporterAccountId | String | False | No | The reporter account id. | |
| ReporterEmail | String | True | No | The reporter email of the issue. | |
| AggregateProgress | Long | True | No | The aggregate progress of the issue. | |
| TotalProgress | Long | True | No | The aggregate total progress of the issue. | |
| Votes | Int | True | No | Votes of the issue. | |
| HasVotes | Bool | True | No | The vote status of the issue. | |
| DueDate | Date | False | No | The due date of the issue. | |
| Labels | String | False | No | The labels of an issue. | |
| Environment | String | False | No | The environment of an issue. | |
| SecurityLevel | String | False | No | The security level of an issue. | |
| FixVersionsAggregate | String | False | No | The fix versions of the issue | |
| ComponentsAggregate | String | False | No | Aggregate list of components included in the issue. | |
| IssueLinksAggregate | String | False | No | The issue links of the issue. | |
| AffectedVersionsAggregate | String | False | No | The affected versions of the issue. | |
| SubtasksAggregate | String | True | No | The subtasks of the issue. | |
| ItemURL | String | True | No | A browsable link of the issue. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. | |
| Attachments | String | False | Yes | Search for issues that have or do not have attachments. This column can be queried with IS EMPTY or IS NOT EMPTY. | |
| Comment | String | False | Yes | Search for issues that have a comment that contains particular text. | |
| Category | String | False | Yes | Search for issues that belong to projects in a particular category. | |
| SprintId | Integer | False | Yes | Search for issues that belongs to a specific sprint, by specifying the Id of the Sprint. | |
| SprintName | String | False | Yes | Search for issues that belongs to a specific sprint, by specifying the name of the Sprint. | |
| Filter | String | False | Yes | Search for issues of saved filters. This column can be queried with filter name or filter id. |
IssueSecurityLevelMembers
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The ID of the issue security level member. | |
| IssueSecurityLevelId | String | False | No | The ID of the issue security level. | |
| IssueSecuritySchemeId | String | False | No | The ID of the issue security scheme. | |
| HolderParameter | String | False | No | As a group's name can change, use of value is recommended. The identifier associated with the type value that defines the holder of the permission. | |
| HolderType | String | False | No | The type of the permission holder. | |
| HolderValue | String | False | No | The identifier associated with the type value that defines the holder of the permission. |
IssueSubtasks
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| SubtaskId [KEY] | String | False | No | The Id of the subtask. | |
| SubtaskKey | String | False | No | The key of the subtask. | |
| IssueId | Integer | False | Issues.Id | No | The Id of the parent issue. |
| IssueKey | String | False | Issues.Key | No | The key of the parent issue. |
| IssueCreatedDate | Datetime | False | No | The date the subtask's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the subtask's issue was last updated. | |
| Summary | String | False | No | The summary of the subtask. | |
| TypeId | String | False | IssueTypes.Id | No | The issue type Id of the subtask. |
| TypeName | String | False | IssueTypes.Name | No | The issue type name of the subtask. |
| TypeDescription | String | False | IssueTypes.Description | No | The issue type description of the subtask. |
| TypeSubtask | Boolean | False | IssueTypes.Subtask | No | A boolean indicating if the issue is a subtask. |
| PriorityId | String | False | No | The priority Id of the subtask. | |
| PriorityName | String | False | No | The priority name of the subtask. | |
| StatusId | String | False | No | The status Id of the subtask. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
IssueTransitions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the transition. | |
| IssueId [KEY] | Integer | False | Issues.Id | No | The Id of the issue. |
| IssueKey | String | False | Issues.Key | No | The key of the issue. |
| IssueCreatedDate | Datetime | False | No | The date the transition's issue was created. | |
| IssueUpdatedDate | Datetime | False | No | The date the transition's issue was last updated. | |
| HasScreen | String | False | No | Whether the transition has a screen. | |
| Name | String | False | No | The name of the transition. | |
| ToDescription | String | False | No | The description of the status the issue is transitioning to. | |
| ToId | String | False | No | The Id of the status the issue is transitioning to. | |
| ToName | String | False | No | The name of the status the issue is transitioning to. | |
| StatusCategoryId | String | False | No | The status category Id of the transition. | |
| StatusCategoryKey | String | False | No | The status category key of the transition. | |
| StatusCategoryName | String | False | No | The status category name of the transition. | |
| JQL | String | False | Yes | JQL (Jira Query Language) allows you to build structured queries. |
IssueTypes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id of the issue type. | |
| Name | String | False | No | The name of the issue type. | |
| Description | String | False | No | The description of the issue type. | |
| Subtask | Boolean | False | No | The subtask of the issue type. Not applicable for update. | |
| IconUrl | String | True | No | The icon URL of the issue type. |
MyPermissions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The Id of the permission. | |
| Key [KEY] | String | False | No | The key of the permission. | |
| Name | String | False | No | The name of the permission. | |
| Type | String | False | No | The type of the permission. | |
| Description | String | False | No | The description of the permission. | |
| HavePermission | Boolean | False | No | Boolean indicating if the permission is set or not. | |
| DeprecatedKey | Boolean | False | No | Boolean indicating if the permission is deprecated. | |
| Permissions | String | False | No | Permissions as comma seperated values. | |
| ProjectKey | String | False | Yes | The key of the project associated with the permission. | |
| ProjectId | String | False | Yes | The Id of the project associated with the permission. | |
| IssueKey | String | False | Yes | The key of the issue associated with the permission. | |
| IssueId | String | False | Yes | The Id of the issue associated with the permission. |
PermissionGrants
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| PermissionSchemeId [KEY] | String | False | PermissionSchemes.Id | No | The ID of the permission scheme. |
| Id [KEY] | String | False | No | The ID of the permission granted details. | |
| Permission | String | False | No | The permission to grant. | |
| HolderParameter | String | False | No | As a group's name can change, use of value is recommended. The identifier associated with the type value that defines the holder of the permission. | |
| HolderType | String | False | No | The type of the permission holder. | |
| HolderValue | String | False | No | The identifier associated with the type value that defines the holder of the permission. |
Permissions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Key [KEY] | String | False | No | The key of the permission. | |
| Name | String | False | No | The name of the permission. | |
| Type | String | False | No | The type of the permission. | |
| Description | String | False | No | The description of the permission. |
PermissionSchemes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | False | No | The ID of the permission scheme. | |
| Name | String | False | No | The name of the permission scheme. | |
| Description | String | False | No | A description for the permission scheme. | |
| ScopeType | String | False | No | The type of the scope. | |
| ScopeProjectId | String | False | No | The id of the project the item has scope in. |
ProjectCategories
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | Unique identifier of the project category. | |
| Name | String | False | No | Name of the project category. | |
| Description | String | False | No | Description of the project category. | |
| Link | String | False | No | Link to this project category. |
ProjectComponents
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | True | No | The Id of the component. | |
| ProjectId | Integer | True | Projects.Id | No | The selected project's id. |
| ProjectKey | String | False | No | The selected project's key. | |
| Name | String | False | No | The name of the component. | |
| Description | String | False | No | The description of the component. | |
| LeadDisplayName | String | True | No | The display name of the component's lead. | |
| LeadKey | String | False | No | The key of the component's lead. | |
| AssigneeType | String | False | No | The type of the component's default assignee. | |
| AssigneeDisplayName | String | True | No | The display name of the component's default assignee. | |
| AssigneeKey | String | True | No | The key of the component's default assignee. | |
| IsAssigneeTypeValid | Boolean | True | No | Whether the assignee type is valid. |
ProjectRoleActors
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Long | False | No | The ID of the role actor. | |
| DisplayName | String | False | No | The display name of the role actor. For users, depending on the user?s privacy setting, this may return an alternative value for the user's name. | |
| Type | String | False | No | The type of role actor. | |
| Name | String | False | No | The name of the role. | |
| AvatarUrl | String | False | No | The avatar of the role actor. | |
| ActorUserAccountId | String | False | No | Details of the user associated with the role. The account ID of the user, which uniquely identifies the user across all Atlassian products. | |
| ActorGroupName | String | False | No | Details of the group associated with the role. The name of the group. As a group's name can change, use of groupId is recommended to identify the group. | |
| ActorGroupDisplayName | String | False | No | Details of the group associated with the role. The display name of the group. | |
| ActorGroupGroupId | String | False | No | Details of the group associated with the role. The ID of the group. | |
| RoleId | Long | False | Roles.Id | No | The Id of the role. |
| ProjectId | Integer | False | Projects.Id | No | The Id of the project associated with the role. |
| ProjectKey | String | False | Projects.Key | No | The key of the project associated with the role. |
| UserName | String | False | Yes | Server platform only. Input for Insert and Delete statements. Details of the user associated with the role. The name of the user. | |
| GroupName | String | False | Yes | Server platform only. Input for Insert and Delete statements. Details of the group associated with the role. The name of the group. |
ProjectRoles
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| RoleId [KEY] | Long | False | Roles.Id | No | The Id of the role. |
| RoleName | String | False | Roles.Name | No | The name of the role. |
| ProjectId [KEY] | Integer | False | Projects.Id | No | The Id of the project associated with the role. |
| ProjectKey [KEY] | String | False | Projects.Key | No | The key of the project associated with the role. |
Projects
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | True | No | The Id of the project. | |
| Key | String | False | No | The key of the project. | |
| Name | String | False | No | The name of the project. | |
| Description | String | False | No | The description of the project. | |
| LeadEmailAddress | String | True | Users.EmailAddress | No | The email address of the project lead. |
| LeadDisplayName | String | True | Users.DisplayName | No | The display name of the project lead. |
| ComponentsAggregate | String | True | No | The components of the project. | |
| IssueTypesAggregate | String | True | No | The issue types of the project. | |
| Url | String | True | No | The URL of the project. | |
| String | True | No | The email of the project. | ||
| AssigneeType | String | False | No | The assignee type of the project. | |
| VersionsAggregate | String | True | No | The versions of the project. | |
| RolesAggregate | String | True | No | The roles of the project. | |
| ProjectKeysAggregate | String | True | No | The project keys of the project. | |
| ProjectCategoryId | String | False | No | The Id of the project category. | |
| ProjectCategoryName | String | True | No | The name of the project category. | |
| ProjectCategoryDescription | String | True | No | The description of the project category. | |
| ProjectTypeKey | String | False | No | The key of the project type. Not applicable for update. | |
| LeadAccountId | String | False | Users.AccountId | No | The Id of the project lead. |
| LeadAccountKey | String | True | Users.Key | No | The Key of the project lead. |
| LeadAccountName | String | False | Users.Name | No | The user name of the project lead. |
| Simplified | Boolean | True | No | Whether the project is team-managed or not. | |
| ItemURL | String | True | No | A browsable link of the project. |
ProjectsIssueTypes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id of the issue type. | |
| ProjectId [KEY] | Int | False | Projects.Id | No | The Id of the project. |
| ProjectName | String | False | Projects.Name | No | The name of the project |
| Name | String | False | No | The name of the issue type. | |
| Description | String | False | No | The description of the issue type. | |
| Subtask | Boolean | False | No | The subtask of the issue type. Not applicable for update. | |
| IconUrl | String | False | No | The icon URL of the issue type. | |
| AvatarId | String | False | No | The id of the avatar |
ProjectsPermissionScheme
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ProjectId | Int64 | False | No | The project ID. | |
| ProjectKey | String | False | No | The project key. | |
| Id | String | False | No | The ID of the permission scheme. | |
| Name | String | False | No | The name of the permission scheme. | |
| Description | String | False | No | The description of the permission scheme. |
ProjectTypes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Key [KEY] | String | False | No | The key of the project type. | |
| DescriptionKey | String | False | No | The key of the project type's description. | |
| Icon | String | False | No | The icon of the project type. | |
| Color | String | False | No | The color of the project type. |
ProjectVersions
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | True | No | The Id of the version. | |
| ProjectId | Integer | False | Projects.Id | No | The selected project's id. |
| ProjectKey | String | False | No | The selected project's key. | |
| Name | String | False | No | The name of the version. | |
| Description | String | False | No | The description of the version. | |
| Released | Boolean | False | No | Whether the version has been released. | |
| ReleaseDate | Date | False | No | Release date of the version. | |
| StartDate | Date | False | No | Optional start date of the version. | |
| UserStartDate | Date | False | No | The date on which work on this version is expected to start. | |
| UserReleaseDate | Date | False | No | The date on which work on this version is expected to finish. | |
| Overdue | Boolean | True | No | Whether the version is overdue for release. | |
| Archived | Boolean | False | No | Whether the version has been archived. When a new version is created, this field is always set to False. |
RoleActors
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Long | False | No | The ID of the role actor. | |
| DisplayName | String | False | No | The display name of the role actor. For users, depending on the user?s privacy setting, this may return an alternative value for the user's name. | |
| Type | String | False | No | The type of role actor. | |
| AvatarUrl | String | False | No | The avatar of the role actor. | |
| ActorUserAccountId | String | False | Users.AccountId | No | Details of the user associated with the role. The account ID of the user, which uniquely identifies the user across all Atlassian products. |
| ActorGroupName | String | False | Groups.Name | No | Details of the group associated with the role. The name of the group. As a group's name can change, use of groupId is recommended to identify the group. |
| ActorGroupDisplayName | String | False | No | Details of the group associated with the role. The display name of the group. | |
| ActorGroupGroupId | String | False | Groups.Id | No | Details of the group associated with the role. The ID of the group. |
| Name | String | False | No | The name of the role. | |
| RoleId | Long | False | Roles.Id | No | The Id of the role. |
| UserKey | String | False | Yes | Server platform only. Input for Insert and Delete statements. Details of the user associated with the role. The key of the user. | |
| GroupName | String | False | Yes | Server platform only. Input for Insert and Delete statements. Details of the group associated with the role. The name of the group. |
Roles
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Long | False | No | The Id of the role. | |
| Name | String | False | No | The name of the role. | |
| Description | String | False | No | The description of the role. | |
| Actors | String | False | No | The list of users who act in this role. | |
| Scope | String | False | No | The scope of the role. | |
| IsAdmin | Boolean | False | No | Whether this role is the admin role for the project. | |
| IsDefault | Boolean | False | No | Whether this role is the default role for the project. |
SecurityLevels
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The ID of the issue level security item. | |
| SecuritySchemeId | Long | False | SecuritySchemes.Id | No | Link to this security level. |
| Name | String | False | No | The name of the issue level security item. | |
| Description | String | False | No | The description of the issue level security item. |
SecuritySchemes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Long | False | No | The ID of the issue security scheme. | |
| Name | String | False | No | The name of the issue security scheme. | |
| Description | String | False | No | The description of the issue security scheme. | |
| DefaultSecurityLevelId | Long | False | No | The ID of the default security level. |
SprintIssues
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | Issues.Id | No | The Id of the issue. |
| Key | String | False | Issues.Key | No | The key of the issue. |
| SprintId [KEY] | Integer | False | Sprints.Id | No | The sprint the issue is assigned to. |
| IssueTypeId | String | False | Issuetypes.Id | No | The issue type Id. |
| IssueTypeName | String | False | No | The issue type name. | |
| StatusId | Integer | False | Statuses.Id | No | The issue status Id. |
| StatusName | String | False | No | The issue status name. | |
| ProjectId | Integer | False | Projects.Id | No | The project Id of the issue. |
| ProjectKey | String | False | Projects.Key | No | The project key of the issue. |
| ProjectName | String | False | No | The project name of the issue. | |
| ClosedSprintsAggregate | String | False | No | The issue's previous sprints that have been closed. | |
| Created | Datetime | False | No | The creation date of the issue. | |
| Updated | Datetime | False | No | The updated date of the issue. |
Sprints
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | True | No | The Id of the sprint. | |
| Name | String | False | No | The name of the sprint. | |
| State | String | False | No | The state of the sprint. A newly created sprint starts in the 'future' state. The state can only transition from 'future' to 'active', and from 'active' to 'closed' | |
| Goal | String | False | No | The goal assigned for the sprint. | |
| OriginBoardId | Integer | False | Boards.Id | No | The board Id the sprint originated from. This field cannot be updated |
| StartDate | Datetime | False | No | The date when the sprint was started. | |
| EndDate | Datetime | False | No | The date when the sprint has ended. | |
| CompleteDate | Datetime | True | No | The date when the sprint was completed. |
Statuses
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | False | No | The Id of the status. | |
| Name | String | False | No | The name of the status. | |
| Description | String | False | No | The description of the status. | |
| CategoryId | Integer | False | No | The Category Id of the status. | |
| CategoryKey | String | False | No | The Category Key of the status. |
TimeTrackingProviders
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Key [KEY] | String | False | No | The key for the time tracking provider. For example, Jira. | |
| Name | String | False | No | The name of the time tracking provider. For example, Jira provided time tracking. | |
| URL | String | False | No | The URL of the configuration page for the time tracking provider app. For example, /example/config/url. This property is only returned if the adminPageKey property is set in the module descriptor of the time tracking provider app. |
Users
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| GroupName | String | True | No | The name of the group the user is part of. | |
| GroupId | String | True | No | The Id of the group the user is part of. | |
| DisplayName | String | False | No | The display name of the user. | |
| EmailAddress | String | False | No | The email address of the user. | |
| Active | Bool | True | No | Indicates whether the user is active. | |
| TimeZone | String | True | No | The time zone specified in the user's profile. | |
| Locale | String | True | No | The locale of the user. | |
| AccountId [KEY] | String | True | No | The accountId of the user, which uniquely identifies the user across all Atlassian products. | |
| AccountType | String | False | No | The accountType of the user. | |
| Products | String | False | No | A delimited string of jira products to which the user has access to, ex: jira-core,jira-servicedesk,jira-product-discovery,jira-software | |
| Key [KEY] | String | True | No | The key of the user. | |
| Name | String | False | No | The name of the user. | |
| IssueKey | String | False | Yes | Search for users who can browse a specific issue. | |
| ProjectKey | String | False | Yes | Search for users who can browse any issue in a project. |
Votes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| DisplayName | String | False | No | The display name of the vote. | |
| Active | Boolean | False | No | Boolean indicating if the vote is active. | |
| AccountId | String | False | No | The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5. | |
| IssueId | String | False | No | The issue Id of the vote. | |
| IssueKey | String | False | No | The issue key of the vote. |
Watchers
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| DisplayName | String | False | No | The displayed name of the watcher. | |
| EmailAddress | String | False | No | The email address of the watcher. | |
| AccountId [KEY] | String | False | No | The accountId of the watcher. | |
| Key [KEY] | String | False | No | The key of the watcher. | |
| Name | String | False | No | The name of the watcher. | |
| IssueId | String | False | No | The issue Id of the watcher. | |
| IssueKey | String | False | No | The issue key of the watcher. |
Workflows
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | False | No | The entity ID of the workflow. | |
| Name | String | False | No | The name of the workflow. | |
| Description | String | False | No | The description of the workflow. | |
| Created | String | False | No | The date when the workflow was created. | |
| Updated | String | False | No | The date when the workflow was updated. | |
| IsDefault | Boolean | False | No | Boolean indicating if the workflow is set as the default. | |
| CanDelete | Boolean | False | No | Boolean indicating whether the workflow can be deleted. | |
| CanEdit | Boolean | False | No | Boolean indicating whether the workflow can be edited. | |
| IsActive | Boolean | False | No | Filters active and inactive workflows. | |
| Query | String | False | No | String used to perform a case-insensitive partial match with workflow name. | |
| Scope | String | False | No | A JSON aggregate outlining the scope of the workflow. This column used exclusively for inserting to and updating workflows (does not return in SELECT query results). | |
| Statuses | String | False | No | A JSON aggregate outlining the statuses to associate with the workflows. This column used exclusively for inserting to and updating workflows (does not return in SELECT query results). | |
| Workflows | String | False | No | The details of the workflows to create. This column used exclusively for inserting to and updating workflows (does not return in SELECT query results). |
WorkflowSchemes
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Integer | True | No | The ID of the workflow scheme. | |
| Name | String | False | No | The name of the workflow scheme. | |
| Description | String | False | No | The description of the workflow scheme. | |
| IssueTypeMappingsAggregate | String | False | No | The issue type to workflow mappings aggregate, where each mapping is an issue type ID and workflow name pair. | |
| DefaultWorkflow | String | False | No | The name of the default workflow for the workflow scheme. | |
| Self | String | True | No | The self/url column. |
WorkflowStatusCategories
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Long | False | No | The ID of the status category. | |
| Key | String | False | No | The key of the status category. | |
| Name | String | False | No | The name of the status category. | |
| ColorName | String | False | No | The name of the color used to represent the status category. | |
| URL | String | False | No | The URL of the status category. |
WorkflowStatuses
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The ID of the status. | |
| StatusCategoryId | Long | False | WorkflowStatusCategories.Id | No | The ID of the status category. |
| Name | String | False | No | The name of the status. | |
| Description | String | False | No | The description of the status. | |
| URL | String | False | No | The description of the status. | |
| IconUrl | String | False | No | The URL of the icon used to represent the status. |
WorklogDeleted
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | False | No | The Id of the audit record. | |
| Updated | Datetime | False | No | The date on when the change was made. | |
| Properties | String | False | No | The properties of the deleted Worklog. |
Worklogs
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id of the worklog. | |
| IssueId [KEY] | Integer | False | Issues.Id | No | The issue Id of the worklog. |
| IssueKey | String | False | Issues.Key | No | The key of the issue. |
| ProjectId | Integer | True | Projects.Id | No | The project Id of the worklog's issue. |
| ProjectName | String | True | No | The project name of the worklog's issue. | |
| IssueCreatedDate | Datetime | True | No | The date the worklogs's issue was created. | |
| IssueUpdatedDate | Datetime | True | No | The date the worklogs's issue was last updated. | |
| AuthorDisplayName | String | True | Users.DisplayName | No | The display name of the author of the worklog. |
| UpdateAuthorDisplayName | String | True | Users.DisplayName | No | The display name of the author who has updated the worklog. |
| Comment | String | False | No | The comment of the worklog. | |
| Created | Datetime | True | No | The date the worklog was created. | |
| Updated | Datetime | True | No | The update date of the worklog. | |
| VisibilityType | String | False | No | The visibility type of the worklog. | |
| VisibilityValue | String | False | No | The visibility value of the worklog. | |
| Started | Datetime | False | No | The start date of the worklog. | |
| TimeSpent | String | False | No | The spent time of the worklog. | |
| TimeSpentSeconds | Long | False | No | The time spent in seconds for the worklog. | |
| AuthorAccountId | String | True | Users.AccountId | No | The name of the author of the worklog. |
| UpdateAuthorAccountId | String | True | Users.AccountId | No | The name of the author who has updated the worklog. |
| AuthorAccountKey | String | True | Users.Key | No | The key of the author of the worklog. |
| AuthorAccountName | String | True | Users.Name | No | The name of the author of the worklog. |
| UpdateAuthorAccountKey | String | True | Users.Key | No | The key of the author who has updated the worklog. |
| UpdateAuthorAccountName | String | True | Users.Name | No | The name of the author who has updated the worklog. |
| ItemURL | String | True | No | A browsable link of the worklog. |