Jira predefined reports
Predefined reports
The Jira data source in Data Integration includes predefined reports. Each report provides a short description of the data, a list of customizable fields (if any), and the schema mapping.
These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.
note
Jira does not have any source-level selections to filter each report in the river.
Project
The Project report returns all projects associated with the given connection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
id  | String | Dimension |
| avatarurls | Record | Dimension |
| entityid | String | Dimension |
| expand | String | Dimension |
| description | String | Dimension |
| isprivate | Boolean | Dimension |
| issuetypes | Record | Dimension |
| key | String | Dimension |
| lead | Record | Dimension |
| name | String | Dimension |
| projectcategory | Record | Dimension |
| projectkeys | String | Dimension |
| projecttypekey | String | Dimension |
| properties | Record | Dimension |
| self | String | Dimension |
| simplified | Boolean | Dimension |
| style | String | Dimension |
| url | String | Dimension |
| uuid | String | Dimension |
Project category
The Project Category report returns all information associated with each project category within the connection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| description | String | Dimension |
| name | String | Dimension |
| self | String | Dimension |
Project type
The Project Type report returns all information associated with each project type within the given connection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| key | String | Dimension |
| color | String | Dimension |
| descriptioni18nkey | String | Dimension |
| formattedkey | String | Dimension |
| icon | String | Dimension |
Project role
The Project Role report returns all information associated with each project role within the given connection. You can customize the report using the "Projects filter" to limit the output.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| admin | Boolean | Dimension |
| default | Boolean | Dimension |
| description | String | Dimension |
| name | String | Dimension |
| roleconfigurable | Boolean | Dimension |
| scope | Record | Dimension |
| self | String | Dimension |
| translatedname | String | Dimension |
Group
The Group report returns all groups associated with the given connection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| groupid | String | Dimension |
| html | String | Dimension |
| labels | Record | Dimension |
| name | String | Dimension |
User
The User report returns all users associated with the given connection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| accountid | String | Dimension |
| accounttype | String | Dimension |
| active | Boolean | Dimension |
| avatarurls | Record | Dimension |
| displayname | String | Dimension |
| emailaddress | String | Dimension |
| locale | String | Dimension |
| self | String | Dimension |
| timezone | String | Dimension |
Group users
The Group Users report returns a list of users who are members of the specified group and its subgroups. You can customize the report using the "Groups filter" to limit the output or choose to include inactive users.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| accountid | String | Dimension |
| group_name | String | Dimension |
| accounttype | String | Dimension |
| active | Boolean | Dimension |
| avatarurls | Record | Dimension |
| displayname | String | Dimension |
| emailaddress | String | Dimension |
| self | String | Dimension |
| timezone | String | Dimension |
Resolution
The Resolution report returns all resolutions associated with the given connection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| description | String | Dimension |
| name | String | Dimension |
| self | String | Dimension |
Issue fields
The Issue Fields report returns a list of all System and Custom fields.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| clausenames | String | Dimension |
| custom | Boolean | Dimension |
| key | String | Dimension |
| name | String | Dimension |
| navigable | Boolean | Dimension |
| orderable | Boolean | Dimension |
| schema | Record | Dimension |
| scope | Record | Dimension |
| searchable | Boolean | Dimension |
| untranslatedname | String | Dimension |
Issue
The Issue report returns a complete representation of issues for the connection. An issue consists of the issue key, a collection of fields, and a link to the workflow transition sub-resource.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| changelog_histories | Record | Dimension |
| changelog_startat | Integer | Metric |
| changelog_total | Integer | Metric |
| expand | String | Dimension |
| fields_aggregateprogress_progress | Integer | Metric |
| fields_aggregateprogress_total | Integer | Metric |
| fields_aggregatetimeestimate | String | Dimension |
| fields_aggregatetimeoriginalestimate | String | Dimension |
| fields_aggregatetimespent | String | Dimension |
| fields_assignee | String | Dimension |
| fields_assignee_accountid | String | Dimension |
| fields_assignee_accounttype | String | Dimension |
| fields_assignee_active | Boolean | Dimension |
| fields_assignee_avatarurls__16x16 | String | Dimension |
| fields_assignee_avatarurls__24x24 | String | Dimension |
| fields_assignee_avatarurls__32x32 | String | Dimension |
| fields_assignee_avatarurls__48x48 | String | Dimension |
| fields_assignee_displayname | String | Dimension |
| fields_assignee_emailaddress | String | Dimension |
| fields_assignee_self | String | Dimension |
| fields_assignee_timezone | String | Dimension |
| fields_components | Record | Dimension |
| fields_created | String | Dimension |
| fields_creator_accountid | String | Dimension |
| fields_creator_accounttype | String | Dimension |
| fields_creator_active | Boolean | Dimension |
| fields_creator_avatarurls__16x16 | String | Dimension |
| fields_creator_avatarurls__24x24 | String | Dimension |
| fields_creator_avatarurls__32x32 | String | Dimension |
| fields_creator_avatarurls__48x48 | String | Dimension |
| fields_creator_displayname | String | Dimension |
| fields_creator_emailaddress | String | Dimension |
| fields_creator_self | String | Dimension |
| fields_creator_timezone | String | Dimension |
| fields_description | String | Dimension |
| fields_description_content | Record | Dimension |
| fields_description_type | String | Dimension |
| fields_description_version | Integer | Metric |
| fields_duedate | String | Dimension |
| fields_environment | String | Dimension |
| fields_fixversions | Record | Dimension |
| fields_issuelinks | Record | Dimension |
| fields_issuetype_avatarid | Integer | Metric |
| fields_issuetype_description | String | Dimension |
| fields_issuetype_entityid | String | Dimension |
| fields_issuetype_hierarchylevel | Integer | Metric |
| fields_issuetype_iconurl | String | Dimension |
| fields_issuetype_id | String | Dimension |
| fields_issuetype_name | String | Dimension |
| fields_issuetype_self | String | Dimension |
| fields_issuetype_subtask | Boolean | Dimension |
| fields_labels | String | Dimension |
| fields_lastviewed | String | Dimension |
| fields_parent_fields_issuetype_avatarid | Integer | Metric |
| fields_parent_fields_issuetype_description | String | Dimension |
| fields_parent_fields_issuetype_entityid | String | Dimension |
| fields_parent_fields_issuetype_hierarchylevel | Integer | Metric |
| fields_parent_fields_issuetype_iconurl | String | Dimension |
| fields_parent_fields_issuetype_id | String | Dimension |
| fields_parent_fields_issuetype_name | String | Dimension |
| fields_parent_fields_issuetype_self | String | Dimension |
| fields_parent_fields_issuetype_subtask | Boolean | Dimension |
| fields_parent_fields_priority_iconurl | String | Dimension |
| fields_parent_fields_priority_id | String | Dimension |
| fields_parent_fields_priority_name | String | Dimension |
| fields_parent_fields_priority_self | String | Dimension |
| fields_parent_fields_status_description | String | Dimension |
| fields_parent_fields_status_iconurl | String | Dimension |
| fields_parent_fields_status_id | String | Dimension |
| fields_parent_fields_status_name | String | Dimension |
| fields_parent_fields_status_self | String | Dimension |
| fields_parent_fields_status_statuscategory_colorname | String | Dimension |
| fields_parent_fields_status_statuscategory_id | Integer | Dimension |
| fields_parent_fields_status_statuscategory_key | String | Dimension |
| fields_parent_fields_status_statuscategory_name | String | Dimension |
| fields_parent_fields_status_statuscategory_self | String | Dimension |
| fields_parent_fields_summary | String | Dimension |
| fields_parent_id | String | Dimension |
| fields_parent_key | String | Dimension |
| fields_parent_self | String | Dimension |
| fields_priority | String | Dimension |
| fields_priority_iconurl | String | Dimension |
| fields_priority_id | String | Dimension |
| fields_priority_name | String | Dimension |
| fields_priority_self | String | Dimension |
| fields_progress_progress | Integer | Metric |
| fields_progress_total | Integer | Metric |
| fields_project_avatarurls__16x16 | String | Dimension |
| fields_project_avatarurls__24x24 | String | Dimension |
| fields_project_avatarurls__32x32 | String | Dimension |
| fields_project_avatarurls__48x48 | String | Dimension |
| fields_project_id | String | Dimension |
| fields_project_key | String | Dimension |
| fields_project_name | String | Dimension |
| fields_project_projectcategory_description | String | Dimension |
| fields_project_projectcategory_id | String | Dimension |
| fields_project_projectcategory_name | String | Dimension |
| fields_project_projectcategory_self | String | Dimension |
| fields_project_projecttypekey | String | Dimension |
| fields_project_self | String | Dimension |
| fields_project_simplified | Boolean | Dimension |
| fields_reporter_accountid | String | Dimension |
| fields_reporter_accounttype | String | Dimension |
| fields_reporter_active | Boolean | Dimension |
| fields_reporter_avatarurls__16x16 | String | Dimension |
| fields_reporter_avatarurls__24x24 | String | Dimension |
| fields_reporter_avatarurls__32x32 | String | Dimension |
| fields_reporter_avatarurls__48x48 | String | Dimension |
| fields_reporter_displayname | String | Dimension |
| fields_reporter_emailaddress | String | Dimension |
| fields_reporter_self | String | Dimension |
| fields_reporter_timezone | String | Dimension |
| fields_resolution | String | Dimension |
| fields_resolution_description | String | Dimension |
| fields_resolution_id | String | Dimension |
| fields_resolution_name | String | Dimension |
| fields_resolution_self | String | Dimension |
| fields_resolutiondate | String | Dimension |
| fields_security | String | Dimension |
| fields_status_description | String | Dimension |
| fields_status_iconurl | String | Dimension |
| fields_status_id | String | Dimension |
| fields_status_name | String | Dimension |
| fields_status_self | String | Dimension |
| fields_status_statuscategory_colorname | String | Dimension |
| fields_status_statuscategory_id | Integer | Dimension |
| fields_status_statuscategory_key | String | Dimension |
| fields_status_statuscategory_name | String | Dimension |
| fields_status_statuscategory_self | String | Dimension |
| fields_statuscategorychangedate | String | Dimension |
| fields_subtasks | Record | Dimension |
| fields_summary | String | Dimension |
| fields_timeestimate | String | Dimension |
| fields_timeoriginalestimate | String | Dimension |
| fields_timespent | String | Dimension |
| fields_updated | String | Dimension |
| fields_votes_hasvoted | Boolean | Dimension |
| fields_votes_self | String | Dimension |
| fields_votes_votes | Integer | Metric |
| fields_watches_iswatching | Boolean | Dimension |
| fields_watches_self | String | Dimension |
| fields_watches_watchcount | Integer | Metric |
| fields_workratio | Integer | Metric |
| changelog_maxresults | Integer | Metric |
| key | String | Dimension |
| self | String | Dimension |
| transitions | Record | Dimension |
