Export Jira Issue, worklogs.timeSpent and worklogs.comment to Google-Sheets
Hello guys,
I need to extract data from Jira to Google-Sheets in real time, that is, whenever when updating the data in the jira, the spreadsheet in Google Sheets will be automatically updated.
The data I need to extract is displayed in image (attachment) . The column title indicates the fields of the issue record in Jira.
Data is coming to Google-Sheets via REST / JSON.
Problem, is in bringing all of the "Log Work" of the same issue.
In the example there are four "Log Work" records for the same Key, (ERP20001-109)
But the result I'm getting is just a single record per line\key.
The Jira structure is composed of
https: // localhost / rest / api / 2 / issue / Key / worklog
where workdescription data is in worklog / worklogs / # / comment
# is the ID of the Work Description records
Question1: Is it possible to generate in Google-Sheets an extra data as in image?
Question2: Can WorkLog structure be broken in rows by WorkLog ID?
