What data we store#

In API / Export fields mapping:

Field Jira (data source)
projectIdOrSpaceId project id
workItemIdOrPageId work item id / issue id
subItemId varying
extra varying
eventTime event time
changelogId changelogId
actorId user who triggered the event
eventType ISSUE_CREATED, ISSUE_UPDATED…
Event stored field Example data remarks
ISSUE_VIEWED, ISSUE_DELETED, ISSUE_CREATEDproject id10039
issue id10148
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-04-26T17:33:00.667+0200
ISSUE_UPDATEDproject id10039
issue id10181
changelog id10361
field idassignee, statusCategory, customfield_10050subItemId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-04-26T17:33:00.667+0200
ISSUE_ASSIGNEDproject id10039
issue id10181
assignee accountId557058:e1cec712-baf5-4d71-a033-12684497b221null if no assignee
actor id557058:e1cec712-baf5-4d71-a033-12684497b221subItemId
ISSUE_MENTIONEDproject id10039Multiple rows (one per mention)
issue id10181
mentioned accountId5dd64082af96bc0efbe55103extra
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-04-13T17:54:15.811+0200
COMMENT_CREATED, COMMENT_UPDATE, COMMENT_DELETEDproject id10000
issue id10000
comment id10003subItemId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-04-13T17:54:15.811+0200
COMMENT_MENTIONEDproject id10039Multiple rows (one per mention)
issue id10181
mentioned accountId557058:aea7ac02-75c1-4f47-9beb-dd89777d4949extra
comment id10138subItemId
actor id5d47f4a40495e90c5d43fc03
event time2025-05-04T22:34:08.841+0200
ISSUELINK_CREATED, ISSUELINK_DELETEDcollection_idnullNot set
sourceIssueId10013workItemIdOrPageId
issue link10071subItemId
actor id5d47f4a40495e90c5d43fc03
WORKLOG_CREATED, WORKLOG_UPDATED, WORKLOG_DELETEDcollection_idnullNot set
issue id10181
worklog id10000subItemId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221From worklog.updateAuthor
time spent2w 2d 3hextra
event time2025-05-04T22:34:08.841+0200
ISSUETYPE_CREATED, ISSUETYPE_UPDATEDproject id10000null if global scope
issue type id10078subItemId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-05-04T22:34:08.841+0200
FIELD_CREATED, FIELD_UPDATED, FIELD_TRASHED, FIELD_RESTORED, FIELD_DELETEDfield idcustomfield_10090subItemId
collection_idnullNot set
item_idnullNot set
actor idnull
event time2025-05-04T22:34:08.841+0200
VERSION_CREATED, VERSION_UPDATED, VERSION_RELEASED, VERSION_UNRELEASED, VERSION_ARCHIVED, VERSION_UNARCHIVED, VERSION_MOVED, VERSION_MERGEDproject id10001
version id10001workItemIdOrPageId
merged version idnullsubItemId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-05-04T22:34:08.841+0200
PROJECT_ARCHIVED, PROJECT_CREATED, PROJECT_DELETED, PROJECT_SOFTDELETED, PROJECT_UNARCHIVED, PROJECT_UPDATED, PROJECT_RESTOREDproject id10070
actor idnullnot available
event time2025-05-04T22:34:08.841+0200
ATTACHMENT_CREATED, ATTACHMENT_DELETEDissue id10000
attachment id10139subItemId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221From attachment.author
collection_idnullNot set
event time2025-05-04T22:34:08.841+0200
COMPONENT_CREATED, COMPONENT_UPDATEDproject id10072
component id10016workItemIdOrPageId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-05-04T22:34:08.841+0200
USER_CREATED, USER_UPDATED, USER_DELETEDuser accountId712020:36604a97-e011-44e5-b7b0-23549fab4bb2workItemIdOrPageId
actor idnullnot available
event time2025-05-04T22:34:08.841+0200
PRODUCT_CREATED, PRODUCT_UPDATEDapp idc9629c67-88ec-4719-88f0-aa066dcff4dcworkItemIdOrPageId
actor id557058:e1cec712-baf5-4d71-a033-12684497b221
event time2025-05-04T22:34:08.841+0200