API Connectors

users-love-us medal soc2
Send your Jira data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Jira Connector Reference

11 metrics460 dimensions
Fields

The Jira connector exposes 471 fields (11 metrics, 460 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Jira Fields

Jira application_roles fields

The application_roles report of the Jira connector includes 14 fields.

ID Type Name Description
application_roles__defaultgroups OBJECT application_roles.defaultGroups application_roles.defaultGroups
application_roles__defaultgroupsdetails OBJECT application_roles.defaultGroupsDetails application_roles.defaultGroupsDetails
application_roles__defined BOOLEAN application_roles.defined application_roles.defined
application_roles__groupdetails OBJECT application_roles.groupDetails application_roles.groupDetails
application_roles__groups OBJECT application_roles.groups application_roles.groups
application_roles__hasunlimitedseats BOOLEAN application_roles.hasUnlimitedSeats application_roles.hasUnlimitedSeats
application_roles__key TEXT application_roles.key application_roles.key
application_roles__name TEXT application_roles.name application_roles.name
application_roles__numberofseats NUMERIC application_roles.numberOfSeats application_roles.numberOfSeats
application_roles__platform BOOLEAN application_roles.platform application_roles.platform
application_roles__remainingseats NUMERIC application_roles.remainingSeats application_roles.remainingSeats
application_roles__selectedbydefault BOOLEAN application_roles.selectedByDefault application_roles.selectedByDefault
application_roles__usercount NUMERIC application_roles.userCount application_roles.userCount
application_roles__usercountdescription TEXT application_roles.userCountDescription application_roles.userCountDescription

Jira avatars fields

The avatars report of the Jira connector includes 7 fields.

ID Type Name Description
avatars__filename TEXT avatars.fileName avatars.fileName
avatars__id TEXT avatars.id avatars.id
avatars__isdeletable BOOLEAN avatars.isDeletable avatars.isDeletable
avatars__isselected BOOLEAN avatars.isSelected avatars.isSelected
avatars__issystemavatar BOOLEAN avatars.isSystemAvatar avatars.isSystemAvatar
avatars__owner TEXT avatars.owner avatars.owner
avatars__urls OBJECT avatars.urls avatars.urls

Jira board_issues fields

The board_issues report of the Jira connector includes 8 fields.

ID Type Name Description
board_issues__boardid TEXT board_issues.boardId board_issues.boardId
board_issues__created TIMESTAMP board_issues.created board_issues.created
board_issues__expand TEXT board_issues.expand board_issues.expand
board_issues__fields OBJECT board_issues.fields board_issues.fields
board_issues__id TEXT board_issues.id board_issues.id
board_issues__key TEXT board_issues.key board_issues.key
board_issues__self TEXT board_issues.self board_issues.self
board_issues__updated TIMESTAMP board_issues.updated board_issues.updated

Jira boards fields

The boards report of the Jira connector includes 7 fields.

ID Type Name Description
boards__id TEXT boards.id boards.id
boards__location OBJECT boards.location boards.location
boards__name TEXT boards.name boards.name
boards__projectid TEXT boards.projectId boards.projectId
boards__projectkey TEXT boards.projectKey boards.projectKey
boards__self TEXT boards.self boards.self
boards__type TEXT boards.type boards.type

Jira dashboards fields

The dashboards report of the Jira connector includes 14 fields.

ID Type Name Description
dashboards__description TEXT dashboards.description dashboards.description
dashboards__editpermission OBJECT dashboards.editpermission dashboards.editpermission
dashboards__editpermissions OBJECT dashboards.editPermissions dashboards.editPermissions
dashboards__id TEXT dashboards.id dashboards.id
dashboards__isfavourite BOOLEAN dashboards.isFavourite dashboards.isFavourite
dashboards__iswritable BOOLEAN dashboards.isWritable dashboards.isWritable
dashboards__name TEXT dashboards.name dashboards.name
dashboards__owner OBJECT dashboards.owner dashboards.owner
dashboards__popularity NUMERIC dashboards.popularity dashboards.popularity
dashboards__rank NUMERIC dashboards.rank dashboards.rank
dashboards__self TEXT dashboards.self dashboards.self
dashboards__sharepermissions OBJECT dashboards.sharePermissions dashboards.sharePermissions
dashboards__systemdashboard BOOLEAN dashboards.systemDashboard dashboards.systemDashboard
dashboards__view TEXT dashboards.view dashboards.view

Jira filter_sharing fields

The filter_sharing report of the Jira connector includes 6 fields.

ID Type Name Description
filter_sharing__filterid TEXT filter_sharing.filterId filter_sharing.filterId
filter_sharing__group OBJECT filter_sharing.group filter_sharing.group
filter_sharing__id TEXT filter_sharing.id filter_sharing.id
filter_sharing__project OBJECT filter_sharing.project filter_sharing.project
filter_sharing__role OBJECT filter_sharing.role filter_sharing.role
filter_sharing__type TEXT filter_sharing.type filter_sharing.type

Jira filters fields

The filters report of the Jira connector includes 15 fields.

ID Type Name Description
filters__approximatelastused TEXT filters.approximateLastUsed filters.approximateLastUsed
filters__description TEXT filters.description filters.description
filters__expand TEXT filters.expand filters.expand
filters__favourite BOOLEAN filters.favourite filters.favourite
filters__favouritedcount NUMERIC filters.favouritedCount filters.favouritedCount
filters__id TEXT filters.id filters.id
filters__iswritable BOOLEAN filters.isWritable filters.isWritable
filters__jql TEXT filters.jql filters.jql
filters__name TEXT filters.name filters.name
filters__owner OBJECT filters.owner filters.owner
filters__searchurl TEXT filters.searchUrl filters.searchUrl
filters__self TEXT filters.self filters.self
filters__sharepermissions OBJECT filters.sharePermissions filters.sharePermissions
filters__subscriptions OBJECT filters.subscriptions filters.subscriptions
filters__viewurl TEXT filters.viewUrl filters.viewUrl

Jira General fields

The General report of the Jira connector includes 3 fields.

ID Type Name Description
account_id TEXT Account ID The unique identifier for the account.
account_name TEXT Account Name The name of the account.
date DATE Date The date of the record.

Jira issue_comments fields

The issue_comments report of the Jira connector includes 12 fields.

ID Type Name Description
issue_comments__author TEXT issue_comments.author issue_comments.author
issue_comments__body OBJECT issue_comments.body issue_comments.body
issue_comments__created TIMESTAMP issue_comments.created issue_comments.created
issue_comments__id TEXT issue_comments.id issue_comments.id
issue_comments__issueid TEXT issue_comments.issueId issue_comments.issueId
issue_comments__jsdpublic BOOLEAN issue_comments.jsdPublic issue_comments.jsdPublic
issue_comments__properties OBJECT issue_comments.properties issue_comments.properties
issue_comments__renderedbody TEXT issue_comments.renderedBody issue_comments.renderedBody
issue_comments__self TEXT issue_comments.self issue_comments.self
issue_comments__updateauthor OBJECT issue_comments.updateAuthor issue_comments.updateAuthor
issue_comments__updated TIMESTAMP issue_comments.updated issue_comments.updated
issue_comments__visibility OBJECT issue_comments.visibility issue_comments.visibility

Jira issue_custom_field_contexts fields

The issue_custom_field_contexts report of the Jira connector includes 7 fields.

ID Type Name Description
issue_custom_field_contexts__description TEXT issue_custom_field_contexts.description issue_custom_field_contexts.description
issue_custom_field_contexts__fieldid TEXT issue_custom_field_contexts.fieldId issue_custom_field_contexts.fieldId
issue_custom_field_contexts__fieldtype TEXT issue_custom_field_contexts.fieldType issue_custom_field_contexts.fieldType
issue_custom_field_contexts__id TEXT issue_custom_field_contexts.id issue_custom_field_contexts.id
issue_custom_field_contexts__isanyissuetype BOOLEAN issue_custom_field_contexts.isAnyIssueType issue_custom_field_contexts.isAnyIssueType
issue_custom_field_contexts__isglobalcontext BOOLEAN issue_custom_field_contexts.isGlobalContext issue_custom_field_contexts.isGlobalContext
issue_custom_field_contexts__name TEXT issue_custom_field_contexts.name issue_custom_field_contexts.name

Jira issue_custom_field_options fields

The issue_custom_field_options report of the Jira connector includes 6 fields.

ID Type Name Description
issue_custom_field_options__contextid TEXT issue_custom_field_options.contextId issue_custom_field_options.contextId
issue_custom_field_options__disabled BOOLEAN issue_custom_field_options.disabled issue_custom_field_options.disabled
issue_custom_field_options__fieldid TEXT issue_custom_field_options.fieldId issue_custom_field_options.fieldId
issue_custom_field_options__id TEXT issue_custom_field_options.id issue_custom_field_options.id
issue_custom_field_options__optionid TEXT issue_custom_field_options.optionId issue_custom_field_options.optionId
issue_custom_field_options__value TEXT issue_custom_field_options.value issue_custom_field_options.value

Jira issue_field_configurations fields

The issue_field_configurations report of the Jira connector includes 4 fields.

ID Type Name Description
issue_field_configurations__description TEXT issue_field_configurations.description issue_field_configurations.description
issue_field_configurations__id TEXT issue_field_configurations.id issue_field_configurations.id
issue_field_configurations__isdefault BOOLEAN issue_field_configurations.isDefault issue_field_configurations.isDefault
issue_field_configurations__name TEXT issue_field_configurations.name issue_field_configurations.name

Jira issue_fields fields

The issue_fields report of the Jira connector includes 11 fields.

ID Type Name Description
issue_fields__clausenames OBJECT issue_fields.clauseNames issue_fields.clauseNames
issue_fields__custom BOOLEAN issue_fields.custom issue_fields.custom
issue_fields__id TEXT issue_fields.id issue_fields.id
issue_fields__key TEXT issue_fields.key issue_fields.key
issue_fields__name TEXT issue_fields.name issue_fields.name
issue_fields__navigable BOOLEAN issue_fields.navigable issue_fields.navigable
issue_fields__orderable BOOLEAN issue_fields.orderable issue_fields.orderable
issue_fields__schema OBJECT issue_fields.schema issue_fields.schema
issue_fields__scope OBJECT issue_fields.scope issue_fields.scope
issue_fields__searchable BOOLEAN issue_fields.searchable issue_fields.searchable
issue_fields__untranslatedname TEXT issue_fields.untranslatedName issue_fields.untranslatedName

Jira issue_notification_schemes fields

The issue_notification_schemes report of the Jira connector includes 7 fields.

ID Type Name Description
issue_notification_schemes__description TEXT issue_notification_schemes.description issue_notification_schemes.description
issue_notification_schemes__expand TEXT issue_notification_schemes.expand issue_notification_schemes.expand
issue_notification_schemes__id TEXT issue_notification_schemes.id issue_notification_schemes.id
issue_notification_schemes__name TEXT issue_notification_schemes.name issue_notification_schemes.name
issue_notification_schemes__notificationschemeevents OBJECT issue_notification_schemes.notificationSchemeEvents issue_notification_schemes.notificationSchemeEvents
issue_notification_schemes__scope OBJECT issue_notification_schemes.scope issue_notification_schemes.scope
issue_notification_schemes__self TEXT issue_notification_schemes.self issue_notification_schemes.self

Jira issue_priorities fields

The issue_priorities report of the Jira connector includes 7 fields.

ID Type Name Description
issue_priorities__description TEXT issue_priorities.description issue_priorities.description
issue_priorities__iconurl TEXT issue_priorities.iconUrl issue_priorities.iconUrl
issue_priorities__id TEXT issue_priorities.id issue_priorities.id
issue_priorities__isdefault BOOLEAN issue_priorities.isDefault issue_priorities.isDefault
issue_priorities__name TEXT issue_priorities.name issue_priorities.name
issue_priorities__self TEXT issue_priorities.self issue_priorities.self
issue_priorities__statuscolor TEXT issue_priorities.statusColor issue_priorities.statusColor

Jira issue_properties fields

The issue_properties report of the Jira connector includes 4 fields.

ID Type Name Description
issue_properties__isdefault BOOLEAN issue_properties.isdefault issue_properties.isdefault
issue_properties__issueid TEXT issue_properties.issueId issue_properties.issueId
issue_properties__key TEXT issue_properties.key issue_properties.key
issue_properties__value OBJECT issue_properties.value issue_properties.value

Jira issue_resolutions fields

The issue_resolutions report of the Jira connector includes 5 fields.

ID Type Name Description
issue_resolutions__description TEXT issue_resolutions.description issue_resolutions.description
issue_resolutions__id TEXT issue_resolutions.id issue_resolutions.id
issue_resolutions__isdefault BOOLEAN issue_resolutions.isDefault issue_resolutions.isDefault
issue_resolutions__name TEXT issue_resolutions.name issue_resolutions.name
issue_resolutions__self TEXT issue_resolutions.self issue_resolutions.self

Jira issue_security_schemes fields

The issue_security_schemes report of the Jira connector includes 6 fields.

ID Type Name Description
issue_security_schemes__defaultsecuritylevelid TEXT issue_security_schemes.defaultSecurityLevelId issue_security_schemes.defaultSecurityLevelId
issue_security_schemes__description TEXT issue_security_schemes.description issue_security_schemes.description
issue_security_schemes__id TEXT issue_security_schemes.id issue_security_schemes.id
issue_security_schemes__levels OBJECT issue_security_schemes.levels issue_security_schemes.levels
issue_security_schemes__name TEXT issue_security_schemes.name issue_security_schemes.name
issue_security_schemes__self TEXT issue_security_schemes.self issue_security_schemes.self

Jira issue_transitions fields

The issue_transitions report of the Jira connector includes 11 fields.

ID Type Name Description
issue_transitions__fields TEXT issue_transitions.fields issue_transitions.fields
issue_transitions__hasscreen BOOLEAN issue_transitions.hasScreen issue_transitions.hasScreen
issue_transitions__id TEXT issue_transitions.id issue_transitions.id
issue_transitions__isavailable BOOLEAN issue_transitions.isAvailable issue_transitions.isAvailable
issue_transitions__isconditional BOOLEAN issue_transitions.isConditional issue_transitions.isConditional
issue_transitions__isglobal BOOLEAN issue_transitions.isGlobal issue_transitions.isGlobal
issue_transitions__isinitial BOOLEAN issue_transitions.isInitial issue_transitions.isInitial
issue_transitions__islooped BOOLEAN issue_transitions.isLooped issue_transitions.isLooped
issue_transitions__issueid TEXT issue_transitions.issueId issue_transitions.issueId
issue_transitions__name TEXT issue_transitions.name issue_transitions.name
issue_transitions__to OBJECT issue_transitions.to issue_transitions.to

Jira issue_type_schemes fields

The issue_type_schemes report of the Jira connector includes 5 fields.

ID Type Name Description
issue_type_schemes__defaultissuetypeid TEXT issue_type_schemes.defaultIssueTypeId issue_type_schemes.defaultIssueTypeId
issue_type_schemes__description TEXT issue_type_schemes.description issue_type_schemes.description
issue_type_schemes__id TEXT issue_type_schemes.id issue_type_schemes.id
issue_type_schemes__isdefault BOOLEAN issue_type_schemes.isDefault issue_type_schemes.isDefault
issue_type_schemes__name TEXT issue_type_schemes.name issue_type_schemes.name

Jira issue_type_screen_schemes fields

The issue_type_screen_schemes report of the Jira connector includes 3 fields.

ID Type Name Description
issue_type_screen_schemes__description TEXT issue_type_screen_schemes.description issue_type_screen_schemes.description
issue_type_screen_schemes__id TEXT issue_type_screen_schemes.id issue_type_screen_schemes.id
issue_type_screen_schemes__name TEXT issue_type_screen_schemes.name issue_type_screen_schemes.name

Jira issue_types fields

The issue_types report of the Jira connector includes 11 fields.

ID Type Name Description
issue_types__avatarid TEXT issue_types.avatarId issue_types.avatarId
issue_types__description TEXT issue_types.description issue_types.description
issue_types__entityid TEXT issue_types.entityId issue_types.entityId
issue_types__hierarchylevel NUMERIC issue_types.hierarchyLevel issue_types.hierarchyLevel
issue_types__iconurl TEXT issue_types.iconUrl issue_types.iconUrl
issue_types__id TEXT issue_types.id issue_types.id
issue_types__name TEXT issue_types.name issue_types.name
issue_types__scope OBJECT issue_types.scope issue_types.scope
issue_types__self TEXT issue_types.self issue_types.self
issue_types__subtask BOOLEAN issue_types.subtask issue_types.subtask
issue_types__untranslatedname TEXT issue_types.untranslatedName issue_types.untranslatedName

Jira issue_votes fields

The issue_votes report of the Jira connector includes 5 fields.

ID Type Name Description
issue_votes__hasvoted BOOLEAN issue_votes.hasVoted issue_votes.hasVoted
issue_votes__issueid TEXT issue_votes.issueId issue_votes.issueId
issue_votes__self TEXT issue_votes.self issue_votes.self
issue_votes__voters OBJECT issue_votes.voters issue_votes.voters
issue_votes__votes NUMERIC issue_votes.votes issue_votes.votes

Jira issue_watchers fields

The issue_watchers report of the Jira connector includes 5 fields.

ID Type Name Description
issue_watchers__issueid TEXT issue_watchers.issueId issue_watchers.issueId
issue_watchers__iswatching BOOLEAN issue_watchers.isWatching issue_watchers.isWatching
issue_watchers__self TEXT issue_watchers.self issue_watchers.self
issue_watchers__watchcount NUMERIC issue_watchers.watchCount issue_watchers.watchCount
issue_watchers__watchers OBJECT issue_watchers.watchers issue_watchers.watchers

Jira issue_worklogs fields

The issue_worklogs report of the Jira connector includes 13 fields.

ID Type Name Description
issue_worklogs__author OBJECT issue_worklogs.author issue_worklogs.author
issue_worklogs__comment OBJECT issue_worklogs.comment issue_worklogs.comment
issue_worklogs__created TIMESTAMP issue_worklogs.created issue_worklogs.created
issue_worklogs__id TEXT issue_worklogs.id issue_worklogs.id
issue_worklogs__issueid TEXT issue_worklogs.issueId issue_worklogs.issueId
issue_worklogs__properties OBJECT issue_worklogs.properties issue_worklogs.properties
issue_worklogs__self TEXT issue_worklogs.self issue_worklogs.self
issue_worklogs__started TIMESTAMP issue_worklogs.started issue_worklogs.started
issue_worklogs__timespent TEXT issue_worklogs.timeSpent issue_worklogs.timeSpent
issue_worklogs__timespentseconds NUMERIC issue_worklogs.timeSpentSeconds issue_worklogs.timeSpentSeconds
issue_worklogs__updateauthor OBJECT issue_worklogs.updateAuthor issue_worklogs.updateAuthor
issue_worklogs__updated TIMESTAMP issue_worklogs.updated issue_worklogs.updated
issue_worklogs__visibility OBJECT issue_worklogs.visibility issue_worklogs.visibility

Jira issues fields

The issues report of the Jira connector includes 19 fields.

ID Type Name Description
issues__changelog OBJECT issues.changelog issues.changelog
issues__created TIMESTAMP issues.created issues.created
issues__editmeta OBJECT issues.editmeta issues.editmeta
issues__expand TEXT issues.expand issues.expand
issues__fields OBJECT issues.fields issues.fields
issues__fieldstoinclude OBJECT issues.fieldsToInclude issues.fieldsToInclude
issues__id TEXT issues.id issues.id
issues__key TEXT issues.key issues.key
issues__names OBJECT issues.names issues.names
issues__operations OBJECT issues.operations issues.operations
issues__projectid TEXT issues.projectId issues.projectId
issues__projectkey TEXT issues.projectKey issues.projectKey
issues__properties OBJECT issues.properties issues.properties
issues__renderedfields OBJECT issues.renderedFields issues.renderedFields
issues__schema OBJECT issues.schema issues.schema
issues__self TEXT issues.self issues.self
issues__transitions OBJECT issues.transitions issues.transitions
issues__updated TIMESTAMP issues.updated issues.updated
issues__versionedrepresentations OBJECT issues.versionedRepresentations issues.versionedRepresentations

Jira jira_settings fields

The jira_settings report of the Jira connector includes 9 fields.

ID Type Name Description
jira_settings__allowedvalues OBJECT jira_settings.allowedValues jira_settings.allowedValues
jira_settings__defaultvalue TEXT jira_settings.defaultValue jira_settings.defaultValue
jira_settings__desc TEXT jira_settings.desc jira_settings.desc
jira_settings__example TEXT jira_settings.example jira_settings.example
jira_settings__id TEXT jira_settings.id jira_settings.id
jira_settings__key TEXT jira_settings.key jira_settings.key
jira_settings__name TEXT jira_settings.name jira_settings.name
jira_settings__type TEXT jira_settings.type jira_settings.type
jira_settings__value TEXT jira_settings.value jira_settings.value

Jira permission_schemes fields

The permission_schemes report of the Jira connector includes 7 fields.

ID Type Name Description
permission_schemes__description TEXT permission_schemes.description permission_schemes.description
permission_schemes__expand TEXT permission_schemes.expand permission_schemes.expand
permission_schemes__id TEXT permission_schemes.id permission_schemes.id
permission_schemes__name TEXT permission_schemes.name permission_schemes.name
permission_schemes__permissions OBJECT permission_schemes.permissions permission_schemes.permissions
permission_schemes__scope OBJECT permission_schemes.scope permission_schemes.scope
permission_schemes__self TEXT permission_schemes.self permission_schemes.self

Jira permissions fields

The permissions report of the Jira connector includes 4 fields.

ID Type Name Description
permissions__description TEXT permissions.description permissions.description
permissions__key TEXT permissions.key permissions.key
permissions__name TEXT permissions.name permissions.name
permissions__type TEXT permissions.type permissions.type

Jira project_avatars fields

The project_avatars report of the Jira connector includes 8 fields.

ID Type Name Description
project_avatars__filename TEXT project_avatars.fileName project_avatars.fileName
project_avatars__id TEXT project_avatars.id project_avatars.id
project_avatars__isdeletable BOOLEAN project_avatars.isDeletable project_avatars.isDeletable
project_avatars__isselected BOOLEAN project_avatars.isSelected project_avatars.isSelected
project_avatars__issystemavatar BOOLEAN project_avatars.isSystemAvatar project_avatars.isSystemAvatar
project_avatars__owner TEXT project_avatars.owner project_avatars.owner
project_avatars__projectid TEXT project_avatars.projectId project_avatars.projectId
project_avatars__urls OBJECT project_avatars.urls project_avatars.urls

Jira project_categories fields

The project_categories report of the Jira connector includes 4 fields.

ID Type Name Description
project_categories__description TEXT project_categories.description project_categories.description
project_categories__id TEXT project_categories.id project_categories.id
project_categories__name TEXT project_categories.name project_categories.name
project_categories__self TEXT project_categories.self project_categories.self

Jira project_components fields

The project_components report of the Jira connector includes 16 fields.

ID Type Name Description
project_components__assignee OBJECT project_components.assignee project_components.assignee
project_components__assigneetype TEXT project_components.assigneeType project_components.assigneeType
project_components__componentbean OBJECT project_components.componentBean project_components.componentBean
project_components__description TEXT project_components.description project_components.description
project_components__id TEXT project_components.id project_components.id
project_components__isassigneetypevalid BOOLEAN project_components.isAssigneeTypeValid project_components.isAssigneeTypeValid
project_components__issuecount NUMERIC project_components.issueCount project_components.issueCount
project_components__lead OBJECT project_components.lead project_components.lead
project_components__leadaccountid TEXT project_components.leadAccountId project_components.leadAccountId
project_components__leadusername TEXT project_components.leadUserName project_components.leadUserName
project_components__name TEXT project_components.name project_components.name
project_components__project TEXT project_components.project project_components.project
project_components__projectid TEXT project_components.projectId project_components.projectId
project_components__realassignee OBJECT project_components.realAssignee project_components.realAssignee
project_components__realassigneetype TEXT project_components.realAssigneeType project_components.realAssigneeType
project_components__self TEXT project_components.self project_components.self

Jira project_permission_schemes fields

The project_permission_schemes report of the Jira connector includes 5 fields.

ID Type Name Description
project_permission_schemes__description TEXT project_permission_schemes.description project_permission_schemes.description
project_permission_schemes__id TEXT project_permission_schemes.id project_permission_schemes.id
project_permission_schemes__name TEXT project_permission_schemes.name project_permission_schemes.name
project_permission_schemes__projectid TEXT project_permission_schemes.projectId project_permission_schemes.projectId
project_permission_schemes__self TEXT project_permission_schemes.self project_permission_schemes.self

Jira project_roles fields

The project_roles report of the Jira connector includes 11 fields.

ID Type Name Description
project_roles__actors OBJECT project_roles.actors project_roles.actors
project_roles__admin BOOLEAN project_roles.admin project_roles.admin
project_roles__currentuserrole BOOLEAN project_roles.currentUserRole project_roles.currentUserRole
project_roles__default BOOLEAN project_roles.default project_roles.default
project_roles__description TEXT project_roles.description project_roles.description
project_roles__id TEXT project_roles.id project_roles.id
project_roles__name TEXT project_roles.name project_roles.name
project_roles__roleconfigurable BOOLEAN project_roles.roleConfigurable project_roles.roleConfigurable
project_roles__scope OBJECT project_roles.scope project_roles.scope
project_roles__self TEXT project_roles.self project_roles.self
project_roles__translatedname TEXT project_roles.translatedName project_roles.translatedName

Jira project_types fields

The project_types report of the Jira connector includes 5 fields.

ID Type Name Description
project_types__color TEXT project_types.color project_types.color
project_types__descriptioni18nkey TEXT project_types.descriptionI18nKey project_types.descriptionI18nKey
project_types__formattedkey TEXT project_types.formattedKey project_types.formattedKey
project_types__icon TEXT project_types.icon project_types.icon
project_types__key TEXT project_types.key project_types.key

Jira project_versions fields

The project_versions report of the Jira connector includes 17 fields.

ID Type Name Description
project_versions__archived BOOLEAN project_versions.archived project_versions.archived
project_versions__description TEXT project_versions.description project_versions.description
project_versions__expand TEXT project_versions.expand project_versions.expand
project_versions__id TEXT project_versions.id project_versions.id
project_versions__issuesstatusforfixversion OBJECT project_versions.issuesStatusForFixVersion project_versions.issuesStatusForFixVersion
project_versions__moveunfixedissuesto TEXT project_versions.moveUnfixedIssuesTo project_versions.moveUnfixedIssuesTo
project_versions__name TEXT project_versions.name project_versions.name
project_versions__operations OBJECT project_versions.operations project_versions.operations
project_versions__overdue BOOLEAN project_versions.overdue project_versions.overdue
project_versions__project TEXT project_versions.project project_versions.project
project_versions__projectid TEXT project_versions.projectId project_versions.projectId
project_versions__released BOOLEAN project_versions.released project_versions.released
project_versions__releasedate TEXT project_versions.releaseDate project_versions.releaseDate
project_versions__self TEXT project_versions.self project_versions.self
project_versions__startdate TEXT project_versions.startDate project_versions.startDate
project_versions__userreleasedate TEXT project_versions.userReleaseDate project_versions.userReleaseDate
project_versions__userstartdate TEXT project_versions.userStartDate project_versions.userStartDate

Jira projects fields

The projects report of the Jira connector includes 34 fields.

ID Type Name Description
projects__archived BOOLEAN projects.archived projects.archived
projects__archivedby TEXT projects.archivedBy projects.archivedBy
projects__archiveddate TEXT projects.archivedDate projects.archivedDate
projects__assigneetype TEXT projects.assigneeType projects.assigneeType
projects__avatarurls TEXT projects.avatarUrls projects.avatarUrls
projects__components OBJECT projects.components projects.components
projects__deleted BOOLEAN projects.deleted projects.deleted
projects__deletedby TEXT projects.deletedBy projects.deletedBy
projects__deleteddate TEXT projects.deletedDate projects.deletedDate
projects__description TEXT projects.description projects.description
projects__email TEXT projects.email projects.email
projects__entityid TEXT projects.entityId projects.entityId
projects__expand TEXT projects.expand projects.expand
projects__favourite BOOLEAN projects.favourite projects.favourite
projects__id TEXT projects.id projects.id
projects__insight TEXT projects.insight projects.insight
projects__isprivate BOOLEAN projects.isPrivate projects.isPrivate
projects__issuetypehierarchy TEXT projects.issueTypeHierarchy projects.issueTypeHierarchy
projects__issuetypes OBJECT projects.issueTypes projects.issueTypes
projects__key TEXT projects.key projects.key
projects__lead TEXT projects.lead projects.lead
projects__name TEXT projects.name projects.name
projects__permissions TEXT projects.permissions projects.permissions
projects__projectcategory TEXT projects.projectCategory projects.projectCategory
projects__projecttypekey TEXT projects.projectTypeKey projects.projectTypeKey
projects__properties OBJECT projects.properties projects.properties
projects__retentiontilldate TEXT projects.retentionTillDate projects.retentionTillDate
projects__roles OBJECT projects.roles projects.roles
projects__self TEXT projects.self projects.self
projects__simplified BOOLEAN projects.simplified projects.simplified
projects__style TEXT projects.style projects.style
projects__url TEXT projects.url projects.url
projects__uuid TEXT projects.uuid projects.uuid
projects__versions OBJECT projects.versions projects.versions

Jira screen_schemes fields

The screen_schemes report of the Jira connector includes 5 fields.

ID Type Name Description
screen_schemes__description TEXT screen_schemes.description screen_schemes.description
screen_schemes__id TEXT screen_schemes.id screen_schemes.id
screen_schemes__issuetypescreenschemes OBJECT screen_schemes.issueTypeScreenSchemes screen_schemes.issueTypeScreenSchemes
screen_schemes__name TEXT screen_schemes.name screen_schemes.name
screen_schemes__screens OBJECT screen_schemes.screens screen_schemes.screens

Jira screen_tab_fields fields

The screen_tab_fields report of the Jira connector includes 4 fields.

ID Type Name Description
screen_tab_fields__id TEXT screen_tab_fields.id screen_tab_fields.id
screen_tab_fields__name TEXT screen_tab_fields.name screen_tab_fields.name
screen_tab_fields__screenid TEXT screen_tab_fields.screenId screen_tab_fields.screenId
screen_tab_fields__tabid TEXT screen_tab_fields.tabId screen_tab_fields.tabId

Jira screen_tabs fields

The screen_tabs report of the Jira connector includes 3 fields.

ID Type Name Description
screen_tabs__id TEXT screen_tabs.id screen_tabs.id
screen_tabs__name TEXT screen_tabs.name screen_tabs.name
screen_tabs__screenid TEXT screen_tabs.screenId screen_tabs.screenId

Jira screens fields

The screens report of the Jira connector includes 4 fields.

ID Type Name Description
screens__description TEXT screens.description screens.description
screens__id TEXT screens.id screens.id
screens__name TEXT screens.name screens.name
screens__scope OBJECT screens.scope screens.scope

Jira sprint_issues fields

The sprint_issues report of the Jira connector includes 9 fields.

ID Type Name Description
sprint_issues__created TIMESTAMP sprint_issues.created sprint_issues.created
sprint_issues__expand TEXT sprint_issues.expand sprint_issues.expand
sprint_issues__fields OBJECT sprint_issues.fields sprint_issues.fields
sprint_issues__id TEXT sprint_issues.id sprint_issues.id
sprint_issues__issueid TEXT sprint_issues.issueId sprint_issues.issueId
sprint_issues__key TEXT sprint_issues.key sprint_issues.key
sprint_issues__self TEXT sprint_issues.self sprint_issues.self
sprint_issues__sprintid TEXT sprint_issues.sprintId sprint_issues.sprintId
sprint_issues__updated TIMESTAMP sprint_issues.updated sprint_issues.updated

Jira sprints fields

The sprints report of the Jira connector includes 11 fields.

ID Type Name Description
sprints__boardid TEXT sprints.boardId sprints.boardId
sprints__completedate TIMESTAMP sprints.completeDate sprints.completeDate
sprints__createddate TIMESTAMP sprints.createdDate sprints.createdDate
sprints__enddate TIMESTAMP sprints.endDate sprints.endDate
sprints__goal TEXT sprints.goal sprints.goal
sprints__id TEXT sprints.id sprints.id
sprints__name TEXT sprints.name sprints.name
sprints__originboardid TEXT sprints.originBoardId sprints.originBoardId
sprints__self TEXT sprints.self sprints.self
sprints__startdate TIMESTAMP sprints.startDate sprints.startDate
sprints__state TEXT sprints.state sprints.state

Jira time_tracking fields

The time_tracking report of the Jira connector includes 3 fields.

ID Type Name Description
time_tracking__key TEXT time_tracking.key time_tracking.key
time_tracking__name TEXT time_tracking.name time_tracking.name
time_tracking__url TEXT time_tracking.url time_tracking.url

Jira users fields

The users report of the Jira connector includes 14 fields.

ID Type Name Description
users__accountid TEXT users.accountId users.accountId
users__accounttype TEXT users.accountType users.accountType
users__active BOOLEAN users.active users.active
users__applicationroles OBJECT users.applicationRoles users.applicationRoles
users__avatarurls OBJECT users.avatarUrls users.avatarUrls
users__displayname TEXT users.displayName users.displayName
users__emailaddress TEXT users.emailAddress users.emailAddress
users__expand TEXT users.expand users.expand
users__groups OBJECT users.groups users.groups
users__key TEXT users.key users.key
users__locale TEXT users.locale users.locale
users__name TEXT users.name users.name
users__self TEXT users.self users.self
users__timezone TEXT users.timeZone users.timeZone

Jira users_groups_detailed fields

The users_groups_detailed report of the Jira connector includes 14 fields.

ID Type Name Description
users_groups_detailed__accountid TEXT users_groups_detailed.accountId users_groups_detailed.accountId
users_groups_detailed__accounttype TEXT users_groups_detailed.accountType users_groups_detailed.accountType
users_groups_detailed__active BOOLEAN users_groups_detailed.active users_groups_detailed.active
users_groups_detailed__applicationroles OBJECT users_groups_detailed.applicationRoles users_groups_detailed.applicationRoles
users_groups_detailed__avatarurls OBJECT users_groups_detailed.avatarUrls users_groups_detailed.avatarUrls
users_groups_detailed__displayname TEXT users_groups_detailed.displayName users_groups_detailed.displayName
users_groups_detailed__emailaddress TEXT users_groups_detailed.emailAddress users_groups_detailed.emailAddress
users_groups_detailed__expand TEXT users_groups_detailed.expand users_groups_detailed.expand
users_groups_detailed__groups OBJECT users_groups_detailed.groups users_groups_detailed.groups
users_groups_detailed__key TEXT users_groups_detailed.key users_groups_detailed.key
users_groups_detailed__locale TEXT users_groups_detailed.locale users_groups_detailed.locale
users_groups_detailed__name TEXT users_groups_detailed.name users_groups_detailed.name
users_groups_detailed__self TEXT users_groups_detailed.self users_groups_detailed.self
users_groups_detailed__timezone TEXT users_groups_detailed.timeZone users_groups_detailed.timeZone

Jira workflow_schemes fields

The workflow_schemes report of the Jira connector includes 13 fields.

ID Type Name Description
workflow_schemes__defaultworkflow TEXT workflow_schemes.defaultWorkflow workflow_schemes.defaultWorkflow
workflow_schemes__description TEXT workflow_schemes.description workflow_schemes.description
workflow_schemes__draft BOOLEAN workflow_schemes.draft workflow_schemes.draft
workflow_schemes__id TEXT workflow_schemes.id workflow_schemes.id
workflow_schemes__issuetypemappings OBJECT workflow_schemes.issueTypeMappings workflow_schemes.issueTypeMappings
workflow_schemes__issuetypes OBJECT workflow_schemes.issueTypes workflow_schemes.issueTypes
workflow_schemes__lastmodified TEXT workflow_schemes.lastModified workflow_schemes.lastModified
workflow_schemes__lastmodifieduser OBJECT workflow_schemes.lastModifiedUser workflow_schemes.lastModifiedUser
workflow_schemes__name TEXT workflow_schemes.name workflow_schemes.name
workflow_schemes__originaldefaultworkflow TEXT workflow_schemes.originalDefaultWorkflow workflow_schemes.originalDefaultWorkflow
workflow_schemes__originalissuetypemappings OBJECT workflow_schemes.originalIssueTypeMappings workflow_schemes.originalIssueTypeMappings
workflow_schemes__self TEXT workflow_schemes.self workflow_schemes.self
workflow_schemes__updatedraftifneeded BOOLEAN workflow_schemes.updateDraftIfNeeded workflow_schemes.updateDraftIfNeeded

Jira workflow_status_categories fields

The workflow_status_categories report of the Jira connector includes 5 fields.

ID Type Name Description
workflow_status_categories__colorname TEXT workflow_status_categories.colorName workflow_status_categories.colorName
workflow_status_categories__id TEXT workflow_status_categories.id workflow_status_categories.id
workflow_status_categories__key TEXT workflow_status_categories.key workflow_status_categories.key
workflow_status_categories__name TEXT workflow_status_categories.name workflow_status_categories.name
workflow_status_categories__self TEXT workflow_status_categories.self workflow_status_categories.self

Jira workflow_statuses fields

The workflow_statuses report of the Jira connector includes 8 fields.

ID Type Name Description
workflow_statuses__description TEXT workflow_statuses.description workflow_statuses.description
workflow_statuses__iconurl TEXT workflow_statuses.iconUrl workflow_statuses.iconUrl
workflow_statuses__id TEXT workflow_statuses.id workflow_statuses.id
workflow_statuses__name TEXT workflow_statuses.name workflow_statuses.name
workflow_statuses__scope OBJECT workflow_statuses.scope workflow_statuses.scope
workflow_statuses__self TEXT workflow_statuses.self workflow_statuses.self
workflow_statuses__statuscategory OBJECT workflow_statuses.statusCategory workflow_statuses.statusCategory
workflow_statuses__untranslatedname TEXT workflow_statuses.untranslatedName workflow_statuses.untranslatedName

Jira workflows fields

The workflows report of the Jira connector includes 6 fields.

ID Type Name Description
workflows__created TEXT workflows.created workflows.created
workflows__description TEXT workflows.description workflows.description
workflows__id OBJECT workflows.id workflows.id
workflows__statuses OBJECT workflows.statuses workflows.statuses
workflows__transitions OBJECT workflows.transitions workflows.transitions
workflows__updated TEXT workflows.updated workflows.updated

Jira other fields

The Jira connector has 25 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
day_of_month TEXT Day of month Day of the month
groups__groupid TEXT groups.groupId groups.groupId groups
groups__name TEXT groups.name groups.name groups
issue_navigator_settings__label TEXT issue_navigator_settings.label issue_navigator_settings.label issue_navigator_settings
issue_navigator_settings__value TEXT issue_navigator_settings.value issue_navigator_settings.value issue_navigator_settings
labels__label TEXT labels.label labels.label labels
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
project_email__emailaddress TEXT project_email.emailAddress project_email.emailAddress project_email
project_email__projectid TEXT project_email.projectId project_email.projectId project_email
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20